Mismatched counts after backup to a staging server.

[istream]

Hi,
Most recently, I backed up my production database (MySQL) and restored to my staging server. Restore was on a clean empty testlink (MySQL) database.
I was hoping to see everything exactly the same as production (up to the time when I backed up the dB). However in my project-->Metric Dashboard,
the numbers (active test cases etc.) reported are different than one on the production. The test cases (total, pass, fail..) in Execution, test cases associated with platforms etc. are same as production.

Any hints as to where should i be looking. I double check the testlink configuration files etc. looked ok.
Thanks

[GunnarD]

How did you do backup?

Did you use mysqldump?

[TurboPT]

Was the production server still in use during the backup?

[istream]

The server was pretty much idle. The production is running RH Enterprise 5.5 and Staging server is running Ubuntu 10.04 LTS. Both platforms running mysql 5.1.50.
Thx

[fman]

1. you have not provided figures i.e. amount of differences: 10 items, 100 items ?
2. Server pretty idle is not enough, you have to be certain 100% than NOBODY is working on TL

[istream]

Hi
Where can i paste the screenshots (production versus staging), if i have to?
IDLE=NO TL USERS at the time.
thx

[GunnarD]

Mysqldump should get everything from your database.

You are sure that nobody has used/updated your productions server after you used mysqldump?

A simple test should be to do a new mysqldump and compare the two using diff.

[istream]

Where can i upload the screenshots, showing numbers from the databases.

[fman]

Upload it on google drive or something like that and provide links.
Anyway this is not going to solve nothing. Best thing you can do is start from scratch
1. prevent ay access to TL (may be stopping web server)
2. be sure no custom procedure (i.e. developed on you company) change the DB
3. backup db
4. import on new fresh empty db
now you can compare