How can I back-up my database?

Log-in to your Server Administrator, then click on Databases. Select the database name that you wish to back-up. Click on phpMyAdmin to the right. On your phpMyAdmin window, click on the database name on the upper left column. You should now see the list of tables in your database. Scroll down until you see a list box tagged "View dump (schema) of database". Select all tables in the list box that you wish to back-up. Select the radio button that says "Structure AND Data". Check on the checkbox that says "Save as file", then hit "GO" button. You will be prompted to save the file with a .sql extension. Name your .sql file and save.

  • 13 Users Found This Useful
Was this answer helpful?

Related Articles

What is MySQL?

MySQL is a fast, easy-to-use, multi-user SQL (Standard Query Language)...

How can I create databases?

You can create MySQL databases easily using your Control Panel. Please follow our flash tutorials...

How many databases can I create?

The number of databases you can create depends on what Hosting Plan you have....

How do I manage my Database?

Every account we have has a phpMyAdmin pre-installed and can be accessed...

How do I restore the file into the MySQL database?

Follow the steps above until you reach the phpMyAdmin window. Open the .sql file that you have...

Powered by WHMCompleteSolution