Errors when uploading dumped data.

[noelh]

I am moving my boards to a new server, and first I am dumping the structure and data then placing that structure and data on the new server but MySQL keeps giving me these errors:

MySQL said:
You have an error in your SQL syntax near ''2 1.00 off 1 ben and jerrys ice cream\r\n4 .75 off 1 ben and jerrys ice cream\r' at line 1 Help!

[MUG]

Originally posted by noelh
I am moving my boards to a new server, and first I am dumping the structure and data then placing that structure and data on the new server but MySQL keeps giving me these errors:

MySQL said:
You have an error in your SQL syntax near ''2 1.00 off 1 ben and jerrys ice cream\r\n4 .75 off 1 ben and jerrys ice cream\r' at line 1 Help!

What are you using to dump the data and import it?

[noelh]

I am using phpMyAdmin to dump the data and structure to a file then on the new server I am uploading the .sql file through phpMyAdmin again.

[MUG]

Originally posted by noelh
I am using phpMyAdmin to dump the data and structure to a file then on the new server I am uploading the .sql file through phpMyAdmin again.

There's your problem. phpMyAdmin has problems making dumps with large databases. http://www.vbulletin.com/manual/movingservers.html

[noelh]

Originally posted by MUG
There's your problem. phpMyAdmin has problems making dumps with large databases. http://www.vbulletin.com/manual/movingservers.html

Thanks so much, but could you elaborate on the following line?

mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql

If my database username is bob and the database name is bobs_db shouldn't the syntax look like this?

mysqldump --opt -ubob -p bobs_db > /dump.sql

All I get is the file dump.sql filled with the instructions to use the dump command (which didn't help).

Thanks is advance.

[noelh]

Originally posted by noelh
Thanks so much, but could you elaborate on the following line?

mysqldump --opt -uUSERNAME -p databasename > /path/to/dump.sql

If my database username is bob and the database name is bobs_db shouldn't the syntax look like this?

mysqldump --opt -ubob -p bobs_db > /dump.sql

All I get is the file dump.sql filled with the instructions to use the dump command (which didn't help).

Thanks is advance.

Got it! Thanks so much.