A Problem Shared . . .

A blog of problems . . . and solutions

Entries Tagged ‘MySQL’

Losing data on MySQL SQL restore

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:
           [...]

Step by Step MySQL Replication

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 [...]

MySQL remote connection problems

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 [...]

MySQL System Tray Monitor and Windows Vista

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 [...]