Here’s a cheap ass script to tar up and dump all of your MySQL databases to separate files using the Debian system maintenance account. Sure there’s plenty of room for improvement here, but hey, it gets the job done and is perfect for a midnight cron job.
Based off of this with a few of my own customizations.
Continue reading “Bash Script – Backup All Databases to Separate Files”
Pieced together from various tutorials on the web with a lot of my own additions, here is a snippet of SQL that will alter or convert all tables in a database from “MyISAM” to “InnoDB”. As long as your MySQL user account has privileges to create stored procedures, all you have to do is simply edit the @DATABASE_NAME variable at the top of the script and run it in PhpMyAdmin if you’ve got it. Enjoy! Continue reading “MySQL Script – Alter/Convert All Tables in a Database from MyISAM to InnoDB”