mysql acts strange

OK ... I have a mysql db on one server (running mysql 3.23.40) that I've already made the dump for--mysqldump -uuser -ppassword dbname > dbname.sql.

FTP it to different server (running mysql 3.23.37) and tried to un-dump this db ... so I did mysql -uuser -ppassword dbname < dbname.sql ... Immediately I get this error:

photon:/var/lib/mysql/db_name# ERROR 1050 at line 11: Table 'some_table' already exists
Never had that one before ...

So, I went to the db directory, remove all the file (Deleting all the tables) ... and tried to redump mysql (Again with mysql -uuser -ppassword dbname < dbname.sql. Now I got this error ...

photon:/var/lib/mysql/db_name# ERROR 1062 at line 22: Duplicate entry '5-42' for key 1
So ... I drop and re-create the db (using drop/create database ) and tried to redump the db again ... Now it works, but ... it does not dump all of the tables .... It just stops after db_table name starting with "p" or something ... Out of the 160MB of total db I am dumping, I only get 110MB .... Also, using sqldump, I got 204 MB of file for dumping this 160 MB db. Is this normal that you gained about 30% in size while you are doing the dump?

So anyway, what is going on? Anybody knows? Does the version differences cause all the problems?

cheers,
mysql acts strange

 

 

 

 

Top