1,105,633 Community Members

basic

Member Avatar
DarkMonarch
Junior Poster
121 posts since Sep 2011
Reputation Points: 1 [?]
Q&As Helped to Solve: 16 [?]
Skill Endorsements: 0 [?]
 
0
 

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

Member Avatar
smantscheff
Nearly a Posting Virtuoso
1,289 posts since Oct 2010
Reputation Points: 265 [?]
Q&As Helped to Solve: 271 [?]
Skill Endorsements: 8 [?]
 
0
 

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.

Member Avatar
DarkMonarch
Junior Poster
121 posts since Sep 2011
Reputation Points: 1 [?]
Q&As Helped to Solve: 16 [?]
Skill Endorsements: 0 [?]
 
0
 

ok thx, i`m on the right track.


Dark

Question Answered as of 2 Years Ago by smantscheff
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article