deploying a mysql website

[kuzi]

I have developed a database driven website using php and mysql on my lap top but my dilema is how do i transfer my website to the remote webserver coz i dont know how to ftp mysql database from the laptop. Are there some settings up that have to be done at the server since the server(linux) also hosts other websites(domain). I know that for static pages all you need to do is ftp the html pages but i dont know how to ftp mysql database.

thanks
[e-mail]

[bpat1434]

You don't ftp a database. On your local server get an SQL dump of your table schema and all info already in it. Then, on the server in the mySQL control panel execute those SQL files.

Normally, via phpMyAdmin, this is all done via the import/export tabs respectively.

~Brett