High availability anyone?

Hi. I'd like to build an HA MySQL server using shared storage over Fibre Channel. Having a look at the mailing list archives, the issue was addressed earlier on (I could find traces of it as early as 1999) but AFAICS no definitive solution has been reached. I know there is a commercial solution f

Backups, Replication and the binlog

Hi all! I have been attempting to set up a system that involves replication and have run into some minor problems. I am only replicating one database but not all of the tables in the database. So when changes are made to the replicated dataase, it is logged to the binary log even if it is from a

FW: make problems on solaris 8 x86

Can anybody help me with this please -Original Message- From: suresh [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:20 PM To: [EMAIL PROTECTED] Subject: make problems on solaris 8 x86 Hello I am installing mysql 3.23.37 on solaris 8 x86. I am having problem with strings-x86.

MySQL get Sig 11 during query from Bugzilla

>Description: When I sent this problem to the list earlier, I hadn't read about mysqlbug, so please excuse the improper question submission. Here is the repeat; I am trying to get a new installation of Bugzilla, v 2.12 installed and working. I used a binary tarball of 3.23.36 f

ERROR 1030 at line 1: Got error -1 from table handle

Hi, I am having problems with the above error, which I get when trying to do this: select name from category where match (name) against ('ipaq'); on this table: Field TypeNullKey Default Extra Privileges id int(10) unsignedPRI NULLauto_increment se

Problem with Sig11 stack trace.

If I am posting this to the wrong list, please let me know which is the more appropriate list. Thanks. I am trying to get a new installation of Bugzilla, v 2.12 installed and working. I used a binary tarball of 3.23.36 for the installation. I am also using the Msql-MySQL modules 1.2215. Wh

Re: URGENTE!!!!!!!!!!

Carlos, Hay una lista en espanol aqui.. http://www.mysql.com/documentation/altlanglists.html You can join a Spanish speaking MySQL list at the above link. carlos weiss wrote: > Disculpen pero no se si me podrian mandar todo lo referente a My SQL todo lo que >tengan. por favor > >

URGENTE!!!!!!!!!!

Disculpen pero no se si me podrian mandar todo lo referente a My SQL todo lo que tengan. por favor _ http://www.latinmail.com. Gratuito, latino y en español. - Befor

Re: ERROR 2002

This is an FAQ and usually means that the mysql server hasn't been started yet. Please search the archives at http://lists.mysql.com for further details. - Original Message - From: "albany" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 15, 2001 9:34 Subject: ERROR 2002

Re: Grant

- Original Message - From: "Richard Kurth" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 15, 2001 8:16 Subject: Grant >I am looking for different views about this > I have a few question about Granting privileges to a user > > 1. Do you have to give them GRANT SELEC

Re: How I can mysqlhotcopy?

TYou need to obtain and install the perl DBI (database interface) and the DBD (DataBase Driver) for msql/MySQL, then it will work. freelsq wrote: > > when I use mysqlhotcopy ,it say this: > > [root@my bin]# ./mysqlhotcopy > Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386

ERROR 2002

Hi, I've installed Mysql on my Linux version 7 and i'm having problems starting the database. I'm getting this message ERROR 2002: Can't connect to local Mysql server through socket '/var/lib/mysql/mysql.sock' (111). I've tried the find this file on my system and it not there. Anybody have a

Replication Survey

Hello, everybody. As some of you may be aware, I will be doing a presentation along with David Axmark on replication at O'Reilly Open Source Convention on July 25, 2001. And I could use your help to prepare. What would be really helpful if you, guys, who are using replication on a more or les

RE: Error 1049 - Unknown database...

I'm going to add that there is nothing wrong with the database name that is in the query. If the same query, with slightly different constraints and the _exact_ same database name, is run 1000 times and 3 of them give the Unknown database error, that rules out an application error. Furthermore,

RE: SCO and getrusage()

Boyd, Thanks for the reply. I do have to agree with you however. I do have a system here at home in which client programs compile correctly with the SCO cc. I am still trying to figure out what is different from the development system at work and the system I recently built at home. Thanks, Pa

Grant

I am looking for different views about this I have a few question about Granting privileges to a user 1. Do you have to give them GRANT SELECT,INSERT,UPDATE, DELETE,CREATE,REFERENCES,DROP,INDEX,ALTER for them to use their database? 2. Is it best to give them the least amount of privileges? 3

Re: MySQL 3.23.38 released

On 12 May 2001 00:51:11 +0300, Michael Widenius wrote: > > You can now find MySQL-Max (MySQL binaries with support for the above > table types) for most supported platforms at > http://www.mysql.com/downloads/mysql-max-3.23.html That's great news!!! Congratulations, guys! Now the problems: :-)

Re: Error 1049 - Unknown database...

Just starting using mysql. I am just guesing here :-). It seems to me that it is looking for a database called "databasename"? Perhaps somewhere in your application you are asking the mysql about "databasename" database. I mean, is it possible that you forgot to replace "databasename" with the r

