How Do You Set Up A Mysql Database Locally When You Have Wamp Installed?
February 6, 2010 under FAQ
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?
Search more about How Do You Set Up A Mysql Database Locally When You Have Wamp Installed?:
You log in to mysql from a console and create the databases and tables. Enter data and then access and manipulate it from php pages. Some sites will allow you to copy the files to their database location. Others you need to run the create from scratch, so use scripts to create them.
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.