Articles posted under “ MySQL ”

by Paul Bradley, a programmer with over 20 years software development experience.

• Adding Page Titles to Analog Reports From A Custom MySQL CMS
  Sample SQL code showing how to extract page titles from a custom database, and add them to an Analog report.
• Don't delete database records, unless you really need to
  It can be time consuming having to restore a small set of records from a full database backup, because a user deleted records they wanted to keep - code your application so that it does not delete records, only marks them as deleted.
• Off Site MySQL Database Backup Service
  After two months of private beta testing, I am now in a position to offer my off-site MySQL database backup service to interested parties.
• Using MySQL's ROUND command to report file sizes in Mb
  How to us MySQL's ROUND and CONCAT commands to display file sizes in Mb
• How to backup your MySQL tables and data every night using a bash script and cron.
  This tutorial will show you how to write a simple bash shell script which will extract your database schema, compress the data and email you the backup.