connect with myODBC to mysql through proxy

2005-11-12 Thread Danny Stolle
Hi all, I have a windows computer in my network which needs an odbc connection through proxy. the only thing is that i don't know how to do this on a windows machine. i have installed the myodbc driver and it works for connecting on a mysql server in my local network. but i have an isp

Re: LIKE problem?

2005-11-12 Thread delta
select count(*) from user where username like 'a%'; select count(*) from user where username not like 'a%' or username is null; is not the same for all letters of the alphabet: letter like not-like sum n 2304 59317 61621 o 0 60797 60797 p 3048 58573 61621 Sounds like

Re: Best Fieldtype to store IP address...

2005-11-12 Thread Björn Persson
Jasper Bryant-Greene: Rhino wrote: Isn't there a new way to express IP addresses called IPV6(?) which has a possibility of 6 distinct parts instead of the traditional 4? I haven't seen one of these new formats myself yet but for all I know, they will become soon in the near future. Maybe

Re: Unable to access mysql database with root user after upgrade?

2005-11-12 Thread SGreen
Murray @ PlanetThoughtful [EMAIL PROTECTED] wrote on 11/11/2005 08:44:37 PM: Hi All, I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine. For some reason my root login can't access the mysql database anymore, though I can use it to access the databases I have defined. In

Re: Unable to access mysql database with root user after upgrade?

2005-11-12 Thread Murray @ PlanetThoughtful
[EMAIL PROTECTED] wrote: Murray @ PlanetThoughtful [EMAIL PROTECTED] wrote on 11/11/2005 08:44:37 PM: Hi All, I recently upgraded from MySQL 4.1.14 to 5.0.15 on my WinXP machine. For some reason my root login can't access the mysql database anymore, though I can use it to access the

Re: MySQL insert performance

2005-11-12 Thread Gleb Paharenko
Please, sorry for a delayed reply. In my previous mail I've asked you include the output of 'show variables' statement, so please do it in your next message. I'd like (and probably others on the list) to see your settings. Also, perform the 'show status' just after

Re: connect with myODBC to mysql through proxy

2005-11-12 Thread Gleb Paharenko
Hello. Please could you describe more in details what kind of proxy you want to use and the network topology (firewalls, routers which perform NAT and so on). Danny Stolle wrote: Hi all, I have a windows computer in my network which needs an odbc connection through proxy. the only

concurrency in mysql 4.0.25

2005-11-12 Thread Chris Kantarjiev
I'm running mysql 4.0.25 on netbsd 3, on a dual-processor opteron machine with 16GB. I'm trying to make things faster, of course. All the data operations are on one very large table (about 20GB, index is 17GB), which I will eventually figure out how to split. I have four processes working on

Problem with collation...

2005-11-12 Thread Alvaro Cobo
Hi guys: I know this question have been asked many times but I still get no solution. I have a database with thousands of rows which by mistake was imported in the wrong way and all the spanish characters went wrong. For example the letter 'á' appears like 'Ãf¡'. The problem is that I am

Re: concurrency in mysql 4.0.25

2005-11-12 Thread Chris Kantarjiev
I see in the pthread(3) man page that there's an environment variable PTHREAD_CONCURRENCY The number of concurrent threads to be run. This value should at least be 1, and smaller than or equal to the number of CPUs. Do I need

mysql_init(m) changes values of variables

2005-11-12 Thread Bruce Martin
Hello all, I found this odd thing when writing a client in C to connect to a mysql database server. I want to use mysql_real_query so I need the strlen() of the sqlStatement. So prior to calling mysql_init(m) I get the length of the sqlStatement. I check that length and it is correct after I

Re: 1266 creating innodb tables

2005-11-12 Thread P. Evans
Much thanks, that did the trick. Pierre Jasper Bryant-Greene [EMAIL PROTECTED] wrote: P. Evans wrote: skip-innodb is commented out,thats why its not in the options I sent previously. The logs are showing something peculiar - InnoDB: Error: log file ./ib_logfile0 is of different size 0

Re: Problem with collation...

2005-11-12 Thread Björn Persson
Alvaro Cobo: I have a database with thousands of rows which by mistake was imported in the wrong way and all the spanish characters went wrong. For example the letter 'á' appears like 'Ãf¡'. That looks like text that was in the UTF-8 encoding has been mistaken for an eight-bit encoding,