MySQL Takes Time to Load

[icywind]

Hi x10Hosting,

The title itself, this is the issue I've observe for couple of weeks of using your hosting server. I'm in Lotus server.

Please help! Having some issues on my site, like loading MySQL also can't backup(export) MySQL database to my computer because it takes time to load in phpmyadmin. Gives me approximately 15 mins or longer to do it and let say it only for waiting.

Thanks for fast solution!

 

[xav0989]

It has been reported that the mysql dump function in phpmyadmin is slow to load. What I do is that I do not export as a file, but as regular SQL, copy it and save it to a file manually. You can also try creating a php script that exports it for you, it will probably be somewhat faster.

- xav0989

 

[icywind]

I don't know what script should I use for it.

 

[Christopher]

Hello,

http://www.tufat.com/s_mybackup_web_database_exporter.htm is a good script to backup databases with.

 

[icywind]

yeah! I've try it out! Working like a fresh cookies!