Bigdump

[lenney]

trying that now just downloaded

lenney Reviewed by lenney on 5th Mar 2010. Bigdump i am trying to import a database which i have moved from one host to another but i get this error while using bigdump Stopped at the line 2626. At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos. Stopped on error how can i get round this Rating: 5

[SS-Chris]

You can also ask your host, or, if you have ssh access, to load the sql dump file in through ssh. Doing so through ssh is much faster, and can handle very large databases.

mysql -u username -p -D databasename < dumptextfile.sql

This will ask you for the database password when run. Of course, you must fill in the correct information above.