Announcement

Collapse
No announcement yet.

Errors when uploading dumped data.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Errors when uploading dumped data.

    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!

  • #2
    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?

    Comment


    • #3
      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.

      Comment


      • #4
        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

        Comment


        • #5
          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.

          Comment


          • #6
            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.

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X