Title: Importing into New Database (SQL) Error.
Last modified: August 20, 2016

---

# Importing into New Database (SQL) Error.

 *  [NativeVoiceTV](https://wordpress.org/support/users/nativevoicetv/)
 * (@nativevoicetv)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/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:”[http://wordpress.org/news&#8221](http://wordpress.org/news&#8221);;
   > 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

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [F C](https://wordpress.org/support/users/pmagony/)
 * (@pmagony)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/importing-into-new-database-sql-error/#post-3559670)
 * Did you ever get this resolved?
 *  Thread Starter [NativeVoiceTV](https://wordpress.org/support/users/nativevoicetv/)
 * (@nativevoicetv)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/importing-into-new-database-sql-error/#post-3559671)
 * No.
    Its seems that someone with sql database knowledge can correct the error,
   for me its a foreign language. But with time I think I can learn it. Thanks. 
   Any help that will prevent these errors and get the data out and placed in a 
   new database file will be helpful to me and others.
 * Thanks.
    Manu

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Importing into New Database (SQL) Error.’ is closed to new replies.

## Tags

 * [Import](https://wordpress.org/support/topic-tag/import/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [NativeVoiceTV](https://wordpress.org/support/users/nativevoicetv/)
 * Last activity: [13 years, 1 month ago](https://wordpress.org/support/topic/importing-into-new-database-sql-error/#post-3559671)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics