Around fifteen months ago, the open source community was very happy to hear that Sun Microsystems had just purchased MySQL, and the worlds most popular database was in very good hands. More »
As part of regular ongoing database housekeeping, you should repair and optimise your MySQL tables on a regular basis. More »
Dynamic database driven websites are great. You just add your content and the website software grabs that content from the database, applies all the necessary formatting and displays it nicely and consistently to the user. More »
Although I don’t spend a lot of time doing any type of relational database administration, occasionally I get asked to find duplicate records in tables. More »
If you’re a software developer, string concatenation is something you do regularly, irrespective of the programming language you use. More »
When putting together dynamic web applications in an ASP environment, developers use ADO recordsets for the overwhelming majority of their database interfacing. More »
For those of you lucky enough to have Linux shell access here’s a quick tip for backing up and restoring your MySQL database: Backup: mysqldump -u username -p –opt databasename | gzip -9 > dumpfilename.sql.gz Restore: gunzip dumpfilename.sql.gz mysql -u username -p databasename < dumpfilename. More »