List:General Discussion« Previous MessageNext Message »
From:Gerald R. Jensen Date:December 9 2002 1:04am
Subject:Re: Can u us a "source code" file to setup a db in MySQL ?
View as plain text  
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" <topmailbox@stripped>
To: "MySQL List" <mysql@stripped>
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 <mysql-thread126957@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-autodata=execpc.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Thread
access->mysqlSandeep Murphy4 Dec
  • Re: access->mysqlSteve Yates4 Dec
  • Re: access->mysqlCrercio O. Silva5 Dec
RE: access->mysqlSteve Bradwell4 Dec
RE: access->mysqlDavid Brodbeck4 Dec
RE: access->mysqlIan Zabel4 Dec
  • Re: access->mysqlCarlin Anderson5 Dec
RE: access->mysqlChris Couture5 Dec
RE: access->mysqlSandeep Murphy5 Dec
  • How is DBTools Software?Will Standley7 Dec
    • Re: How is DBTools Software?Michael She7 Dec
      • RE: How is DBTools Software?Chris Mason8 Dec
        • Re: How is DBTools Software?Insanely Great8 Dec
        • RE: How is DBTools Software?Michael She8 Dec
  • Compiling a list of MySQL tools - Please contribute.Will Standley8 Dec
    • Re: Compiling a list of MySQL tools - Please contribute.Paul DuBois8 Dec
  • Can u us a "source code" file to setup a db in MySQL ?TopMailBox9 Dec
    • Re: Can u us a "source code" file to setup a db in MySQL ?Gerald R. Jensen9 Dec
      • How to get MySQL to list current db's ?Will Standley10 Dec
        • Re: How to get MySQL to list current db's ?Sherwin T. Ang10 Dec
        • Re: How to get MySQL to list current db's ?Daniel Kiss10 Dec
        • Re: How to get MySQL to list current db's ?Michael She10 Dec
          • Where does MySQL store db files?tmb10 Dec
            • How to see # of rec's in all tablestmb10 Dec
              • Re: How to see # of rec's in all tablesBenjamin Pflugmann11 Dec
              • re: How to see # of rec's in all tablesVictoria Reznichenko11 Dec
            • Re: Where does MySQL store db files?Robert Citek10 Dec
              • Re: Where does MySQL store db files?Francisco10 Dec
            • RE: Where does MySQL store db files?Adolfo Bello10 Dec
        • RE: How to get MySQL to list current db's ?Brian P. Austin10 Dec
  • Re: access->mysqlGrant Cooper13 Dec