I am having issues with the columns_priv table in the mysql system database. I cannot add new users currently. I have tried repairing it using mysqlcheck --auto-repair --all-databases --password but ...
We have an issue where a database hangs the server when: a backup is performed (Hangs on a specific table) selecting * or count(1) from a specific table or viewing data that is related to the table ...
Yesterday I dumped my MySQL databases to an SQL file and renamed the ibdata1 file. I then recreated it and imported the SQL file and moved the new ibdata1 file to my MySQL data directory, deleting the ...
I am running several different Firebird versions (2.0, 2.1) on multiple entry level Windows-based servers with wildly varying hardware. The only matching thing between them is that they are running ...
My previous team member “replicated” a database on a server onto another server. But now it's not in sync anymore
Database 1 is a regular database server. He replicated it to Database 2...a direct clone. Master-Master. They are in "sync" all the time. They each have 40 million rows. Today, Database 2 is ...