Tag Archives | mysql

MySQL replication

More brain dumping, this time after setting up MySQL on my test server to replicate offsite as the data on there is becoming important. To start with both machines are running fully updated and upgraded Debian Etch and MySQL 5 as a Debian package with identical copies of the MySQL databases in /var/lib/mysql/. On the [...]

Continue Reading

Nightmare MySQL migration

I've been migrating a large number of websites over from one server to another, always an enjoyable task. So I get to the last one, copy the database over and do the normal mysql import along the lines of: [code]mysql -ufoo -pbar database_name < database_name.sql[/code] Errors++ Turns out the Donke^H^H^H^HDeveloper who built the application didn't [...]

Continue Reading

MySQL Workbench

I just downloaded MySQL workbench 1.06 beta. I stumbled across it after finding this message on the DBDesigner forum page: Dear DBDesigner4 users, Due to several attacks against the DBDesigner4 forum it has now been closed down. We simply cannot understand the sick motivation of people to attack Open Source projects. So please understand that [...]

Continue Reading