Hello, I need to move mysql db (content ) fro one host to anther. can some one will share some ideas?
How big is it? If it isn't huge you can download it from your server in zipped format then upload it again using phpmyadmin to the new host. If it's a bigger dB you can download it in zipped format then upload it to the root area of your site and use Big Dump to import it to MySQL.
Just to add on to what has already been said (as they've covered the basic idea). When you zip up your database (or simply export it into the .sql file), the best way to transfer it to the new host is through SSH as you can avoid your slow downtime and uptime speeds, and use your fast server speeds. (On the new host from the directory you want it to appear in, via SSH): wget "http://www.url.com/db.sql" Saves me hours, as I move files back and forth all the time. Residential upspeeds suck.