MySQL Tips

MySQL backups

Useful tutorial on the best way to make backups of your MySQL databases: MySQL backups. [...]

up ↑
software
28th Oct 2004

XML MySQL dump

When you want to make backups of your MySQL db's you can use mysqldump. Additionally you can dump it as well-formed XML, which could be handy! [...]

up ↑
software
4th Oct 2004

Storing IP addresses in MySQL

use the MySQL functions INET_ATON and INET_NTOA. [...]

up ↑
software
1st Aug 2005

Referential Integrity in MySQL

Ian Gilfillan briefly explains the concepts of referential integrity, and delves into how MySQL enforces those concepts with its definition of foreig [...]

up ↑
software
26th Aug 2003

HEAP tables in MySQL

We all know accessing data in RAM is a lot quicker than accessing data on disk. So, with this in mind, wouldn't it make sense for MySQL to store as [...]

up ↑
software
22nd Sep 2003

MySQL shortcuts

Learn some shortcuts when designing your MySQL databases. Article from Database Journal. [...]

up ↑
software
23rd Mar 2004

Repairing Database Corruption in MySQL

MySQL has some easy-to-use tools that can easily repair most cases of table corruption, and this article introduces you to these. [...]

up ↑
software
27th Jan 2004

MySQL-PHP Restriction Fears Unwarranted

Open-source database vendor MySQL recently initiated some restrictions on the bundling of MySQL libraries with the PHP scripting language ... read t [...]

up ↑
software
5th Apr 2004

UPDATE: MySQL Launches Admin Tool

MySQL teams up with JBoss and ZendThe goal is to give DBAs a way to configure servers, monitor database activity and perform backup and restore tasks [...]

up ↑
software
27th Jan 2004

Ten Questions with Marten Mickos

Marten Mickos is CEO of MySQL [...]

up ↑
software
27th Aug 2006

Free Oracle Database

If you can host it, this free Oracle database can be implemented with PHP. Try it instead of MySQL. Limited to 4Gb of data. [...]

up ↑
software
2nd Nov 2005

Import an Excel file into MySQL

After uploading the Excel file to your web space, use this SQL:load data local infile '/complete/path/to/your_csv_file.csv' into table table_namefield [...]

up ↑
programming
30th Jul 2006

MySQL tips

Categories

Subscribe