What's the best way to import a large database? (Over 500mbs)

Usually importing anything over around 10mbs times out through the browser interface, what other options are available to import large databases? Would I have to use SSH or telnet or something?

I dont have much experience with this but back when I owned talkdevelopment.com way back when I used IPB I had to do something similar as it had a large database. I ended up using SSH through cpanel.

you would need to do it via ssh

upload it via ftp (or even ftp from the other server)

then use ssh and mysql commands to import it.

you could break it up into 2 mb chunks and upload it bit by bit

you can use this command, it should restore the db

Originally Posted by Adam you could break it up into 2 mb chunks and upload it bit by bit

That reminds me when I manually copied and pasted Queries into phpMyAdmin a few lines at time. Boy was that time consuming!

SSH it would be the best way.