Re: Auto_increment value

Refer to the man page for myisamchk ryan > Hi, > > how I can change AUTO_INCREMENT value for one concrete table in mysql > database? (e. g., this value you can get from 'show table status'). Thanx! > > oSup > > > > e-mail: [EMAIL PROTECTED] > ICQ: 10798264 > tel.: 06

RE: RE: Hmmm...I have all the info, but how do i analyse this?

Hi... I have a table where I log every "search" entered into my site, and I = enter every match returned, Searches had LogType 1 and results have logtype = 2... And a field called GroupIdentifier links several results to one = search... How can I get a number of "searched" without responses? It

Re: Looking for info on Fuzzy Searching with MySQL

Here's the approach I used for searching through a table that needed to search 7 different fields in the table and weight them differently: I run through this expression for each word that's split from the searchstring and through each field with different weights given to each field. Then th

Error 1049 - Unknown database...

Hi, I have a MySQL 3.23.37 server that runs on a FreeBSD 4.2 SMP box which runs some semi-intensive web applications. The system itself has 1GB memory. A few times a minute, I get the following error from my applications: MySQL Error: 1049 (Unknown database 'databasename') The server receives

Re: Hom many columns is too many?

On Mon, May 14, 2001 at 03:51:00PM -0700, Gary Bickford wrote: > > Personal data databases often seem to have variable information that > doesn't fit all that well in relational databases. For example, > multiple phone numbers for different purposes. Create a table with three columns. (1) And

Auto_increment value

Hi, how I can change AUTO_INCREMENT value for one concrete table in mysql database? (e. g., this value you can get from 'show table status'). Thanx! oSup e-mail: [EMAIL PROTECTED] ICQ: 10798264 tel.: 0608/974782 SMS: [EMAIL PROTECTED]

Error 1067 - 010514 19:00:45 MySql: Forcing close of thread xx user: 'sync'

Hi I have tried to search through your knowledge base however I could not find anything that specifically addressed an issue I am observing. I am trying to set up a batch file that will launch the necessary components/services for my AvantGo 3.4 Server. I am processing this on an NT 4.0 Workstat

Re: InnoDB and concurrent operations

Heikki Tuuri wrote: > > Steve, > > on what operating system you are running? > linux, intel 2.2.12 > Was the rollback (and the table load) disk bound? Did you configure much > memory to the InnoDB buffer pool? > I would say the rollback was processor bound, the machine was running with almos

Re: Changing Data Fields through GUI?

You can change data with ksql but to use it, you will have to install some old Qt1.44 and old KDE stuff, asl well as an old libstc++ library, if you don't already have them installed. j- k- On Monday 14 May 2001 14:40, Peter Kovari wrote: > Could someone t

Re: Hom many columns is too many?

Personal data databases often seem to have variable information that doesn't fit all that well in relational databases. For example, multiple phone numbers for different purposes. One thing I'm considering is to have a variable text field that contains XML-encoded data to handle all this misc

Re: SCO and getrusage()

Paul, I am not sure, but I think this is coming up because you need to use gcc libraries. I seem to remember that I tried to link libmysql... with the regular SCO compiler and I got this message. The regular SCO cc will not work. You have to use gcc-2.95.2 or newer, because the regular SCO com

