How do I backup my MySQL database?

How do I backup my MySQL database?

This answer explains how you can backup your database.

This article applies to Linux Hosting accounts.

 

phpMyAdmin has an option to make backups of your database. You can access phpMyAdmin by:

1

Log in to your Webfusion control panel at cp.webfusion.com.

2

Click on the "My hosting" button.

3

Click on the "login" link for the relevant package.

4

Enter the corresponding password for the account and click on the "login" button.

5

Click on the "My webspace" button.

6

Click on the "My databases" button.

7

Select the database that you would like to administer by clicking on the database name.

8

Check the correct database is selected.

9

Type your database Username and password into the Login Screen and click on the "Login" button.

Tip: Alternatively, you can install any MySQL database administration package that is compatible with our servers onto your account, or you can write your own database tools in PHP, CGI or Perl.

To backup:

10

Login to your phpMyAdmin.

11

Click on the database name in the left hand frame.

12

Click on the export option you will then see View dump (schema) of database.

13

Select the Structure and data option.

13

Check the box for Save as file along with any compression options you require.

14

Click on Go

If this times out then your database may be too large to back up using a web browser. In this case you will need to use alternate means to back up your database.