Tables of MySQL couldn't be restored

[northcloud]

I have backed up my DB from my first server (saved in a .sql file). When I tried to restore it in another DB on my second server (executing sql statements in .sql file), there are many errors stopping to execute sql insert statements. I don't know if these errors will effect my system on first server. Will these error may crash my system? Does anyone know the answers? Thank in advance in help.

[AstroTeg]

The errors are insert errors. They don't directy effect the first server. Although it is possible if you were to try restoring these sql files on the first server, you may or may not get the errors.

My first thought would be you have a versioning problem between servers and the first server generated a file that doesn't want to play nicely on the second server.

[northcloud]

Thanks, AstroTeg. MySQL version on my first server is 3.23.58 and is 4.0.22 on second server. A futher question. The database on my first server is huge. Most data (they will take 80% I guess) are documents which are used in the system, not system's data. I don't need to backup those docs often. I am thinking I may split the DB to 2 , one for docs, another one for system's data. I only backup system's data regularly and backup the DB with Docs not very often. But I am not sure it is possible to execute a query crossing multiple tables in 2 DB and how is the performance. Which one is better design, put all data in one huge DB or seperate them?