Win Linux

2004-05-01 Thread Segismundo
Hi all! I want you to present this question: 1) I'm working finely with Mysql 5 over W2k without problems on Disk1. My datadir is on Disk2. Ok. 2) One mounth ago, i've installed Linux (Debian) and yesterday i've instaled mysql 4.00 on a partition of the Disk1. Without problems. 3) I'm trying

Re: Win Linux

2004-05-01 Thread Ivan Cukic (Foment)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | | 4) My question is: Is it possible that de datadir was the same to | Win and Linux because i can't duplicate my databases? The disk2 is | read and write. If it is possible, how? You can create a symlink. Have you tested compatibility between MySQL 5

ERROR 2026: SSL connection error

2004-05-01 Thread Tobias Gunkel
Hello! I'm using MySQL 4.0.18 on a SuSE 9.0 machine. I compiled it with ./configure \ --with-vio \ --with-openssl \ --without-debug \ --without-bench \ --enable-assembler I've created the certs keys with the following commands: openssl

MySQL Users Table

2004-05-01 Thread shaun thornburgh
Hi, I have just installed MySQL on Windows 2000, after inspecting the mysql users table I have noticed that there are four users: Host User localhost root gcw root % root gcw I know about the two root accounts but where did the gcw user come from, there is no

RE: MySQL Users Table

2004-05-01 Thread electroteque
your hostname ? -Original Message- From: shaun thornburgh [mailto:[EMAIL PROTECTED] Sent: Saturday, May 01, 2004 10:53 PM To: [EMAIL PROTECTED] Subject: MySQL Users Table Hi, I have just installed MySQL on Windows 2000, after inspecting the mysql users table I have noticed that there

lower_case_table_names

2004-05-01 Thread shaun thornburgh
Hi, I am trying to set the mysql variable lower_case_table_names to 2, however I am having serious difficulties! I understand I need to do this at the command line but I have tried the following (with many variations) without success: C:\mysql\binmysqld --SET-lower_case_table_names=2;

Re: MySQL Users Table

2004-05-01 Thread Paul DuBois
At 12:53 + 5/1/04, shaun thornburgh wrote: Hi, I have just installed MySQL on Windows 2000, after inspecting the mysql users table I have noticed that there are four users: Host User localhost root gcw root % root gcw Three of the accounts have a root name and one

Re: lower_case_table_names

2004-05-01 Thread Paul DuBois
At 13:23 + 5/1/04, shaun thornburgh wrote: Hi, I am trying to set the mysql variable lower_case_table_names to 2, however I am having serious difficulties! I understand I need to do this at the command line but I have tried the following (with many variations) without success:

No Posting

2004-05-01 Thread Kirti S. Bajwa
Test message. This is a test message. I have not received any post from MySQL for two days. I just want to make sure that this message gets back to me. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Fwd: [xbasic] Re: Calls to C libs (database)

2004-05-01 Thread lists
Howdy -- I've been tinkering with Xbasic(http://xbasic.org). While there isn't any native DB support (ODBC is in the works). This got me to thinking about making calls to MySQL libs or dll(s) (in the case of Windows). Being mainly a PHP person (and no C), I'm hoping than someone will explain

Re: triggers (or too-many-crappy-questions)

2004-05-01 Thread Robert A. Rosenberg
At 12:22 -0700 on 04/30/2004, Eric wrote about Re: triggers (or too-many-crappy-questions): Hi, Can we have list for people who just like to give newbies shit? How about [EMAIL PROTECTED] How much have you guys paid for your support hmm? This is a free mailing list and I don't really see why

Re: Connect string for ASP

2004-05-01 Thread Joshua J. Kugler
Ummm...you can't do that. The MyODBC driver is used by the script to connect via ODBC. It has to be in a place where ASP can find and use it. It does no good if it is on another machine. The driver does not need to reside on the server machine: it is a client-side piece of software. j-

Re: libmysql setting it's own signal handlers?

2004-05-01 Thread Joshua J. Kugler
OK...thanks for the clarification. It helps. And it's good to know that what I'm doing won't break anything. j- k- On Thursday 29 April 2004 07:16 pm, Sasha Pachev said something like: Joshua J. Kugler wrote: I have a program that is using (via a front end library) libmysql. If I

Re: triggers (or too-many-crappy-questions)

2004-05-01 Thread Joshua J. Kugler
I found that the Postgres mailing list was full of very polite, super helpful people. I found that the MySQL list was full of relatively cranky people with little patience. Over that last year, I've I think I've discovered why. The average quality of the questions posted on the MySQL list

Repair tables

2004-05-01 Thread Mike Blezien
Hello, What is the recommend alternative to REPAIR TABLE for InnoDB tables, this does not work with Innodb table types ?? TIA -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com

Re: Repair tables

2004-05-01 Thread Paul DuBois
At 18:12 -0500 5/1/04, Mike Blezien wrote: Hello, What is the recommend alternative to REPAIR TABLE for InnoDB tables, this does not work with Innodb table types ?? Dump and reload. http://dev.mysql.com/doc/mysql/en/Backing_up.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin,

Accessing DBMS remotely: MySQL? FireBird?

2004-05-01 Thread The masked marvel
Hi, Some of our customers have remote offices. I was wondering if it'd be safe to have a DBMS running at their central office, and have our client application running on hosts in the branches connect to it through a VPN via the Net? What happens if the connection goes south while a branch

Delayed insert record visibility

2004-05-01 Thread Peter Thomas
I'm trying to understand the delayed insert process to see whether I can use it to reduce the load on mysql, and have the following question. Are 'delayed inserts' which are queued but not yet actually added to the database by the handler visible to selects on the table? I'm assuming they are

Performance Tuning on FreeBSD

2004-05-01 Thread Max Clark
Hi all, I have a db that is connection heavy running on FreeBSD 4.9. The server was compiled with Linux Threads enabled. I am searching for performance tuning information. Outside of enabling Linux Threads I haven't been able to find much else. I am under the impression that I should be using

Indexing

2004-05-01 Thread John Mistler
I know this is an elementary question, but I am getting two sets of instructions from different MySQL manuals about setting an index on a prefix of a column of a table. One says to use: KEY indexName (colName(length)) and the other says to use INDEX indexName (colName(length)) Are both all