Sea Crest Hosting

[Piggie]

How do I backup my database or table?

First open phpMyAdmin from the Plesk control panel (other’s can find it somewhere in their control panels.) In Plesk, click databases, then the database name. Then click DB Webadmin, which opens phpMyAdmin.

Once open there should be a place to click called Export. If it’s not available then click on the database name in the left frame, then click on the Export tab.

Here you can backup the structure, data or both. If you don’t click anything default is to save both. The click Save as file and it will also give you the option in some cases to save as a normal or compressed. It’s better to compress large databases. This will now download to your local machine copy of the database from which you can restore or recreate the database if you use the both option above.


How do I restore (upload) my database or tables and what is a .sql file?

Again, First open phpMyAdmin from the Plesk control panel (other’s can find it somewhere in their control panels.) In Plesk, click databases, then the database name. Then click DB Webadmin, which opens phpMyAdmin.

Once open there should be a place to click called Import. If it’s not available then click on the database name in the left frame, then click on the Import tab

Then look for the File to Import and Browse to find the file to upload you saved on your local machine. At this point you should be able to just click Go and it will upload you’re your web site. Some of the older versions ask what format you saved (.sql, .sql.gzip, or .sql.zip), then just tell it and hit Go.

Restore Addendum:

If you totally lost or have a corrupted database, but have a good copy of your database backup, then do this also.

Delete the data base from your website, then create it again, using the same database name, user name and password. This will save editing your config file in your php program. Then go to the above instructions and upload the database into your new database. You program should run again.
_________________
This forum is made entirely of post consumer data bits... Piggie