Uploading MySQL databases

[reiss]

Hi
I've finished a website on my localhost all working perfectly with MySQL database setup.
will be upgrading our webserver to include a MySQL database which means i'll have to transfer all the work to the webserver.

I've never done this before and its a little daunting, i'm guessing all i need to change is the connection strings, but with regards to actually transfering the databases im unsure.

my database is stored in c:\program files\MySQL\MySQL Server 5.0\data

the files are *.frm

do i just upload these files to the webserver?

any tips on database transfer are much appreciated.

[bwcc]

If you're running phpmyadmin, you can use the export function for your dbase(s) to export the sql statement to a text file, which you can then import into another mysql server. Or, the command line from mysql is mysqldump :

http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

[reiss]

thanks
yes, have phpmyadmin. will give that a go