Archive for the ‘MySQL’ Category

MySQL - Change the table types to INNODB!

Thursday, May 8th, 2008

MySQL databases:

mysam locks at table level - rubbish and has a performance hit.

Change to innoDB for row level locking! This should be the default!

ALTER TABLE table_name ENGINE = INNODB;

Posted in MySQL | No Comments »

Managing Hierarchical Data in MySQL

Wednesday, February 6th, 2008

http://dev.mysql.com/tech-resources/articles/hierarchical-data.html

Posted in MySQL | No Comments »

MySQL

Wednesday, June 20th, 2007

Using a file to insert data on the command line:
cat directory/filename.sql | mysql -u user_name -p database_name

Posted in MySQL | No Comments »