Re: REvoke select rights.

2003-12-16 Thread Sohail Hasan
Egor Egorov wrote: Sohail Hasan <[EMAIL PROTECTED]> wrote: I have created a database and created a user with select rights to that database, there is a table name xyz in that database that I don't want that user to view, that's why i want to revoke that select rights from

REvoke select rights.

2003-12-15 Thread Sohail Hasan
Hi All, I have created a database and created a user with select rights to that database, there is a table name xyz in that database that I don't want that user to view, that's why i want to revoke that select rights from only that table, can anyone tell me what syntax of revoke would be use

query not visible by sh processlist

2003-11-14 Thread Sohail Hasan
Hi All, Is there a possibility that a certain query that is executing in mysql by application is not visible by a "show processlist" command. As happened in my database a query was taking number of CPU cycles but when seen through the show processlist command nothing was displayed. shasan --

mysql import log

2003-09-07 Thread Sohail Hasan
Hi All, Can anybody tell me how can I get a log of my database import command. Sohail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

log-bin not created

2003-08-14 Thread Sohail Hasan
I am using mysql version 4.0.12 on a solaris sparc box. My server has stopped creating the log-bin files although it is defined in my.cnf. The directory permissions of the data directory are fine. What is wrong with the setup? Sohail -- MySQL General Mailing List For list archives: http://lis

Mysql original database and GRANTS.

2003-07-12 Thread Sohail Hasan
Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application that modified my root GRANTS and now I am not able to see my mysql database as I login from root account. I am not even able to create or delete any

Re: tables size in mysql database

2003-06-11 Thread Sohail Hasan
it isn't then what is the field for that? Jeremy Zawodny wrote: On Wed, Jun 11, 2003 at 10:08:47AM +0500, Sohail Hasan wrote: Hi there, How can I see per table size of all tables in a particular database. SHOW TABLE STATUS -- MySQL General Mailing List For list archives:

tables size in mysql database

2003-06-10 Thread Sohail Hasan
Hi there, How can I see per table size of all tables in a particular database. Sohail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fw: Load data infile & replication - 3.23.56

2003-03-27 Thread Sohail Hasan
Dear Alexander, I am running mysql 4.0.12 on both the master and slave servers. I am facing the same problem with a slight variation. When I am trying to import my database dump on the master the replication fails and slave thread exits with the following error in the hostname.err file on the s

Replication failing during the import

2003-03-27 Thread Sohail Hasan
Hi all, I am getting a replication failure on the slave when I run a dump import of my database on the master. Both servers are running mysql 4.0.12 production release. The error displayed on the slave error log file is as follows: ERROR: 1005 Can't create table './cms/category.frm' (errno: 1