Error in Database Restore

[raaman rai]

Hi experts, i dumped my MySQL database and now when i restore it in another machine i cannot restore two of my tables. It restores upto some point and then stops. Both of these tables have around 700 and 200 long records. Now i dont know where the error is from.

I feel there is something wrong in my records which is creating a problem while restoring. I mean some tags or some special characters used in my records which disallows the restoration. Can i know any of such things? The error i get is ERROR 2005 (HY000): Unknown MySQL server host 'bidder' (11001).

Please enlighten me?

And recently i discovered that if i restore it through PHPMyAdmin, it works without any problem. Only when i restore it through command line i get the problem

[coolsti]

How did you dump your database? If you used mysqldump, then what you have is a simple text file. You can then look at it yourself in a text editor.

Mind, this can be difficult to do with some editors because the lines may be very very long.

But if it is just a text file, try to find the line that is causing problems and look at it. You can also just copy lines that you think are causing problems to another text file or directly to a mysql console window to debug it.

Also, if it is a text file, then try to find the bad line and post it here.