My mysql DB is on my hosts server. Is there a way i can save the tables/db to my own computer or dl the db or something?

use mysqldump to dump to a text file then FTP the file to your computer.

Or if you have phpmyadmin, do a dump and then select the radio button for "save as file".

where can i dl mysqldump? I don't use php so I don't think the php one would be right for me. Is there a way I can set up a mysql db on my pc and just copy the files onto that?

Yes, read the manual and learn how to use mysqldump as I suggested.

where's the manual and program? and how can I put a mysql db on my pc.

Visit mysql.com
you can download the program from there and you can find the manual under the Development tab.

This message comes up everytime I enter a web site address

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)Database Error. Please try again later.

is there any solution to it.

Look forward to your reply

Martin

This is the program i want to dl right? http://dev.mysql.com/downloads/mysql/4.1.html

How do I set up a connection to my hosts database so i can mysqldump?

Local connections are made through socket files. The location of that file has to be specified either on the command line or in /etc/my.cnf (debian: /etc/mysql/my.cnf, Windows: c:\windows\my.ini). Check the entry regarding the socket file, it's under
[client]
...
and
[mysqld]
...
It has to be the same in both sections.

it's simple:
search the executable mysql and put it's location in your PATH.
Than make your connection like this

mysql -u<user> -p<password> -h<host>

Some users have NO password, in this case DO NOT put -p in the command line.

mysql is a simple command line tool. For ease of use take some sort of gui tool. MySQL AB has some on their home Pg for download.