Database import error syntax; can’t find it in MySQL

I have tried to import my .sql database into Phpmyadmin, because I’m moving to another hosting. But it won’t work. I just get this error.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '_transient_timeout_feed_mod_b9388c83948825c1edaef0d856b7b109', '1492459638', 'no' at line 2

I’ve looked it up, but I can’t seem to figure out what is wrong with this part.

Snippet from the specific code where the error should be:

INSERT INTO `wp_options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES
(2857, '_transient_timeout_feed_mod_b9388c83948825c1edaef0d856b7b109', '1492459638', 'no'),
(2858, '_transient_feed_mod_b9388c83948825c1edaef0d856b7b109', '1492416438', 'no'),
(2859, '_transient_timeout_plugin_slugs', '1492502838', 'no'),
(2860, '_transient_plugin_slugs', 'a:1:{i:0;s:24:"wordpress-seo/wp-seo.php";}', 'no'),

Can someone help me out here? What can I do next to find the error (and delete/replace it)?

Thanks!

Read more here: Database import error syntax; can’t find it in MySQL

Leave a Reply

Your email address will not be published. Required fields are marked *