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.
My bad, my big db corrupt, all fine :D
hmm no, <br>i just follow this one https://www.digitalocean.com/community/articles/how-to-install-phpmyadmin-on-a-lemp-server/ <br> <br>just work on small database, but not for large >700mb <br>or wait let me check first if the db got error/corrupt im afraid :/
After you installed MySQL, did you activate it with this command?:<pre>sudo mysql_install_db</pre><br/>and afterwards run the MySQL set up script?:<pre>sudo /usr/bin/mysql_secure_installation</pre>