How to get wordpress db backup if i want to change my host provider? (I am not expert in mysql) Do i need to learn mysql first? Same we have static web backup?
Do you have access to your mysql through phpmyadmin? If yes you can just use that for backup. Backing up mysql will be different from normal static pages. Any idea what controlpanel are you using at present?
1) Access phpmyadmin 2) Select Export 3) Save as SQL 4) Download the file 5) Import it in your new host I just sold a blog, so thats how I know this
http://wordpress.org/extend/plugins/search.php?q=backup Shows you a number of backup plugins. The one I was refering too comes with the default Wordpress installation.