how do you guys start a DB?

create a DB put it on the server and then connect and add stuff or create DB with server script and then add stuff ?
BTW, i`m using php for manipulating the DB. It`s an employee online app.

i was going to create the DB with mysql workbench and then write a script for the inputs and modif.

i just want to start this the right way.


6 Years
Discussion Span
Last Post by DarkMonarch

There is no right way.
A standard method is a mysql script which you feed first into your development database, then, if all is fine, into your production database, and which contains all necessary statements for table creation and the initial population with test data.
You should not do that with a GUI but rather with the MySQL command line interface - that way you will know what you are doing, and you can integrate it into a batch process.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.