Can I backup my MySQL database? How do I backup my database?

You can backup your database two ways.

1. Click on Backup in Cpanel then click on the database name. This will download a gzipped copy to your computer.

2. Use the PHPMyAdmin feature in your control panel by clicking on MySQL and then phpmyadmin at the bottom. In PHPMyAdmin, select the database you want to backup and select "Export" tab on the right screen. Choose the tables you wish to backup (or "Select All" for all tables). Scroll down and tick "Save File As..." and click on the "Go" button. Simply save the database that begins to download, on your local computer.

  • 2 användare blev hjälpta av detta svar
Hjälpte svaret dig?

Relaterade artiklar

Can I use MySQL Front to access my database?

You can remotely connect to your database by using your domain name as the host you are...

Does your MySQL server support extended character sets, foreign character sets, and collation sets?

In the control panel's left-hand side of the page, there should be a MySQL version for your...

How do I rename a table in phpMyAdmin?

Here is a step-by-step for renaming a table: 1. Log into cPanel 2. Click on "MySQL Databases"...

Securing MySQL

Due to differing needs and requirements this is difficult to answer except on a case by case...