Re: [Sheflug] Access to MySQL

[Mark J Hewitt<nospam [at] elsabio.demon.co.uk>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 8 May 00, at 15:57, Steve Tickle wrote:

> I'm looking at converting an Access db to MySQL 
> 
> "What do I do with the resulting files?" - Pipe/paste them into MySQL's
> monitor program. Please read MySQL's documentation for further info.
> 
> This is where I grind to a halt, how do I pipe/paste them into MySQL's
> monitor program? Which monitor program? and whereabouts in the MySQL
> documentation should I be looking for help?

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?




-----BEGIN PGP SIGNATURE-----
Version: PGP 6.0.2 -- QDPGP 2.60 
Comment: PGP Signature

iQA/AwUBORb8Hxo3dDZB8V9VEQJc+ACfepnQRMAhyjl5irV+ZisFidMZWLgAoJH5
dY4Z9ECXF1kb4Zw/wU/NLMtJ
=Xv5W
-----END PGP SIGNATURE-----
-- 
Mark J. Hewitt      at home           mjh [at] elsabio.demon.co.uk
"As for the best leaders, the people do not notice their existence.
 The next best leaders, the people admire.  The next, the people
 fear, and the next the people hate.  But when the best leader's
 work is done, the people say, "We did it ourselves."
 Lao Tzu, 6th Century BC.
---------------------------------------------------------------------
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.