An I.T. 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 […]

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

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

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