HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

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
extracted it,
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
Enter password:
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
Table: User
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?

Sign In or Register to comment.