rokokkopi
By:
rokokkopi

Restore big mysql

July 31, 2013 1.7k 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?
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
Have another answer? Share your knowledge.