Help moving MySQL database from old webhost to here. Gives error.

[mil1ion]

So I am trying to move a MySQL database from my old webhost on to X10. First what I do is export the old one in PHPMyadmin. I only have the options of zip, gzip, or bzip. It doesn't matter which one I do because when I go to PHPMyadmin on X10 and try to import it, it gives me a mile long error. I wouldn't say I'm that much of a noob, but help would be appriciated.

 

[Gouri]

Can you tell us what is the error. So we can help you.

 

[mil1ion]

OK so I googled and tried something different, but I think I got a much more hopful error. I just plain exported my old db on my old webhost and copied everything inot a text file and saved it to my computer. Then I tried uploading that onto X10 and this is the error I got.

Error

SQL query:
INSERT INTO `cache` VALUES('theme_registry:greenNblack', 0x613a3136323a7b733a31323a22776562666f726d5f76696577223b613a363a7b733a393a22617267756d656e7473223b613a353a7b733a343a226e6f6465223b4e3b733a363a22746561736572223b4e3b733a343a2270616765223b4e3b733a343a22666f726d223b4e3b733a373a22656e61626c6564223b4e3b7d733a343a2274797065223b733a363a226d6f64756c65223b733a31303a227468656d652070617468223b733a32353a2273697465732f616c6c2f6d6f64756c65732f776562666f726d223b733a383a2266756e6374696f6e223b733a31383a227468656d655f776562666f726d5f76696577223b733a31313a227468656d65207061746873223b613a313a7b693a303b733a32353a2273697465732f616c6c2f6d6f64756c65732f776562666f726d223b7d733a32303a2270726570726f636573732066756e6374696f6e73223b613a313a7b693a303b733a31393a2274656d706c6174655f70726570726f63657373223b7d7d733a32313a22776562666f726d5f766965775f6d65737361676573223b613a363a7b733a393a22617267756d656e7473223b613a363a7b733a343a226e6f6465223b4e3b733a363a22746561736572223b4e3b733a343a2270616765223b4e3b733a31363a2[...]
MySQL said:
#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

 

[misson]

Take a closer look at the rest of the error, where it identifies exactly where the query is syntactically incorrect. You should see (assuming what you pasted is exactly the same as what's in the query) that it's somewhere in the hex number, right after a space. Hex numbers can't have spaces.

 

[mil1ion]

So pretty much are you telling me that in all the jumble of stuff after greennblack there is a space in there that I have to remove?

 

[misson]

So pretty much are you telling me that in all the jumble of stuff after greennblack there is a space in there that I have to remove?

No, there are many spaces that you need to remove. In the sample you posted, there are 19, and presumably much more in the full query. Use a scripting language (e.g. PHP, Python) or a powerful editor (e.g. emacs) to remove the spaces.

Note the parenthetical comment in my previous post: this is assuming the posted fragment is an accurate copy of what's in the original query. If the act of copying introduced the spaces, the problem will lie elsewhere. That is why I said to read the rest of the error message. In fact, better post a little of it; you should be able to edit the post with the error message and add it there.

 

[descalzo]

Note the parenthetical comment in my previous post: this is assuming the posted fragment is an accurate copy of what's in the original query. If the act of copying introduced the spaces, the problem will lie elsewhere

I think the spaces are due to the forum display. If you 'quote' his post, there are no spaces that I can see.

SQL query:
INSERT INTO `cache` VALUES('theme_registry:greenNblack',

Just wondering if you need to copy over the cache.

 

[mil1ion]

Ya I looked at the actually text that I copied and there were no spaces in the whole thing whatsoever. Should I upload the text file so you can see it cus I don't really know anything about this...
Edit:
I know that greennblack is a drupal theme I have installed. If all else fails do you think I should try uninstalling that theme and then try it?

 

[oraya68]

So I am trying to move a MySQL database from my old webhost on to X10. First what I do is export the old one in PHPMyadmin. I only have the options of zip, gzip, or bzip. It doesn't matter which one I do because when I go to PHPMyadmin on X10 and try to import it, it gives me a mile long error. I wouldn't say I'm that much of a noob, but help would be appriciated.

You need to check your versions! I suspect you are getting this due to two different versions. Are you able to back up the database from the command line, with the --compatible=mysql50 flag?

Kind regards,
Oraya