MySQL error #1064 – moving to new hosting

  • Slavek

    (@jackoneill)


    8 years, 3 months ago

    Hey guys, I’m moving my blog from Godaddy to new hosting and while importing my sql database to new hosting I’m getting error 1064.

    On Godaddy, I use “Managed WordPress” hosting (preinstalled WordPress, auto updates, NO OPTION to create more databases in phpmyadmin). I have also one subfolder with another WP installation (manual) because I have my blog in two languages (English and Czech, both of them use UTF-8). Here is how my database structure looks http://pasteboard.co/XAuQbFo.jpg. So I guess it looks like a mess because I have two WP installations and only one database.

    I exported the sql database from Godaddy as a .zip file and when I import in to the new hosting, I get the error 1064, you can see it here http://pasteboard.co/XAIgUOI.jpg.

    Any idea how to fix it? I’ve tried different export compatibility mode, but didn’t help. Or is there any other way how to move WP site with all of the articles, setting, plugins ets. to the new hosting?

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘MySQL error #1064 – moving to new hosting’ is closed to new replies.