Restore Issues

Follow

Jason Mallory

• June 30, 2015 15:29

Cannot get a restore to work. This is a production system and needs to be addressed somehow:

 

mysql -u root -p db_old < dblatest.sql
Enter password:
ERROR 1047 (08S01) at line 66749: Unknown command

0

• 

  Jason Mallory

  • June 30, 2015 15:32

  This always happens and varies on the line the error appears. I have tried multiple times

  0

  Comment actions Permalink
• 

  Ashraf Sharif

  • June 30, 2015 16:27

  Hi Jason,

  You could try this:

  mysql -u root -p db_old --max_allowed_packet=1024M < dblatest.sql 

  The command will increase the maximum packet size to 1G. Ensure you have sufficient memory beforehand. If it still fails, try to examine the failing line:

  awk '{ if (NR==66749) print $0 }' dblatest.sql >> line66749.sql
  cat line66749.sql

  Regards,

  Ashraf

  0

  Comment actions Permalink

Please sign in to leave a comment.