Using PowWeb's Database Backups

[MLWhite707]

I just discovered that PowWeb has done a number of backups to my database, and I've download and unzipped one of them. However, I don't know how to recover any data from the dump file. Can anyone help me with this?

IHS,
mike

[KarlFry]

You can open up the dump file in a program like Notepad or Wordpad to view its basic contents. If you need a backup restored to your database, you can either do so through http://phpmyadmin.powweb.com - or if the dump file is over a few megabytes you may need one of our admins to upload the database for you.

If you need one of our admins to upload a database for you, please email support@powweb.com and include the following information:

1) Upload the dump file to the root of your webspace. What is the filename?
2) What is the name of the database you want the dump imported to?
3) What database server is it on?
4) What is your FTP username and FTP server?

#1 and #2 are necessary - #3 and #4 are appreciated and preferred.

Please make sure not to post any of this information here in the forums for your security.

Karl F.
PowWeb Technical Support

[MLWhite707]

Thanks, Karl! I've discovered that I haven't yet overwritten or otherwise lost my original database, so it appears to be intact for now. However, for future reference, how would I edit the content of such a dump file in Notepad? Furthermore, since I'm still quite new to using php, how would I use phymyadmin to restore a database backup? Your help is GREATLY appreciated! Have a very Merry Christmas and a Blessed New Year!

IHS,
mike
http://www.parsonplace.com
http://software.parsonplace.com
http://books.parsonplace.com
http://shop.parsonplace.com

[KarlFry]

In Notepad it wouldn't be particularly easy to update/edit. I would recommend using phpmyadmin for editing as well.

To import a database in phpmyadmin, log in, go to "Databases", select your database, click on the "SQL" tab, open up the contents of your .dmp file, and copy/paste the queries into that large box and click "Go".

It won't let you directly import the .dmp file since it has some header info, but if you open up the .dmp in notepad you can remove the header info and send in only the queries.

Karl F.
PowWeb Technical Support

[MLWhite707]

Which part constitutes the header section? Once I've excised that part, would I use the browse option to choose the dump file and upload it that way, or how would I proceed to do that? Thanks again for all you help!

IHS,
mike