mysql to web server

[Baleric]

hey guys, i have a mysql database that is on my local machine at home, i would liek to move it to my web server, i have the ip address for the web server for the server=; in the connection string, but i dont know the process of actually
placing my db on the server, do i just upload it to my directory?

my web server is running helm, it gives me the privelage to add a new mysql database, but i need to add my one up there including the data,

im using windows hosting and asp to connect,

cheers guys,

baleric

[guelphdad]

use mysqldump to dump your database.

mysqldump yourdatabasename > outputfilename

then ftp it in place. on your server create the database by just issuing:


create databasename

then import into your database from the mysqldump file

mysql databasename < outputfilename
you do both from the shell and not from mysql client.