How can I backup a MySQL database through cPanel?
Yes, you can backup a mySQL database through a user’s cPanel under the mySQL section. Once you load the mySQL section you will launch the phpMyAdmin for that user. Within the phpMyAdmin there will be a link called “Export”. Click that and select the database you wish to export and check the box called “Save as File” and enter in a file name in the text field below. Leaving the default options checked should be good enough for a standard SQL backup. Then hit Go. You will then be prompted by your web browser to save a file to your local computer. This is your newly created SQL backup file. If phpMyAdmin fails to produce a file for download and seems to have be hanging it most likely means that the database you are trying to export is too big for phpMyAdmin. If you are familar with command line access via SSH you can issue the below command to produce the same file.
Related Questions
- I see that WebSecure Backup uses the SQLite database. Can I replace the SQLite database in my backup server with PostgreSQL, MySQL or MS-SQL Server etc?
- I see that StoreGrid uses the MySQL database. Can I replace the MySQL database in my backup server with PostgreSQL or MS-SQL Server etc?
- How do I backup MySQL database and Application files?
