Re: Images

From: "GH" <[EMAIL PROTECTED]> > I was wondering how to get images into and out of a Mysql database > was told it was possible. > > I have mysql 4.0.18 The general opinion is that files should be stored in a file system and not a database. There are circumstances that you might want to store bi

Re: Leasing time on a superfast mysql box

Hi Mark, (B (BI have the parts for 4 Opteron systems here (Dual CPU machines) (B (BAll Types 844 to 848 luying right in front of me. (B2x Sata HDD (B2x SCSI HDD (B6-12GB MEMORY (B (BI also have (B (BFedora Core 1 (BSuse Linux 9.0 (BTurbo Linux 8 (BMandrake 10 rc1 (BWindows 64 BETA (

Re: update a record but not the timestamp

The simple solution is to explicitly set the timestamp column to the value it already has. Assuming Time is your timestamp column, you need: UPDATE `table` SET `AID` = 2, Time = Time WHERE `SID` = 5; See the manual for more . Mich

Re: Problem with replication

Hi Dana, (B (Bthe tool might be free for developers, but is it also Open source ?? (BDoes it solve the issues described by the threat owner ? (BIf not, can the owner easily adapt it to solve his problems with it ? (B (BI am just adding this question, to make it not look like your are (Bmissu

Leasing time on a superfast mysql box

I have a large database of zip codes with longitude and latitude of each, and I periodically generate a lookup table for each zip showing all zip codes within various radii. The process takes a day on my poor workstations 2.5GHz CPU, but I need to do it faster. Does anyone know of somewhere I can b

test message

Am a new member of the list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: update a record but not the timestamp

Never mind, I just figured it out: First, I copied the whole 'hits' table to 'hits_bak', then ran this: INSERT INTO `csrtech_dirserv`.`hits` SELECT `SID` , 2 AS `AID` , `Phrase` , `IP` , `Link` , `Time` , `Amt` , `F` FROM `csrtech_dirserv`.`hits_bak` WHERE `SID` =5 So that coppied al

update a record but not the timestamp

We've got about 1,000 records in a table that have timestamps on them. We've ran into a situation where we need to go back and update one field in all of those records without altering the timestamp. since the timestamp is automatically changed when the record is updated we are in a bind. The sql

Re: SELECT queries on replicate DB server

> > My question is: > Why would they deem it necessary to use yet a third server? Could it > be because the main server and the main slave are constantly being > updated and they wouldn't want to overload the main slave(which > is not on as high a horsepower of a box I know for a fact). Could it

SELECT queries on replicate DB server

We have a main db server that has a pretty big db and it sometimes gets overloaded. We also have a replicated slave server... every update to the main server writes through to it and it is the one that is backed up to avoid interruption service for the website. There are certain sections of th

Re: Windows VS Linux Platform

Patrick Connolly wrote: |> Last time I checked ( which was a while ago ) the only difference I |> found was that table & field names weren't case sensitive under Windows I think you mean ...table and database names Yeah that too. Like I said, it was a while ago. -- Daniel Kasak IT Develop

Re: Problems with phpMyAdmin, GD library, and jpegs

If you are storing a complete image in MySQL you don't need gd at all. Just output the correct header and the image file. GD is for creating images on the fly. Also if you can store the image in a file on disk and the path to the image in MySQL. -- Eric Bergen [EMAIL PROTECTED] On Mon, 27 Sep

Re: Images

It is possible but not very logical. MySQL isn't a filesystem. Unless you have an extreme situation you should store the path in MySQL and the image itself in a file. -- Eric Bergen [EMAIL PROTECTED] On Mon, 27 Sep 2004 18:20:02 -0400, GH <[EMAIL PROTECTED]> wrote: > I was wondering how to get i

Images

I was wondering how to get images into and out of a Mysql database was told it was possible. I have mysql 4.0.18 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Problems with phpMyAdmin, GD library, and jpegs

Greetings, Am having some problems with phpMyAdmin, GD library and jpegs. Here is the short version of the story. I installed phpMyAdmin, modified a database to install a graphic image into one of the tables and it showed the graphic from within phpMyAdmin - no problem. I then wrote a very sim

Re: Newbie question about blob data types ie. Storing .xls in blob

Good binary storage article w/ sample code: http://php.dreamwerx.net/forums/viewtopic.php?t=6 On Mon, 27 Sep 2004 16:47:37 -0500, Jack Taffar <[EMAIL PROTECTED]> wrote: > > Is it possible to store an excel file into a blob field in mysql? If so how > do I go about importing the file into the b

Newbie question about blob data types ie. Storing .xls in blob

Is it possible to store an excel file into a blob field in mysql? If so how do I go about importing the file into the blob field, and get it back out into an .xls file? Thanks in advnace Jack Taffar AOG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Re: server timezone and system timezon

Have the location selecting adjust the timezone when it selects. Example select t + interval 6 hour from t -- Eric Bergen [EMAIL PROTECTED] On Mon, 27 Sep 2004 12:24:36 -0600, Elim Qiu <[EMAIL PROTECTED]> wrote: > Hi, I'm looking for help on timezone issues. > > I'm using mysql for a web appli

Re: Date Range

- Original Message - From: <[EMAIL PROTECTED]> To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 27, 2004 14:30 Subject: Re: Date Range > I think you are very close but you are missing the LAST day of each month. > I think you need to change you

Re: Conexiones no autorizadas

> > Hola , > > Estoy empezando a notar intentos de ingreso con usuarios ilegales > no existentes) a mi server. > > Mi pregunta es : Como lo rastreo teniendo como unico dato el numero de > ip desde el cual se esta conectando? > > O si alguien tiene una mejor idea o ha pasado por lo mismo, > le a

Re: Addslashes / data sort

> PHP / MySQL > > > > I'm using PHP to retrieve user input and store it in MySQL. PHP's > addslashes function is used on data going into the database and PHP's > stripslashes function is being used on data coming from the database. This > is allowing me to store and retrieve data with no problems,

Re: Date Range

I think you are very close but you are missing the LAST day of each month. I think you need to change your WHERE to read WHERE queue_time >= @Start AND queue_time < @BegOfMonth Reasoning: If @BegOfMonth is '2004-09-01' then @End will be '2004-08-31'. If queue_time is a datetime value somewhen d

Re: Conexiones no autorizadas

Very sorry!!! I've just mistaken the email address.. This message was intended to be sent to a Spanish SuSE List. I Apologize. Mauricio On Mon, 2004-09-27 at 15:55, Mauricio Pellegrini wrote: > Hola , > > Estoy empezando a notar intentos de ingreso con usuarios ilegales > no existentes) a mi

Re: How to pick the oldest row

> Hi , I'm trying to fetch the oldest row from a result > set in wich the resulting rows have duplicates, > > I need only one row for each duplicate. > > The problem is that I need always the oldest row > Like in the example > > SELECT * > FROM `mj_tmp` > WHERE idk NOT IN > (SELECT idk FR

Re: Date Range

- Original Message - From: <[EMAIL PROTECTED]> To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 27, 2004 11:40 Subject: Re: Date Range > To compute the date range for "two months ago". (if the current month is > September, this will return July

Newbie - Server won't start after update

Greetings! I had mysql 4.0.18 installed from the binary package, was working my way through the tutorial [totally new to database work]. Then i installed the 4.0.20 package [again from your binary], i can't start the server. Here are the results: PowerBook:/usr/local/mysql portable$ sudo ./b

server timezone and system timezon

Hi, I'm looking for help on timezone issues. I'm using mysql for a web application about time related events. I've two servers in different locations with different timezones. How to setup the database server so that the datetime value will not depend on the server machine's timezone? In other w

Re: Date Range

At 14:50 -0400 9/27/04, [EMAIL PROTECTED] wrote: Paul DuBois <[EMAIL PROTECTED]> wrote on 09/27/2004 02:07:54 PM: At 12:57 -0500 9/27/04, Dirk Bremer (NISC) wrote: >- Original Message - >From: <[EMAIL PROTECTED]> >To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >

Re: Date Range

At 12:57 -0500 9/27/04, Dirk Bremer (NISC) wrote: - Original Message - From: <[EMAIL PROTECTED]> To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 27, 2004 11:40 Subject: Re: Date Range I see that you are on 4.0.18 so you can't use many of the ne

Re: Date Range

> Whether he needs semicolons depends on which tool he is using to execute > his statements. If he is using the MySQL client or any of several other > tools, I agree. If he is going through an ODBC connection, he doesn't need > them. (At least my 3.52.x drivers can't accept more than one statement

Re: MIGRATION OF DATABASE FROM ONE BOX TO ANOTHER BOX

Might try using windows program called SQLYOG.. makes this dead easy.. On Fri, 24 Sep 2004 09:52:10 -0700 (PDT), Seena Blace <[EMAIL PROTECTED]> wrote: > Hi, > How to migrate mysql database from one box to another box ? > thanks > -Seena > > > - > Do you Yahoo!?

Re: Newbie - Server won't start after update

David Lowe wrote: Greetings! I had mysql 4.0.18 installed from the binary package, was working my way through the tutorial [totally new to database work]. Then i installed the 4.0.20 package [again from your binary], i can't start the server. Here are the results: PowerBook:/usr/local/my

Re: Date Range

Paul DuBois <[EMAIL PROTECTED]> wrote on 09/27/2004 02:07:54 PM: > At 12:57 -0500 9/27/04, Dirk Bremer (NISC) wrote: > >- Original Message - > >From: <[EMAIL PROTECTED]> > >To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]> > >Sent: Monday, September 27, 2004 11:40 > >

Re: high availability question

(Sorry for the long reply) > If i write to server A, will server B automatically be > notified of the change, and be properly updated? If i change server B > instead, will server A be notified and updated? Yes...Just like that. :-) They will both have the same data. I have a similar set up in my o

Conexiones no autorizadas

Hola , Estoy empezando a notar intentos de ingreso con usuarios ilegales no existentes) a mi server. Mi pregunta es : Como lo rastreo teniendo como unico dato el numero de ip desde el cual se esta conectando? O si alguien tiene una mejor idea o ha pasado por lo mismo, le agradecere me comente s