Can u us a source code file to setup a db in MySQL ?

2002-12-08 Thread TopMailBox
When created a complicated db in MySQL can you first create a source file
with all the MySQL commands... and then either pipe them to MySQL or have
MySQL read the source file and then create the db accordingly ??

Or, must you input/key in one command at a time to the program in real time?

Thanks for any info.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Can u us a source code file to setup a db in MySQL ?

2002-12-08 Thread Gerald R. Jensen
Try:
mysql -u{username} -p {databasename}filename.sql

Make sure you put full create statements in the file, along with nay data
you wish to insert into the database.

Gerald Jensen

- Original Message -
From: TopMailBox [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, December 08, 2002 6:43 PM
Subject: Can u us a source code file to setup a db in MySQL ?


When created a complicated db in MySQL can you first create a source file
with all the MySQL commands... and then either pipe them to MySQL or have
MySQL read the source file and then create the db accordingly ??

Or, must you input/key in one command at a time to the program in real time?

Thanks for any info.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php