Power up with new SaaS Add-Ons from the DigitalOcean Marketplace

Question

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 https://www.digitalocean.com/community/articles/how-to-install-linux-nginx-mysql-php-lemp-stack-on-ubuntu-12-04

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?

Subscribe
Share
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.

rokokkopi • August 1, 2013

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

rokokkopi • July 31, 2013

hmm no, <br>i just follow this one https://www.digitalocean.com/community/articles/how-to-install-phpmyadmin-on-a-lemp-server/ <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 :/

pablo • July 31, 2013

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>