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
(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
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
Subject: Re: Date
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:
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!?
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 per
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 new date
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]
Sent: Monday,
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
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
- 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's data)
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 FROM `mj_tmp`
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
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
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, but
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
- 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 your WHERE
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
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
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 blob
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
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]
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
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
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 Developer
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
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
be
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
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
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]
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
Hi Dana,
the tool might be free for developers, but is it also Open source ??
Does it solve the issues described by the threat owner ?
If not, can the owner easily adapt it to solve his problems with it ?
I am just adding this question, to make it not look like your are
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
http://dev.mysql.com/doc/mysql/en/TIMESTAMP_pre-4.1.html.
Hi Mark,
I have the parts for 4 Opteron systems here (Dual CPU machines)
All Types 844 to 848 luying right in front of me.
2x Sata HDD
2x SCSI HDD
6-12GB MEMORY
I also have
Fedora Core 1
Suse Linux 9.0
Turbo Linux 8
Mandrake 10 rc1
Windows 64 BETA
34 matches
Mail list logo