Re: error once backing up database

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 th

Re: error once backing up database

thx Ananda. I will try. Cheers, 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 dat

Re: error once backing up database

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 a

Re: error once backing up database

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 t

Re: error once backing up database

You cannot execute the grant 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

Re: error once backing up database

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] > w

Re: error once backing up database

You mean to say, you cannot execute the "GRANT" command. regards anandkl On 7/19/07, Banyan He <[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

Re: error once backing up database

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 Kuma

Re: error once backing up database

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' identified by 'password'; and then try you mysqldump regards anandkl On 7/19/07, Banyan He <[EMAIL PROTECTED]> wrote: Hi Guys,

error once backing up database

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 adv