Category Archives: MySQL

Disable anything that will write to the database Update the my.cnf files for all servers to support circular replication, by adding log-slave-updates and ensuring you have unique server ids and the auto increment values are suitable. Then restart mysql to pick … Continue reading →

After experimenting a bit with MySQL locking today, I thought I’d make a note of what I’d discovered: To create a lock, you need to use: LOCK TABLES table1 [READ |WRITE], table2 [READ |WRITE] READ is used to stop other people … Continue reading →

If you find that after rebooting your MySQL slave it stops replicating with the master and you see the “Failed to open the relay log” error in the logs it is probably caused by MySQL putting it’s relay logs in … Continue reading →

load data local infile ‘export.csv’ into table table_name fields terminated by ‘,’ enclosed by ‘“‘ lines terminated by ‘n’ (field_list)

update [table_name] set [field_name] = replace([field_name], ‘[string_to_find]’, ‘[string_to_replace]’); Replace within a field

Make sure that expire_logs_days is set to ensure that log rotation takes place