Question

Restore big mysql

Posted July 31, 2013 2.3k views
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?

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.

×
3 answers
After you installed MySQL, did you activate it with this command?:
sudo mysql_install_db

and afterwards run the MySQL set up script?:
sudo /usr/bin/mysql_secure_installation
hmm no,
i just follow this one https://www.digitalocean.com/community/articles/how-to-install-phpmyadmin-on-a-lemp-server/

just work on small database, but not for large >700mb
or wait let me check first if the db got error/corrupt im afraid :/
My bad, my big db corrupt, all fine :D
Submit an Answer