(dumb) embedded question

hi is it possible to have 2 applications update/insert/delete records from a embedded database. example: app1 on a repetitive process checks for record in table1 while app2 inserts a record in table1. if u think about it, it should be possible. technically, the mysqld process is now imbedded

mysql 4.0.20 bug -lmysqld linking error (bug?)

hi i'm trying to compile my C app using mysql embedded stuff, but i get the following linking error. is this a mysql 4.0.20 bug? should i replace -lmysqld with -lmysqlclient when compiling for embeeded mysql? (does solve the problem.) gcc -L/usr/lib/mysql -ofdlog fdlog.o util.o fdipc.o

foreign keys......

hi how does 1 know if a foreign key is defined? describe tablename and show index from tablename dont sufice tks Disclaimer http://www.shoprite.co.za/disclaimer.html

column names in select

'lo is it possible to suppress (i.e. not display) the column names from the resultset of a select statement? if so, how? tks tom Disclaimer http://www.shoprite.co.za/disclaimer.html

purge logs problem

hi listers i have 'log-bin' enabled in my.cnf for replication purposes. once in so many days i remove them using syntax purge master logs to 'logname'. this is fine and works ever time for all lognames i specify. but today i have a problem with 1 of the 7 i had to delete (the last 1 for that

mysqladmin processlist and pid

hi listers how would i determine the association between the id from mysqladmin processlist to a pid? what i'm after is that i notice some of the mysql threads have a high cpu utilization. i see this using top (on a linux box). i would like to know which user/program is responsible for tuning

SQ puzzle

SQL puzzle from the Informix mailing list: Two mathematicians (Boris and Vladimir) met accidently for the first time in 20 years. They greet each other and begin catching up on their respective lives. Boris asks Vladi Do you have any children? Yes replies Vladimir, I have three. How old are

DBD::MySQL and win32

hi listers where can i find/download such software? tks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

solution...... RE: :MySQL and win32

sorry guys, i was a bit quick. i found it @ http://search.cpan.org/~rudy/DBD-mysql-2.9003/lib/DBD/mysql.pm -Original Message- From: Tom Roos Sent: 05 January 2004 14:26 To: [EMAIL PROTECTED] Subject: DBD::MySQL and win32 hi listers where can i find/download such software? tks

RE: Memory and C API...

it could be that err is initialized as 0 or not initialized at all -Original Message- From: Lars Wenderoth [mailto:[EMAIL PROTECTED] Sent: 23 September 2003 13:02 To: [EMAIL PROTECTED] Subject: Memory and C API... Hello there! I have a problem with a little C program i am writing.. It

RE: Slave not replicating database

whats the error? -Original Message- From: Søren Neigaard [mailto:[EMAIL PROTECTED] Sent: 18 September 2003 09:52 To: '[EMAIL PROTECTED]' Subject: Slave not replicating database I have just added aother slave to a master i have running. I have used the command: CHANGE MASTER TO

RE: MySQL C API

whats the error u get? -Original Message- From: Håkan Medin [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 10:31 To: [EMAIL PROTECTED] Subject: MySQL C API Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't

RE: ERROR 1030: Got error 127 from table handler

hows u're disk space? -Original Message- From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 19:11 To: [EMAIL PROTECTED] Subject: ERROR 1030: Got error 127 from table handler /usr/local/mysql/bin/perror 127 Error code 127: Unknown error 127 127 =

notification when replication stops.....

hi every now and then my replication stops. i now about this when i logon 2 the slave and check the status. what is the best procedure i would follow 2 automate a notification message when replication stops? i ryn mysql 4.0.13 on rh linux tks _ ___ _ __ /___

mysqld --myisam-recover=[option,[option]]

hi listers does this option only apply when the mysqld starts up or each time a table is opened for read/write? thanks _ ___ _ __ /______/ / ___/ / \ // / / / // / / ^ v / / / / /__/ / / / \/ / /

RE: Frequent Table Corruption - Please Help

hi guys i am runing the rh 2.4.20-18.7smp kernel with mysql 4.0.13 and i sometimes experience problems with table corruptions when volumes become high. i'm trying different parameters for mysqld to see if the problem goes away. tom -Original Message- From: Richard Gabriel

table crash problem

hi listers i've upgraded my mysql env from 3.23.53 to 4.0.13. also, i changed os from m$ to rh 7.3. what did not change was h/ware. since the upgrade, i often get the error message table is marked as crashed and should be repaired. (errno 145). i then run myisamcheck --auto-repair to fix the

RE: replication

on the slave, run show slave status at the mysql prompt. if there is an error, one of the fileds will tell u what it is -Original Message- From: Moritz Steiner [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 16:41 To: [EMAIL PROTECTED] Subject: replication I set up a replication with

test 1 2 3...

_ ___ _ __ /______/ / ___/ / \ // / / / // / / ^ v / / / / /__/ / / / \/ / / /_ / /__ / /_ / /_ / Cell: 083 440 2213 Ph: 021 980 4969

question: replication of tmp table.....

g'day listers i run a mysql 4.0.13 master and slave on linux rh 7.3 servers. every now and then i get a error on the slave. the error is that it cannot insert data into a table that does not exist. the problem is that the table its complaining about is a tmp table. that table is created when

RE: question: replication of tmp table.....

ahh.. http://www.mysql.com/doc/en/Replication_Options.html: replicate-wild-ignore-table=db_name.table_name tks alec -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 14 July 2003 14:29 To: Tom Roos Subject: Re: question: replication of tmp table

error 2003

hi listers i have a c program that connects to a myssql db. for some reason or another, every now and again i get the following error message ERROR in mysql_real_connect() Number: 2003 Message: Can't connect to MySQL server on 'softdistqa' (10048) i find enough info on mysql website about

Hmmm, nice GUI admin tool

checkout http://www.webyog.com/ sql,query _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus - Before

subtraction on datetime fields

hi i want to build a query in which i have 2 datetime fields which i subtract from one another. what is the result set? is it in (milli)seconds, is it a unix timestamp? what type of convertion do i have to apply to report the difference in minutes? tks tom

question about mysql_real_escape_string()

hi does this function handle a binary string of any length or is there some sort of max limit. when i load a binary file (filesize 49Kb) into a blob field, the function is ok but when the filesize is 1.8Mb, the function fails and my programs aborts. using the debugger, the program aborts when

sample c code wanted

hi my query is that i am looking for sample c code on how to load/extract binary data into/from a blob field. can u help me? tks tom _ The new MSN 8: advanced junk mail protection and 2 months FREE*