Results 1 to 5 of 5

Thread: MySQL 5.0 - Possible Issue?

  1. #1

    Default MySQL 5.0 - Possible Issue?

    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. #2
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: MySQL 5.0 - Possible Issue?

    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

    Code:
    mysql mydb < previousbackup.sql
    Technology is 'stuff that doesn't work yet.' -- Bran Ferren

  3. #3

    Default Re: MySQL 5.0 - Possible Issue?

    Quote Originally Posted by vodoo View Post
    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

    Code:
    mysql mydb < previousbackup.sql
    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. #4
    Join Date
    Jan 2009
    Location
    Switzerland
    Posts
    1,529

    Default Re: MySQL 5.0 - Possible Issue?

    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.
    Technology is 'stuff that doesn't work yet.' -- Bran Ferren

  5. #5
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: MySQL 5.0 - Possible Issue?

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •