database Archives - Solveddoc

application / database / PHPMyadmin / server techniques

How to export Database from PHPMyAdmin?

August 10, 2021 by Shoaib Khattak

While transferring your website from one server to another you may need to export your database in some cases. In this article, I am going to show you how to export Database from PHPMyAdmin.

Exporting a database is just a few-click process. Just login to your PHPMyAdmin dashboard providing username and password. to export Database from PHPMyAdmin

You can see all the database you have created In your database is there.

Select the database you want to export. To select a database click on it. And you can see all the tables of your database on your screen.

Now from the top bar click on the Export button to start the export database.

Now you have to select the type of file in which you want to export your database. After selecting file type click on the Go button on the right bottom side.

on clicking the Go button process will start and you can see the download progress on your browser.

Once done you can use it for importing anywhere.

Also read: How to resolve PHPMyAdmin blank page error CyberPanel?

Read: How to connect CyberPanel with CyberPanel Cloud?

Follow US on Facebook / Twitter / Instagram .

authentication / Command Line / configuration / database / Uncategorized

How to access MySql root user using the command line?

July 26, 2021 by Shoaib Khattak

Often in the case of big databases or lack of user interfaces you need to do MySQL functions using the command line on your server. In this article, we will discuss How to access MySql root users using the command line?

We try to minimize this article as we can.

Login to SSH using your credetial vis putty/bitvise etc.
Now copy this comand and paste on your ssh terminal.

mysql -u root -p

After this terminal will ask for the root MySQL password provide a password to be processed.

In the case of cyberpanel Mysql root password location is. /etc/cyberpanel/mysqlPassword. use cmd to show.

cat /etc/cyberpanel/mysqlPassword

Read: How to connect CyberPanel with CyberPanel Cloud?

Follow US on Facebook / Twitter / Instagram .

Command Line / configuration / CyberPanel / database / PHPMyadmin

How to resolve PHPMyAdmin blank page error CyberPanel?

July 2, 2021 by Shoaib Khattak

Sometime after update you faced PHPMyAdmin blank page error CyberPanel. In this article i will tell you the shortest way to resolve PHPMyAdmin blank page error CyberPanel.

You have to do few steps to resolve this issue.

You have to load your default PhpMyadmin script and replaced it with the present script.

1.Login to SSH. Change directory to the phpmyadmin using this command.

cd /usr/local/CyberCP/public/phpmyadmin

2. Here you have one simple file and one the working config file. Rename the working config to the new file like config.inc.php.old using this command.

mv config.inc.php config.inc.php.old

3. Now rename simple file to the working file and try to access phpmyadmin from the CyberPanel.

mv config.sample.inc.php config.inc.php

Go to the PhpMyAdmin page of your CyberPanel and check now.

https://<ServerIp>:8090/dataBases/phpMyAdmin

Read: How to connect CyberPanel with CyberPanel Cloud?

Follow US on Facebook / Twitter / Instagram .

authentication / Backup / centos / child domains / clone / Command Line / configuration / CyberPanel / Dashboard / database / Uncategorized

CyberPanel Features List

June 24, 2021June 24, 2021 by Shoaib Khattak

This article will discuss the CyberPanel features list. All the features discussed in detail. This CyberPanel features list has all the features CyberPanel has.

CyberPanel Dasboard:

After login, you come to the base page, which is the CyberPanel dashboard. On the dashboard, you can see a sidebar on the left side, in this sidebar you can almost the feature of CyberPanel. In the center of the page you see those feature buttons you can access these feature from the sidebar lists or you can access through these buttons. On the right, you can see the Resources bar here you can see CPU usage, Ram usage, and Disk usage in percentage, how much you used the resources.

This is the all I discuss above are belong to the base/dashboard page of CyberPanel. now I’m discussing the sidebar feature list one by one.

CyberPanel Features List details

Sidebar in CyberPanel Dashboard:

here is the whole sidebar or CyberPanel Dashboard, the Sidebar is divided into three section that is Overview, Main, and Server.

Overview

In the Overview section, there is the general information of your server,
On the Top, you can see the IP address(255.255.255.255) that IP is your server IP address.
The next button is the Dashboard button, after clicking on this button go to the dashboard.
The next button is version management, if you want to know about your CyberPanel version click on this button.
The last button in this section is Connect if you want to connect your server to the CyberPanel Cloud then click on this button

Main

On the second section of the CyberPanel dashboard sidebar, you can see a lot of feature dropdown lists,

Users

This first feature is Users when you click on Users a dropdown list shown on your sidebar that has a lot more features.
View Profile, this feature shows your account details e.g Username, Account ACL, Email, etc.
Create New User, if you want to create a new user click on this button.
List Users, if you want to list all users of CyberPanel click on this button the all use show on your screen.
Modify Users, as the name shows, this button is for update/modify your user’s information.
Reseller Center, This feature issue the Reseller account.
Create New ACL, This feature is for Creating a new ACL (Access Control List)
Delete ACL, if you want to Delete ACL (Access Control List) this feature is for deleting.
Modify ACL, if you want to modify or update ACL (Access Control List) click on this.
API Access, Enable or disable via this button.

Websites

On the Section, the whole information about your websites that you are deployed on this server.
Create Website, You can create a new website by clicking on the button
List Website, You can list you all website that are deployed on your this server
List Child Domains, if you want to List all Child domain you can view all by clicking on this button
Modify Website, if you want to update/Modify your website click on this button
Suspend/Unsuspend,
Delete Website, if you want to delete your website click on this button.

Packages

Packages on CyberPanel help you assign resources to an individual website, you must create at least one package before you start creating websites.
Create Packages, You can create a package according to your requirement.
List Packages, List all Packages.
Delete Package, Delete the packages you won’t need anymore.
Modify Package, If you feel the need to modify the parameters for the existing package you can do so via modify package page.

Database

On the Database, you can create, delete, list, and access your database
Create Database, if you want to create a new database click on this button
Delete Database, On this button, it will delete the database
List Database, On this button it will list the database after selecting the website
PHPMyAdmin, if you want to access your PHPMyAdmin click on this button.

DNS

On this Button the whole information about DNS(Domain Name Server)
Create Nameserver, You can create a NameServer according to your requirement via this button.
Config Default Nameservers, Configure Nameserver via this Button
Create DNS Zone, Before you can use the “ADD/MODIFY DNS Records” page you have to create a DNS zone first, this is the first step to start using the DNS server.
Delete Zone, Once the DNS zone is created you can delete the zone using this button.
Add/Delete Records, Once the DNS zone is created you can add or delete records using this button.
Cloudflare, In version v2.0.0, CyberPanel has added the ability to synchronize DNS entries between Cloudflare and CyberPanel DNS on your own server

Email

In this section, you can create, list, delete email, etc,
Create Email, if you want to create a new email then click on this
List Email, This button is for List all Email created on the website.
Delete Email, if you want to delete Email click on this button
Email Forwarding,
Change Password, if you want to update or change the password of your email click on its button
DKIM Manager, access DKIM manager through this button
Access Webmail, access Webmail(Rainloop) through this button

FTP

Create FTP Account, click on this button to create a new FPT account
Delete FTP Account, if you want to delete an FPT account click on this button
List FTP Accounts, This button is for List all FTP account

Backup

Taking complete backup of a website account is simple.
Create Back up, If you want to create a backup click on this.
Restore Back up, Backup restore only works with backups generated through the backup generation tool in CyberPanel.
Add/Delete Destination, if you want to Add or Delete Back up Destination click on this
Schedule Back up, if you want to schedule your website’s backup then click and produce.
Setup Google Drive, This feature is for Google drive one-click backup
Remote Backups, this feature is for Remote backup

Incremental Back up

CyberPanel version v1.9.1 adds supports for incremental backups, Local, SFTP, S3 backup
Create/Restore Back up, you can create a local or remote incremental backup.
Add/Remove Destinations, From this button, you can directly go to backup destinations.
Schedule Backups, if you want to schedule your website’s backup then click and produce.
Restore from Remote this feature is for Incremental Remote backup

SSL

Manage SSL, If you want to Manage SSL click on this button and manage
Hostname SSL, If you want to issue Hostname SSL you can issue it via this button
MailServer SSL, this button is for Mailserver SSl

Server

The third and last section of CyberPanel sidebae is server.

Web Terminal:

CyberPanel v1.9.2 onwards has a web terminal (to access your server SSH). However, in some browsers, you might not be able to use Web Terminal with default self-signed SSL. In that case, just set up CyberPanel on SSL. Now access CyberPanel using that domain.

Cloudlinux

CloudLinux and CageFS is available with CyberPanel v.1.8.6, but before using any of its features, you need to convert your operating system to CloudLinux OS. Use the commands below to convert your server to CloudLinux OS.
Create Package,
List Packages,
Monitor Usage,

Containerization

Containerization feature (v1.8.0 and above required, currently only CentOS is supported) offers to limit website resources and have no link to our Docker Manager feature. With containerization you can limit various system resources for a website, groups are used on the back end to enforce these limits. You can limit:

CPU Usage.
Memory Usage.
Network Usage.
Disk Usage (IO and IOPS)

Docker Manager

CyberPanel gives you the ability to manage your Docker container and images the easy way. Some of the exciting features of CyberPanel Docker Manager:

Search and pull images from Docker Hub (Along with tags).
Prune the system.
Create Container from available/pulled images.
List and manage container that includes:
1. Start/Stop Containers.
2. View Logs.
3. Export the file.
4. View Processes inside the container.
5. Delete Containers.
6. Re-create containers.

Manage Images,
Manage Containers,
Create New Container,

Tuning
LiteSpeed Tuning,
PHP Tuning,

Server Status

This feature is for check your server status and maintains it.
Top Processes, from this feature you can check Top process.
LiteSpeed Status, from this feature you can LiteSpeed status
CyberPanel Main Log File, from this feature you can check CyberPanel Mail log files
Services Status, from this feature you can check your servers Status
Change Port, if you want to change your port then this feature is for that
Package Manager, from this feature you can access your package manager

PHP

Install Extensions, if you want to install extensions e.g. redis etc extension you can install via this option
Eidt PHP Configes if you want to change or configure your PHP version or anything else then you can change from this option

Logs

This is main featuer of CyberPanel. if you want see your server log you can watch from the option you can see:
Server Mail,
Access Log,
Error Logs,
Email Log,
FTP Logs,
ModSec Audit Logs,

Security

This feature is for your server security. there is a lot of more feature in this.
Firewall, you can stop, start, reload, and add/delete firewall through his option
Secure SSH, Securing SSH is one of the most important tasks of a system administrator. CyberPanel allows you to change SSH port, disable root login and save your SSH keys.
ModSecurity Conf, this feature is for ModSecurity configuration.
The ModSecurity Rules, if you want to add/remove update or anything else with ModSecurity Rule you can from this option
For the ModSecurity Rules Packs, you can check the ModSecurity Rule pack from this option.
CSF, You can configure CSF(ConfigServer Security & Firewall) from this button
CageFS, you can enable/disable CageFS from this button
Immunity 360, you can enable/disable Imunify 360 from this.
ImunifyAV, you can enable/disable ImunifyAV from this.

Mail Settings

This feature is related to your emails.
Mail Queue, If you want to see your mail Queue(pending mails) you can see.
Email Policy Server, this feature s for Email policy.
Email Limits, this feature is for email limits
SpamAssassin, you can Install SpamAssassin through this feature.
Email Marketing, this feature is for Email Marketing
MailScanner, If you want to install or remove MailScanner you can from this feature.

Manage Services

This feature is related to your server Service and application that you can install and check status.
Applications, you can install and uninstall applications from this feature.
Manage PowerDNS, PowerDNS is the service you can check this form this option
And Manage Postfix, you can check postfix service form this option
Manage FTP, you can check FTP form this option

Plugins

You can install new plugin and uninstall installed plugin from this feature.

This are the main CyberPanel features list.

Here you can read How to log in to the Rainloop admin dashboard?

How to Change Upload limit On CyberPanel?

You can follow us on Facebook too.

configuration / CyberPanel / database / domain / upgrade / upload

How to Change Upload limit On CyberPanel?

May 25, 2021 by Shoaib Khattak

if you want to upload a file from the file manager on CyberPanel and the size of the file is large according to the upload limit. Then you need to change (Mostly increase) the default setting. In this article, we show how to change the upload limit on cyberpanel step by step.

https://<your-ip>:8090

Go to PHP → Eidt PHP Configs → Basic, and select the version of PHP on which you want to change upload limit.

Set the limit in upload_max_filesize according to your choice and then click on Save Changes

After doing that also press the Restart PHP button this thing will apply all changes on server level and you can now good to go wit it.

You can also read about child domain and more in the next article.

May be you are new and also want to know How to create a Database in CyberPanel?

configuration / CyberPanel / database / Developer / domain / server techniques / Technologies

How to create a Database in CyberPanel?

March 16, 2021 by Shoaib Khattak

