Where are the MySQL data files on CentOS?
They’re located in /var/lib/mysql/ Each database has a subfolder here. You’ll also find the MySQL log files here.
How to repair MySQL tables from the Command Line
Sometimes your tables crash and your website is unresponsive. You don’t have access to phpMyAdmin to do a repair, because you can’t access Plesk. That sucks! When you’re out in the field and all that’s at hand is a trusty SSH connection from your mobile, here’s an alternative way to bring your WordPress Sites back … Read more
How to restore your database?
The Database is the heart of your WordPress installation. Simply backing up and restoring all your files via FTP is not enough – it only contains the actual WordPress “programme” if you will, your plugins and themes, and all your uploaded media files (like pictures). It does NOT however contain your posts, links and some … Read more
How to move WordPress from one server to another
It’s not as difficult as one might think, as this article explains: http://codex.wordpress.org/Moving_WordPress If however this means not a lot to you, or you have tried and it’s still not working, you should check out the following topics: How to backup your Database How to restore your Database Hope this helps 😉