Re: MySQL Migration

2001-08-25 Thread Katherine Porter
MySQL does have a program mysqlimport. I, myself, being a scripting gal would most probably dump my Oracle DB into a comma delimited file or straight out raw SQL and make the text substitions to match the INSERT and CREATE TABLE syntax. Post a sample of your dump file and I can help you forge

Re: MySQL Still a wise choice for developers?

2001-08-25 Thread Katherine Porter
> The last thing that wurries me is the lack of updates on the issue, > when i, as a wurried client & customer go to the mysql.com website, the > only thing i find is a 'open inventation for 2001/07/18'. Being > deep-august i presume that has come and gone, and no results or > communications c

Re: Perl DBI -- How to select all returned values into an array

2001-08-25 Thread Katherine Porter
For single values I usually use this DBI function and query: my $val =3D $dbh->selectrow_array("SELECT value FROM tab1 WHERE test=3D= 2"); However, what if I want to store a bunch of values into an array? my @vals =3D $dbh->?("SELECT value FROM tab1 WHERE test > 10"); What's the syntax

RE: Upgrading to 3.23.37 from 3.22.32

2001-08-09 Thread Katherine Porter
My suggestion would be to chown the database files to the same ownership of the mysqld daemon. This should solve your persmission issues. -Original Message- From:Adam Douglas [EMAIL PROTECTED] Sent:Thu, 9 Aug 2001 10:11:44 -0600 To: [EMAIL PROTECTED], [EMAIL PROTECTED] Su