Learn how to back up and validate your database backups

In this post we”ll focus on backing up our application database. Most web sites or web applications will be backed by some form of database. It is important to know how to create, query and backup your database in case anything happens to your data and you need to restore it. It’s also important to …

Continue reading ‘Learn how to back up and validate your database backups’ »

Interesting tech things found this week

Because its Friday, just some interesting things I found during the week that might be worth a look: mySQL Dumper, http://www.mysqldumper.net/ – a PHP and Perl based tool for backing up MySQL databases. You can easily dump your data into a backup file and – if needed – restore it. IMDB (Internet Movie Database) API …

Continue reading ‘Interesting tech things found this week’ »

How to export from MSSQL 2005 and import in to mySQL

I’m writing this mainly as a guide to myself in case I need to do this again in the future. I had to do this last year too, it was a headache each time to find an approach that worked. My goal is to copy the tables and data from a Microsoft SQL Server database …

Continue reading ‘How to export from MSSQL 2005 and import in to mySQL’ »