Title: Migration WordPress Database Error
Last modified: August 30, 2016

---

# Migration WordPress Database Error

 *  [giusti.simone](https://wordpress.org/support/users/giustisimone/)
 * (@giustisimone)
 * [10 years, 6 months ago](https://wordpress.org/support/topic/migration-wordpress-database-error/)
 * Hello, i have 2 web site developed in WordPress. Now i have a problem: i must
   migrate server for this 2 website (no domain change, only migrate hosting).
 * I have dumped database from old hosting via phpMyAdmin. In new hosting (VPS self-
   managed) i have imported dump.sql in new database using phpMyAdmin… but i have
   many problem with import.
 * During import phpMyAdmin fails with many errors like following:
 *     ```
       Ending quote ' was expected. (near "" at position 1440)
   
       #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:43:{s:18:"animate_speed_hide";s:3:"500";s:18:"animate_speed_show";s:3:"500";s' at line 1
       ```
   
 * I have isolated one single query that fails (there are many other!):
 * `INSERT INTO`wp_options` VALUES(324, ‘CookieLawInfo-0.9’, ‘a:43:{s:18:”animate_speed_hide”;
   s:3:”500″;s:18:”animate_speed_show”;s:3:”500″;s:10:”background”;s:4:”#fff”;s:
   14:”background_url”;s:0:””;s:6:”border”;s:4:”#444″;s:9:”border_on”;b:1;s:13:”
   button_1_text”;s:7:”Accetto”;s:12:”button_1_url”;s:1:”#”;s:15:”button_1_action”;
   s:27:”#cookie_action_close_header”;s:20:”button_1_link_colour”;s:4:”#fff”;s:16:”
   button_1_new_win”;b:0;s:18:”button_1_as_button”;b:1;s:22:”button_1_button_colour”;
   s:4:”#000″;s:20:”button_1_button_size”;s:6:”medium”;s:13:”button_2_text”;s:17:”
   Maggiori dettagli”;s:12:”button_2_url”;s:37:”[https://www.webfilla.it/cookie-policy&#8221](https://www.webfilla.it/cookie-policy&#8221);;
   s:15:”button_2_action”;s:17:”CONSTANT_OPEN_URL”;s:20:”button_2_link_colour”;s:
   4:”#444″;s:16:”button_2_new_win”;b:1;s:18:”button_2_as_button”;b:0;s:22:”button_2_button_colour”;
   s:4:”#333″;s:20:”button_2_button_size”;s:6:”medium”;s:11:”font_family”;s:7:”inherit”;
   s:10:”header_fix”;b:0;s:5:”is_on”;b:1;s:19:”notify_animate_hide”;b:1;s:19:”notify_animate_show”;
   b:0;s:13:”notify_div_id”;s:20:”#cookie-law-info-bar”;s:26:”notify_position_horizontal”;
   s:5:”right”;s:24:”notify_position_vertical”;s:6:”bottom”;s:14:”notify_message”;
   s:169:”Il nostro sito fa uso di cookie per offrire una migliore esperienza di
   navigazione. Continuando la navigazione autorizzi l\\”uso dei cookie. [cookie_button][
   cookie_link]”;s:12:”scroll_close”;b:0;s:19:”scroll_close_reload”;b:0;s:20:”showagain_background”;
   s:4:”#fff”;s:16:”showagain_border”;s:4:”#000″;s:14:”showagain_text”;s:24:”Privacy&
   Cookies Policy”;s:16:”showagain_div_id”;s:22:”#cookie-law-info-again”;s:13:”showagain_tab”;
   b:0;s:20:”showagain_x_position”;s:5:”100px”;s:4:”text”;s:4:”#000″;s:17:”use_colour_picker”;
   b:1;s:12:”show_once_yn”;b:0;s:9:”show_once”;s:5:”10000″;}’, ‘yes’);
    `
 * Where the problem is? If i upload dump.sql in some server (like localhost) import
   works fine and all go right, in some other server, like new VPS, import fail 
   because single query inside dump fails.
 * Previous query stop failing if i change `l\\''uso` to `l\'uso`… but the point
   is not this. I can’t manually change thousand error in import file!
 * I ask your help for know what to change to make importable same dump.sql file
   in every mysql server.
 * Have you any experience? Can you help me, please?
 * Best Regards,
    Simone

The topic ‘Migration WordPress Database Error’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [dump](https://wordpress.org/support/topic-tag/dump/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [giusti.simone](https://wordpress.org/support/users/giustisimone/)
 * Last activity: [10 years, 6 months ago](https://wordpress.org/support/topic/migration-wordpress-database-error/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics