How to export Database from PHPMyAdmin?

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

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.

Read more: How to create, delete and manage Child Domains in CyberPanel?

database

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

go button

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.

file type

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

download

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 .

How to access MySql root user using the command line?

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.

  1. Login to SSH using your credetial vis putty/bitvise etc.
  2. 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?

Read more: How to create, delete and manage Child Domains in CyberPanel?

Follow US on Facebook / Twitter Instagram .

How to resolve PHPMyAdmin blank page error CyberPanel?

How to resolve PHPMyAdmin blank page error CyberPanel?

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.

How to resolve PHPMyAdmin blank page error CyberPanel?

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
How to resolve PHPMyAdmin blank page error CyberPanel?

Read: How to connect CyberPanel with CyberPanel Cloud?

Read more: How to create, delete and manage Child Domains in CyberPanel?

Follow US on Facebook / Twitter Instagram .

CyberPanel Features List

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.

compelet cyberpanel features list

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

CyberPanel Dasboard:

Read More: How to Change Upload limit On CyberPanel?

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.


Main

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.

Websites

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.

Packages

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.

Database

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

DNS

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

email

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

ftp

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

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

incbackup

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

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.

server

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,

cloudlinux

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:

  1. CPU Usage.
  2. Memory Usage.
  3. Network Usage.
  4. Disk Usage (IO and IOPS)
Containerization

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:

  1. Search and pull images from Docker Hub (Along with tags).
  2. Prune the system.
  3. Create Container from available/pulled images.
  4. 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,

Containerization

Tuning
LiteSpeed Tuning,
PHP Tuning,

tunning

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

status

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

php

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,

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.

security

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.

mail

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

manage

Plugins

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

plugin

This are the main CyberPanel features list.

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

Read More: How to Change Upload limit On CyberPanel?

How to Change Upload limit On CyberPanel?

You can follow us on Facebook too.

How to Change Upload limit On CyberPanel?

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.

Login to your CyberPanel as using the link:

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.
Change Upload limit of PhpMyAdmin
  • Set the limit in upload_max_filesize according to your choice and then click on Save Changes
Change Upload limit On CyberPanel

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.

Read more: How to create, delete and manage Child Domains in CyberPanel?

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

How to create a Database in CyberPanel?

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.

Table of Contents:

  1. Login to CyberPanel
  2. Create New Database
  3. Access Database

Login to CyberPanel:

First of all visi the CyberPanel login URL to login to your CyberPanel it must be with port 8090, Look like:

https://<somainname/IP>:8090

Provide username and password and login to your CyberPanel dashboard.

CyberPanel Login

Create New Database:

Once you logged in go to the Database->Create Database: in the left menu.

Create New Database
Create New Database

On this create database page you have to select the domain for which you want to create a new database.

select domain
select domain

Now screen ask you to provide the details for database.

  1. Username
  2. Database name
  3. Password
provide the details for database
Provide the Details for Database

When you press Create Database button this will create a new one for you on your server.

you can also list the database for any of your site on sever from Database-> List Database then select the domain and you can see the list.

list the database
list database

Access Database:

To access your database you created you have to go to Database-> PHPMYADMIN. Then press Access Now button.

You can see the PHPMyAdmin screen now. Where you can see all database for all domains. You can check the database your created and do any operation you want to do on this database.

Read more: How to create, delete and manage Child Domains in CyberPanel?

Follow US on Facebook / Twitter Instagram .

How to Install Node Js on Windows?

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?

  1. Node js is free and opensource environment.
  2. Node js uses javascript on the server.
  3. 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.

Download Node.js

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:

  1. Click on the download file and then click install.
Install Node

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

Run Install Node

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

Agreement Install Node

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.

Path Install Node

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.

Install Node next

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.

Auto Install Node

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

Install Node

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

Install Node js status

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

Install done Node

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
Node js version

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