MySQL version 4 - please also tag with mysql for search purposes.
Questions tagged [mysql-4]
4 questions
5
votes
1 answer
Dump with special characters in table column name
I'm taking over an old database, and while doing recovery tests from my dump I found out a table is wrongly backed up, the table definition is truncated.
Looking at the live db I've found a column name with special character in the name. That is the…
Maxxer
- 201
- 1
- 10
2
votes
1 answer
Is there an easy way to update a mysqldump file from version 9.11 to 10.11?
We have a client that has had their servers for soo long, they were still running MySQL 4.0.24.
Now that they are refreshing their servers, we took a mysqldump of their current database to put into the new servers and are getting errors like:
ERROR…
B.Kaatz
- 141
- 7
0
votes
2 answers
How can we check for data integrity when we upgrade from MySQL 4.1 to MySQL 5.5?
By data integrity, I mean:
Schema integrity
Data (record level) integrity
Checksum was an option, but since the storage format for some data types in MySQL 5.5 has been changed, it won't be reliable.
Another option is to parse the XML file…
bin
- 13
- 1
- 4
0
votes
1 answer
Regularly clone/backup 2 MySQL databases unidirectionally from PC to Laptop both running Windows
I have a PC running Windows XP with a custom ERP system and MySQL Server 4.x (A) and a Laptop running Windows 10, same MySQL 4.x and same custom ERP (B). I'm afraid I can't upgrade PC nor MySQL, etc. Can't touch anything.
I installed SQLYog Ultimate…
Enrique
- 123
- 4