Cpanel download
To access phpMyAdmin you must first login to your cPanel account.
#Cpanel download how to#
How to Backup and Restore mySQL database using phpMyAdmin Mysql -u root -p databasename < databasename.sql Mysqldump -u root -p databasename > databasename.sqlĭo the below steps to Restore the mySQL database from server backend Use the below mysqldump command if you have set mySQL root password on the server Mysqldump databasename > databasename.sql You can use mysqldump command to create an SQL backup of the mySQL database Log into your server via SSH as ‘root’ userĢ. Steps to backup the mySQL database from Server backendġ. Click on “Upload” to restore the database Under “Restore a MySQL Database Backup” you can see the option to upload the database backupĬlick on “choose File” and select the database backup from the PC.ģ. You can follow the same steps to restore the mySQL database backupġ. SQl backup download will start and you can choose the location on PC to save the sql backup. Click on the database name to download the SQL backup in gz format Under “Download a MySQL Database Backup” you can see list of all databases in your cPanel accountĦ. Here you can download backup of the databases in your cPanel accountĥ. Search for “Backup” in the cPanel home page Enter cPanel username and password to loginģ.
Open a new web browser and log in to cPanelĢ. You can take mysql database backup either through cPanel (Frontend) or from server backend (command line)ġ.