We wanted to have a common MySQL DB instance for Development purpose.
so we took a dump of the data and moved it to the server using the below procedure.
It does load the data, but the problem now is the response time which is very slow.
server time for operations which usually took .5 sec take up to 22 sec now.
*server doesn’t have xamp installed, but uses MySQL manager ver 5.2.
any idea why this occurs?