HOW TO INSTALL MYSQL ODBC ON AIX 5.3 ?

FOLLOW ARE SOME MY OPERATOR STEPS,HOW WILL I TO DO IT? p570a:/mysql/mysql-connector-odbc-5.1.6-aix5.3-powerpc-64bit/bin >./myodbc-installer exec(): 0509-036 Cannot load program ./myodbc-installer because of the following errors: 0509-150 Dependent module libodbc.so could not be loaded.

mysqldump.exe gives "Access Denied" for user

Gurus, I'm running a Windows Server 2003 cmd shell script to backup my databases using: %mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% -p%dbpass% > %bkupdir%\dbBkup_%dbname%_%yy%%mm%%dd%.sql @ECHO Done! New File: dbBkup_%dbname%_%yy%%mm%%dd%.sql It's been running fine until I've had to change

Re: db is bring dropped, binlog help

n my server's log and it appears that a > connection is given an ID (which is where you see which user it was) then > that ID is used throughout the log to indicate which queries have been > executed from that connection. > > Hope you get this sorted out! > > Andy > >

db is bring dropped, binlog help

Hi folks, We're experiencing a really bizarre thing. One of our mysql 5.0 databases is mysteriously and constantly being dropped. This is a cap from our binlog: #090409 15:09:13 server id 1 end_log_pos 326997 Query thread_id=9923 exec_time=1 error_code=0 SET TIMESTAMP=1239304153/*

RE: MySQL Daylight Savings Time Patch

d for Solaris 2.x, 9 and 10, Windows XP, and Mac OS X 10.4, and almost certainly others. HTH, Dan On 2/20/07, Chris White <[EMAIL PROTECTED]> wrote: > > Sun, Jennifer wrote: > > Any answers for the question below ? > > > > Is there a DST patch for MySql

RE: MySQL Daylight Savings Time Patch

Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, February 09, 2007 9:30 AM To: mysql@lists.mysql.com Subject: MySQL Daylight Savings Time Patch Is there a DST patch

Re: transitioning from ms sql

On 9/27/06, Arjun Bhandari <[EMAIL PROTECTED]> wrote: Hi, I have been using MS SQL for the last one year, however would not like to Huh? If you would NOT like to transition to MySQL, then why are you asking all these stuff? -- MySQL General Mailing List For list archives: http://lists.mysql.c

Strange insert: ERROR 1172 (42000)

This is so weird! I'm getting a: ERROR 1172 (42000): Result consisted of more than one row I've setup 2 machines. Same table (dbsetup.sql) , same insert statement (foo.sql), same version (5.0.24a). Only difference is: One is my laptop on FC5-i386, the other is a server on RHEL4u4-i386 Any clues

Re: CentOS 4.3 - MySQL - NIS user issue

On 8/31/06, Tom Brown <[EMAIL PROTECTED]> wrote: Hi I have what i think is a strange issue - now when a NIS user tries to use the db [EMAIL PROTECTED] su - bugzilla [EMAIL PROTECTED] mysql -u bugs -p bugs ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mys

Re: Outputting text in a

On 8/24/06, Dan Buettner <[EMAIL PROTECTED]> wrote: Sure - in your sql script, put in SELECT "text to the screen"; Then you'll get 2 copies... Try this: SELECT "text to the screen" AS ''; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://li

restarting mysql server

Dear there, After install mysql 4.1.12 by using rpm, I have some problems to restart server after shutting down it. When I use "mysqld_safe" try to restart, it give me error as follws: Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld

problem-Lost connection to MySQL server during query

