I am trying to import a 10 gig database to my local installation of mysql. I'm using Ubuntu 11.10. I am using the command line to do it.
mysql -u root -p database < database.backup.sql
I left it running for 2 days and finally stopped it just to see whats going on and I only had some of the tables. I need a better way to do this, but I haven't found anything saying to do it differently than the command line.
Is there another way of doing this that doesn't time out the server (or whatever its doing) ?