Re: spool log to a file

The problem with below statement is that, if i there is any error in sql statements it does not get written to 1.txt. So, even if there is any error, how can i get it written to 1.txt. mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' > 1.txt On 7/29/08, Mary Bahrami <[EMAIL

Prepared statement cursors problem.

Hi all: I need to set a cursor for doing a SELECT (using the C API) According the documentation I did in order to setup the cursor. --- const unsigned long cursor_type = CURSOR_TYPE_READ_ONLY; if (mysql_stmt_attr_set (mysql_stmt, STMT_ATTR_CURSOR_TYPE, (void *) &cursor_type)) { g_

Re: log-queries-not-using-indexes and "Using index" in the Extra col of Explain

Isn't the choice in the the "type" col of Explain a "full index scan" rather than a full table scan ?My understanding was that the "ALL" stands for "full table scan ". Thanks, Mariella On Tue, Jul 29, 2008 at 11:03 AM, Mary Bahrami <[EMAIL PROTECTED]>wrote: > The optimizer made the correct ch

Re: MySQL won't start with external bind-adress in my.cnf

Thanks Chaim, You just clued me in. First, when you said to post output of ifconfig, I realized my LAN is configured not directly to the public address, but to 192.168.1.250 which is then tied to the public IP through port forwarding. I'm not completely up on why this was done, but when t

locked file mysqld-nt.exe when re-installing mysql on windows server

Hi I'm reinstalling an instance of MySQL 4.1 on a Windows Server 2003 machine, but I cannot delete the original installation folder or re-install into it due to the presence of the mysqld-nt.exe file in the C:\mysql\bin folder. I've killed all services relating to MySQL (or those that I can clearly

Re: MySQL won't start with external bind-adress in my.cnf

Skip Evans wrote: Chaim Rieger wrote: Skip Evans wrote: can you post the output of ifconfig please bge0: flags=8843 mtu 1500 options=1a inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255 bge1: flags

Re: MySQL won't start with external bind-adress in my.cnf

Chaim Rieger wrote: can you post the output of ifconfig please I should have noted that 192.168.1.250 on bge1 is configured for port forwarding to the public IP address of the server. -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720 http://bigskypengu

Re: MySQL won't start with external bind-adress in my.cnf

Chaim Rieger wrote: Skip Evans wrote: can you post the output of ifconfig please bge0: flags=8843 mtu 1500 options=1a inet6 fe80::230:48ff:fe88:2b8a%bge0 prefixlen 64 scopeid 0x1 inet 192.168.1.100 netmask 0xff00 broadcast 192.168.1.255 ether 00:30:48:88

RE: MySQL won't start with external bind-adress in my.cnf

I have 5.1 a VCS mysql cluster and I set the bind address for the virtual ip the nodes share in the mysql script; didn't look up 6.0 changes yet: $bindir/mysqld_safe --datadir=$datadir --pid-file=$server_pid_file --bind-address=17x.20.999.999 --local_infile=0 $other_args >/dev/null 2>&1 & -O

Re: MySQL won't start with external bind-adress in my.cnf

Gerald L. Clark wrote: Does that IP address resolve to your hostname? Yes, it does. -- Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison, WI 53703 608-250-2720 http://bigskypenguin.com =-=-=-=-=-=-=-=-=-= Check out PHPenguin, a lightweight and versatile PHP/MySQL, AJAX & DHTML deve

Re: MySQL won't start with external bind-adress in my.cnf

Skip Evans wrote: Hey Chaim, I'm sorry, I don't know what you mean by "default route". I am only familiar with the current contents of my.cnf, and mods were made according to instructions I found via Google. I don't see this noted in MySQL anywhere. Is this a network-wide configuration? ca

Re: MySQL won't start with external bind-adress in my.cnf

Skip Evans wrote: Hey all, I'm trying to get my MySQL server configured so outside connections can access it with OpenOffice.org 2.4. My server is running on FreeBSD 6.0 and the my.cnf file looks like this currently. [mysqld] user = mysql pid-file = /usr/local/mysql/bigskypenguin.com.pid s

Re: MySQL won't start with external bind-adress in my.cnf

Hey Chaim, I'm sorry, I don't know what you mean by "default route". I am only familiar with the current contents of my.cnf, and mods were made according to instructions I found via Google. I don't see this noted in MySQL anywhere. Is this a network-wide configuration? Skip Chaim Rieger

MySQL won't start with external bind-adress in my.cnf

Hey all, I'm trying to get my MySQL server configured so outside connections can access it with OpenOffice.org 2.4. My server is running on FreeBSD 6.0 and the my.cnf file looks like this currently. [mysqld] user = mysql pid-file = /usr/local/mysql/bigskypenguin.com.pid socket = /tmp/mysql

RE: log-queries-not-using-indexes and "Using index" in the Extra col of Explain

The optimizer made the correct choice when it did a full table scan where there were few rows...I wouldn't want to override the optimizer in this case. Check that you updated statistics between these two queries (information_schema.statistics.cardinality). -Original Message- From: MySQLFo

RE: spool log to a file

I use mysql -uroot -pxxx -Dtest -s -e 'select * from amc_25;' > 1.txt but it would be nice to see other solutions... -Original Message- From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2008 6:37 AM To: mysql Subject: spool log to a file Hi All, I am executing

spool log to a file

Hi All, I am executing below command, but there is no entires in 1.txt, its an empty file. How can i write the logs into this file. mysql -uroot -pxxx -Dtest -s --tee=1.txt -e 'select * from amc_25;' regards anandkl

spool log to a file

Hi All, I am executing below command, but there is no entires in 1.txt, its an empty file. How can i write the logs into this file. mysql -uroot -pxxx -Dtest -s --tee=1.txt -e 'select * from amc_25;' regards anandkl

log-queries-not-using-indexes and "Using index" in the Extra col of Explain

Hi All, I have been using mysql 5.1.26-rc on Linux and configured to log queries that do not use index through log-queries-not-using-indexes I would like to ask two questions, please: 1) I have noticed that in some cases some queries get logged because a scan of the index on a field is executed.

Prepared statement cursors problem.

Hi all: I need to set a cursor for doing a SELECT (using the C API) According the documentation I did in order to setup the cursor. --- const unsigned long cursor_type = CURSOR_TYPE_READ_ONLY; if (mysql_stmt_attr_set (mysql_stmt, STMT_ATTR_CURSOR_TYPE, (void *) &cursor_type)) { g_

Bug?: mysqldump for view definitions

Hi I have a testview defined as mysql> create table testview (a int); Query OK, 0 rows affected (0.01 sec) mysql> create view view_of_testview as (select * from testview); Query OK, 0 rows affected (0.00 sec) I create a dump of this view definition with mysqldump --tab=/tmp test view_of_testv