Re: running sql commands from a shell
On Thursday 17 Jan 2002 1:13 am, Mr Aaron Brandis wrote: Hi everyone This is the first time I have posted to this list and I was wondering if someone could answer my question. I know you can run commands from a shell prompt (such as unix...) like: shell mysql -e 'SELECT * FROM table' database for a simple select query and shell mysqlimport --local database table.txt to import information from a text file. I was just wondering how (and even if you can) set up a pager and write to a file from the shell. I can do it from the mysql command prompt like this: mysql pager cat /home/aaron/tube.txt; mysql select Run from tubes; This will put the result of the query into tubes.txt So does anyone know if i can do this from the shell prompt?? type tee FILENAME and notee to stop - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not updating tables with data but no errors either
On Thursday 17 Jan 2002 4:52 pm, fla wire wrote: Hello, I have a freebsd machine running mysql and php. Yes I am one of those newbies. I have read the FU*K manual. I have a sams learn in 21 day book. also a php essentials and build your own database drive book. I have a brazilian rain forest of manuals,printouts etc. We have a php page that we put in people that belong to a football pool. However it is not adding the data to the table. We do not get any error messages either even tho the php page is setup to display the errors. I find no errors in the http-errrors.log. the httpd-access.log shows the post with no errors. I have checked permissions and the seem right. I can go to the machine and add a person by command line. Using the same info as in the mysql_connect on the php page i can add from the command line. tried the mysql_error() function in php ? printed the connection variable to check you have a resource id ? - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Tergat MySQL Studio
On Thursday 17 Jan 2002 7:16 pm, Alok K. Dhir wrote: P.S. For those who haven't used Mascon, I highly recommend it. It's a terrific tool for managing MySQL databases the only thing I would say against it, is that it's a client not a server, and a larger organisation that needs to change passwords has a small problem with informing every user. (I've had similar problems myself when disgruntled employees have left). - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL newbie question
On Wednesday 16 Jan 2002 7:36 pm, you wrote: Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program, either by itself, or with any arguments, I get the following error. ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) Could anyone provide advice as to what I need to do to get this running? Thanks for any assistance you can provide. type ps -A | grep mysql to see if mysql is running. If its not then try /etc/init.d/mysqld start to see if there are any error messages. If it just wasn't started when you booted type ntsys and scroll down the menu until you reach mysqld and hit space which should put a little star by it and therfore get it working - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: tables_priv not working
On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote: I can't get table-specific grants to work. snip Have you flush privileges ? - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: tables_priv not working
On Wednesday 16 Jan 2002 8:50 pm, Hamlin Nicholas-qa568 wrote: On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote: I can't get table-specific grants to work. snip Have you flush privileges ? Yes. That didn't change it. I think I've got it, from the manual section 4.2.9 :- http://www.mysql.com/doc/R/e/Request_access.html The tables_priv and columns_priv tables are sorted on the Host, Db, and User fields.This is similar to db table sorting, although the sorting is simpler because only the Host field may contain wild cards. - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php