Error SQL query: -- MySQL dump 8.23 -- -- Host: localhost Database: databaseRR ------------------------------------------------------- -- -- Server version 3.23.58 -- -- Table structure for table `access` -- DROP TABLE IF EXISTS `access` ; MySQL said: #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 '--------------------------------------------------------- -- Server version 3.23' at line 1 any ideas why the database won't import?
Likely the cmd line is too long, remove all the comments before the CREATE TABLE. I had the very same problem when I moved some vB databases from an old 3.x.x MySQL to a new 5.x.x one. For me it was already enough to just delete the comments before the first actual SQL statement.
Sounds awefull familiar.... I had to tweak some field settings (mostly lenghts) and "enable" the "can be NULL" manually afterwards for almost all fields....