If you want to create a Database in CyberPanel. And do not know how to do this you are on right place read this article to know how you can create a new DataBase on CyberPanel for your Website.

How to change Upload Limit on CyberPanel? Increase or decrease Upload Size through CyberPanel?

December 18, 2020October 20, 2020 by Shoaib Khattak

CyberPanel is a Webhosting control panel. If you want to upload a file of large size and you are unable to do so. So here I will tell you how to change the Maximum upload file size.

Sometimes you want to import a database of large size or you want to upload an image or file on your size of large size and then you receive an error that you cant upload a file more than 2M (2M is the default size for the post in CyberPanel).

Here I will tell you how you can increase the Max upload limit for post and file. You can also change different things like maximum execution time, max input time, etc.

Follow all the steps to change Upload Limit.

Login to your CyberPanel using your credentials.

2. Now go to the PHP->Edit PHP Configs

3. You can see the Basic and Advanced buttons here. Remain on Basic and Select your required PHP version from here.

3. You can see Basic and Advanced button here. Remain on Basic and Select your required PHP version from here.

4. Once you select the required version you can see the different option here

Here you can update the values for all fields according to your requirements. You can update values here Like Max uploads size, max execution time, Post size, etc.

After updating values you need to click the save button to save all changes .

In the last steps, you need to restart PHP in the latest version of CyberPanel they give the option of restart in the Panel. Below the configuration. But if you are on the old version you have to restart PHP.

Without restarting PHP the changes will never applied.

database / Installation / Node js / Windows

How to Install Node Js on Windows?

December 18, 2020September 25, 2020 by Shoaib Khattak

You want to Install node js on windows 10 machine?

To start the guide to install node js on your windows 10 machine. First of all, we have to know what actually node js is. Before knowing how to install node js on your windows 10 know about the node js.

Basic node js is a JavaScript runtime environment. It simply means that the node js run-time environment includes everything you need to execute a program written in JavaScript. Now I would like to mention some points about node js for better understanding.

What is node js?

Node js is free and opensource environment.
Node js uses javascript on the server.
Node js can generate dynamic pages, can do many operation on databases and its is available for different platforms (Operating Systems).

How to Install Node js on windows 10?

In order to install node js to your windows 10 machine. You need to follow different steps.

Download Node.js

In order to install node js on your windows 10, you have to download the Node js. To do so click here or visit this link https://nodejs.org/en/download/ in your favorite browser. Here you can see this screen.

You can see the latest and current version always chose the current version from them because that is the stable one then chose the windows installer from the operating systems. you can also download:

Windows Installer (.msi)
Windows Binary (.zip)
Source Code

In 32 and 64 bits depending on your operating system.

Install Node js on windows 10:

Once your download completed now its time to install it on your machine to do so follow these steps:

Click on the download file and then click install.

2. You will receive a screen that asks you to run Wizard to install node js. Press Next.

3. Now accept the License Agreement. To go to the next step.

4. You can specify the location in your computer where you want to install the node js. By default its C:/Program Files/nodejs/ and leave as its and click Next.

5. In this step you can see which node js packages you are going to install and what is disk usage, and all. Click Next to proceed.

6. In this step you can allow node js to Automatically install the necessary tools. you can follow the instruction from the link given on-screen. Then press Next.

7. All setup is done Press Install to install node js on your windows 10.

Allow the installation and this installation may take some time to complete wait until the status bar show completion.

8. All done now your node js is installed and you can press Finish and go ahead.

Verification of node js installation

Once the installation process has done you need to verify the installation of your node js on windows 10. to do so just run a simple command:

npm -v

You can see the installed version it’s mean your installation is complete. Now your system is good to go.

How to migrate WordPress Site using Migrate Guru Step by Step guide

CyberPanel Dasboard:

CyberPanel Features List details

Sidebar in CyberPanel Dashboard:

Overview

Main

Users

Websites

Packages

Database

DNS

Email

FTP

Backup

Incremental Back up

SSL

Server

Web Terminal:

Cloudlinux

Containerization

Docker Manager

TuningLiteSpeed Tuning, PHP Tuning,

Server Status

PHP

Logs

Security

Mail Settings

Manage Services

Plugins

Table of Contents:

Login to CyberPanel:

Create New Database:

Access Database:

What is node js?

How to Install Node js on windows 10?

Download Node.js

Install Node js on windows 10:

Verification of node js installation

Tuning
LiteSpeed Tuning,
PHP Tuning,