I recently had to backup and restore a MySQL database so I dumped the whole database into a SQL file but when I came to restore I found that in one of the biggest tables a lot of the data was missing.
Looking at the warnings when I ran the restore query I found I had:
[...]
Here’s a quick checklist on how to setup replication.
http://docs.hp.com/en/5991-7432/ar01s05.html gives more information.
First on the master server’s my.cnf or my.ini file comment out these lines:
#skip-networking
#bind-address = 127.0.0.1
Then in the [mysqld] section add:
log-bin=mysql-bin
server-id=1
Then restart MySQL with
/etc/init.d/mysql restart
Now create a user on the master that the slave can use to connect:
GRANT REPLICATION SLAVE ON *.* TO ’slave_user’@’%’ IDENTIFIED BY ‘<SOME PASSWORD>’;
GRANT [...]
I’ve been experimenting with running MySQL on different operating systems and LAMP/WAMP/OAMP platforms and as I always wanted to connect to the database server from a PC on my LAN I have kept coming across connection errors.
So far I’ve figured out that the following steps fix most of the connection issues. I should say that [...]
I’ve installed MySQL server on Windows Vista and installed the MySQL GUI tools. I found a problem with the MySQL System Tray Monitor though – it seemed unable to stop, start or restart the MySQL service and would not allow me to save any changes I made to the MySQL instance configuration. Whenever I tried to [...]