problems with BLOB's ?

Hi I am trying to insert some BLOB's in my database - i created the table already and when i use the standard-insert-commando i give the position on my harddisk of this file. So far so good. But when i try to get the data back from the database, i simply get nonsense or nothing I use ( windo

Re: MySQL Installation in a user account

On Sat, 5 May 2001, David Loke wrote: > Hi Guys! > > I am a web server system administrator. I would like to enable the users of > my server to be able to install MySQL individually. That means each user > will have their individual MySQL root access. And from there, their PHP can > connect to t

mySQL and polish characters

Hello, I've encountered teh following problem using the mySQL engine both on WinNT and Linux RH6.2 so I think this is platform independant error. So.. I can't force the mySQL to properly do the SELECT query on the bases containing the polish specific characters... I tried the win1250 and latin2

MySQL Installation in a user account

Hi Guys! I am a web server system administrator. I would like to enable the users of my server to be able to install MySQL individually. That means each user will have their individual MySQL root access. And from there, their PHP can connect to their MySQL db. Is that possible? Rgds --

Re: Cron job to start/restart mysql for non-root user

Have 'cron' run the normal "mysql" init script (should have come with the distribution). The script already checks to see if there's a "mysql" process already running (and issues a "A mysqld process already exists" message). Your 'cron' entry should look like: 00,10,20,30,40,50 * * * * /ho

5-way join killers

Hello ppl, [long e- follows] I'm running a large set of queries on mysql and am trying to fine-tune a specific type of them. I have the following tables: table alpha --- id auto_increment a1 mediumint (other rows not of interest) table beta -- id auto_increment b1 char

Cron job to start/restart mysql for non-root user

I have a 'normal user' mysql setup on a server not my own - I have no root access and they won't add mysql to the server's startup scripts. I need a way to have the daemon start up when the server is rebooted. I do have access to cron jobs, so I thought I might build a script that fires ever

MySQL-Server getting signal 11 ... almost every day arround 0:00 am ... using temporary tables

Hello, I've got a problem: My MySQL-Server gets signal 11 almost every day arround 0:00 am ... I have a nice mrtg - graph showing this ... ;o) In fact every time the server crashes the statement shown in the server.log (or a similar one with other memID) is executed. topsitesTEMP is a tempora

MySQLGUI: running VERY slow on Win98SE

Dear Support Team, I've installed MySQLGUI 1.7.4.2 on my Win98 Computer and it's running VERY slow making it unusable. Is there any hint you could give me? Thanks, Thomas Beyer Multimedia Production University Of Applied Sciences Kiel Germany

Question

Hello all, mysql uses only one index for the entire execution of a query? i.e. if it uses one index to do the row retrieval because it matches the where criteria but then has to sort these rows on something else that would benefit from index, would mysql use this index? tia, thalis -

MYISAM recovery.

Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello mysql, Peter> It seems like mysql sometimes tries to hard to repair the table with Peter> myisam tables with fixed row format. Peter> I've had a chance to several times found data in one of the tables Peter> co

Question.

Hi! > "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes: Peter> Hello mysql, Peter> Any ideas how this may happen: Peter> Mysql version 3.23.37, auto recovery turned on. mysql> check table layers_st50.g00stat_sitepaths; Peter> +---+---+--+

Result: Got error -1 from table handler

Hi, What's the meanning of this error? Message: General error: Got error -1 from table handler SQLState: S1000 ErrorCode: 1030 Thank you Carlos Godoy

mysql install problem

Hi: I tried to install mysql on my machine. So I download the binary tarball and proceed according to the instruction in the INSTALL file (same problem happened for two different versions that I tried). However, when I tried to run the last step "bin/safe_mysqld --user=mysql &". It says mysqld

Re: database problems

I have a similar problem to this.. What happens is somehow something is causing mysql to hang which forces it to reach max connections.. if i shutdown and restart mysql using safe_mysqld --skip=networking it starts fine.. will do selects fine but not inserts because the tables that were being in

Problem with a simple select

Hi all, I am able to show all the table in a database but when I try a simple selct in one of the table I get the following mysql> show tables; +-+ | Tables_in_bugunison | +-+ | attachments | | bugs| | bugs_activity | | cc

Re: Aggregate string values

