Having Trouble Importing DB Into New BlueHost

[Michale]

Rather than resurrect an old thread, I decided to ask anew..

We're moving our established site over to Blue Host. I am having the problem of not having access to the old database to IMPORT it to the new setup.

So, barring a fix for that, I was thinking of doing a FULL BACKUP and then bringing that over to the new BH setup.. But it says that such a BackUp can only be restored by an ADMIN.

So, my question is, with the BH Admin be willing to do this as a one time deal?

Thanx..


Michale

[charlesgan]

basically you can backup existing database, to temporary file, then import to BH database. Use phpmyadmin

Backup of Mysql database
It is assumed that you have phpMyAdmin installed since a lot of web service providers use it.

i found these online...

0. Open phpMyAdmin.
1. Click Export in the Menu to get to where you can backup you MySql database. Image showing the export menu.
2. Make sure that you have selected to export your entire database, and not just one table. There should be as many tables in the export list as showing under the database name.
3. Select"SQL"-> for output format, Check "Structure" and "Add AUTO_INCREMENT" value. Check "Enclose table and field name with backquotes". Check "DATA", check use "hexadecimal for binary field". Export type set to "INSERT".
4. Check "Save as file", do not change the file name, use compression if you want. Then click "GO" to download the backup file.
Image showing step 2-4.

Restoring a backup of a MySql database
1. To restore a database, you click the SQL tab.
2. On the "SQL"-page , unclick the show query here again.
3. Browse to your backup of the database.
4. Click Go.

[charlesgan]

here is the export db steps...

http://www.tamba2.org.uk/wordpress/backup/

[Michale]

That did the trick.

Many thanx...


Michale