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 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

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.