Now that you have the database downloaded via the Export tool, you should store it in a safe location that preferably has redundancy. The data will now be saved into your computer.Ĥ. Check 'IF NOT EXISTS': this prevents errors during restores if the tables are already there.Check 'Add DROP TABLE': this can be useful for over-writing an existing database.Select SQL from the Format drop-down menu.(If your database is very large use a compression method) In the Output section check Save output to a file and select None for Compression.In most situations Quick export will be what you select, however if you want to ensure any custom tables are included in the database you will want to use Custom with the following options: There are two methods of export, Quick and Custom. To back up the databases, do the following: Log in to WHM as the root user. Here you will see all databases associated with your.

After you have selected all databases you would like to be backed up, you will click the Export button. Once you have entered into phpMyAdmin (which can be done via cPanel), click on the Database button. Select the database that you wish to backup form the ones shown within phpMyAdmin.ģ. Here you will see all databases associated with your cPanel account. In certain version of phpMyAdmin you may be automatically redirected to this area upon logging into the system.Ģ. Once you have entered into phpMyAdmin (which can be done via cPanel), click on the Database button. A tutorial for simple CMS Database Backup with phpMyAdmin.ġ.

Backup database phpmyadmin