Tag Archive: mysql

Jul
31

Mysql Update Turns On Binary Logging

debian

I recently ran an apt-get update on my Debian Etch server as I wanted to install pSpell for php. I found that the apt repros were out of date. After and Internet search I found that they have been archived. This is worrying that the OS that I am running is now seemingly obsolete but …

Continue reading »

Oct
27

Backing Up Mysql Databases On A Cron

With all the websites that I run, keeping backups is essentail. I first wrote a bash script that I ran on a cron job whcih backed up each database and then zipped the sql file up: #!/bin/sh mysqldump -uroot -ppwd –opt db1 > /sqldata/db1.sql mysqldump -uroot -ppwd –opt db2 > /sqldata/db2.sql cd /sqldata/ tar -zcvf …

Continue reading »