what can I do....
is there any other way to make it suit?
is there any other way to make it suit?
Dump in one Mysql server does not suit the other!
There are probably some differences (e.g. server, database name, etc.) that are getting in the way. When I switched a site from one host to another, I used a text editor to get rid of references that were specific to the old server and to change things that were different between the two servers. When I then ran the resulting file, it worked fine.
It would have been helpful if you had described the error you are getting. I had a similar issue. I removed the "DEFAULT CHARSET=latin1" at the end of "create table" statements in the dump and it worked fine for me.
Yes, you have to remove the charset thing before you can use your database on our server 
 |