By juc1 on

Hi all

I have done mysql dumps before successfully but now there is some problem. My database has 63 tables, but when I export it, it says 'download complete' after 383 KB (without compression) which I think is small. Then when I import it, I get an error message mentioning my theme registry =

http://d.imagehost.org/0389/mysql_error.jpg

Error
SQL query: 

INSERT INTO `cache` (`cid`, `data`, `expire`, `created`, `headers`, `serialized`) VALUES ('theme_registry:simply_modern', 0x613a3234313a7b733a31323a22776562666f726d5f76696577223b613a373a7b733a393a22617267756d656e7473223b613a353a7b733a343a226e6f6465223b4e3b733a363a22746561736572223b4e3b733a343a2270616765223b4e3b733a343a22666f726d223b4e3b733a373a22656e61626c6564223b4e3b7d733a343a2274797065223b733a363a226d6f64756c65223b733a31303a227468656d652070617468223b733a32353a2273697465732f616c6c2f6d6f64756c65732f776562666f726d223b733a383a2266756e6374696f6e223b733a31383a227468656d655f776562666f726d5f76696577223b733a31333a22696e636c7564652066696c6573223b613a303a7b7d733a31313a227468656d65207061746873223b613a313a7b693a303b733a32353a2273697465732f616c6c2f6d6f64756c65732f776562666f726d223b7d733a32303a2270726570726f636573732066756e6374696f6e73223b613a313a7b693a303b733a31393a2274656d706c6174655f70726570726f63657373223b7d7d733a32313a22776562666f726d5f766965775f6d65737361676573223b613a373a7b733a393a226172677[...] 

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 2

When I look at the imported database it has only the first 9 tables instead of 63. Although the error message occurs at import, I suspect that the problem is occurring prior to this ie at export.

Any suggestions please?

Thank you

⋅ Categories: Drupal 6.x

Comments

odegard’s picture

odegard commented

What do you use to dump the db? phpmyadmin? backup and migrate? adminer?

I've used all of them and I'm really starting to like adminer. It's like phpmyadmin but it's only *one* file. Also, bakcup and migrate can't import dumps from other tools, but this is beside the topic.

juc1’s picture

juc1 commented

@ odegard, thanks for your reply, I am using phpmyadmin which I just tested on a different installation and export / import worked fine. I will do some more testing and report back...

Thanks

juc1’s picture

juc1 commented

OK so I tested a few other exports and it seems to be this particular database that is the problem. The drupal website running off this database that I am trying to export works perfectly well.

Any suggestions please?

juc1’s picture

juc1 commented

Update - as shown above the error message mentioned my active theme (simply modern) so I changed to another theme and this time the database exported correctly. So it seems that the simply modern theme being active somehow causes a problem with the database exporting correctly