Database migration issue

Hi,

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.

link

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.

note:
*server doesn’t have xamp installed, but uses MySQL manager ver 5.2.

any idea why this occurs?

Thanks,

vishal

Hi vishal,

Given that you only moved the database to another server, you should be investigating network performance and mysql performance and perhaps looking for help on MySql forums. This is unlikely to be an application issue.

Kind Regards,

Bruce