typical: need help

I m running a mysql-server 3.23.49 under suse 6.4 (kernel 2.2.14) and myodbc 3,51 .. I have an mdb file and want to export the tables from access 2002 to the mysqldb .. I can connect to the db and read the tables .. but when I want to export them .. I get a syntax error ??? What is wrong ---

Lost primary key from table

Hi, I've really interresting topic this time: our application stopped getting data. It turned out these queries were unexpectedly slow while operating on MyISAM tables: ++---+---+--+-+--++--

AIX binary distribution problem

I downloaded the AIX binary distribution of mysql 3.23.49. Unpacks OK, apart from camplaints about @LongLink: 402 % tar -xf mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar tar: can't create ././@LongLink: Permission denied tar: can't create ././@LongLink: Permission denied ... (repeated many times) Wh

Innodb replication and Database renaming question

Hi, I'm still using Mysql 3.23.46 because, as far as I remember, in .47 was reintroduced the limit of 500 chars max in Innodb primary keys (limit that would break my application). Is it still present ? Is it present in Mysql 4 ? I also need to know if Innodb is reliable in replication mode

Re: Why I can not connect to mysql (using jdbc)

Jianping Zhu wrote: > catch (SQLException se){System.out.println("trouble to connect");}// Change your catch statement--you're throwing away information now. You may find helpful debug info... catch (SQLException se) { System.out.println(se);} OR catch (SQLException se) { System.out.println("t

mingw, mysql c api, win2k cmd line error

I am having a heck of a time getting a simple c program up and running using mingw and the mysql c api. My makefile is simple enough I'm not sure what the -lm switch on the search compile line is for but I saw it in someone's makefile on the web so I through it in hoping it would work): # mak

Bug

1. I' am using mysql-max-3.23.49 for Windows and y have a problem to insert a tuple with the char ñ. Anyone can tell me how solve this problem ? 2. I'm developing an aplication with Power Builder 7.0. What is the compatibily of MySQL with Power Builder 7.0 ? Thanks. --

Slow query

Hi all. I'm using MySQL server 3.23.47 (client 3.23.44) on Windows 98 (...sorry) accessing to database via ODBC (MySQL ODBC release 3.5.01.01) and VC++6.0 & MFC (CRecordset). I have noticed that queries are really slow... with a simple SELECT like this: SELECT ID_Field, Text_Field, Date_Fie

Re: Text Limitation

Sergei, thank you for clarifying this. I was misinterpreting the manual where it says: `FULLTEXT' indexes can be created from `VARCHAR' and `TEXT' columns at `CREATE TABLE' time ... Regards, Thomas Spahni On Wed, 13 Mar 2002, Sergei Golubchik wrote: > Hi! > > On Mar 13, Thomas Spahni wrote:

Re: remote connect

Please endulge me, On wich machine is PHP running. - Original Message - From: "Mike Estes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 9:41 AM Subject: remote connect > I can't connect to mysql remotely. I have added my hostname to the host > table, i have

Re: remote connect

On Friday, 15. March 2002 09:41, Mike Estes wrote: > I can't connect to mysql remotely. I have added my hostname to the host > table, i have the correct entries in user table,for localhost, my hostname, > my ip, and even %. i can login locally through the shell, and the uname and > pass is same fo

remote connect

I can't connect to mysql remotely. I have added my hostname to the host table, i have the correct entries in user table,for localhost, my hostname, my ip, and even %. i can login locally through the shell, and the uname and pass is same for all entries. What else could be wrong. I'm using a php sc

processes stuck in "Opening table" state

hi all, i've got a mysql server running around 100 queries per sec for most of the time. i got only 1 table in MyISAM format. i got only around 6000 updates to this table per day. max_connection is set to 600 thread_cache is set to 600 table_cache is set to 600 (there is NO join operation) eve

Re: GETTING STARTED !!

On Friday, 15. March 2002 09:32, Sammy Lau wrote: > > 2. How to check if mysql server is up ? > > [Sammy] trying to connect the mysqlserver is the best way to do the job. Try: ps -ax | grep mysqld or mysqladmin ping Regards Georg ---

Re: GETTING STARTED !!

"Suresh R. Soni" wrote: > > Hi All, > I have good Sybase experience and I have installed > MySQL in a Linux box. Can u please answer my following > queries: [Sammy] I like Sybase very much as well. =) > 1. When I run safe_mysqld I get "Starting mysqld > daemon with database from /var/lib/mysql 0

<    1   2