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 (0.0

"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 Ande

Master election feature thing in Mysql 4.0 ?

rk etc.. Regards, 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 &l

oracledump - mysqldump for an oracle database

s out information about 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 mysel

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

Re: mysql uses 99% cpu under freebsd 4.3

seg's.. ? 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:2

Oracle => MySQL migration

if he 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 Consu

Re: Antwort: Storing pictures in mySQL

mance 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 - Fr

Re: Storing pictures in mySQL

Alias 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.

Replication

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

Compiling MySQL on Solaris with -static: Impossible? Why??

Is it true that you can't compile on Solaris with -static ?? If so, why is that so?? Regards, Johan Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

Reserved word in CREATE TABLE? source varchar(255),

Hi, I got the following error from mysql (client): ERROR at line 1: Failed to open file 'varchar(255),', error: 2 The .sql file I were sending to stdin of mysql has the following content: CREATE TABLE IDENTITY ( id bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment, company_id bigint(20