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.


Dark

Recommended Answers

All 2 Replies

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.

ok thx, i`m on the right track.


Dark

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.