On Fri, 4 May 2001, Joel Desamero wrote: > Hello, > > I was wondering if there is a way to aggregate string values when grouping together >results. I guess what I'm looking for is the string version of the SUM() function. Is >there such a thing in MySQL? > > Thanks. No. You could write you

Re: 'Show' output

On your mysql monitor do: mysql> tee filename.out This will redirect everhting to filename.out besides ptinting it to the screen. Alternatively from you shell: $ echo "show status;"|mysql -u thalis -p lala > filename.out regards, thalis On Fri, 4 May 2001, Tim wrote: > > Is there any way t

Re: database problems

Shut down the server before repairing tables. Robert Clugston wrote: > List, > I'm having some serious problems with MySQL. I have some PHP and perl > scripts that do INSERTs into MySQL. Multiple times during the day various > tables become corrupted. > Repairing the table using myisamch

Aggregate string values

Hello, I was wondering if there is a way to aggregate string values when grouping together results. I guess what I'm looking for is the string version of the SUM() function. Is there such a thing in MySQL? Thanks. Joel

Re: Open Source MySQL Appl. Dev Tools for W2K/NT?W98.

try http://www.nusphere.com Curtis On Fri, 4 May 2001, Fowler, J.T. wrote: > I will be having to develop a MySQL application on Windows 2000, NT, and/or > Windows 98 system - no choice on the OS. What I would like to do is develop > using Open Source tools instead of MS products like VB, etc

Re: running mysql as different users

>the script. However, after that, I could not run mysql as root or mysql. >It gave me the same error message as it could not connect to local MySQL >server through /var/lib/mysql/mysql.sock. /etc/my.cnf might have a line giving the uri above. Mysql.sock normally lives in /tmp change my.cnf ac

Re: 'Show' output

On Fri, May 04, 2001 at 01:48:59PM -0400, Tim wrote: > > Is there any way to redirect the output of a 'Show' command to a > text file?? I know you can do this with a SELECT sql statement... tee somefile show tables; notee -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Financ

help with libmysqlclient.so

Hi, I have recently installed mysql-3.23.29a-gamma on Solaris 2.8. This works fine but I am having problems installing the Msql-Mysql Perl module. This makes but bombs out during testing with what seems to be a fairly common error (I've been scouring email lists)... Can't load '../blib/arch/aut

RE: select query?

On Fri, 04 May 2001, Roger Karnouk wrote: > Something like this should work: > select ip, mac, count(mac) > from ipmac > group by ip,mac having count(mac) > 1 > hope this helps Yes! Thanks Roger - this is just the thing. group by ip, mac having count(mac) > 1 returns nothing, but if we use gr

Re: 'Show' output

echo 'show blah blah blah' | mysql -u user -ppassword > /directory/filename Tim wrote: > > Is there any way to redirect the output of a 'Show' command to a text > file?? I know you can do this with a SELECT sql statement... > > -TIM > > ---

running mysql as different users

Hi everyone: I had question. I tried to set up slashcode1.0.11 on my machine. In order to do that I need to install MySQL. First I installed mysql successfully. I was able to access the server as user either root or mysql . I found it very confusing that I got the message that it could connect

RE: select query?

select ip, mac from ipmac group by mac having count(*) > 1; > I have a table with IP/MAC address combinations and I want to track > which MAC address might have used an IP address other than the one > originally assigned. > > Is there some way that I can query my table for duplicate MAC > addres

RE: database problems

List, I'm having some serious problems with MySQL. I have some PHP and perl scripts that do INSERTs into MySQL. Multiple times during the day various tables become corrupted. Repairing the table using myisamchk with "-r" usually fixes the problem, but sometimes I have to restart mysqld to

RE: Auto_increment or manual??

Hummm, this is very interesting. It looks like using an AUTO_INC will work ok for a "1 master to many slaves" ok, but for mixed mode replication "many master to many slave" this would work out quite well, therefor not to stumble on eachothers unique keys generated. However, what about this approac

'Show' output

Is there any way to redirect the output of a 'Show' command to a text file?? I know you can do this with a SELECT sql statement... -TIM - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: rotating binary log files...

On Fri, May 04, 2001 at 01:38:53AM -0400, Mike Farley wrote: > > Can anyone shed some light on how we should be rotating the binary > log files? The FLUSH LOGS command works for me. > Try this. Enable a binary log file, then rename it to some other > name. Then execute a flush logs command.

RE: NULL value in VARCHAR fields

At 10:28 AM -0700 5/4/01, Shankar Unni wrote: >Paul DuBois writes: > > > > At 8:21 PM +0200 5/3/01, stefan mojschewitsch wrote: >> > >> >using DEFAULT USER(), would be nice, but only constants are allowed. >> >to prevent inserting rows without iuser, i like to have this field >> >with NOT NUL

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

In my case they appear to be left open indefinitely, until Apache is restarted. This is not what's supposed to happen, of course. I haven't tried tuning low_idle (I think that's what it's called, from the mysql_connect() doc at php.net). I probably should try that as well. I'm sure persis

select query?

I have a table with IP/MAC address combinations and I want to track which MAC address might have used an IP address other than the one originally assigned. Is there some way that I can query my table for duplicate MAC addresses without specifying a MAC address. In plain english the query would b

Re: some question about create db

First off... there is a space between the -u and the username (it might work without it, haven't tried). You don't have to put a dabase name before the < as long as there is something in the SQL file you're feeding MySQL. Make a CREATE DATABASE temp; USE DATABASE temp; sql here sql here sql

RE: Open Source MySQL Appl. Dev Tools for W2K/NT?W98.

I use both MySQL winDOZE and the the Linux RH version with ASTA Servers sharing the databases between win machines , Linux and Palm. ASTA is not Freeware. But the MySQL Server that can connect to Win, Linux from a Win machine is as well as a few other cool tools. Cheers Mike -Origina

Newbie installation problems with Apache/MySQL/PHP under Linux

Rather than tell me my question is too far off-topic from MySQL list, would you please suggest another list that you know of? Thanks, but if you are willing to help, here is my problem: I'm attempting to get Apache, MySQL, and PHP working together on a RedHat Linux system that I have total contro

Re: some question about create db

That's a good question and I need some help related to the same too. Usually I create scripts like: createSequences.sql, createTableX.sql, createTableY.sql, populateTableX,etc.. that are called by a script called makeDB.sql The way I run it in Oracle is: sqL> @makeDB How can I do the same wi

Re: some question about create db

Might be a case of the blind leading the blind here (list folks: please correct me if I'm way off base ...) I believe that one way to do this would be to create a file with any SQL commands you want to run and then redirect it to mysql via back ticks: `mysql -uroot < sql_command_file`; Normally

Errcode 28 then 122?

I looked through the mailing list archive for an answer to this, but I can't find a way around this problem. I have a table with about 225,000 records. I kept getting an out of disk space error when running this query: mysql> select count(*),state from import_talents group by state; ERROR 3: Er

Re: Occasional hang of mysql

Sorry to say I can't help but am really interested in the resolution. If it helps the brains at all, I experience the same thing on the following system. mandrake 8 kernel 2.4.3 ReiserFS (mysql data on scsi drive, rest on an IDE) mysql .37 binary (couldn't get the source to compile) seems to have

some question about create db

I have to create a database from an application (written in perl) how can I do? how can I create a db if the user is not a root? which command can I use? Thank you in advance, Mario. - Before posting, please check: http://www.

Open Source MySQL Appl. Dev Tools for W2K/NT?W98.

I will be having to develop a MySQL application on Windows 2000, NT, and/or Windows 98 system - no choice on the OS. What I would like to do is develop using Open Source tools instead of MS products like VB, etc. What tools are available? Thanks, J.T.Fowler 512-326-6371 [EMAIL PROTECTED]

Re: missing fields after load data from text file

I have a table with 62 fields, I loaded data into MYSQL table from text file using LOAD DATA INFILE...TERMINATE BY '|' ENCLOSED BY '!' After the load, I did a "describe" on that table, only the first 21 fields showed up. However, when I did "SELECT" on the missing fields, there were actually

Re: Database size

> > > Hi, > > > > > > I have a problem, my database has reached Linux Redhat 7.1 > > > max file size. (2147483647 Bytes). Does eny one know what i > > > can do to make a lager database. (lager > > > filesystem) > > > > > > Thanks > > > Erik Dhiin I myself run a 300Gb database on a Linux redhat 6

Re: auto_increment

Check out the myisamchk manual page and the --set-auto-increment[=value] flag. regards, thalis On Fri, 4 May 2001, Stefan Wehowsky wrote: > Let´s say I got a column "id" that is of type tinyint and has the extra > "auto_increment". Let´s further say that I have 50 entries in that > column. Now

Re: MYSQL C API

At 3:03 PM +0100 5/4/01, VVM Ravikumar Sarma Chengalvala wrote: >Hi PAUL, >1.Thanks for the mail. >2.Regarding the return values I wonder anyone else has >encountered other than the values -1,0 for >mysql_query(). You need to stop asking this question. The function is explicitly documented to sa

Re: MYSQL C API

Hi PAUL, 1.Thanks for the mail. 2.Regarding the return values I wonder anyone else has encountered other than the values -1,0 for mysql_query(). 3. I will try our the option suggested by you for mysql_real_connect(); 3. Another thing does mysql_api has any provision to send the error messages to t

Re: auto_increment

Hi, There is no other go.I too had similar problems.But it does not hurt me as the auto_increment column is always being used as a primary key in my case. We have got to live with it until and unless we have some option to insert into the deleted row. Regards, Ravi --- Joseph Bueno <[EMAIL PROTE

Re: can not see data or tables in database

Are the database directories and tables owned my the user under which you have mysqld running? Richard Kurth wrote: > I set up a couple of databases last night in mysql and every thing is > working just fine. Today when I try to access the data it is not there > Using phpMyAdmin when I look at

Re: auto_increment

True. The only thing that could be done is write a UDF (user-defined function), which accepts a table and field name as parameters and somehow manages to find the first unused ID in that table.. and hope it is atomic, too.. I don't think this is too easy to do, though :) G'luck, Peter -- Hey,

RE: auto_increment

I believe that this behaviour is standard for autoincrementing fields on all database systems that support them. -Original Message- From: Stefan Wehowsky [mailto:[EMAIL PROTECTED]] Sent: Fri, 04 May 2001 10:37 To: [EMAIL PROTECTED] Subject: auto_increment Let´s say I got a column "id" t

RTFM - Show locks

database, sql Hi there I have tried looking in the manual but can't see the solution to this. user a issues a lock on table1, userb then tries to do a select and obviously the select will wait until the lock is released. So my questions are :- 1. How do you change the 'timeout' period that us

Occasional hang of mysql

Hi there! I encounterd with a problem recently. Mysql occasionally hangs so that it can't be killed with -SIGKILL, that is there is one thread persist after killall -9 mysqld and it can't be killed in any way. The only way to get mysql back to work is server reboot. I'm using mysql-3.23.37 on Red

Re: auto_increment

Stefan Wehowsky wrote: > > Let´s say I got a column "id" that is of type tinyint and has the extra > "auto_increment". Let´s further say that I have 50 entries in that > column. Now if I delete e.g. entry No. 30 and right after that add > another entry without naming an id (for ist auto_increment

Can we store Japaneese characters in MySql Database

Hello, Is it possible to store the Japaneese character set in MySql Database? Thanks Regards Narayanan. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (t

MYISAM recovery.

Hello mysql, It seems like mysql sometimes tries to hard to repair the table with myisam tables with fixed row format. I've had a chance to several times found data in one of the tables completely destroyed - the data looked like random. mysql> select * from g01layers_stat_cities limit

RE: distinct on varchar fields

Have you tried: select concat("blah", x, "bleh") from y group by x; > Hi All, > > when I use a distinct on varchar fields, does mySQL truncate the value > of the string to some set value. > This two queries give me a completely different number of rows and I am > not sure how to influence the

auto_increment

Let´s say I got a column "id" that is of type tinyint and has the extra "auto_increment". Let´s further say that I have 50 entries in that column. Now if I delete e.g. entry No. 30 and right after that add another entry without naming an id (for ist auto_increment) MySQL gives it the id 51 AND NOT

distinct on varchar fields

Hi All, when I use a distinct on varchar fields, does mySQL truncate the value of the string to some set value. This two queries give me a completely different number of rows and I am not sure how to influence the behaviour: select distinct x from y; (many rows result) and select distinct conc