importing the text dump impossible due to comments
i exported a phpbb3.2 forum with the vanilla porter.
i got a nice export.txt.gz
and tried to import the 40Mo file with the command line into my "test" database:
mysql -uroot -p test < export_forum_2016-12-31_054650.txt
ERROR 1064 (42000) at line 1: 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 '// Export Started: 2016-12-31 05:46:50
UserID:int,LastIPAddress:varc' at line 1
but the interpreter bugs upon the comments in the import file, it does not understand it and blocks the import.
// Exported Table: Role (13 rows, 00:00.00)
how could i make it work?