mysql

Mysql database replication

Overview on Mysql database replication.
http://dev.mysql.com/doc/refman/5.0/en/replication.html

Wednesday, March 16, 2011 - 14:54
Read more
mysql
Posted by: 
Dominique De Cooman
On: 
Tue, 2009-12-01 22:00

how to run multiple drupal installations on a single database

This is the situation:
You have two drupal sites with each a database. Your hosting allows only one database.
This is your solution:
Prefixing!

Read more
mac
mysql
xampp
Posted by: 
Dominique De Cooman
On: 
Mon, 2009-06-01 22:58

MAC OS Xampp Mysql #1153 - Got a packet bigger than 'max_allowed_packet' bytes

When installing a xampp on mac os Mysql could throw an error #1153 - Got a packet bigger than 'max_allowed_packet' bytes
Solution : Extend the max_allowed_packet size located in Application/Xampp/xamppfiles/etc/my.cnf

On windows systems the file is called my.ini
On linux systems it is also my.cnf

Read more
drupal6
mysql
Posted by: 
Dominique De Cooman
On: 
Wed, 2009-04-29 22:59

Solution in case db_last_insert fails on you because LAST_INSERT_ID() is giving 0

Problem: You want to know the next id for the nodes. According to drupal you should use db_last_insert('table', 'field'). It returned allways zero for me.

What is the solution to overcome this problem? use SHOW TABLE STATUS WHERE Name='node' in the returned object you 'll find the next value for the autoincrement.

Subscribe to mysql