How do I backup a MariaDB - MySQL Database?

Here are the steps on how to backup a MySQL database using phpMyAdmin in your Ultra Web Hosting control panel (cPanel):

  1. Log in to your control panel.
  2. Click phpMyAdmin.
  3. Click on the "Databases" tab.
  4. Select the database that you want to backup.
  5. Click on the "Export" tab at the top.
  6. In the "Export Method" section, select "Quick".
  7. In the "Format" section, select "SQL".
  8. In the "Output" section, select "Download".
  9. Click on the "Go" button.

phpMyAdmin will create a backup file of the database and download it to your local computer. You can then store the backup file in a safe place.

 

Here are some additional tips for backing up your database using phpMyAdmin:

 

  • Select the "Custom" export method if you want to have more control over the backup file. This will allow you to specify the tables that you want to backup, as well as the format of the backup file.
  • Enable the "Add DROP TABLE statements" option if you want to be able to restore the database from the backup file. This will add DROP TABLE statements to the backup file, which will drop the tables before they are recreated.
  • Test your backups regularly to make sure that they are working properly. This will help you to make sure that you can restore your data if necessary.
 If you need additional help, Ultra is here for you. Contact Ultra for award winning support.
  • 446 Users Found This Useful

Was this answer helpful?

Related Articles

The MySQL server is currently offline admin bin Cpanel/cpmysql/DBCACHE: exit 11

The error message...  The MySQL server is currently offline admin bin Cpanel/cpmysql/DBCACHE:...

Warning: Unknown(): open_basedir restriction in effect

Basedir restriction is set for security. This most often occurs when you are calling an app...

How can I find my MariaDB - MySQL version?

Method 1: Through cPanel   Log in to your Ultra Web Hosting account. Click on the cPanel...

I am having problems with a script I wrote

PHP suexec is running on all of our shared servers. If you are running code that is insecure or...

Error 500 - Internal Server Error - PHP

This can be due to several factors. The first thing to check is that the permissions on the file...