Re: Compiled C-language CGI-BINs with MySQL

2006-11-11 Thread Lars Heidieker
) and which use the C-language interface of MySQL? Does it work OK? Thanks. - -- Viele Grüße, Lars Heidieker [EMAIL PROTECTED] http://paradoxon.info - Mystische Erklärungen. Die mystischen Erklärungen gelten für tief; die Wahrheit ist, dass sie noch nicht

Re: MyISAM vs InnoDB

2006-11-07 Thread Lars Heidieker
transaction_id COMMIT PREPARED transaction_id ROLLBACK PREPARED transaction_id and it states PREPARE TRANSACTION -- prepare the current transaction for two-phase commit - -- Viele Grüße, Lars Heidieker [EMAIL PROTECTED] http://paradoxon.info - Mystische

Re: Compile/Install problems, NetBSD 1.6

2002-12-25 Thread Lars Heidieker
Hi, have you tried the mysql-server from the pkg collection of netbsd? Lars On Dienstag, Dezember 24, 2002, at 09:44 Uhr, Bruce Lane wrote: Fellow MySQL'ers, I've been trying to install MySQL ver. 3.23.54a on NetBSD 1.6 on an i386 platform. The difficulty I've been running into is

Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

2002-11-21 Thread Lars Heidieker
Does the memory amount used increases any further if repeating the dump import. If so there is a leak if not you just got fooled by the standard malloc of solaris which wont return memory free(d) to the system but instead the memory will be kept in a pool for the next malloc. Lars On

Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

2002-11-21 Thread Lars Heidieker
, Markus On Don, 21 Nov 2002, Lars Heidieker wrote: Does the memory amount used increases any further if repeating the dump import. If so there is a leak if not you just got fooled by the standard malloc of solaris which wont return memory free(d) to the system but instead the memory

Re: Copying to tmp table

2002-09-23 Thread Lars Heidieker
hi, on solaris it probably a good idee to change the tmp directory from /var/tmp - /tmp as /tmp is a ram disk that gives a good performance boost if tmp tables are involved. The sort_buffer variable the the one to look at try increasing it, as if the result fits into the sort buffer no tmptable

Re: Mystery files

2002-03-20 Thread Lars Heidieker
Have a look for binary log files in the manual these are binary log files, needed for replication setup eg. Lars mysql mailing list user wrote: Hi, I my mysql server database directory (that is the directory that holds the .err and .pid files) so strange files have apeared. They look line

Re: MYSQL DATABASE BACKUP

2002-03-19 Thread Lars Heidieker
not quite sure what you mean by locking. each table will be locked during readout for the dump automaticly for the time the select runs and delivers data to the dumping program. it is not needed to lock the tables (more than one) in advance for a dump, but that, might better for dataintegrety.

Re: Dropped database

2002-02-15 Thread Lars Heidieker
Just copy the backup files into the database dir and the database should be back. Lars At 08:22 AM 2/15/2002 -0500, Paul wrote: Hello mysql, I dropped an entire database but I have the frm, myd and myi files in a backup. What are the complete steps to restoring this database?

Re: Solaris Optimizations

2001-09-06 Thread Lars Heidieker
I think what you see is the fact that x86systems have overtaken workstations in some respect. have a look at spec.org for specint (which should be most relevant for databases) the same is true for memory throughput (look out for streambench) At 01:13 PM 9/6/2001 -0700, Floyd Mann wrote: Hello

Re: Case insensitive records search

2001-06-11 Thread Lars Heidieker
Andis Grasis wrote: Hi! I have such SQL : select CompanyName from Company where CompanyName like '%car%' Really I need in query result all of companys, which contains symbols CAR in any case (car, Car,CAr, CAR, e.t.c). I think that I need Case insensitive records search. Is it's

Re: backup mysql using crontab

2001-04-03 Thread Lars Heidieker
Pete Harlan wrote: Probably because you need to redirect your output into the file AFTER all the options. Rewrite your command like this: In which shell? In SunOS /bin/sh, or in bash, the shell strips out the redirection, and the program sees what's left. It doesn't matter where the

Re: backup mysql using crontab

2001-04-02 Thread Lars Heidieker
Hi, the cammod looks wiered to me try something like mysqldump --flush-logs --add-drop-table -u root -pmarkloky shuncheong /backup/shuncheong.sql lars "Mark Lo (3)" wrote: Hi, I would like to know how to backup mysql using crontab or cron jog. I have add a line in my crontab file :

Re: Newbie simple question

2001-01-13 Thread Lars Heidieker
Nick Gianakas wrote: Hi all, I just started learning mySQL yesterday. I'm using it for a web application (simple CGI stuff). To begin, I wrote a simple program that just initializes a mySQL connection and then closes it. Here's my problem: I'm getting compile errors when I link the