Restore big mysql

July 31, 2013 2.1k views
rokokkopi
By:
rokokkopi
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?
Log In to Comment
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
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
rokokkopi August 1, 2013
My bad, my big db corrupt, all fine :D
Reply
Have another answer? Share your knowledge.