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 أعضاء وجدوا هذه المقالة مفيدة
هل كانت المقالة مفيدة ؟

مقالات مشابهة

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

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 create a database in MySQL?

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

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

Securing MySQL

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