Quick snippet of query to get the size of tables within a MySQL Database.
Tag archives for mysql
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…
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