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 Users Found This Useful
這篇文章有幫助嗎?

相關文章

Can I connect to MySQL remotely?

Yes, you can connect to your MySQL database remotely using a client such as MySQL-Front at...

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"...

How do I create a database in MySQL?

You can create a database via your control panel by clicking on the mySQL icon. When you create...

What is the number of maximum connections allowed to a single MySQL database?

We allow up to 50 simultaneous connections per MySQL user, and up to 1500 simultaneous...