Re: insert warning - how to look at

Hi, mysql show warnings; BR johan Sydney Puente wrote: Hello, I have an application which is inserting rows into a Mysql 5.024 db. It seems to stop when an insert generates a warning. when I insert the suspect line on the mysql commandline I get this: Query OK, 1 row affected, 1 warning

Index length too long, but no index specified!

), BEMERKUNG VARCHAR(100), LOESCHKZ VARCHAR(1), U_VERSION VARCHAR(1) ); Normally, I've got this error when using KEY(x, y, x) where the column length of x, y and z overrides 500 chars. Help, anyone? Regards, Johan Andersson

Master election feature thing in Mysql 4.0 ?

, Johan Andersson Consultant - 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 [EMAIL PROTECTED] To unsubscribe

oracledump - mysqldump for an oracle database

either all tables or some specified in one oracle SID. The output format is the same as mysqldump's which makes the whole thing a migration utility, Oracle to MySQL.. If there is some interest I'll make it a public program, otherwise I'll keep it for myself.. :) Best regards, Johan Andersson

Migration Oracle = MySQL

Anybody tried this? and hopefully got some good ideas of how to do it properly? I'm trying to create a perl script that just produces a MySQL compliant SQL file based on the tables from Oracle, but I can't get everything work, like indexes etc.. Someone? // Johan Andersson

Re: mysql uses 99% cpu under freebsd 4.3

.. ? Regards, Johan Andersson Consultant Qbranch - Original Message - From: "Lars Andersson" [EMAIL PROTECTED] To: "Andrew Schmidt" [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 09, 2001 11:26 PM Subject: Re: mysql uses 99% cpu under f

Oracle = MySQL migration

never have worked with Oracle.. So the question is.. Do someone know a simplier way to do this (perl script, or whatever) or do I have to teach myself PL/SQL and make a script that produces a MySQL sql script ? Regards, Johan Andersson Consultant

Re: Storing pictures in mySQL

directive in the Apache config. But, that specific solution is good if you're going to use it for a website, maybe not for a java application or something.. Well, I hope you got some ideas now.. Just don't store the images in the database.. it will be a performance buster. Regards, Johan

Re: Antwort: Storing pictures in mySQL

buster. So, I still recommend you to place the image files in the filesystem and only the filenames in the database. (I use the PK for that table as filename, then you don't need to store the filenames either... ) Regards, Johan Andersson Consultant - Original Message - From: "

Replication

the slave to ignore that table, and don't want the table to be sent at all to the slave machine.. Got it ? =) Regards, Johan Andersson Consultant