Moving MySQL data from one machine to another
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?
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
mysql -u root -p newdatabase < /path/to/dump.sql