UBB.Developers Forums Community Development Programming MySQL and Server Configuration Restore a .sql backup

I have a backup of my DB in .sql format, how can I restore it on my local server ? Using phpMyAdmin ? How exactly... when I try I get a timeout of the page.

Thanks !

is it a large file? (how many megs is it?)

Hi id242, yes it seems large to me, about 150 MB.

I found THIS post from you... could be my case ?

[]Rutto said:
I have a backup of my DB in .sql format, how can I restore it on my local server ? Using phpMyAdmin ? How exactly... when I try I get a timeout of the page.

Thanks ! [/]

If you have command line or shell access to your server, this should work:

/path-to/mysql/bin/mysql -f -u <dbusername> -p <password> <forumdb> < /path-to/forumbackup.sql

(remove the < and > around the username, pwd, db)

I've used that to restore a 750MB db and it takes a couple of minutes but works fine.

Someone please correct me if there's a better way.

ask the hosting company to do it for you is another alternative for large databases.