Question

Restore big mysql

Posted July 31, 2013 2.2k 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?
Add a comment
rokokkopi
By:
rokokkopi
Add a comment

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
pablo July 31, 2013
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
Reply Report
rokokkopi July 31, 2013
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 :/
Reply Report
rokokkopi August 1, 2013
My bad, my big db corrupt, all fine :D
Reply Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help