I have 9 databases in MySQL that need to be backed up, so I wrote a bash script that: Creates folder /backups/SQL_BACK-yymmdd For each of the databases, uses mysqldump to generate a backup file (in the above folder) named dbname-yymmdd.sql. After completing for all the databases, then generates a tar.gz of the folder. The compressed… Continue reading Backing Up MySQL
Tag: webdev
Initial Setup
I used Softaculous for a quick clean install of D7. A simple copy from backup of various directories (gallery, images, sites) plus the .htaccess file allowed quick setup of the gallery (unharmed in my database debacle) and the site banner image. Overnight, a bunch of jerks tried setting up logins for the site, but they… Continue reading Initial Setup
Rebuilding the Site
A few weeks ago I taught myself another lesson on the need for backups when I deleted the MySQL database behind this site. No backup, no database, no site. So, in parallel with rebuilding the site, I am also writing a set of cron routines that will use mysqldump to make scheduled copies of all… Continue reading Rebuilding the Site
Upgrade to drupal 7
Drupal 7 came out months ago. I’ve been waiting to see if any issues came up, but I think I’ve waited long enough. Drupal 7 comes with a detailed Upgrade.txt file plus lots of online documentation to supplement it. That said, it looks like there will be a fair amount to consider, so I will… Continue reading Upgrade to drupal 7