Changing Data Fields through GUI?

Could someone tell us, how to change individual data fields with MYSQLGUI, or when is this feature going to be available? Does anyone know about any other tool that enables you to change individual data fields in tables? Thanks, -Peter -

Looking for info on Fuzzy Searching with MySQL

I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are there other MySQL features that help with Fuzzy searching? Soundex seems very useful, but I'm not sure how to apply it to multi-word strings. I'd also be interested in pointers to general info on writing fuzzy searches. A

GRANT & REVOKE

Hi there I have been battling with this stupid little thing for a while now, I want to grant privileges for SELECT,INSERT,UPDATE,DELETE to a particular user on a particular database. That works 100%. Now I want to revoke DELETE privileges for that same user on say four or five tables, but it says

Re:InnoDB and concurrent operations

Steve, on what operating system you are running? Was the rollback (and the table load) disk bound? Did you configure much memory to the InnoDB buffer pool? Was MySQL responsive during the table loading? Is MySQL responsive if you do a big rollback without cancelling (ctrl-c) the client process

Re: InnoDB Autoincrement deadlock,

Joe, it is a feature which will change :). What it currently does is to execute a SELECT MAX(auto-increment-column) before it does the insert. When the other user comes, he will set a waiting next-key lock in his SELECT MAX(...). The waiting lock prevents the first user from inserting. I knew th

Re: i have question

try: tar -zxvf thezippedfile.tar.gz this should feed by way of tar and gzip - Original Message - From: "LS" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 14, 2001 3:02 PM Subject: i have question hi; i tried to download the file mysqlDBD but how to find GNU zipping pr

InnoDB and concurrent operations

There seem to be some operations that cannot be performed on the server whie InnoDB is doing something. For example I inserted about 200,000 rows in to a table from a file (mysql database < file) the file starts with begin; and contains many inserts, I cancelled (ctrl-c) in the middle of the o

does the create table supports checks on column definition on mysql???

