switched host – mysql error #1064 – nearly figured out

  • Resolved jetshack

    (@jetshack)


    19 years, 2 months ago

    I’m in the process of moving a WP site to another host. I’ve been running into problems moving the database over, but after searching through the forums I’ve been able to get all of the tables installed and working except for the wp_posts table

    Specifically I’m getting this error

    #1064 – You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1

    the ” is where I’m stumped. All of the other errors I was able to mess around with and figure out…

    There are literally hundreds of these fields…. is there some sort of NULL setting I can do a global replace with?

    i.e. find ” replace with ‘NULL’
    sort of thing.

Viewing 15 replies - 16 through 30 (of 37 total)
  • Thread Starter jetshack

    (@jetshack)

    I can get access to it, but I’ll have to wait on nameservers to move over…

    Is there no way to just get the wp_posts table inserted? The other tables are already in and working

    phpMyAdmin
    Click the ‘Browse’ icon along from wp_options
    rows of tables will appear.
    click through to page 3
    Check otion_id 64 65 66 67 68 69 73 74
    Then ‘with selected’ choose Delete.

    Then re-export the db.

    (I can do that here for you if you want ?)

    mail coming back at you ??

    Thread Starter jetshack

    (@jetshack)

    sorry for the bits of delays in getting back and forth here… I’m in the se houston area… and everybody is freaking out right now.

    No apologies needed ??

    Thread Starter jetshack

    (@jetshack)

    so what you’re saying for me to do is:
    1. switch nameservers back over to old host
    2. reexport database as mentioned above.
    3. switch nameservers back to new host
    4. reimport database…

    That host is so flakey (the reason for teh move) that that could take a few days (which I’m allright with)…. just as an fyi their servers are down right now.

    No – I have the old db don’t I – so I can play around with that for you.

    I sent you just the posts table to see if that will import ?

    Thread Starter jetshack

    (@jetshack)

    ohhh… I haven’t checked yet… hold on

    Thread Starter jetshack

    (@jetshack)

    inserted as is and got the error for the
    DEFAULT CHARSET=latin1

    so i took out the
    DEFAULT CHARSET=latin1

    but still ended with the error
    #1064 – You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1

    I’m mailing you a full database.

    I have removed the dashboard excess junk, and I have removed the charset line. What is in that is an exported file from the import I did.

    If this fails and you’ve had enough, I’ll sort it for you – you’ve probably got other matters that need dealing with.

    Thread Starter jetshack

    (@jetshack)

    worked great!

    what exactly did you change around? I’ve got 2 more wp sites that I’ll be moving off those servers…

    that site was the smallest (which is why I did it first)… I’m sure I’ll run into similar errors…

    Thread Starter jetshack

    (@jetshack)

    (btw https://www.docfell.net)

    yay !

    Apart from what I noted above, I just imported / exported through xampp. If you want, just mail me the db’s like you did and I’ll mail them back at you once I’ve run them through the same process.
    I wish I could be more exact because then I could write it up !

    Thread Starter jetshack

    (@jetshack)

    allright… I might take you up on that.

    once again thanks alot… After about 3 hours of farting with that I was dreading the thought of doing the other two.

    vic

    (@vic)

    I’m having the same #1064 problem as jetshack did.

    I’m moving

    from:
    MySQL 4.0.25-standard
    phpMyAdmin 2.6.4-pl2

    to:
    MySQL 4.1.13-standard
    phpMyAdmin 2.6.4-pl2

    Should I delete these rows as podz suggested?
    https://vw.economists.com.hk/wp_options_page3.png

Viewing 15 replies - 16 through 30 (of 37 total)
  • The topic ‘switched host – mysql error #1064 – nearly figured out’ is closed to new replies.