Importing into New Database (SQL) Error.

I created a new database (remote) and tried importing Database file into it from my local Desktop and I tried various import configurations but the same error.

This is the wpconfig.php file which was at my local site.

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'writeind_ependentdb');

/** MySQL database username */
define('DB_USER', <em>[redacted]</em>);

/** MySQL database password */
define('DB_PASSWORD', <em>[redacted]</em>);

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

I tried the various DB_Charsets and different DB versions but with
no avail.

Here is the original file information:

– php version: 5.2.17
– mysql version: 5.1.66

Here is what I get as an error consistently when I try to import into the new database file below:

Error

SQL query:

INSERT INTO wp_options (option_id, blog_id, option_name, option_value, autoload) VALUES (345, 0, ‘_transient_feed_ac0b00fe65abe10e0c5b588f3ed8c7ca’, ‘a:4:{s:5:”child”;a:1:{s:0:””;a:1:{s:3:”rss”;a:1:{i:0;a:6:{s:4:”data”;s:3:”\n\n\n”;s:7:”attribs”;a:1:{s:0:””;a:1:{s:7:”version”;s:3:”2.0″;}}s:8:”xml_base”;s:0:””;s:17:”xml_base_explicit”;b:0;s:8:”xml_lang”;s:0:””;s:5:”child”;a:1:{s:0:””;a:1:{s:7:”channel”;a:1:{i:0;a:6:{s:4:”data”;s:50:”\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n “;s:7:”attribs”;a:0:{}s:8:”xml_base”;s:0:””;s:17:”xml_base_explicit”;b:0;s:8:”xml_lang”;s:0:””;s:5:”child”;a:3:{s:0:””;a:7:{s:5:”title”;a:1:{i:0;a:5:{s:4:”data”;s:14:”WordPress News”;s:7:”attribs”;a:0:{}s:8:”xml_base”;s:0:””;s:17:”xml_base_explicit”;b:0;s:8:”xml_lang”;s:0:””;}}s:4:”link”;a:1:{i:0;a:5:{s:4:”data”;s:25:”https://www.ads-software.com/news”;s:7:”attribs”;a:0:{}s:8:”xml_base”;s:0:””;s:17:”xml_base_explicit”;b:0;s:8:”xml_lang”;s:0:””;}}s:11:”description”;a:1:{i:0;a:5:{s:4:”d[…]

MySQL said: Documentation
#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 ”a:4:{s:5:”child”;a:1:{s:0:””;a:1:{s:3:”rss”;a:1:{i:0;a:6:{s:4:”data”;s:3:”\n\n\’ at line 2

Any other way to extract the data from the database and recreate a new database that will not give me the above errors?

Thanks to all WP-Database gurus.

Manu