Re: table locking and priorities

2001-06-13 Thread Mohammad Shoja
is text and number so you I can't autoincrement a username like abc003434 ... - Original Message - From: Mohammad Shoja [EMAIL PROTECTED] To: anna soobrattee [EMAIL PROTECTED] Sent: Wednesday, June 13, 2001 11:57 AM Subject: Re: table locking and priorities Hi Anna, Why you

Again MySQL and LOG

2001-05-31 Thread Mohammad Shoja
Thank you all for your suggestions, I'm using tcsh so I resolve this problem like this: mysql -u root dbname test.sql ! log and its working on command line but the problem is, it doesnt work when I put mentioned statement into a bach file. for example I create a file (createtables) and its

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-05-30 Thread Mohammad Shoja
Thank you for all your suggestions, I got it. the problem was in our web server because of security $ENV{HOME} doesnt point to my home directory so my .my.cnf file was unreachable. That's it. may be It can be helpful for other people as well. my %attr = ( PrintError =0,

Log

2001-05-30 Thread Mohammad Shoja
Hello everybody. would you please tell me how can I log execution of a DDL? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root databasename test.sql log it Just send errors and logs to STDERR. Thanks you for

Re: SELECT question.

2001-05-30 Thread Mohammad Shoja
I am stuck on a select query and was wondering if someone could help. I have I've written a database app. that helps me run my business (trucking). I need however to write a query that shows me all of the loads that are delivered but not billed (invoiced). Which means that I have to

Log HELP!

2001-05-30 Thread Mohammad Shoja
Mybe this is not a mysql question but a unix command line question: would you please tell me how can I log execution of a DDL? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root databasename test.sql log it

Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)

2001-05-29 Thread Mohammad Shoja
Thanks for your reply The question is why in command line there is no problem? It is looking for /tmp/mysql.sock and the one that exists is /tmp/mysql.sock.shoja Two different files.. It can't find what it is looking for. Try: safe_mysqld --socket=/tmp/mysql.sock and it should work