If you have to install Microsoft SQL Server 2000 on Windows 7 you’ll find that Windows Sync Center automatically starts at Windows startup. Opening Sync Center will show that Microsoft SQL Server 2000 has been automatically added and cannot be deleted. To remove this sync partnership you need to edit the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SyncMgr\Handlers Find [...]
Running PHP on a Windows 2003 Server and connecting to Microsoft SQL Server 2000 Service Pack 4 we found that sometimes the PHP script could connect to the SQL Server but most of the time we’d get ‘mssql_connect() unable to connect to server’. After Googling the problem I found a lot of references to needing [...]
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 [...]
One issue I’ve found using Microsoft Access as a front end to MySQL is that when running an update query I often got an error saying the record was not updated due to a lock violation. It turns out if the data Access is updating is the same as the existing values then it gives [...]
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 [...]