1

I am trying to restore a mysql dump file for a wordpress site.

I am using mysql Ver 14.14 on ubuntu 16.04

I tried this command as I have used it before with different projects

$ mysql -u USER -p NEW_DATABASE < DUMP_FILE.sql

I am getting this error after prompted for password

ERROR 1064 (42000) at line 944: 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 ''a:406:{i:0;a:7:{s:4:\"slug\";s:15:\"general_options\";s:6:\"parent\";s:15:\"gen' at line 1

Lelio Faieta
  • 6,457
  • 7
  • 40
  • 74
Ibrahim
  • 11
  • 1
  • How did you acquire the dump file? in what version of mysql? – Nae May 23 '19 at 16:29
  • Can you try this syntax:mysql -u username -p[yourpassword] database_name < dump.sql – Aress Support May 23 '19 at 17:49
  • I acquired the dump file using - mysqldump -u [uname] -p[pass] db_name > db_backup.sql - the dump file was created last year but I don't know the mysql version. – Ibrahim May 24 '19 at 02:04
  • using syntax:mysql -u username -p[yourpassword] database_name < dump.sql - generated same error. – Ibrahim May 24 '19 at 02:05

0 Answers0