I have a big MySQL backup that need to dump back to the DB, however, using telnet, it seems that it can't finish the job. I've waited for a while then I stopped it.
Do you think it has a limit on the size of the text file when restoring a database or I should just keep waiting? The file size is about 24MB.
There's no limit - I know a few people from the vBulletin.com forums who've dumped databases of up to 200Mb through telnet.
Try just waiting a bit longer - shouldn't take more than a couple of minutes though. If you still have no success, try contacting the host.
when you run the mysqldump command use the -- opt command so as not to load the mysql dump into memory before dumping
mysqldump --opt -u username -p databasename > dump.sql
I think on most MySQL installations there is a limit to how large a packet can be, I think the default is 1MB, so that could be your problem.
Thanks for the replies,
I am in the process of restoring it, so I used:
mysql -u username -p database_name < backup.file
And I've waited for about over 10 minutes.
When I stopped the process, and checked the DB, it got a few tables (but not all the tables)