Trying to restore a 250 mb MYSQL DB...
I'm trying to restore a 250 mb mysql file and I can't seem to do it.
I uploaded the file named mysql.sql into the directory /home/USERNAME/public_html/ using ftp.
I logged into shell, root, and did:
cd /home/USERNAME/public_html/
mysql DATABASE -uUSERNAME -pPASSWORD < mysql.sql
and it went for like 10 minutes then came back with an error at line 1789, lost connection to mysql server during query.
I've tried this three times now and every time it loses the connection, it inputs like 15 megs of data then quits. Then when I run it again, I have to empty the table because it says it already exists.
This is a backup from a friend, so he can't make the backup again for me with "drop tables" or anything like that, that is usually how I make backups with extended quotes and everything so I never have to deal with crap like this.
How can I fix this and restore the database fully?
