[]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.