MySQL 5.0 - Possible Issue?

English Applications
#1

I currently backup my database using MySQL Administrator.

I wanted to test out restoring the database, so on my test server I deleted the database and restored the .sql file to a new schema with the same name as the old. one. It appears to complete the process just fine. But I noticed that the number of rows for the restored database is slightly less than what was backed up.

Is this normal or should the numbers be exactly the same?

It’s only a difference of about 28 rows. I seem to be able to view the data just fine in the query tool.

#2

They should be identical. Exactly the same number of rows. There’s something odd here.

Try a backup with mysqldump from the command line and restore to a different database with

mysql mydb < previousbackup.sql
#3

I tried it this time with mysqldump. Now it restores the correct number of rows. But DATA LENGTH and INDEX LENGTH are still under by only a little bit. Is that still not ok?

#4

But DATA LENGTH and INDEX LENGTH are still under by only a little bit. Is that still not ok?

Do you mean that the size of the data and index files is not the same as before? That’s ok.

#5

I’ve never had a problem using mysqldump but, as you are still using 5.0, be aware when you come to update that the default language has changed; so you will need to add the relevant language commands to your backup or restore to ensure that you don’t run into any problems after an update.