Tag archives for mysql

  1. Ahhh, smell the newness

    So about a week ago I switched hosting providers for this and 17 other personal low-traffic sites. In the process I took the chance to get familiar with Nginx, MariaDB, AWS EC2 Instances & EBS Volumes, and Capistrano. It was a great exercise, and surprisingly it worked on the first go! (at least for the…

  2. MySQL – dumping extremely large databases

    Spent a bit of time figuring this one out… If you’re going to need to dump a very large mysql database, you’ll probably need to use “–single-transaction” to make it work. mysqldump -u [username] -p –single-transaction [database name] > [your dump file].sql