You will be redirected to the phpMyAdmin interface, from which it is possible to perform all database operations. In the main cPanel screen, you need to search and click on the “phpMyAdmin” link, as shown below. To use phpMyAdmin, the first thing you need to do is login to cPanel from the client area. If you are not familiar with this tool, before moving further, I invite you to read my phpMyAdmin guide. PhpMyAdmin is a software used to manage all aspects of databases. In order, let’s first see how it is possible to export databases from phpMyAdmin via the cPanel panel simply and quickly. Export only one of your databases using the Backup function.Export databases directly from cPanel using the “Full Backup” function.To export databases, it is possible to adopt three different solutions: cPanel: export databases using the Backup tool.How to export databases with phpMyAdmin.You will see the below message when the import is successfully completed. Click on “Import” tab to import the database backupĥ. Click on “Structure” table and delete the tables in the databaseĬlick on “Check All” to select all tables like shown in the below picture. Select the database to which you’re going to restore the backupĤ. click on “phpMyAdmin” Under “Databases”ģ. You don’t have to do the below steps if you’re restoring the database backup to a new empty databse.Ģ. Restore mySQL database backup to an existing database using phpMyAdmin If you want to restore to the same database then delete the tables first and then restore. If you are restoring the database to an existing database with tables you might see errors like “tables already exists” etc. Create a new database in cPanel and restore it. It is better to restore the database to an empty database. Do the below steps to restore the database. Now you have saved the backup of the database to the PC. Select quick option, SQL format and click on ‘Go”.Ĭhoose the directory in which you wish to save the backup. If you want to dump only selected tables then you can choose Custom import method instead of Quick.ĩ. If you select custom, you can select the Character set (utf-8, iso-8859-8 etc), compression type (zip, gzipped, bzipped etc), output format (SQL, JSON, CSV, YAML, XML etc) etc. You can see “Export” tab to export tables of the databaseĨ. Click on the database you want to backupħ. In the phpMyAdmin page (on the left side) you can see list of databases in your cPanel accountĦ. Click on “phpMyAdmin” Under “Databases”ĥ. Search for phpMyAdmin in cPanel search barĤ. In the cPanel login screen you must enter the cPanel username and password to loginģ. YourServerIp and should be replaced with the actual domain name.Ģ. cPanel account login details will be provided by your webhosting company. To access phpMyAdmin you must first login to your cPanel account. 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)ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |