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 INTOwp_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”;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