MYSQL SSH dump problem

2025-04-14

I earlier dumped a phpbb forum, (mysqldump --opt -u username -p database > file.sql) although I could not seem to then restore it using mysql -u username -p database < file.sql to another account on the same server.

It always would output this error

ERROR 1064 at line 568: 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 '
by varchar(100) NOT NULL default ''
) TYPE=MyISAM' at line 5

The only way I could get it restored was by a full account backup.

Other phpbb forum mysqldumps work no problem just this one account