Restoring A Database


#1

Hey guys, trying to restore a mysql database for my IPB forum. I’ve got the .sql file which I got from phpmyadmin from my old host, and now I’ve moved here, how do I upload that into my database?

I have the database made, I just need to upload all the tables and data etc, how would I do this in the control panel?


#2

Do the reverse of what you did with your old isp: Log into phpmyadmin and click import instead of export. I’ll trust you can follow the onscreen instructions rather than me talk you all the way through it.


#3

It’s possible that you may have to edit that .sql file so it contains proper information for your new database setup. This info is somewhere in the first 20 or so lines of your .sql file.

-Scott


#4

Note that if your DB file is larger than 7MB or so, you may not be able to restore it using phpmyadmin, due to the default upload file size limit of the PHP installation.

If this is the case, you will need to log-in using SSH to restore the DB.

Mark


Save [color=#CC0000]$50[/color] on DreamHost hosting using promo code [color=#CC0000]SAVEMONEY[/color] ( Click for promo code details )


#5

See the wiki article called ‘migrate mysql’ it will walk you through the process.

–Matttail
art.googlies.net - personal website


#6

Thanks guys, I’m just stupid and forgot that it’s accessed by yourdb.yourdomain.com :stuck_out_tongue:

Cheers