mysqldumpslow

I'm trying to find what causes mysqldumpslow to crash for us every time the log is anything but trivial. The following does not crash it, but it does give incorrect results: # User@Host: apache[apache] @ morpheus.e [1.1.1.1] # Query_time: 8 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 replace in

no of bits

Hello, Can any one tell me in mysql for sorting how many bits it is check please tell me as soon as possible Cheers Umasankar - Before posting, please check: http://www.mysql.com/manual.php (the manual) htt

RE: Can somebody help me with "round (columna,columnb) "?

On Wed, 27 Feb 2002 22:10:44 +0100, Roger Baklund wrote: >One obvious workaround is to avoid floating point numbers... or in mysql >terms, use the decimal/numeric data type instead of float/double... but that >does not solve the problem in this case, I guess floating point is used >internally in

Lookup tables and indexing

Is there a rule of thumb for small tables and whether they should be indexed? I have several small, two column lookup tables with few rows (100-300) and some very small tables (< 10 rows). I don't plan on indexing the very small ones, but what about the others? Thanks, --jeff sql,query --

Sorting

Hello, I am new to mysql.For the best reference of mysql which site i will look for. please tell me what is the query to sort field name in ascending order Cheers Umashankar - Before posting, please check: http://w

Join with absent values in right table

Hi Assume I have two tables, A and B, and both share a key field (for the sake of argument, lets call it key_id). Is there a way to determine for which values of key_id in A there is no corresponding row in B? e.g I might have Table A: key_id , value 1,1 2,1 3,3 4,4 and Table B key_id, other

Re: load data error

sorry for my fault: I forgot $ (dollar sign) before sql variable. Sommai At 09:58 28/2/2002 +0700, Sommai Fongnamthip wrote: >Hi, > Please tell me why this mysql in php error: > >sql = "LOAD DATA LOCAL INFILE \"/home/httpds/htdocs/srg/data/tct.csv\" >INTO TABLE tct_temp FIELDS TERMINAT

mysqlgui help

Dear sirs I could not connect to mysql database when using mysqlgui. The error message is access denied for the user: [EMAIL PROTECTED] (using password: yes). If I use the mysql -u root -ppassword command, I can connect to the database. Can you kindly tell me something about it?. I am running mys

load data error

Hi, Please tell me why this mysql in php error: sql = "LOAD DATA LOCAL INFILE \"/home/httpds/htdocs/srg/data/tct.csv\" INTO TABLE tct_temp FIELDS TERMINATED BY '\|'"; $result = mysql_db_query("$dbName", $sql) or die ("Can not run: $sql"); I try another sql style like th

Re: Problem with Insert

Hi Chris, On Thu, 2002-02-28 at 10:26, Chris Herold wrote: > Problem: > Having trouble inserting text files longer than a few lines into MySQL > although short ones go in fine. > > I'm using a form in HTML to get a value for $abstract... > > > > > > > I am then using PHP to insert the info

RE: FULLTEXT error?

Hi Doug, What's the MySQL version you're running? Your SQL query worked fine on my PC. MySQL 3.23.47 Win98SE Last time I had some problem (that was 3.23.32 I think) when mixing VARCHAR and TEXT types in the FULLTEXT index. After upgrading to MySQL 3.23.47, I did not encounter anymore problem lik

Re: flexible foreign keys?

Why not put a flag variable (tinyint or enum) in your ABA table and instead of deleting the records, just mark them as no longer valid? --jeff - Original Message - From: "David Felio" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 11:49 AM Subject:

Re: Query Problem...

Thanks guys, works a treat. Yip, it was the Alias thing... interesting. - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "asherh" <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 2:39 PM Subject: RE: Query Problem... > * asherh > > An exam

Re: ignore words in full text indexes

Hi! On Feb 28, David yahoo wrote: > Hi all, > > I m using mysql 4.01 alpha > > I read in the doc : > "MySQL uses a very simple parser to split text into words. A ``word'' is any > sequence of letters, numbers, `'', and `_'. Any ``word'' that is present in > the stopword list or just too short (

Re: Problem with Insert

