Most hosts have phpmyadmin installed, so it is very easy.

Check out this link (first google result for 'phpmyadmin import export')

Import and export databases using phpMyAdmin - TechRepublic

If you are using wamp server you can use phpmyadmin to take backup of the database, You can export it to sql file and later you can import it.

You have many choices, if you are using Wordpress you can install a plugin and voilà, you have an instant snapshot of your whole database or chosen tables ready for download.

Of course as Andrew H and webzie mentioned you can always perform a MySQL dump from within phpMyAdmin.

You also have a plethora of online services and software to make the backup easier and even automatic.

Greatest of luck

You can use Xcloner There's a plugin for WordPress, or it has a stadalone program.

Thats a stuff one to do my friend send me a PM I (THINK) I may have a tutorial for you.

WILL -

As was said previously PHPMyAdmin is the simplest way of doing this. It is generally installed on most shared hosts.

If you are using a VPS you can either do a mysqldump via SSH or install PHPMyAdmin and continue through that.

PHPMyAdmin allows you to download your MySQL database, and upload an existing backup file. All from within your browser.

If you have any questions, feel free to send me a PM.