online mysql connection

I built a website locally on my machine using php4/mysql

but now i"m trying to upload it to my website, so I need to connect to my online host which provides both php4 and mysql. But to connect to mysql my host says

"You can access the database using Perl DBI (with DBD::mysql) or Mysql.pm module. You can also access it from the command line via SSH using mysql command"

But I have absolutely no idea how to use perl, or to be honest, what that message means. Please help me, i tried to use phpmyadmin and give the settings they gave me, but they also gave me a directory to put into there, and phpmyadmin doesnt allow for that, any ideas how I could connect and upload my database with the info in it?

rulian,

This may not be what you are looking for, but I believe it will get you going in the correct direction.

From what I understand you cannot just "copy and paste" mysql db files. You have to work some magic.

There are two possible ways of doing this:

1. The first is using a command called mysqldump. This "dumps" the db into a directory of your choice. I really don't know for sure, but this might actually pull the files off your machine. Read more about it: http://www.mysql.com/doc/m/y/mysqldump.html

2. The other is called mysqlhotcopy. This actually copies the mysql files to the directory of your choice. Read more about it: http://www.mysql.com/doc/m/y/mysqlhotcopy.html

I hope this helps,
oach

thanks i'll give it a shot