djbennett999

How do you have multiple databases setup locally and how do you know the details of each for testing different local installations of Joomla for example?

When you have a system fully developed locally how do you transfer the actual mySQL database to web space like OneandOne to make it useable on the web?

david

mySQL uses a command line interface to configure.

However with WAMP you also have phpmyadmin, which can configure your database(s).

If you point your browser to http://localhost or http://127.0.0.1. It should bring up an interface to configure such things.

Transfering, you would perhaps copy the files to the server. But the server is probably running its own mySQL and phpadmin. You would then have to create fresh databases on the server end with phpmyadmin. Then you could use the import options or issue sql commands in phpmyadmin to get your data into them.