Please tell me. I want to move my blog to another host. ItÅ› just piece of shit that many hosting companies do not stand by their promise of uptime. Finally I have got one good. Host. Please tell me the step by step procedure to do that. thanks
1. Download your whole blog folder by FTP to your hard drive. 2. Go to phpMyadmin and backup all the tables in your database. 3. Go to your new host and create a database for your blog with the same name and the same password for user. 4. Upload everything to your new host. 5. Import all the tables to your new database. 6. You're done. PS Don't forget to modify your DNS.
If you want to move the whole site and both hosts (old and new) use cPanel, you can make a backup of your site (from cPanel) and then import it to your new host. Usually a new host is offering this service, ask to your new host support, you just need to provide your cPanel account info and they will take care everything. Sorry if you had already known this method though Otherwise do as r3born said. There are 10 WordPress tables normally (if there's no plugins etc which add more tables).
A follow-up on r3born's post. Lastly, edit your wp-config.php file to reflect your new host's username, password and db. Tables are generated during WP installation. All you need to do is select your database and hit export.
Be sure to have two copies running at the same time (the old site and the one on the new server). Test the new one to make sure it works before changing the DNS.