Restore Issues

Comments

2 comments

  • Avatar
    Jason Mallory

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

    0
    Comment actions Permalink
  • Avatar
    Ashraf Sharif

    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.

Powered by Zendesk