MySQL PHP Connector

2006-04-28 Thread Krisno Hasan
Could you give me MySQL PHP Connector, both mysql and mysqli connectors version 5.0.18? Thanks.

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

retyping data

2002-10-18 Thread Hasan / Impex Holidays Maldives
characters when in C: prompt. Does anyone know a solution, I have tried changing the properties but nothing seems to help. Thanks, Hasan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

About transferring database

2002-08-14 Thread Hasan Ozduru
Dear MySQL company, How can I transfer datas from Microsoft Access database to MySQL database? And also if you could please answer how can I transfer datas from Microsoft Access database to SQL database. Best regards. Hasan

Re: DB backup

2002-07-08 Thread Impex Holidays Maldives / Hasan
hi, you should be using the c: prompt to run command and not the mysql prompt. Hasan - Original Message - From: "Horacio Lam" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 7:30 PM Subject: DB backup > I'm trying to do a backu

backup of mysql

2002-07-07 Thread Impex Holidays Maldives / Hasan
Hi, This may be out of topic,but still I'm working on a mysql back up file. Does any one have a shell script to ftp a file to another location, so that I can schedule to run this file with cron. Many thanks, Hasan - B

backup

2002-07-07 Thread Impex Holidays Maldives / Hasan
Hi, Does any one have a shell script to ftp a file to another location, so that I can schedule to run this file with cron. Many thanks, Hasan - Original Message - From: +ACI-Gerald R. Jensen+ACI- +ADw-gjensen+AEA-autodatasys.com+AD4- To: +ACI-Impex Holidays Maldives / Hasan+ACI- +ADw

MySQL backup

2002-02-24 Thread Hasan Niyaz
Hello everyone, I am trying to do backups using the crond daemon on my Linux server. Can I write a similar line as below on my crontab file. Any examples would be appreciated. mysqldump impex > siteroot/home/hasan/backup/backup.sql Alternatively i am thinking of running a perl file ...wh

backup

2002-02-24 Thread Impex Holidays Maldives / Hasan
Hello everyone, I am trying to do backups using the crond daemon on my Linux server. Can I write a similar line as below on my crontab file. Any examples would be appreciated. mysqldump impex +AD4- siteroot/home/hasan/backup/backup.sql Alternatively i am thinking of running a perl file

backup with crond

2002-02-24 Thread Impex Holidays Maldives / Hasan
Hello everyone, I am trying to do backups using the crond daemon on my Linux server. Can I write a similar line as below on my crontab file. Any examples would be appreciated. mysqldump impex +AD4- siteroot/home/hasan/backup/backup.sql Alternatively i am thinking of running a perl file

connect mysql to java and/or asp

2001-07-18 Thread Hasan
anyone can give me a scoop on how to connect mysql to java and/or asp? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: assign auto password

2001-06-19 Thread Hasan Niyaz
I use the MD5 command in mysql...I think PHP also has this... refer to the manual Hasan - Original Message - From: "Mike" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 19, 2001 9:50 AM Subject: RE: assign auto password > Using PHP you

Re: Elapsed time

2001-06-11 Thread Hasan Niyaz
Rich, You can try TO_DAYS() first before finding the diff. of the two dates. Perhaps this would give you a better solution. Hasan - Original Message - From: "Rich Duzenbury" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 5:22 AM

Re: Field length problem!

2001-06-11 Thread Hasan Niyaz
hi, what did you assign the col type and what is the length... - Original Message - From: "Simon Abolnar" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 11, 2001 8:15 PM Subject: Field length problem! Hello! When I add record in database everything works OK. When I mod

Re: Pound (£) Symbol and MySQL

2001-06-08 Thread Hasan Niyaz
is the column an int? if this is the case why not you strip the pound sign before inserting. with PHP you can always add the sign when retrieving. Hasan - Original Message - From: "technical Support" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday,

Re: dealing with datetime

2001-06-08 Thread Hasan Niyaz
You might want to first find lastlength before running the update query. - Original Message - From: "Siim Einfeldt aka Itpunk" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 2:25 AM Subject: dealing with datetime > > Hi, > > Just working here on a php-mysql p

Re: New To mySQL

2001-06-07 Thread Hasan Niyaz
Start with the manual - Original Message - From: "Geoffrey Van Nuffelen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 07, 2001 5:34 PM Subject: New To mySQL > Hi all, > > I am a new user of mysql DB. > > I am working with WN NT 4. > I already downloaded the m

Re: MySQL too slow....

2001-06-07 Thread Hasan Niyaz
I use PHP, a very special scripting language for the web and has an excellent list of commands to interface with MySQL. I recommend the book professional PHP and also the site php.net thanks, Hasan Impex - Original Message - From: "Muhammad Asif" <[EMAIL PROTECTED]

Re: events that i can trigger on intervals.

2001-06-05 Thread Hasan Niyaz
Hi, Just wanted to thank everyone for all the suggestions. cheers, Hasan - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Hasan Niyaz" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 06, 2001 1:45 AM Sub

events that i can trigger on intervals.

2001-06-05 Thread Hasan Niyaz
. Thanks, Hasan ps. I use a PHP interface. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EM

MySQL developer group

2001-02-18 Thread Hasan Niyaz
interested please, contact us for details for this system. Looking forward to hear from you soon. Hasan Niyaz Manager Sales and Marketing. Direct: 960 773995 Impex Holidays Maldives Affiliated with Impex Delaware, Inc / USA Phone : (960) 310355

problem in tar

2001-02-17 Thread HASAN farooq
I have GNU tarbut still when i decompress the the mysql i get mysql-3.22.32-sun-solaris2.7-sparc/sql-bench/Results/ATIS-Adabas-Linux_2.0.35_ i686-cmp-adabas,mysql, 691 bytes, 2 tape blocks tar: directory checksum error i have used both versions mysql-3.22.32-sun-solaris2.7-sparc.tar mysql-3.23.3