Restore big mysql

  • Posted July 31, 2013

Im follow all guide Install nginx, MySQL, PHP (LEMP) stack on Ubuntu 12.04 and all goes well. from

but error trying to restore dump mysql about 800mb sql running: mysql -p -u root db_name_here < databasenamehere.sql got timeout and try editing /etc/mysql/my.cnf max_allowed_packet = 1G

now i got “killed” after try to restore

any problem or how to solve this?


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

My bad, my big db corrupt, all fine :D

hmm no, <br>i just follow this one <br> <br>just work on small database, but not for large >700mb <br>or wait let me check first if the db got error/corrupt im afraid :/

After you installed MySQL, did you activate it with this command?:<pre>sudo mysql_install_db</pre><br/>and afterwards run the MySQL set up script?:<pre>sudo /usr/bin/mysql_secure_installation</pre>