Re: mysqldev user ?

On Wed, 2003-09-10 at 16:36, Lenz Grimmer wrote: > -BEGIN PGP SIGNED MESSAGE- > > warning: user mysqldev does not exist - using root > > warning: user mysqldev does not exist - using root > > This is a warning, not an error. Did the install continue? Where exactly > did you get this messag

mysqldev user ?

All, I recently updated the RPM files on my Linux box to 4.0.15 ... During the update, I received the following error : warning: user mysqldev does not exist - using root warning: user mysqldev does not exist - using root Can someone please explain to me what this user is and what it's

Optimizing with TEXT fields

Hi all, I'm in the process of designing a database and I'm a bit of an optimization freak ... I'd like to make sure that the actual structure of the database is optimal. With that said, my question is about TEXT fields. In the actual CREATE TABLE statement, would it make the table "fast

Continuing a previous selection

I want to select a large amount of data from the database, but I can't use it all at once. Is there a way to "pick up where I left off" and get another X rows of data? For instance, suppose I have the following table in a database : CREATE TABLE namelist (nameid INTUNSIGNEDNOT NULL

Major MySQL Server Problems

Greetings, We're experiencing some severe problems with MySQL and I'm at a loss as to what to look at ... It seems we've encountered some sort of a loop but I'm not sure what's causing it. The system will run fine for a while and then begin using 100% cpu on both processors in the syste

MySQL Stability Problem

Hi all, I seem to be running into a stability problem with our current mySQL server. I'm at a loss as to where to begin looking. We first noticed a problem with large files being created in the /tmp directory. That hasn't happened since, but yesterday the server bogged down twice. The

RE: RPM Installation Question

ocket file your pid file You can set these too in your /etc/my.cnf pid-file=/usr/data/mysql/mysql.pid socket=/tmp/mysql.sock or some such directories Your err files will write to the datadir you specify > -Original Message- > From: Jason Frisvold [mailto:[EMAIL PROTECTED]] > Sen

RPM Installation Question

I was hoping to use the RPM distribution to install MySQL on my Linux machine.  However, I notice that it sets the data directory to /var/lib/mysql  ...  This is unacceptable for my purposes...  I know I can probably use a link to fix this, but I'd rather do it the "right" way...  How do I tell

RE: Auto Increment Fields

y, and I'm not sure about the former." -- Albert Einstein [1879-1955] -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 04, 2001 4:37 PM To: Jason Frisvold; '[EMAIL PROTECTED]' Subject: Re: Auto Increment Fields At 4:08 PM -0400

Auto Increment Fields

Is there a way to have DBI return the value of the auto-incremented field upon insert? Or do I have to insert and then do a select afterwards? Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED]

MySQL Queries

Setup : MySQL 3.23.42 Perl 5.6.0 DBI 10.32 I’m trying to do a few different queries where the table name needs to be dynamic. I’ve tried the following : $dbquery = $dbhandler->prepare_cached(“SELECT id, target FROM ? where somedata=?”); $dbquery->execute($tablename,$somedata); But I keep gett

RE: Last Modified function?

I know you can set a column in each table that will update itself with the current ctime every time that row is modified, but I haven't found a per db, or per table variable yet. (I believe mSQL has something like this, but not mysql. --- Jason H. Frisvold Senior ATM Engi

REPLACE vs INSERT/UPDATE

Currently I'm checking to see if a value exists in the database before deciding whether to update it or insert it. Would this be quicker to do if I merely used REPLACE? Is that the purpose of the REPLACE command? If it exists, just update it, and if it doesn't exist, insert it? Thanks, --

RE: Mysql List Bounce Message?

That would explain it... I appreciate the prompt replies :) Thanks! sql --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- "Only two things are infinite, the universe and hum

Mysql List Bounce Message?

Can anyone explain why I'm getting a "Mail account is disabled" message from [EMAIL PROTECTED] regarding anything I post to the mysql list? The body of the message says : The mail account ([EMAIL PROTECTED]) is currently disabled, and is not receiving mail at this time. Thanks, --

RE: Post-install

Try this : /usr/bin/mysqladmin -u root -p password '22' The first instance of 'password' is a command.. It doesn't mean you need to replace it with the password.. --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [E

MySQL Queries

Setup : MySQL 3.23.42 Perl 5.6.0 DBI 10.32 I’m trying to do a few different queries where the table name needs to be dynamic. I’ve tried the following : $dbquery = $dbhandler->prepare_cached(“SELECT id, target FROM ? where somedata=?”); $dbquery->execute($tablename,$somedata); But I keep gett

Update TimeStamp

Is there any way to query a mySQL database for the last time it was updated? I need this ability to trigger a "restart" in some other applications that create config files and such for MRTG... Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata

Database Permissions

Greetings, I'm having a little trouble understanding how the permissions work within mySQL. I have 3 current databases. The first is the default mysql database, and the other 2 are ones that I have created. I want to be able to grant access to each table individually based on username.

RE: MySQL Tables over Multiple Drives

e and link the directoris manually. I think there may be a performance gain, instead of performance hit...Because as the file spread on diff discs, the seek time gain. The code should has been stablize already, I think. BTW, why you want it to span over multiple drive? - Original Message --

RE: MySQL Tables over Multiple Drives

t: Tuesday, January 30, 2001 5:41 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Tables over Multiple Drives Compile mysql with --with-raid option, then use symbolic link to link it to other drive - Original Message ----- From: "Jason Frisvold" <[EMAIL PROTECTED]> To: <[EMAIL PROTE

MySQL Tables over Multiple Drives

I looked through the manual briefly and did not see this addressed anywhere.. Is it possible to have a table span over multiple drive without a raid? Or perhaps possible to specify a directory where a table will reside other than the default directory? Thanks, --- Jason

Front End Needed

I know it's not "correct" to just jump in and ask and I apologize, but I'm under a bit of a time crunch here... I need to find a web front end that I can use to update a table in MySQL. What I'm looking for is a program that will display an entire table with records as a web page for editing. So