We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,996 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

basic

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

2
Contributors
2
Replies
1 Day
Discussion Span
1 Year Ago
Last Updated
3
Views
Question
Answered
DarkMonarch
Junior Poster
120 posts since Sep 2011
Reputation Points: 11
Solved Threads: 16
Skill Endorsements: 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.

smantscheff
Nearly a Posting Virtuoso
1,297 posts since Oct 2010
Reputation Points: 321
Solved Threads: 270
Skill Endorsements: 8

ok thx, i`m on the right track.


Dark

DarkMonarch
Junior Poster
120 posts since Sep 2011
Reputation Points: 11
Solved Threads: 16
Skill Endorsements: 0
Question Answered as of 1 Year Ago by smantscheff

This question has already been solved: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.0633 seconds using 2.66MB