PHP database MAMP

normally you would build your site locally and when finished, copy all your content to the live server. This includes your database. So you would keep it locally and on the live server. The local database will not be used anymore I guess? just for development. All the changes you make with content will be made on the live server.

Do you use a cms system?

Ahh.. I just found this course: (https://teamtreehouse.com/library/database-foundations). This might be helpful solving my problem :-)

Henrik,

Using MAMP is a great way to get things started on your local computer. But yes once you're finished what you'd do is run an export within your MAMP's PHPMyAdmin. You'd then create a new database on your host and then import your database file into that new database.

So in MAMP click on your database section and click for PHPMyAdmin, click on your database on the left side of the new browser interface that opened for PHPMyAdmin, and then on the right section of the screen you'll see an export tab, click that. The default settings are typically just fine, then press Go. This will give you a SQL file. So then on your host, you can create a database of the same name and then either use whatever import tools they have or copy and paste the contents of that SQL file to be excited by the database server. Each individual host should be able to give you guidance as to their particular process. Definitely watch the Database Foundations course it'll give you a much better idea as to what's going on in that SQL file.