mysql export from localhost to server

fati

how to transfer my localhost DB to Server?

how can I know which folder in the server I should place it?

what are the extensions of mysql db & tables?

Thank you

johanafm

That probably depends on storage engine, possibly OS and perhaps also wether you use a single file schema structure, or one file per table. I'm not even sure they have an extension.

Either way, that's not how you move a database. If you go to google and type "mysql" into the search field, one of the top suggestions you get is "mysqldump". That's the way to go.

Roger_Ramjet

An even easier way to do this is to use the MySQL Workbench which has a database migration tool built in. The workbench beats the pants off of web interfaces like phpmyadmin. Download it here http://www.mysql.com/products/workbench/

PS, it does require that your remote server be configured to allow for remote connection, which depends on how and where you are hosted. Even if the remote server is not available, I'd still recommend the workbench for your localhost when developing.

Derokorian

You could use the console as well doing mysqldump, then importing the file into your web server. Tho the migration tool in workbench is pretty damn efficient and easy to use.

sneakyimp

you usually have to use mysqldump from the command line (via SSH using puTTY or other terminal program) and if you don't have command line access it gets dodgy because you have to go through all kinds of other trouble.

if your database is small, phpmyadmin can be really easy to use.

Roger's right about the workbench app, but it takes some getting used to (well worth it in the long run but perhaps risky if you are facing a deadline).

Roger_Ramjet

There are the older MySQL Tools one of which is the Migration Toolkit and this is simple and intuitive to use. Download it here
http://dev.mysql.com/downloads/gui-tools/5.0.html