Ananda, I cannot host the reasons. Just add one more parameter to avoid
"LOCK TABLES".
mysqldump --lock-tables=false db
That works.
Cheers,
Thx guys.
Ananda Kumar wrote:
Hi Banyan,
Permission can vary from database to database.
Please ask your dba to grant you the permission and then try the
mysqldump
On 7/19/07, Banyan He <[EMAIL PROTECTED]> wrote:
The question is in this server, I cannot backup the database by issuing
mysqldump. On another server, I can. I am sure nobody changes the
settings. That's confusing to me.
> ant command because you don't have permission to do so.
> The GRANT command allows you to set permissions on databases and
> tables, thereby giving access to possibly sensitive data.
>
> It is in no way a serious restriction, it is a very important security
> feature.
>
> If you don't have the grant permission and need it, ask your database
> administrator to set up rights.
> Don't assume that what may be easier for you in other software
> environments, is the better solution. In this case, it clearly is not.
>
> regards,
>
> boro
>
> Banyan He schreef:
>> Yes, the server shows me that. I cannot execute the grant command.
>> This is a serious restriction software works with mysql.
>>
>> Ananda Kumar wrote:
>>> You mean to say, you cannot execute the "GRANT" command.
>>>
>>> regards
>>> anandkl
>>>
>>>
>>> On 7/19/07, *Banyan He* <[EMAIL PROTECTED]
>>> <mailto:[EMAIL PROTECTED]>> wrote:
>>>
>>> Thx Ananada. Actually, I don't have the admin permission on this
>>> server.
>>> The grant command is unavailable for me. I have no ideas about
>>> this. I
>>> install the software on two machines, one of them can issue this
>>> command
>>> and works fine with it. Another cannot.
>>>
>>> OS: windows 2003
>>>
>>> Cheers,
>>> Ananda Kumar wrote:
>>> > Looks like this user does hot have permission on
message_tracker
>>> while
>>> > connecting on the local host.
>>> >
>>> > try this.
>>> >
>>> > grant all on message_tracker to 'admin'@'localhost'
>>> > <mailto:[EMAIL PROTECTED]> identified by 'password';
>>> > and then try you mysqldump
>>> >
>>> > regards
>>> > anandkl
>>> >
>>> >
>>> > On 7/19/07, *Banyan He* <[EMAIL PROTECTED]
>>> <mailto:[EMAIL PROTECTED]>
>>> > <mailto: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>>
wrote:
>>> >
>>> > Hi Guys,
>>> >
>>> > I encounter an issue once I backup the database.
>>> >
>>> > mysqldump -u admin -phost --databases message_tracker > z:
>>> > sqlbackup.sql
>>> >
>>> > mysqldump: Got error: 1044: Access denied for user
>>> 'admin'@'localhost'
>>> > to database 'message_tracker' when using LOCK TABLES
>>> >
>>> > I am using windows as the OS.
>>> >
>>> > Any advices will be appreciated.
>>> >
>>> > Regards,
>>> >
>>> > --
>>> > ---------------
>>> > Banyan He
>>> > IronPort Customer Support
>>> > MSN: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>>> <mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
>>> > Skype: banyan.he
>>> > Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>>> <mailto: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
>>> > http://www.rootong.com
>>> >
>>> >
>>> >
>>> >
>>> > --
>>> > MySQL General Mailing List
>>> > For list archives: http://lists.mysql.com/mysql
>>> > <http://lists.mysql.com/mysql>
>>> > To
>>> > unsubscribe:
>>> http://lists.mysql.com/[EMAIL PROTECTED]
>>> >
>>> >
>>>
>>> --
>>> ---------------
>>> Banyan He
>>> IronPort Customer Support
>>> MSN: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>>> Skype: banyan.he
>>> Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>>> http://www.rootong.com
>>>
>>>
>>>
>>
>>
------------------------------------------------------------------------
>>
>>
>>
>
>
>
--
---------------
Banyan He
IronPort Customer Support
MSN: [EMAIL PROTECTED]
Skype: banyan.he
Email: [EMAIL PROTECTED]
http://www.rootong.com
--
---------------
Banyan He
IronPort Customer Support
MSN: [EMAIL PROTECTED]
Skype: banyan.he
Email: [EMAIL PROTECTED]
http://www.rootong.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]