Moving MySQL data from one machine to another

[p2ranger]

I'm running MySQL on my Win98 machine here at home right now. It has Database stuff on it already.

My web host offers MySQL and if I decide to use that instead, will I be able to transfer the information easily on to their Unix machine?

I know where the MySQL data files reside on my computer now. Is it a matter of moving the files over or will I have to insert the informaion manually?

Thanks

Jason
><>

[prequel]

yup..

i have nusphere installed on my home pc

just dump/backup the database

mysqldump --opt -u root -p dbname > C:\nusphere\apache\htdocs\dump.sql

upload to your site a/c and reimport into a database you need to create on the site a/c

i..e newdatabase

mysql -u root -p newdatabase < /path/to/dump.sql

[p2ranger]

Right on!

Thanks

Jason
><>