I have been having this small but very annoying problem for about a few months now since I switched from 3.5.4. I have started backing up my database for a long time ago, and i never had this problem.Whenever I do an import, it always gives this error:
Code:
Error at the line 5177: /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
MySQL: Variable 'sql_mode' can't be set to the value of 'NULL'
The code that corresponds to that portion is the LAST line of code in my .sql file. Even though MySQL gives this error and stops, it still imports the data all the way until the last line so it works. But its quiet annoying to get this error.
Last a 7 lines of my SQL file is always this:
Code:
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;