Can somebody please tell me how I would go about backing up a database in Plesk?


Thanks

Can someone please tell me how to backup a database in a Plesk control panel?

Hi,

If you are running Plesk 6 (unlikely), then there is a button in the control panel for this purpose.

If you are running an earlier version, then the best way is to use the Plesk control panel to get into the PHPMyAdmin program, and you can backup your databases using a the 'dump' function in there.

First, log in to Plesk. Then you'll want to open the settings for the domain with the database (just click on the domain name from the list).

Next, click the Databases button. This will generate a list of databases available. Click on the database you wish to back up.

You will see on the next screen a phpMyAdmin button. Click on it. This will open a new browser window with the phpMyAdmin program running in it.

On the left side you'll see a list of your database fields. At the top should be the name of your database, you will probably need to click it for the correct screen to show up on the right side.

On the right side, there will be a section that says "View dump schema of database". Below that you should click on 'structure and data', and also click on 'save as file'. Be sure to pick either zipped or gzipped, depending on what software you use (more than likely 'zipped').

After you are done, click the GO button and you will be given a chance to name your backup file and define the location (directory) on your computer where you want to save it.

If your database is LARGE, you might run into some problems with this method, but try it first and see, it will probably be ok.

David

Inside phpmyadmin inside the Control Panel under Databses do the following:

1. open phpmyadmin and select your DB

2. Now you can see a drop down menu in the left frame of phpMyAdmin where you select your database.

3. In the header of the right frame you should now see "Export". Click it

4. Now you see a multiline selection field where you can select tables to be backed up. If you select no table or all tables then the backup stores the whole database.


5. Select on the right side "Structure & Data" and below the selection field "Add 'drop table'" , "Complete inserts" , " Extended inserts" , " Enclose table and field names with backquotes" and "Save as file". If you have also "zipped" and "gzipped" there you can get a smaller backup file.

6. When you now click on "Go" a download popup should appear for your backup

Thanks!

Thanks!

Merged threads