Hi all,
I know it is an old question and I have read from the mysql website
about the topic. Until now, mysql still doesn't support 2 ways
replication, quoted from mysql website. As I have multiple location
and each location will have a DB. Most of all need to read and write
to the database.
At 12:11 AM 2/11/2007, you wrote:
This is true, if the db is still on same db server.
Correct me if I am wrong, but it will not protect if some body copies the
files to other DB server, then they can see the DB
Suhas
Suhas,
You are correct. If the person has physical access to the MyS
On 10.02.2007 17:39 CE(S)T, Yves Goergen wrote:
> ERROR 1060 (42S21) at line 22: Duplicate column name 'File_priv'
> (and some more similar stuff)
As I found out I already asked that on a previous upgrade. Other sources
make me think that this is not an actual error but intended if the
tables are
Or, another, perhaps easier way:
SELECT * FROM foobar
WHERE yourdatefield < CURDATE() - INTERVAL 7 DAY;
Cheers,
Jay
Lars Schwarz wrote:
depending on your mysql version:
for the date/time field version:
select * from foobar where yourdatefield < DATE_ADD( CURDATE( ) ,
INTERVAL -7 DAY )
i do
Miguel Vaz wrote:
I have three tables:
TABLE Person
- id_person, name, id_levelA, id_sizeA, id_levelB, id_sizeB
TABLE Levels
- id, desc
TABLE Sizes
- id, desc
Hi! You can always join a table twice :)
SELECT
p.id_person
, lA.desc as levelA
, sA.desc as sizeA
, lB.
Hi,
You can only set this parameters in order to monitoring slow queries:
long_query_time = 120 ( example of 2 minutes)
#log-long-format
#log-slow-queries=/var/log/slow-queries.log
You can enable and disable using " # "
You set :
log=ON
log_slow_queries = ON
log_slow_queries=/var/log/slow-q
Hi , Everyone :: I need your help.
I have problem about mysql.
it about log_slow_queries
this is my.cnf file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
#skip-networking
skip-innodb
skip-bdb
skip-name-resolve
skip-locking
skip-character-set-clie
depending on your mysql version:
for the date/time field version:
select * from foobar where yourdatefield < DATE_ADD( CURDATE( ) ,
INTERVAL -7 DAY )
i don't use unix timestamps, but you may check the UNIXTIME() and
UNIX_TIMESTAMP() functions for converting them before using the
DATE_ADD().
la
Hi all
I want to extract the records that aren't oldest of 1 week.
Ho can I do this in two mode?
1) when my data field is int(10) and I store record with unix time
(1171152000)
2) when my data field is a data field and I store record with format
2007-02-11 12:50:02
Thanks
--
MySQL General Ma
Hi all
I want to extract the records that aren't oldest of 1 week.
Ho can I do this in two mode?
1) when my data field is int(10) and I store record with unix time
(1171152000)
2) when my data field is a data field and I store record with format
2007-02-11 12:50:02
Thanks
--
MySQL General Ma
hi tsr,
where's the question? :) store the reference to the file in the
database, not the file itself.
hth: lars
On 2/11/07, tsr.offentlig <[EMAIL PROTECTED]> wrote:
Hi,
Ok, I've been searching around for information on storing images in a DB
(ok, not very original, but anyhow).
After readin
2007/2/10, Dimitar Vasilev <[EMAIL PROTECTED]>:
Hi all,
First I would like to thank you for the invaluable pieces of advice.
I've made a good progress thanks to you.
Now I'm trying to display the output of people who have shareholders at
more than one place
select COUNT (*),IME,LAND,CNT,ID, (se
Hi,
Ok, I've been searching around for information on storing images in a DB
(ok, not very original, but anyhow).
After reading these links:
http://www.dreamwerx.net/phpforum/?id=1
http://www.zend.com/zend/trick/tricks-sept-2001.php?article=tricks-sept-2001&kind=tr&id=2033&open=1&anc=0&view=1
13 matches
Mail list logo