HI all,
I am trying to use mysqldump for a new DB:
entered:
mysqldump --opt -uroot -p dbname > dbBak
Output
mysqldump: Got error: 1044: Access denied for user: '[EMAIL PROTECTED]' to
database 'mdirect' when using LOCK TABLES
Then I logon as root (without specifing a db) - works
Many thanks Chris
-Original Message-
From: Chris Elsworth [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 11:22
To: Curley, Thomas
Cc: [EMAIL PROTECTED]
Subject: Re: NOT EXISTS
On Mon, Dec 15, 2003 at 10:59:32AM -, Curley, Thomas wrote:
> Guys
>
> Any idea why this query
Guys
Any idea why this query will not work in 4.0.13
select batch_id from BATCH
where NOT EXISTS (select 1 from TXN where TXN.batch_id = BATCH.batch_id)
You have an error in your SQL syntax near 'EXISTS (select * from TXN where
TXN.batch_id = BATCH.batch_id)' at line 1
thanks
Good question - mysqlimport seems to work siliently and not report any errors. I had
read that this was to be improved in 4 - has it ??
appreciate answers
Thomas
-Original Message-
From: Greg G [mailto:[EMAIL PROTECTED]
Sent: 02 December 2003 15:22
To: [EMAIL PROTECTED]
Subject: D
Hi all,
Platform RH linux on Dell with MySql 4
I changes the directory to where the data file was picked up from to a symbolic link
and now get the error
Can't get stat of '/home/test/data_in/TEST.TXT' (Errcode: 13)
So all I did was to change ~test/data_in to a sym link to ~txn/data_in
Anyo
EMAIL PROTECTED]
Sent: 26 November 2003 13:36
To: Curley, Thomas; [EMAIL PROTECTED]
Subject: RE: Security Question
One of the first things that I did at my former job was to turn off all
external-facing network adapters to our DB machines. If you're fortunate
enough that your DB resides on it
solution to this then MySql should not be used on internet accessible
boxes for dynamic web sites
Thomas
-Original Message-
From: Fagyal, Csongor [mailto:[EMAIL PROTECTED]
Sent: 26 November 2003 12:51
To: Curley, Thomas
Cc: [EMAIL PROTECTED]
Subject: Re: Security Question
Thomas
I am trying to find a solution to the following security issue with MySql DB on linux
- Someone copies the DB files to another box, starts a mysql instance, loads the DB
and presto - views the 'private' data !!!
Ideally I would like to know if there is any option in MySql to store the DB files i
Hi,
Any anyone have recommendations on MySql books currently in print. What's the best or
is the online manual all that's needed !
Thomas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht