Has anyone ported a MySQL client to IBM AS/400?
I have a customer (on AS/400) that would like to mirror some data to a
MySQL server.
Thank you for any help you can offer.
Regards,
Rich
-
Before posting, please check:
On Fri, 24 Aug 2001, Sinisa Milivojevic wrote:
Trond Eivind Glomsrød writes:
Peter Zaitsev [EMAIL PROTECTED] writes:
I'm trying to compile mysql 3.23.41 with recent glibc 2.2.4 but this
somehow does not work with the following diagnose:
It builds just fine with glibc 2.2.4
I have a large (40 million rows) table that currently consists of a few
integers and a varchar. I need to add a memo (text 255 chars) field to
about 2% of the rows. Originally I was going to create another table with a
key and the memo field, but this method is complicating the programming
I hate when my dumbness shows on world-wide tv
Please nullify my last query= Subject: not regexp
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
This is kind of an open letter and request for help.
Also would apply to our pgSQL friends as well.
What would be a major benefit is
Guides/FAQs etc on converting from Oracle or MSSQL to MySQL and pgSQL
Easy data conversion and export from Oracle MSSQL to MySQL and pgSQL
And so on ..
Today
** Virus Warning Message (on steiner.cc.vt.edu)
Found virus TROJ_SIRCAM.A in file religous studies intro.doc.com
The uncleanable file was deleted.
*
Hi! How are you?
I send you this file in order to have your advice
Hi
I have a table with a filed that is unique (used unique() in the
creation).
how do I undo this unique()?
thanks
berber
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi
I'm wondering is MySQL is Cluster aware?
Can it work in an Active/Passive or Active/Active Configuration of a
cluster?
thanks
berber
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine
running Irix and going to be using a mySQL db on a Linux box behind a
firewall. Since I will set up a tunnel with ssh2 to forward port 3306, it
will appear to the Irix system that the db exists locally. Now here is what
Rich Duzenbury writes:
I have need to replicate some data from an AS/400 to a MySQL server.
Has anyone ported a client?
Regards,
Rich
You can make a client on AIX, but OS/400 ... sorry no.
Best way to accomplish what you need is to save table create scripts
and to use SELECT ...INTO
To be honest, I'm not sure if you can just transport the db files. I'm sure
it won't work it you're using different versions of MySQL on the machines.
What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL
statements to recreate the table. I'll use SELECT ... INTO OUTFILE
Config:
* Mac: Mac OS X 10.0.4; java 1.3.1; mysql 3.23.32
* Linux: Linux 2.2.19/debian testing; java 1.3.1; mysql 3.23.36
I *really* could use some help here. I need to get MySQL up and running;
I've been at it for 2 days and can't get my WO app to see it, whether I
try on Linux or OS X.
George:
Suggest you use mysqldump, including the option to automagically create the
database and table schema.
On the WinNT machine:
mysqldump -u{username} -p -c --databases {databasename}{databasename}.sql
Copy the file(s) across the network to the LinuxPPC box
On the LinuxPPC box:
mysql
for a particular query i have to select data from five tables.
can any one suggest me a best way to do that in terms of performace..
thanks in advance
muruganandam
-
Before posting, please check:
Do a SQLDUMP using a program like MySQLFront in NT then connect to the Linux MySQL
using the same from NT. Run the SQL script you made and your off to the races.
Just did this for my move from NT to Linux.
There might be even a better way to do this but that's how I did mine and it worked.
Hello,
I have tried MySQL Front and it works very nicely I've used it for
importing data and data modification. I just have a few questions I hope
you can answer...
Firstly I imported some MS Access 2000 tables. The import see to go fine,
but when I went back to check some of the data
Hi group,
Im using the latest mySQL 3.23.41, ever since I installed the new
version I've been getting Lost connection to MySQL server during query
50% of the time on my mySQL server. I have a load average of 247 queries
per second accordig to mysqladmin status.
Anyone experienced the same
Jeremy Falcon writes:
To be honest, I'm not sure if you can just transport the db files. I'm sure
it won't work it you're using different versions of MySQL on the machines.
What I do when going from Win2K to FreeBSD is a mysqldump to extract the SQL
statements to recreate the table. I'll
Can anyone give an example of how to use the
where option in mysqldump to get a dump of only those
records whose values of field fieldx are larger than
something?
For example
for all database tables of db mydatabase
which possess a field named fieldx store in
the dump only those records
table a has ak1 and ak2 as primary key
table b has bk1 and bk2 as primary key
how do I join these tables?
if i write
where a.ak1 = b.bk1 and a.ak2 = b.bk2
data are returned multiple times.
AnneMarie,
When you say data are returned multiple times please clarify what you mean:
a) Does
DROP TABLE Track
Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
Anyone know what that means? As you can see, it came from tryign to do a
DROP on a table.
Thanks,
Tyler Longren
-
Before posting, please
- Original Message -
From: muruganandam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, September 05, 2001 4:04 PM
Subject: selection from multiple tables;
for a particular query i have to select data from five tables.
can any one suggest me a best way to do that in terms
I still get this error. Can someone help me to solve this?
MySQL Query Failed. Error 1030: Got error -1 from table handler
$query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY id;
$result = mysql_query($query) or die('MySQL Query Failed. Error
'.mysql_errno().':
'.mysql_error());
hi,
I think this mail list is very helpful to me.
But several hundred letters one day may bomb my mailbox up,
and it is a great problem to manage all the letter.
I have an advice to the friends who manage this list.
Please add a label to every letter from this mail list in order
for
Hi Armando, I think you probably need to notify the mainter of the
port for freebsd (from ports)
Port: mysql-server-3.23.40
Path: /usr/ports/databases/mysql323-server
Info: Multithreaded SQL database (server)
Maint: [EMAIL PROTECTED]
It's probably something in the port install script.
table a has ak1 and ak2 as primary key
table b has bk1 and bk2 as primary key
how do I join these tables?
if i write
where a.ak1 = b.bk1 and a.ak2 = b.bk2
data are returned multiple times.
AnneMarie,
When you say data are returned multiple times please clarify what you mean:
a) Does
On Friday 24 August 2001 00:09, Jeremy Zawodny wrote:
On Thu, Aug 23, 2001 at 01:15:25PM -0400, Robinson, Mike wrote:
I just set up a master/slave replication scheme and all is well, but
through the procedure did get bit on the tail.
After the setup, and after the master and slave
This is an Official WebStream Press Release
Release date: August 23, 2001
For more information contact:
Gary Lee at 888-932-2333
WebStream Internet Solutions Signs Contract With Broward Alliance
FOR IMMEDIATE RELEASE
Fort Lauderdale, FL - August 23, 2001 - WebStream Internet Solutions has
Rudy,
there is an explanation to this behaviour:
on escaped data you could un-escape almost everything, one can escape almost any
character if wanted.. .. so \\ gets \ and \* gets *, \% gets % and \N gets... N.
mysql select \A\B\C\J\N;
+-+
|ABCJN|
+-+
|ABCJN|
+-+
1 row in set
Description:
'mysqldump --allow-keywords' seems not to work using
mysql-3.23.38-1.alpha.rpm or mysql-3.23.41-1.alpha.rpm, i.e.
keyword-permissive column names are not produced. The same
command works properly on MySQL 3.23.22 on Linux on Intel hardware.
Trond Eivind Glomsrød writes:
On Fri, 24 Aug 2001, Sinisa Milivojevic wrote:
You know better then me that 2.2.4 should NOT be built with gcc 3 !
Which was why I asked :) - 2.2.4 wants 2.96RH or 2.95.3 (2.95.2 should
work on IA32, though)
--
Trond Eivind Glomsrød
Red Hat, Inc.
Hello-
I poked around on the site but didn't find any definite answer. Roughly
when is version 4.0 of MySQL expected out? I saw the information on the
todo in
regards to version 4.0 and the subsequent 4.1 but didn't see any dates.
Thanks for any help.
Steve
Hi Rich,
i haven't heard about an AS/400-Client so far.
As long you might don't want to start writing an asynchronus
dataque server on the AS/400 and a client on the mySQL-Server
to handle the data mirroring, i would suggest to try IBM's
JDBC-API. Together with Sun's JDBC 2.0 Optional Package
Hi Rich,
i haven't heard about an AS/400-Client so far.
As long you might don't want to start writing an asynchronus
dataque server on the AS/400 and a client on the mySQL-Server
to handle the data mirroring, i would suggest to try IBM's
JDBC-API. Together with Sun's JDBC 2.0 Optional Package
What is the maximum table size allowed by MySQL and Redhat 7.0 be default?
Benjamin Arai
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi,
I was trying to install mysql on Linux Redhat 7.1, after following all the
steps on the website, I tried to start mysql server using the mysql.server
start command, and I got this error message saying that mysql.server is not
found evern though it's under support-files folder and I cd-ed
The other solution is rsync. I dont know much about this guy yet, but I
have some concerns with using it to copy over large remote files. For
example, if I have a 1.2 gig table that has been heavily modified over a
weeks work, how reliable is the remote file after rsync? I guess Im just
Hi !!
)-Original Message-
)From: Wen Tien [mailto:[EMAIL PROTECTED]]
)Sent: Friday, August 24, 2001 1:58 PM
)To: [EMAIL PROTECTED]; Werner Stürenburg
)Cc: [EMAIL PROTECTED]
)Subject: RE: myODBC?
)
)
)Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine
)running Irix
Hi !!!
Can anyone has the answer for him ? How we can have a secure data transfer
over the web using MySQL and its APIs ? He is desperately needed some idea
in order to take further steps with MySQL ?
Regards
Venu
)-Original Message-
)From: A. Chris Nichols [mailto:[EMAIL PROTECTED]]
Hi !!!
)-Original Message-
)From: Werner Stürenburg [mailto:[EMAIL PROTECTED]]
)Sent: Friday, August 24, 2001 5:59 AM
)To: Wen Tien
)Cc: [EMAIL PROTECTED]
)Subject: Re: myODBC?
)
)
)In my understanding, myODBC is a middleware for programs which
)don't know how to deal directly with
Hi
I'd also like to know the answer to this. I also had a thought that it
might be nice to have a site to post answers that come through this email
list. I know there are archives but they can be difficult to use to find
the answer to peoples questions. What does everyone think about
Dear Everyone,
I have been looking at this mysql.com/org dispute for a while now,
and i must say i am getting more and more wurried. I have been a
faithfull user of MySql for some years now. Not because it is the 'best
full features database out there', but because it serves my specific
needs
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle, and
now we must migrate the data from MySQL to Oracle (I
know, it's not something I wanted to do.) What is the
best way to do this? Import into another database
(something like Access) then
Well, I've been a die-hard mysql fan for two years now and have been using
it with php for a web-based app. It has never crashed on me and has
performed perfectly.
As our app has grown, we have found a need for subselects and complex
queries and the work-arounds were ok until our databases
DROP TABLE Track
Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
Anyone know what that means? As you can see, it came from tryign to do a
DROP on a table.
Permission denied.
Maybe the dir permissions aren't correctly set up?
/ Carsten
--
Carsten H. Pedersen
keeper and
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 can be
Hello Hans,
a few weeks ago i had a similar task to accomplish, porting a mySQL
DB over to IBM's DB2 for S/390, so i can relate to this kind of
*most exciting* job.
Anyway, from my experience I wouldn't recommend anything like a bulk
copy or mass import/export. Because when you are switching
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote:
hi,
I think this mail list is very helpful to me.
But several hundred letters one day may bomb my mailbox up,
and it is a great problem to manage all the letter.
I have an advice to the friends who manage this list.
Also, I'm seeing this in the logfile:
java.lang.NullPointerException
WOApplication 'Newsie': Exception occurred while handling request:
com.webobjects.foundation.NSForwardException
[com.webobjects.jdbcadaptor.JDBCAdaptorException] null
Paul
(in case you're wondering, yes, i did get mysql
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
On Sat, Aug 25, 2001 at 06:37:26PM +0200, Chris Chabot wrote:
I have been looking at this mysql.com/org dispute for a while now,
and i must say i am getting more and more wurried.
Many of us have.
I have been a faithfull user of MySql for some years now. Not
because it is the 'best
On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote:
The other solution is rsync. I dont know much about this guy yet,
but I have some concerns with using it to copy over large remote
files. For example, if I have a 1.2 gig table that has been heavily
modified over a weeks work,
At 10:39 AM -0700 8/25/01, Hans Zaunere wrote:
We have about 300,000 records currently in a MySQL
database. A new system has been built on Oracle, and
now we must migrate the data from MySQL to Oracle (I
know, it's not something I wanted to do.) What is the
best way to do this? Import into
As stated on the bugs and fixes page on http://www.innodb.com/bugfixes.html
there is a problem with the latest innodb code that causes corruption when
doing updates... I believe I have run into that problem... First mysql would
hang.. and do nothing. After killing it and restarting it the error
On 24-Aug-2001 [EMAIL PROTECTED] wrote:
Can anyone give an example of how to use the
where option in mysqldump to get a dump of only those
records whose values of field fieldx are larger than
something?
For example
for all database tables of db mydatabase
which possess a field
On Sat, Aug 25, 2001 at 08:32:00AM -0500, Steve Suehring wrote:
Hello-
I poked around on the site but didn't find any definite answer.
Roughly when is version 4.0 of MySQL expected out? I saw the
information on the todo in regards to version 4.0 and the subsequent
4.1 but didn't see any
Hello Hans,
a few weeks ago i had a similar task to accomplish, porting a mySQL
DB over to IBM's DB2 for S/390, so i can relate to this kind of
*most exciting* job.
Anyway, from my experience I wouldn't recommend anything like a bulk
copy or mass import/export. Because when you are switching
At 10:07 AM -0700 8/24/01, Katherine Porter wrote:
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
On Sat, Aug 25, 2001 at 09:42:33AM +0800, aDragon wrote:
I think this mail list is very helpful to me. But several
hundred letters one day may bomb my mailbox up, and it is a
great problem to manage all the letter. I have an advice to the
friends who manage this list.
Hi,
You are missing the ; at the end of the SQL statement
try $query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY
id;;
instead of $query = SELECT * FROM question WHERE answer'1' AND id250
ORDER BY id;
CPereira
- Original Message -
From: Martin Kampherbeek [EMAIL
I would also strongly suggest not storing your images in the database but
rather a link to the image.
even that - why?
if you're using an ultrafast webserver like Tux in combination with
Apache/php-perl
the Tux webserver serves the images incredibly fast (see specweb tests)
what advantage
I don't know if this just a shoot in the wind but heres my configuration.
Everyting to be posted to and from the db is done first threw https: then
I have a VPN set from the actual db to http. From inside the VPN I have it
setup for IPsec. This is about as secure as I possibly know from my
(in case you're wondering, yes, i did get mysql working argh.)
info: WO5, Mac OS X 10.0.4, MySQL 3.23.32, mm.mysql JDBC adaptor 2.0.6.1
I get this error:
java.lang.IllegalStateException: Adaptor
com.webobjects.jdbcadaptor.JDBCAdaptor@b7ad3 failed to provide new primary
keys for entity
On Fri, Aug 24, 2001 at 10:07:59AM -0700, Katherine Porter wrote:
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
Hi !!
)-Original Message-
)From: Paul Schreiber [mailto:[EMAIL PROTECTED]]
)Sent: Friday, August 24, 2001 1:21 PM
)To: Web Objects admin; Web Objects newsiest; Web Objects dev; MySQL List
)Subject: MySQL, Web Objects 5: job connection problems
)
)
)Comfit:
)* Mac: Mac OS X 10.0.4; java
On Thu, Aug 23, 2001 at 11:11:38AM -0700, Steven Roussey wrote:
mysql explain select * from dominf.domip order by ip desc;
'ORDER BY something DESC' does not use an index. It must
be ascending. See the manual.
Also, I forgot, if you do this often and it needs to be in DESC
order,
At 11:24 PM +0100 8/25/01, Carlos Pereira wrote:
Hi,
You are missing the ; at the end of the SQL statement
try $query = SELECT * FROM question WHERE answer'1' AND id250 ORDER BY
id;;
instead of $query = SELECT * FROM question WHERE answer'1' AND id250
ORDER BY id;
No. A semicolon statement
67 matches
Mail list logo
