mysql

Mysql database replication

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

Posted by: 
Dominique De Cooman

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

Posted by: 
Dominique De Cooman

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

Posted by: 
Dominique De Cooman

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