Hello guys. I need little help here. I want to save my site database because I want to move my site to another host but the thing is. I dont have any idea how to do it? Help would be really appreciated. Thanks

You have to use a tool for that.
Guessing that you use mysql, it can done by phpMyAdmin, or the mysqldump utility.
http://www.ehow.com/how_2036600_crea...abase-php.html
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Which database do you use?

You can backup your mysql from the phpmyadmin. Most hosts provide it from the control panel. If not, you can use mysql administrator application to backup.

If you are using ms sql then you can request the backup by contacting your hosting company. However, it is still possible to import/export your database using the enterprise manager or MS SQL Management studio.

As others have said, you can use phpMyAdmin to export your database. Then you can use BigDump, http://www.ozerov.de/bigdump.php, to import into the new DB.

If you have just switched to web programming I would suggest you to use phpadmin instead of mysqldump.

mysql GUI client