Restore a .sql backup - 09/27/2004 9:18 PM
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 !
Thanks !
Re: Restore a .sql backup - 09/28/2004 6:23 AM
is it a large file? (how many megs is it?)
Re: Restore a .sql backup - 09/28/2004 8:57 AM
Hi id242, yes it seems large to me, about 150 MB.
Re: Restore a .sql backup - 09/28/2004 9:11 AM
I found THIS post from you... could be my case ? 
Re: Restore a .sql backup - 09/28/2004 11:56 PM
[]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.
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.
Re: Restore a .sql backup - 09/29/2004 12:49 AM
ask the hosting company to do it for you is another alternative for large databases.