Error during importing a mysql database from 5.6.34 to 5.7.x

user_17687167 0
Viewed 285

I am importing a .sql file using MySQL WorkBench but getting an error for syntax. The sql file was obtained from a DB running 5.6.34 and new one is running 5.7.2.09.1. Here is the screenshot of the error.

ERROR 1064 (42000) at line 11347: 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 'DEFINER=`psx360`@`localhost` SQL SECURITY DEFINER */

workbench mysql
1 Answers

Open the .sql file with your code editor such as vscode, then search and replace (like press CTRL + H) DEFINER=psx360@localhost SQL SECURITY DEFINER with blank value in the replace textbox. ie deleting all the occurence.

user_90773470
Related