Re: [Sheflug] Access to MySQL

[Steve Tickle <nospam [at] quarndon.co.uk>]

At 18:40 08/05/2000 +0100, Mark J Hewitt wrote:


>If you have MySQL running, you will have in its installation bin directory a
>program called mysql.  I don't know what the two export files are called,
>but you can do something like:
>
>  $ mysql connection_parameters < first_file
>  $ mysql connection_parameters < second file
>
>or
>
>  $ cat first_file second_file | mysql connection_parameters
>
>Where connection_parameters define the database (schema) that you
>wish to populate, and first_ and second_file are the files from your
>export script (and $ is the Linux prompt!)
>
>I expect that you will have to create the MySQL database before you
>start.
>
>And try:
>
>  $ man mysql
>
>for some basic help!
>
>Is that OK?

The text files produced aren't just comma delimited data, they actually 
contain the MySQL commands to create the db tables and SQL links and 
queries. If they just contained the data then I could import them into 
MySQL using the 'LOAD DATA INFILE' command having previously created the 
db, but as they don't I'm a little confused.

I can send _part_ of the files to you off list if you like (one of them is 
over 2MB as it's mostly data)


Steve


---------------------------------------------------------------------
Sheffield Linux User's Group - http://www.sheflug.co.uk
To unsubscribe from this list send mail to
- <sheflug-request [at] vuw.ac.nz> - with the word 
 "unsubscribe" in the body of the message. 

  GNU the choice of a complete generation.