Hi- Problem: Having trouble inserting text files longer than a few lines into MySQL although short ones go in fine. I'm using a form in HTML to get a value for $abstract... I am then using PHP to insert the information into MySQL... <> When $abstract is relatively short/small (3 or

MySQL-3.23.49-1.src.rpm does not build under RedHat Linux 6.2

I see binaries are now shipping with vwesrion 3.23.49a. Have sources been changed since 3.23.49? I'm asking since I've tried to build binary packages from MySQL-3.23.49-1.src.rpm as suggested. The compilation fails like this: [..snip...] creating libmysqlclient.la (cd .libs && rm -f libmysqlclien

heap tables and slow index query

server version: 3.23.47 mysql> create table myhits ( -> libid int unsigned not null, -> begin bigint unsigned not null, -> end bigint unsigned not null, -> index(libid), -> index(begin), -> index(end) -> ) type = heap; Query OK, 0 rows affected (0.00 sec) [ insert st

RE: ignore words in full text indexes

David, I think the nominal minimum word length is 4 so 'fiat' will not be indexed. This can be modified however. regards, Dan > -Original Message- > From: David yahoo [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 28 February 2002 12:28 p.m. > To: [EMAIL PROTECTED] > Subject: ignore word

ignore words in full text indexes

Hi all, I m using mysql 4.01 alpha I read in the doc : "MySQL uses a very simple parser to split text into words. A ``word'' is any sequence of letters, numbers, `'', and `_'. Any ``word'' that is present in the stopword list or just too short (3 characters or less) is ignored. " My queries let

Re: I heard that MySQL 4.01 supports Views?

> On Wednesday 27 February 2002 05:16 pm, you wrote: > > At 17:09 -0500 2/27/02, Anthony W. Marino wrote: > > >On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: > > > > >Does MySQL 4.01 support Views? And if so, how? > > > > > > > > Ask the person who told you that it does to substanti

Re: Myisamchk can't repair table help help help

Steve Rapaport wrote: > > Arrrggghhh! > > This is definitely a problem! > Can't access table White in mysql 4.0.1: table is "read-only". > why? because it's corrupt! > Try to fix: takes a long time (about an hour) and seems to work. > But it's still corrupt and read-only: > [cut] > [roo

Re: FULLTEXT error?

Doug, Can quite see why you have id as a key twice, but... This worked first time for me (3.23.40-nt). Regards, =dn > Error > > SQL-query: > > CREATE TABLE quotes ( > id int(9) NOT NULL auto_increment, > author varchar(255), > content text, >

RE: I heard that MySQL 4.01 supports Views?

>We shoudn't stifle interest in this list. We should offer guidance and >direction and thus help them help themselves (ie; Please follow the >yellowbrick road...) I don't think that was his intent... It's just that this is in the .sig for the list...

RE: Query Problem...

* asherh > An example of the record output I was after is... > > ProjectIDProjectOwnerProjectManager > A12345 Bob Smith John Smith > > from tables: > > User - > UserIdFullName > 1Bob Smith > 2John Smith > > Project - > ProjectIdProj

Re: Query Problem...

Hi Ash, > I have tried all sorts of joins and statements without much success... I can > obtain one name or both names if they are the same... but not different > names together in the one record. =how about some example code showing what you are doing? At the very least it gives me a 'starting

Re: I heard that MySQL 4.01 supports Views?

On Wednesday 27 February 2002 05:16 pm, you wrote: > At 17:09 -0500 2/27/02, Anthony W. Marino wrote: > >On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: > > > >Does MySQL 4.01 support Views? And if so, how? > > > > > > Ask the person who told you that it does to substantiate the > >

Re: I heard that MySQL 4.01 supports Views?

At 17:09 -0500 2/27/02, Anthony W. Marino wrote: >On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: > > >Does MySQL 4.01 support Views? And if so, how? >> > > Ask the person who told you that it does to substantiate the assertion. >> > >Can't you just say NO or just don't respond? Sure

LOAD DATA LOCAL INFILE in Alpha 3.23.49

>Description: LOAD DATA LOCAL INFILE ... leads to 'The used command is not allowed with this MySQL version' This happens regardless of whether I have a local-infile= 1 in my /etc/my.cnf. In neither case does the local-infile variable show up with SHOW VARIABLES. >How-To-Repeat: >Fix: >

Re: I heard that MySQL 4.01 supports Views?

On Wednesday 27 February 2002 04:59 pm, Paul DuBois wrote: > At 16:31 -0500 2/27/02, Stephen Cox wrote: > >Does MySQL 4.01 support Views? And if so, how? > > Ask the person who told you that it does to substantiate the assertion. > > >Stephen Cox > >Web Development, Webmaster > >[EMAIL PROTECTED]

Re: I heard that MySQL 4.01 supports Views?

At 16:31 -0500 2/27/02, Stephen Cox wrote: >Does MySQL 4.01 support Views? And if so, how? Ask the person who told you that it does to substantiate the assertion. > >Stephen Cox >Web Development, Webmaster >[EMAIL PROTECTED] -

Starting mysqld fails

Hi, I downloaded the tarball for the latest RH binaries of Mysql 3.23.49a. I "installed" it according to the INSTALL-BINARY file included with the package. When I tried to run mysql according to the same file it crashed giving no explanation. I have tried the suggestions listed on the websit

I heard that MySQL 4.01 supports Views?

Does MySQL 4.01 support Views? And if so, how? Stephen Cox Web Development, Webmaster [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (

Re: Datawarehousing

Hi, On Thu, 2002-02-28 at 04:43, Oscar Colino wrote: > I read your thread discussion Jan and it is certainly very interesting to > me. > There are though a couple of areas where I would (oh shit you wrote this > email in 1999, I hope you are still there anyway ..) be rather skeptical, > and th

Myisamchk can't repair table help help help

Arrrggghhh! This is definitely a problem! Can't access table White in mysql 4.0.1: table is "read-only". why? because it's corrupt! Try to fix: takes a long time (about an hour) and seems to work. But it's still corrupt and read-only: [root@db1 elenco4_fb02]# myisamchk White; Checking MyI

FULLTEXT error?

Error SQL-query: CREATE TABLE quotes ( id int(9) NOT NULL auto_increment, author varchar(255), content text, PRIMARY KEY (id), UNIQUE KEY id (id), FULLTEXT KEY author (author,content) ) TYPE=

RE: Can somebody help me with "round (columna,columnb) "?

* Doug Thompson > On Wed, 27 Feb 2002 13:53:15 +0100, Roger Baklund wrote: > > >* Doug Thompson > > >> I found using variables to work as expected with 3.23.43 and > >> Win98. > >> > >> I was unable to duplicate your changing outputs. > > > >I was using a 3.23.30-gamma win2k. > > > >> mysql> selec

PHP Security Update

>From the PHP home page: PHP Security Update [27-Feb-2002] Due to a security issue found in all versions of PHP (including 3.x and 4.x), a new version of PHP has been released. Details about the security issue are available at http://security.e-matters.de/advisories/012002.html. All users of PHP

Re: innodb on xfs

Hi! >From http://www.innodb.com/ibman.html : " Note that InnoDB does not create directories: you have to create them yourself. Use the Unix or MS-DOS mkdir command to create the data and log group home directories. Check also that the MySQL server has the rights to create files in the directorie

Re: MySQLdMax crashed (for unknown reasons), please help

Jonathan, the bug is probably the SHOW CREATE TABLE bug which was fixed in 3.23.48. Please upgrade to 3.23.49a. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB

HELP - Admin Removed mysql.host

Hi, I think that one of the admins on my MySQL 3.23.38 server somehow removed mysql.host when he was cleaning out old databases, I get the error: 020227 15:21:46 mysqld started 020227 15:21:46 /usr/local/libexec/mysqld: Table 'mysql.host' doesn't exist 020227 15:21:46 mysqld ended If I re-run

Re: php - apache compilation

Thanx Vic, Are you saying I have to recompile apache as well before reconfiguring PHP. Thanx Toks - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 9:54 AM Subject: php - apache compilation > Oladejo, > W

help: can't get anonymous access configured

Hi All, I want to make my publicDB available for anonymous access from everywhere and spend hours and hours reading the manuals and FAQ's and searching the web, but can't make it work. After deleting all entries in mysql.user apart from root@localhost: grant select on publicDB.* to johan; works

Re: flexible foreign keys?

When I try to delete a row from the parent table and the key is in use in the child table, I get: ERROR 1217: Cannot delete a parent row: a foreign key constraint fails So it doesn't cascade and delete rows in the child table (assuming I am interpreting "cascade on delete" correctly), but it d

RE: Order by on Alphnumeric

select * from table where strcol REGEXP "^[[:digit:]]+$" order by strcol Regards Dan > -Original Message- > From: Prospect'In [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 28 February 2002 11:31 a.m. > To: [EMAIL PROTECTED] > Subject: Order by on Alphnumeric > > > sql,query >

Re: flexible foreign keys?

InnoDB doesn't support the CASCADE functionality of foreign keys, so it's possible deleting the key from the parent table won't have any effect on existing transactions in the child. It may only prevent new records from being inserted with that key -- which is essentially what you want. Most DBs t

Re: replication issue

It would appear that the apparent lagging/slave processes not working (yet telling me they are up) was due to having two slaves set to the same server-id. I will know as more time passes. On Wed, Feb 27, 2002 at 09:27:04AM -0600, Michael Douglass said: > > David, > > I am seeing the exact s

Order by on Alphnumeric

sql,query Good Day, I have a varchar field which contains alphanumeric data. I want to be able to order this field by only the numeric values in the field. help!! Rick - Before posting, please check: http://www.mysql.co

Re: SQL

You want the row with the max Version? How about SELECT Number, Version, Description FROM versions ORDER BY Version DESC LIMIT 1; Michael On Wed, 27 Feb 2002, Miguel Alves (SEP) wrote: > Hi, > > I'm using MySQL for the first time and have been trying to solve > this basic SQ

RE: SQL

Hi Miguel, As far as I know (I'm no expert), this can't be done in a single MySQL query. The following link shows how you can do it using a temporary table: http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html#exam ple-Maximum-column-group-row Alternatively, if you are using

Datawarehousing

Hi there , I read your thread discussion Jan and it is certainly very interesting to me. There are though a couple of areas where I would (oh shit you wrote this email in 1999, I hope you are still there anyway ..) be rather skeptical, and these are: Facts: - An average DW will contain an a

Re: select takes a very long time

Alfredo Cole <[EMAIL PROTECTED]> wrote: > select tr.*,ma.nombre from cbtran as tr, cbma as ma where > tr.empresa='1' and tr.mes='1' and tr.anio='2002' and > >concat(ma.empresa,ma.clase,ma.tipo,ma.mayor,ma.grupo,ma.costo,ma.cuenta,ma.subcuenta)=concat(tr.empresa,tr.cuenta) > > order by tr.anio

Re: Query Problem...

Hi, Thanks for the reply. An example of the record output I was after is... ProjectIDProjectOwnerProjectManager A12345 Bob Smith John Smith from tables: User - UserIdFullName 1Bob Smith 2John Smith Project - ProjectIdProjectOw

Re: MySQL Server cluster?

can MySQL run as cluster under the platform of IBM AS/400 also?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

SQL

Hi, I'm using MySQL for the first time and have been trying to solve this basic SQL problem for 2 days... I have tried everything from using JOINs to local variables, searching in www.mysql.com and Paul DuBois MySQL book (Great book!), but failed to do this in a single SQL query has I

RE: Client installation by itself?

Hi, > -Original Message- > From: Scalper [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, February 27, 2002 6:53 AM > To: [EMAIL PROTECTED] > Subject: Re: Client installation by itself? > > > I asked this question as well some time back and got the standard answer > 'READ THE MANUAL'.

Re: BIIIG problem with some of the records

Hi Edward, [I've put this back on the list - others will be able to share their wisdom/you might not have to wait so long for me to get around to a reply!] My first thought is that you have a neat system of encoding the link data being stored in MySQL. I assume this is preceded by some sort of

Re: select takes a very long time

Hi Alfredo, What an amazing piece of code! The join statement is a computation on both sides, so therefore no index is of material use. Consequently a table scan would be required. Have you tried EXPLAIN? Regards, =dn > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi: > > Using MySQL

Re: mysql installation on linux(RH7.2)

"nagendra prasad" <[EMAIL PROTECTED]> writes: > hi > i downloaded mysql rpms from mysql.com > & tried to install them on linux. > when i use the command rpm -i mysqlpackname in shell > it says > > error:can't get exclusive lock on /var/lib/rpm/packages > error:can't open packages database in /v

Re: Query Problem...

Hi Ash, > I am using MySQL 3.22.32 and are trying to accomplish the following (without > going into too much detail, this is an example of the exact situation)... > > 1) I have two tables: > > a) User table containing: UserID, FullName > b) Project table containing: ProjectID, ProjectManagerID

select takes a very long time

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi: Using MySQL version 3.23.39-Max, SuSE 7.2 I have two tables, cbtran with 46564 rows and cbma with 4184 rows. Both tables are indexed. The following query: select tr.*,ma.nombre from cbtran as tr, cbma as ma where tr.empresa='1' and tr.mes='1

Re: perl mysql DBI::db question

i am using the older v1.19 DBI. i looked at that line and it should not cause a problem. the values are stored, even after the handle is destroyed or the connection closed. the error is complaining that i should destroy statement handles or call finish. thanks for the respones. - Original Mes

RE: NuSphere v. MySQL 4

Please be careful of reading only half of the story, unfortunately the article in question only talks about half of the issues. See http://www.nusphere.com/releases/index.htm for more information and related documents. Britt... > > -Original Message- > > From: Tyler Longren [mailto:[EMA

Re: perl mysql DBI::db question

On Wed, 27 Feb 2002 10:40:21 -0600, "nickg" <[EMAIL PROTECTED]> wrote: >> >>You need to tell the handler you are finished with your statement, this will >>free resources, etc.. >> >>http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish >> >> >>$sql_check->finish; EXTREMELY out-dated! MySQL

Re: order by date error!!!

Hi, Wakan wrote : > > Hi, > I've noticed this problem, even if I don't know if it's really a mysql problem: > if I store a date in standard format, in a date field, all kinds of > ordering are OK. > But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), > the order by clause attem

RE: perl mysql DBI::db question

You need to tell the handler you are finished with your statement, this will free resources, etc.. http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish $sql_check->finish; my $sql_check = $dbh->prepare("select user,password,prefs from users where username='$LNAME'"); # I do

Re: perl mysql DBI::db question

Try moving your $dbh->disconnect call after it prints out the fetchrow_array() my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array(); if($debug_state) { print "S: $t_user,$t_password,$t_prefs\n"; } $dbh->disconnect(); If your using an older version of DBI, like 1.13 or

core dump in clients in MYSQL 3.23.49 using groups

>Description: When using groups in 3.23.49, client dumps core. This bug sounds to be new (it does not appear in 3.23.41) >How-To-Repeat: Just compile a little C client (you can also dump cores with DBI perl module) : % cat bug.c #include #include int main(void) { MYSQL mysql; mysql_init

flexible foreign keys?

I have a MySQL InnoDB table for recording checking account transactions and it currently has a foreign key on the routing number referencing a local copy of the fed ach routing number database. It works a little too well, in that a routing number may be good today, but not tomorrow. I would lik

Re: order by date error!!!

Wakan <[EMAIL PROTECTED]> wrote: > But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), > the order by clause attempt to order the new format incorrectly, because > I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, and 13-2-2002!!! > What can you say about this? Can you

RE: order by date error!!!

> But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), > the order by clause attempt to order the new format > incorrectly, because > I've an output like this: 12-2-2002, 12-3-2002, 12-4-2002, > and 13-2-2002!!! I normally do this: SELECT DATE_FORMAT(datefield,'%d-%m-%Y') as d

perl mysql DBI::db question

i am trying to write a program in perl and am getting a mysql error from my module. here is the error: DBI::db=HASH(0x294738)->disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at ./pop.pl line 124, line 2." i think a

www-mysql package

Dear all. Has anyone practice in www-mysql package ? I've installed apache, www-mysql. And so ? What next. Marek Wysmulek. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mys

Query Problem...

Hi, I am using MySQL 3.22.32 and are trying to accomplish the following (without going into too much detail, this is an example of the exact situation)... 1) I have two tables: a) User table containing: UserID, FullName b) Project table containing: ProjectID, ProjectManagerID and ProjectOwner

order by date error!!!

Hi, I've noticed this problem, even if I don't know if it's really a mysql problem: if I store a date in standard format, in a date field, all kinds of ordering are OK. But if I change the output format with: DATE_FORMAT(data,'%d-%m-%Y'), the order by clause attempt to order the new format incorr

Client installation by itself?

Carl, Wednesday, February 27, 2002, 4:16:51 PM, you wrote: CM> Is it possible to install just the mysql client software for NT? The only CM> client distributions I can find include the mysql server as well. Take a look at MySQLGUI and MyCC. You can find them at: http://www.mysql.com/downlo

Changed localhost?

Anthony, Wednesday, February 27, 2002, 4:58:09 PM, you wrote: AR> All of a sudden Apache and MySQL are not running correctly under Windows 98. AR> It appears that somehow localhost was changed from 127.0.0.1 to something else. No, localhost is 127.0.0.1 What type of error did you recieve? AR> T

RE: NULL Values in mysqldump

On 27 Feb 2002, at 10:31, Baines, Dominic wrote: > However, in this case the MySQL columns values are NULL the problem > (if it is one) is that /N does not mean NULL in other RDBMS and you have > to craft a method of converting or parsing the data either at load or > pre-load to another format

RE: Can somebody help me with "round (columna,columnb) "?

On Wed, 27 Feb 2002 13:53:15 +0100, Roger Baklund wrote: >* Doug Thompson >> I found using variables to work as expected with 3.23.43 and Win98. >> >> I was unable to duplicate your changing outputs. > >I was using a 3.23.30-gamma win2k. > >> mysql> select @a:=digits,number,round(number,@a) fro

RE: Changed localhost?

Hi, Localhost is always associated to at least 127.0.0.1 IP, however you can add as many IP adresses as you want to your machine by using TCP/IP properties window in your control panel. As long as you add IP adresses (reference them in tcp/ip layer) your apache will handle the HTTP request. It w

RE: Sum function question

It can be done but it involves quite a few statements and the use of temporary variables and a temporary table. assuming that your table is defined as follows CREATE TABLE `tble` ( `keyf` char(1) default NULL, `Field1` char(8) default NULL ) do this: set @k=''; set @field=''; create temp

RE: NULL Values in mysqldump

There is a huge difference between a NULL and NOT NULL and an empty string and it would be handled in the table definition statements of the 'new' RDBMS usually with a default column setting. However, in this case the MySQL columns values are NULL the problem (if it is one) is that /N does not

mysql installation on linux(RH7.2)

hi i downloaded mysql rpms from mysql.com & tried to install them on linux. when i use the command rpm -i mysqlpackname in shell it says error:can't get exclusive lock on /var/lib/rpm/packages error:can't open packages database in /var/lib/rpm what shall i do. later i managed to install it using

Re: replication issue

David, I am seeing the exact same thing on some Solaris boxen. My database sees a couple of updates every minute or two; and show slave status on the slave always appears to lag behind the master. The data in my tables lag as well as I've done some rudimentary checksumming and have found dif

Changed localhost?

All of a sudden Apache and MySQL are not running correctly under Windows 98. It appears that somehow localhost was changed from 127.0.0.1 to something else. Could the fact that I NOW have a 24/7cable connection to the Net cause the problem? Thanks! Anthony Rodriguez ([EMAIL PROTECTED]) -

Re: Client installation by itself?

I asked this question as well some time back and got the standard answer 'READ THE MANUAL'. However, I still never found the answer to my question, so when I get closer to deployment, I am going to experiment. I am thinking that only MyODBC installation is required on the client and possibly

RE: NuSphere v. MySQL 4

Please be careful of reading only half of the story, unfortunately the article in question only talks about > -Original Message- > From: Tyler Longren [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 26, 2002 3:25 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: NuSphere

Re: NULL Values in mysqldump

On 27 Feb 2002, at 8:18, Baines, Dominic wrote: > If you immediately use the dump, this is fine if it is to be used > with MySQL but if you want to port it to another RDBMS the /N for > a NULL causes some 'issues'. If you don't care about the difference between NULL and the empty string or 0, w

php - apache compilation

Oladejo, Wednesday, February 27, 2002, 3:04:05 AM, you wrote: Oeoen> Hi All, Oeoen> I am trying to compile php with mysql and apache into it, however during the Oeoen> ./configure, I keep getting "Invalid Apache directory - unable to find Oeoen> httpd.h under /usr/include/apache", even though tha

many field insert

Sommai, Wednesday, February 27, 2002, 11:29:30 AM, you wrote: SF> Hi, SF> I have to insert data to table which has many fields (252 fields). This SF> table was successful update by the LOAD DATA infile. But when I generate SF> SQL statement with from VB, SQL statment length got more tha

Re: Sum function question

Hi Javier, > Hi, I have a table like this > >Key Field-1 >A string1 >A string2 >A string3 >B string1 >B string 2 > > I want to create a query to get the following result (only one line by key > field): > >A - string1,string2,string3

OT: Please Somebody can explain me what this message means??? Fw: ezmlm warning

Sorry for the length of this message, but, I don´t understand what it means, and why it says my address will be removed from the list without explanation. thanx - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 27, 2002 12:58 AM Subject: ezm

Client installation by itself?

Is it possible to install just the mysql client software for NT? The only client distributions I can find include the mysql server as well. Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 - Before posting, p

mysqlhotcopy Problems with Databases/Tables with minus or blanks in name

Description: When using mysqlhotcopy for database backups, it fails to backup a Database or Table with a minus ("-") or blanks in its name, for example when using "mydb.user-table", "mydb.user table", "my db.usertable" or "my-db.usertable" and says "You have an error in your SQL Syntax" How-To

Fixing corrupted table

Hi. I am running MySQL 3.22.30, and am having trouble repairing a corrupted table with isamchk. Everything that I've tried either doesn't work, or wipes out all the data. Here's what I've tried so far: *** isamchk -d guestbook ISAM file: guestbook Data records: 79764 Deleted bl

Japanese alpha sorting?

Paul, Wednesday, February 27, 2002, 4:47:46 AM, you wrote: PW> Hi, PW> I wish to alphabetically sort data retrieved from MySQL using JSP for PW> web a page. The data will be stored in Japanese. I understand there are PW> multiple alphabets/dialects in Japanese with a large number of character

NULL Values in mysqldump

This is probably an easy one for someone... Is here an easy way NOT to have a mysqldump data file that includes /N when the column is a NULL ? Ideally what I'm looking for is a mysqldump option that doesn't put a /N in the data file for al the NULL VALUES. Scripting a global cut or strip out o

Sum function question

Hi, I have a table like this Key Field-1 A string1 A string2 A string3 B string1 B string 2 I want to create a query to get the following result (only one line by key field): A - string1,string2,string3 B - string1,string2 I try to u

Re: .net

Joshua Angolano writes: > I have tried to use the Mysql++ api with visual C++ .net. It would not > even compile the library. > Has anyone had any luck with this?? Maybe there is some setting that I > missed?? Are there any plans to update Mysql++ to work with visual > C++.net?? > Thanks, >

Re: .net

Joshua Angolano writes: > Has anyone tried to use the Mysql++ api with visual C++.net? >Thanks, > Josh > As far as I know, no. But it is worth a try if you have VC++.net. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL

Re: Wrong sorting order using cp1257 character set.

[EMAIL PROTECTED] writes: > >Description: > There are a few errors in characters sorting order > in sql/share/charsets/cp1257.conf file. > > Characters 0xE0 0x5A 0x7A 0xDE 0xFE are treated equaly. > But accoding Lithuanian standart LST 1285:1993 (if you interested :) > character 0xE0 s

  1   2   >