Hi, I install Mysql 4.1.12-0 by rpm. When I try to create a table, it give me "Lost connection to MySQL server during query". My query is like: CREATE TABLE ArrayBatch ( id int(11) NOT NULL auto_increment, arrayType int(11) NOT NULL default '0', descr text NOT NULL, printStartDate date

problem-Lost connection to MySQL server during query

Dear there, I met some problem when I try to use \. command to create several tables from a file in mysql. I got error as follows: ERROR 2013 (HY000): Lost connection to MySQL server during query ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... ERROR 2002 (HY0

Install mysql question

Dear there, I have some problems when installing mysql under rpm. Hope some people can give me help. I install MySQL-server-4.1.12-0.i386 package and MySQL--client--4.1.12-0.i386 package under root account. Under the root account, I can start the mysql and it seems working fine. However, wh

ERROR 1105: Unknown error with flush logs

Hi, We are running mysql-4.0.22 on Gentoo Linux. We do regular mysqlhotcopy of all databases and do regular flush logs for transaction logs. However, My flush logs failed since yesterday, the mysqladmin flush-logs gave me error: /usr/bin/mysqladmin: refresh failed; error: 'Unknown error' When

RE: tuning suggestion for large query

] Sent: Thursday, September 02, 2004 2:41 PM To: Sun, Jennifer Cc: [EMAIL PROTECTED] Subject: Re: tuning suggestion for large query Due to the nature of myisam tables, when you are doing a query then the table will be locked for writes. Reads will still be permitted until another write request is

RE: tuning suggestion for large query

0:37 AM To: [EMAIL PROTECTED] Subject: RE: tuning suggestion for large query At 04:13 PM 9/1/2004, Sun, Jennifer wrote: >Thanks Mike. >Seems like even with handler, the big query process is still consuming all >my RAM and swap and being killed with error >'VM: killing process my

RE: tuning suggestion for large query

The command is issued from mysql command line. Is there any parameters or options I can use without locking the table? -Original Message- From: Marc Slemko [mailto:[EMAIL PROTECTED] Sent: Thursday, September 02, 2004 2:24 PM To: Sun, Jennifer Cc: [EMAIL PROTECTED] Subject: Re: tuning

RE: tuning suggestion for large query

Thanks Mike. Seems like even with handler, the big query process is still consuming all my RAM and swap and being killed with error 'VM: killing process mysql __alloc_pages: 0-order allocation failed (gfp=0x1d2/0)' I would like to find a startup parameter either for client or server to limit per

tuning suggestion for large query

Hi, We have a job that do 'select * from big-table' on a staging mysql database, then dump to data warehouse, it is scheduled to run once a day, but may be run manually. Also we have several other small OLTP database on the same server. When the big job run, it would use all the physical mem and

which table type does not have the maximum columns limitation?

Dear List: I wonder if there exist a type of table which can allow for unlimited or at least more than 1024 columns? I know MaxDB has 1024 max columns. Please give me a hint if you could. Thanks in advance! Hongyu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Restore table option

Hi there, Does anybody know how to drop table option? I added a table option "alter table abc order by col1 desc". Now I want to remove this option, How can I do? Thanks

os X install followup

This is a follow-up mac os X installation problem: I mentioned in an earlier e-mail that var/ and run/ are nowhere to be found, so I did as Jim Dickenson suggested and mv'd data to var. now when I run "./bin/mysqld_safe &", I get an error that says /usr/local/mysql/libexec/mysql is missing (be

os X install mySQL help

This is a mac os X installation problem: When I download/install the pkg version of mysql 4.0.13, two directories seem to be missing in /usr/local/bin/mysql: var/ and run/. So, when I try to run mysqld_safe (or safe_mysqld), I get errors like: " touch: /usr/local/mysql/var/myhostname.err: N

Re: A simple error about mysql

Roger - Original Message - From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> To: "Roger Sun" <[EMAIL PROTECTED]> Sent: Tuesday, September 17, 2002 5:23 PM Subject: AW: A simple error about mysql > Hi Roger, > > as far as i understood , you can log

A simple error about mysql

Hi,every one: pls help me. i have downloaded a mysql 3.23.52 server and client linux rpm package. i installed them on rh7.2 everything is ok. and the mysqld daemon has also been started. but when i try to change the root password using the folloing command: /usr/bin/mysqladmin -u root pas

Searching text in a big table

Hi there, I have a big table which has 25 rows.And each row has a BLOB field which stores lots of text. When I search text in this table(using the query: where CONTENT like '%news%'),the searching speed is quite slow. is there anybody also have such problem? Any ideas about improving the s

Searching text in a big table

Hi there, I have a big table which has 25 rows.And each row has a BLOB field which stores lots of text. When I search text in this table(using the query: where CONTENT like '%news%'),the searching speed is quite slow. is there anybody also have such problem? Any ideas about improving the sp

RE: Mysql Installation problem with 3.23.49 Linux Source release on RH7.3 Beta 1.

I am trying to install mysql 3.23.49 source release on RH7.3 Beta 1 workstation... Encountered the following gcc C++ compiler executable creation problem when ./configure checks for C++ compiler it complains : checking for gcc... gcc checking whether the C compiler (gcc ) works... y

mysqlbug

Hi everybody! I am a new for MYSQL. I want to install MYSQL on AIX 4.3.2 (UNIX). And I got the following error message. Could someone can help me? Shell> set MYSQL = '/adm/ac/listserv/Calendar/mysql' Shell> echo $MYSQL /adm/ac/listserv/Calendar/mysql Shell> scripts/mysql_insta

Re: How to send multiple statements to the server?

Hi; Mysql is not like the Linux/Unix command line. You can't perform such an operation. Sun root wrote: > Hi! > i'm using mysql 3.23.47 and i'm triing to send 2 or more statements in > one string separated with ';' but i does n