part of database structure example: Create table cliente ( idcliente Int(8) NOT NULL, nombre Varchar(30) NOT NULL, idzona Int(5) NOT NULL, zipcode Varchar(8), direccion Varchar(30) NOT NULL, idasiscom Int(5) NOT NULL, listaprecio Int(2) NOT NULL, diasvencimientofactura Int(2) NOT NULL,

i have question

hi; i tried to download the file mysqlDBD but how to find GNU zipping program? thnks leo

Re: AUTO_INCREMENT value

Hi, how I can change AUTO_INCREMENT value for one concrete table in mysql database? (this value you can get from 'show table status'). Thanx! oSup e-mail: [EMAIL PROTECTED] ICQ: 10798264 tel.: 0608/974782 SMS: [EMAIL PROTECTED]

InnoDB Autoincrement deadlock,

I'm having some problems with tables using autoincrementing primary keys when I use InnoDB.. I've searched through the documentation at Mysql and innobase's website, and havn't been able to find anything saying this is a limitation of innodb, so I will assume this is a bug (or unintention

manual on spanish

You know about mysql manual on spanish ? Carlos Dagorret Rio Cuarto Argentina - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Require an opinion

MySQL is in fact, as you said, a backend database. Forms, reports, labels, those are all done client side. If you do not want to develop your own client application, I suggest using Mascon (if you have some windows clients) available at: www.scibit.com. I have found it to be a VERY nice client

PATCH: InnoDB asserts in trx0roll.c if run out of space in 3.23.38

Hi! I noticed that in the rollback code of 3.23.38 a new bug had slipped in. If you run out of tablespace, you will get an assertion failure in trx0roll.c line 887. You can download a fixed mysql/innobase/row/row0undo.c from http://www.innobase.fi/bugfixes.html, or alternatively just delete the

Require an opinion

I am new to Linux as well as MySQL. I moved to Linux from OS/2 where I was using R:Base to do my database work. When I inquired about a database for Linux I was overwhelmed with the response MySQL. So I went out and bought a few books and started to study. MySQL is obviously a ready for prime

RE: What is reference_priv used for?

hi. last i heard, it was unused... -ravi. -Original Message- From: Jose de Leon [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 2:13 PM To: [EMAIL PROTECTED] Subject: What is reference_priv used for? When granging privaleges for sql databases, what is the reference_priv privaleg

InnoDB tablespace tools

Is there a plan to have any tablespace management tools for innobase? I personaly dont' care if these are via a separate program or through the mysql SQL interface but the following would be very handy. move tables between tablespaces list tables in a tablespace shrink tablespace It is very

Re: MySQL FullText improvements in V4.0

I too am curious! I think one feature that I'd really like to see is the ability to tell the number of times a string appears inside another string. This would help a lot when trying to do search results weighting. -Chris On Mon, 14 May 2001, David Simmons - EliteUKServe.Net wrote: > > H

PROPOSAL mysqldump change for InnoDB

Due to the fact that piping a table from mysqldump to an INNODB table can be as much as 30X slower if the insert is not done with transactions, would it make sense to add some option to mysqldump to make every X inserts a transaction. for example mysqldump --transactionrows=10 mydatabase |

What is reference_priv used for?

When granging privaleges for sql databases, what is the reference_priv privalege used for? I have check the online documentation and I can find no clear description of what this is used for. There are a few mentions of the reference_priv but only that it exists, not what it is used for. If ther

Re: table options and performance

Steve Ruby wrote: > > Steve Ruby wrote: > > > I'm inserting 49,990 rows via file containing individual inserts > > (1 insert per sql statement). The table contains 7 columns and 6 > > indexes. > > > > Why is there so much difference on the time taken to insert the > > files? > > > > averages: >

my sql_escape_string()--Bug?

Hi Sinisa, 1. Thanks for the detailed mails .I got to the problem I am facing with '\' character. 2. Actually I am expecting the function to add an additional \ when a single '\' comes as a part of string.For example: I want to insert a File path like "\Program Files\xy\xyz.geo" I n expecting the

MySQL FullText improvements in V4.0

Hi, I've heard that there are plans to improve the database fulltext capabilities such as the ability to search for words less than 4 characters in length and searches such as +word1 -word2 and that these changes are to come in version 4.0. Can anyone confirm this and also if so can you give

Re: Excluding Data from a Query with PHP

KAZ> Hi KAZ> I've got a question on how to exclude a data from a query. Suppose I KAZ> have KAZ> the following query that is being used in combination with a PHP web KAZ> site: KAZ> "SELECT * FROM activities WHERE month='$month' AND year='$year'" KAZ> Now suppose the activities table looks like

RE: Excluding Data from a Query with PHP

SELECT * FROM activities WHERE month='$month' AND year='$year' and username != 'myuen' -Original Message- From: Kelly Alexander Zia [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 1:45 PM To: mySQL Subject: Excluding Data from a Query with PHP Hi I've got a question on how to exc

Excluding Data from a Query with PHP

Hi I've got a question on how to exclude a data from a query. Suppose I have the following query that is being used in combination with a PHP web site: "SELECT * FROM activities WHERE month='$month' AND year='$year'" Now suppose the activities table looks like this: ID username month

MySQL suddenly shutdown and cannot start up again.

Hi all, My RedHat 6.1 + MySQL 3.22.32 server box has some rare thing happens today. This box is sitting on the 192 network. It allows a cgi program to run select and update SQL statement, which triggered by the Internet. This box was received a lot of query this afternoon. Suddenly, it(redhat)

Re: INNER JOIN problem

>Is there a limit to the number of inner join statements within an sql >statement. I am using the following statement: > >SELECT DISTINCT suburb_def.Suburb, church_location.Name, church_location.URL > > FROM (suburb_def > INNER JOIN church_location ON suburb_def.ID = church_location.Subur

Re: group by and order by

>I have a table with texts, all of different type, I have field named >type to know which is which. What I would want is with one SQL query >select the latest from each type, but this query... > >select id, headline, type from texts group by type order by date; > >will give the first of each typ

mysql++ and Programming with MFC

Anyone have success in using mysql++ with MFC in Visual C++ 6.0, if so what did you do to get it to work? I emailed the guy who did the mysql++ port for Visual C++ and he told me that it is a major problem getting it to work with MFC. I tried all the stuff he suggested to get it to work, changing

Re: Bug in CAPI of My Sql

Hi Sinisa, Thanks for spending the time.Here are few observations on mysql_escape_string().I have checked it up and found to be working but with the following problems. i) It works well when I want to insert strings like: "'xyz" or "x'yz". ii) When I use "x\yz" with the function I see a junk char

Re: telnet MySQL

On Mon, May 14, 2001 at 07:26:44AM -0700, Shtykh Roman wrote: > When I try to telnet MySQL which uses port 3030 as > below: > telnet grdmss57 3030 > I get : > Trying 163.143.156.38... > Connected to grdmss57.u-aizu.ac.jp. > Escape character is '^]'. > ( > 3.23.38jN(xIDWiConnection closed by foreig

Re[2]: Mysql shutdwon very long

Bonjour Heikki, HT> InnoDB will flush the buffer pool and do the purge of old versions HT> at shutdown. It does these operations also when the database is HT> running, but there may be remaining work to do at shutdown. HT> How is the load of your database when you are running it? HT> Does mysqld

Re: telnet MySQL

On Mon, May 14, 2001 at 07:26:44AM -0700, Shtykh Roman spake thusly: *] telnet grdmss57 3030 Can you connect to the database through a normal client? -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED] "Linux re

Re:Mysql shutdwon very long

Alex, InnoDB will flush the buffer pool and do the purge of old versions at shutdown. It does these operations also when the database is running, but there may be remaining work to do at shutdown. How is the load of your database when you are running it? Does mysqld say? InnoDB: Starting shu

About MySql users

Hi everybody, I have MySql installed in My own LAN and I alrready made test to use MySql as optional SQL server. Test was great in speed, so I have just one question. I want to offer my Systems with tradicional LAN Access and optional SQL server. As you know, SQL Servers are too expensesive f

telnet MySQL

When I try to telnet MySQL which uses port 3030 as below: telnet grdmss57 3030 I get : Trying 163.143.156.38... Connected to grdmss57.u-aizu.ac.jp. Escape character is '^]'. ( 3.23.38jN(xIDWiConnection closed by foreign host. What is the possible reason? Is it normal?

Mysql shutdwon very long

Bonjour, I'm using "mysqladmin shutdown" to take the server down. In the past, it was the question of a few seconds. But now, it takes many minutes to Mysql to shutdown. I'm wondering if this as something to do with Innobase ... ? Could there be a reason for Mysqld to take minutes to

RE: MySQL 3.23.38 released

Sorry its early for me and I didnt read the bottom of this email. Sorry:) -Original Message- From: Robert Henkel [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 8:40 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MySQL 3.23.38 re

Re: Bug in CAPI of My Sql

VVM Ravikumar Sarma Chengalvala writes: > Hi Sinisa, > Thanks for the detailed mail.Can you send me the > syntax for mysql_escape_string() please so that I can > check up with what I have been trying out. > > Regards, > Ravi Here is an example from C++ : char* s = new char[in.size()*2+1

Re: Bug in CAPI of My Sql

Hi Sinisa, Thanks for the detailed mail.Can you send me the syntax for mysql_escape_string() please so that I can check up with what I have been trying out. Regards, Ravi --- Sinisa Milivojevic <[EMAIL PROTECTED]> wrote: > VVM Ravikumar Sarma Chengalvala writes: > > Sinisa, > > 1. > > Thanks for

Re: Converting MS-Access to MySQL

[EMAIL PROTECTED] writes: > Hello MySQL, > > We are a company that is considering a change to the MySQL database. > > Due to the fact that we got a lot of MS-access databases around here we want > to ask you about the possibilities to converte MS-access databases to mySQL. > > I m interested in

RE: MySQL 3.23.38 released

Can you compile a win32 version of this? Or will there be a binary for win32 soon? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:51 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: MySQL 3.23.38 release

RE: Hom many columns is too many?

Without knowing more detail about the data and the requirements of that data its hard to say how the database structure "should" be. To say I am right over you and you are right over me is pointless. Its very dependant on the data. I agree you can have a entity with 75+ attributes and its not g

Re: Database (Recursion and Factorials)

On Mon, May 14, 2001 at 09:32:05AM -0400, lkeeton wrote: [snip] > how does it take place. For instance in this example I pass 5 it then gets to > the line below and evaluates value = 5 * factorial(5-1)-> right there that > tells me to call the function again and pass it 4 then when I get to the

Converting MS-Access to MySQL

Hello MySQL, We are a company that is considering a change to the MySQL database. Due to the fact that we got a lot of MS-access databases around here we want to ask you about the possibilities to converte MS-access databases to mySQL. I m interested in the bugs that is known ( loosing datatype

Re: Bug in CAPI of My Sql

VVM Ravikumar Sarma Chengalvala writes: > Sinisa, > 1. > Thanks for the mail. > 2. > I observed that mysql_escape_string()soes not work > either.If I want to store a file name with back > slashes,I feel mysql_escape_string() should introduce > the additional backslash required .But it does not do

upgrade from SUSE7.0

hi, I upgraded the mysql provided by suse with the 3.23.37, and I have a problem... It's said that i have to change the root user with /user/bin/mysqladmin -u root -h mycomputer -p password 'new-password'. But when i do this, i have an answer that says : /usr/bin/mysqladmin: connect to serve

Re: Bug in CAPI of My Sql

Sinisa, 1. Thanks for the mail. 2. I observed that mysql_escape_string()soes not work either.If I want to store a file name with back slashes,I feel mysql_escape_string() should introduce the additional backslash required .But it does not do so.It is just copying from source string to destination

Database (Recursion and Factorials)

I am currently working on a factorial procedure that figures out a factorial for a number and eventually I will store it in the mysql database. I am kind of getting caught up with this program below. I am confused how the program is executed with all the recursive direct calls to itself. Can s

why will mysql support view?

i wonder when mysql can support view?does the 3.23 support it? if no,but now i need to use view,can u tell me other way to replace it? i am eager for your help! _ IP¿¨¡¢ÉÏÍø¿¨ÌøË®¼Û http://shopping.263.net/category08.htm NO.5ÏãË®µêÓ­ÏÄÈÈÂô http:/

(URGENT) Help mysql+redhat automatically reboot.

Hi all, My RedHat 6.1 + MySQL server box has some rare thing happens today. This box is sitting on the 192.168 network. It allows a cgi program to select and update its records. The cgi program was triggered by the Internet. This box was received a lot of query this afternoon. Suddenly, it(redh

Re: execute insert error, ERROR 2006

SJ writes: > I insert a sql statment, size is 30M, a field type is longtext > using >mysql dbname < filename > > in file, it is a sql as insert into table ... values ... > > where file size is 10 M, it execute well, but report error when file size is to 30M > > > it report: > ERROR

execute insert error, ERROR 2006

I insert a sql statment, size is 30M, a field type is longtext using mysql dbname < filename in file, it is a sql as insert into table ... values ... where file size is 10 M, it execute well, but report error when file size is to 30M it report: ERROR 2006 at line 1: MYSQL server has

Re: MySQL and c++ API

dave writes: > > Here's my problem. I'm new to the linux world. I've installed linux 7 on an > old pentium machine. I've gotten MySQL server started (safe_mysqld &) and > can work with the MySQL interface (mysql). What I want to do is code in c++ > against a MySQL database. I've downloaded the AP

Query regarding backup of database

how to copy database from one pc to another without networking _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before postin

Re: Can't compile mysqlgui because "edfile.o" missing (fwd)

[EMAIL PROTECTED] writes: > I'm trying to compile the mysqlgui source currently available on mysql.com > (version 1.7.5). I've successfully compiled/installed the packages > fltk-1.0.11 and flek-0.1.1 (as suggested by the doc/README.TXT file > supplied with mysqlgui), as well as the fl_editor-0.4

MySQL and c++ API

Here's my problem. I'm new to the linux world. I've installed linux 7 on an old pentium machine. I've gotten MySQL server started (safe_mysqld &) and can work with the MySQL interface (mysql). What I want to do is code in c++ against a MySQL database. I've downloaded the API MySQL++-1.7.8-1.i386.

Problems BDB tables

Hi. This is my first post to this list, and it's about a problem we have with BDB tables in MySQL. From time to time when we retrieve data from a table we don't get right answer, i mean, we get part of the result set. Then if we make an "optimize table " and try to retrieve same data we get right

Re: Problem getting INNOBASE (3.23.37) working on FreeBSD (4.2)

On Sun, May 13, 2001 at 06:09:12PM +0300, Heikki Tuuri wrote: > > > >> >Suggested improvements would be the addition of COALESCE TABLESPACE > >> > >> Do you mean reorganization and compaction of a tablespace? The way to > >> do it is to dump and reload all tables in the tablespace. > > > >During

Re: Input of special characters!

Please RTFM http://www.mysql.com/doc/S/t/String_syntax.html - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, May 14, 2001 18:12 Subject: Input of special characters! > Hi! > > I have started to write a small web based application and encountered a >

Re: Urgent Help Needed

Hi, Tried that and also got an error, I just hope someone has had to do this type of search!! Would have thought so! Just need to search a MATCH and others at the same time. Thanks all. Barry In a message dated 14/5/01 10:54:16 am, [EMAIL PROTECTED] writes: << > The one we tried was: > > $SQ

Bad import with ID='-1', bug or feature?

Hi, I tried import some tables from dumped text file (command line - with command SOURCE), where one row in table ABC had a value -1 in ID column (it means with properties 'primary key auto_increment' etc.). After, when I tried insert some new data to table ABC (INSERT without ID column specified

Re: Urgent Help Needed

Hi I escape all the characters as the values are passed to the page. It is driving me mad, just to get this to work! Not many people I know have the solution. I would have thought searching FULLTEXT and other fields at the same time would be easy. Any help again appreciated. Barry In a mes

Input of special characters!

Hi! I have started to write a small web based application and encountered a small problem. If I use any of escape characters in the web based forms like the singel quote ' the value of that field will not be inserted in the database. I know that a singel quote can be written like '' to be able

Re: Urgent Help Needed

Hi, Does $keywords contain a quote ? You must escape special characters in strings before using them in SQL statements. If you are using Perl DBI look use 'quote' function otherwise, check MySQL API for your programming language. Hope this helps -- Joseph Bueno NetClub/Trader.com [EMAIL PROTEC

restarting

I did install mysql server on my linux box, but something went wrong, i guess. I wuold like to know how to rebuild the whole system, destroying all mysql RPMs and its directories, creating a new one by running RPMs once more. All this to use mysqlgui.. Please, i know this is a dumb quyestion,

RE: Urgent Help Needed

> The one we tried was: > > $SQL = " SELECT * FROM cvtemplate WHERE employment_type = > '$employment_type' > AND location = '$location' AND related_discipline = > '$related_discipline', > MATCH specific_work_profile, wxcdone, wxcdtwo, wxcdthree, > wxcdfour AGAINST > ('$keywords') AS score FROM cvt

Re: Backup a database

Hello: I have already searched on the archives, but any of the solutions are valid for me because I only have remote access to a windows server to get the data+structure, and to the new server I only have mySQLAdmin access to the database. Best Regards Visual PHP Studio, RAD deve

Urgent Help Needed

Hi Group, I posted this question before, and need help urgently. The problem is using a specific search! What we are trying to do is intially search 3 fields and then once the results are found it needs to be able to narrow down the results by searching the intial 3 criteria and also a keyword

Security Update ?

A few weeks ago there was a flurry of postings re a security hole in MySQL (including flames about whether or not the message should have been posted, but that's a different issue. Are there any status updates regarding this problem ? Fixed / Gone away / never there in first place ? Info woul

  1   2   >