Re: mysql daemon problem

On Tue, Feb 20, 2001 at 03:11:18PM -0800, Hyup Cho(Etec) wrote: > Hi mysql support, > > I got the following error message whenever I tried to run mysqld > daemon. > It worked before but it's something wrong about getting passwd, I > think. > What caused this error ? > My system is Linux i686 syst

Re: Once again... quotas...

On Tue, Feb 20, 2001 at 04:19:27PM +, Tristan 'Minty' Colgate wrote: > > I have recently been asked to implement per database quotas for > mysql for a large scale shared webhosting environmnet, from the > lists it seems pretty obvious that mysql cant achieve this at the > moment (without us

Unable to start mysqld due to permission problem

>Description: I followed the installation steps as provided at: www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Installing_binary When I ran 'bin/safe_mysqld --user=mysqld &' mysqld would not start. When I did an ls -l, here's what I got: lrwxrwxrwx 1 mysqlroot

Re: MySQL Tables

Have you tried checktable? Are there many numbers giving weird results or just one? Are you running an old version of Mysql? Any of the columns auto inc by any chance. BTW you really shouldn't "cut" your original message unless it isn't really important. This is in case someone knows the answ

RE: :mySQL

oops wrong site name :-( go to www.cpan.org... Sorry -Original Message- From: Barry Radloff Sent: 21 February 2001 08:16 To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: :mySQL hi ryan DBD::... are 'drivers' for perl to a specific db, you need to go to www.cpan.com and download

RE: :mySQL

hi ryan DBD::... are 'drivers' for perl to a specific db, you need to go to www.cpan.com and download the DBI module for perl and the relevant driver I assume mysql as this is a mysql list... alternatively if you have net access you can use: perl -MCPAN -e shell and type install Bundle::DBI (i

BDB Tables

I am experimenting with MySQL for both Linux and Windows 2000. The trouble is, I do not Have Visual C to compile the BDB code under Windows 2K. Is there any place to download them for Windows 2000 in a binary form? Or is there somebody who can compile them for me?

Re: how to define the space of mysql user?

connect to your database as root and do 'show variables'. what you want to look for is 'data dir' something, that'll tell you where the mysql databases are stored... Atle On Wed, 21 Feb 2001, yindu wrote: > since mysql have no limit with database.i can only limit the space in Filesystem >q

Re: MySQL Tables

On Wed, 21 Feb 2001, Rolf Hopkins wrote: > I think you'll get better results if you don't quote your numbers. Quotes > should be used for text and dates (depending) but not numbers. tried, but same results. *> MP3's EN VIVO de INFUSION: http://members.xoom.com/sysfork/ *> MP OnLine? EL BBS? Fe

Re: MySQL Tables

I think you'll get better results if you don't quote your numbers. Quotes should be used for text and dates (depending) but not numbers. - Original Message - From: "Arturo Busleiman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 21, 2001 11:54 Subject: MySQL Tabl

MySQL Tables

These are the commands I'm currently using to build the MySQL tables used/needed by a program I'm doing: What is wrong here that an INSERT ('2','2','1','test',NULL) generates: | 33554432 | 33554432 | 1 | test| 20171221080222 | the 33554432 shouldn't be 2's? anything other than INT wor

Re: Replacing Content

Marcus Ouimet ([EMAIL PROTECTED]) writes: > I am trying to figure out how to change content using wildcards. Something > like: > > if the data in the field "date" in the table products equals 2001*.* change > to 200100 "update products set date='200100' where date like '2001%'" should w

Re: Compiler error #2

Hi John, Try compiling MySQL with gcc 2.8.1. I have just compiled MySQL 3.23.32 on Tru64 4.0D with a few warning messages. The compiled binary runs fine. I used to try gcc 2.95.2, but as you know :) - Chat - Before posting,

Re: importing access db to mysql

- Original Message - From: "Ed Carp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, February 21, 2001 11:17 Subject: Re: importing access db to mysql > Rolf Hopkins ([EMAIL PROTECTED]) writes: > > > Try http://www.accessmysql.com/

Re: ranking album plays by city, help me beat Oracle

> Huh? You got it 7 times faster by only extracting that query from the > for loop and changing it to a group by? Or did you do anything else? Sorry there were some other unnecessary queries that were mistakenly in the measurement.. Here is the missing EXPLAIN. mysql> EXPLAIN SELECT same_

Re: importing access db to mysql

Rolf Hopkins ([EMAIL PROTECTED]) writes: > Try http://www.accessmysql.com/ Oh. Yet another person trying to sell you something that can be downloaded freely elsewhere. Try http://www.mysql.com/downloads/gui-clients.html Oh, sorry, that didn't answer the original poster's question, but I do

Re: LOAD_FILE /TEXT

Yes, you have missed something. Somewhere into chapter 7 of the manual, can't remember exactly where off the top of my head, it talks about adding backslashes. It is to do with inserting text. It is required for special characters. - Original Message - From: "Richard Vibert" <[EMAIL P

Re: Problem in a particular Query

Sub selects are not yet supported. Please read the manual. A normal query should also do the trick as well. > select t1.service_nm from servicecntr_nm > t1,service_prod_index t2 where t1.serv_cod=t2.serv_cod and t2.prod_no=11 and > t1.city_cod='in000501'; - Original Message - From: "an

Connection errors

010220 19:27:11 Aborted connection 21199 to db: 'vlndb' user: 'root' (Got an error reading communication packets)) Has anyone experienced this error in MySQL and do you know what it means? Kyle Higgins USCO Logistics UNIX Manager Email: [EMAIL PROTECTED]

how to define the space of mysql user?

since mysql have no limit with database.i can only limit the space in Filesystem quotas. but i didn't know the filesysterm about mysql database.where are them?is there any documents about this?

Re: Broken Select/Join

Johnny Withers ([EMAIL PROTECTED]) writes: > I have recently upgraded from MySQL 3.22.27 to 3.23.33. > I'm running Redhat Linux 6.1 on a p2 300 w/128MB of ram. > > The following select statement worked fine in mysql 3.22.27: > > SELECT supplier.id,subcatsicbond.sub_catid,subcatsicbond.siccode >

importing access db to mysql

hello friends. I am new to mysql, so pls bear with the silly questions. I have exported an access database to .csv file. Now I need to import it into mysql. But guys, please do not waste your time telling me how to do this. Please tell me where I can find the info and i will find it. thanks fo

Re: Comment field of a table

Fethiye Akbulut ([EMAIL PROTECTED]) writes: > I would like to see if all the tables in my database have the "comment" > field equal to a given value. I understand that "show table status" command > is able to show us the "comment" field's value. I was wondering how we can > extract only this f

Re: need mysql sample to accomplish existing asp function

Rolf Hopkins ([EMAIL PROTECTED]) writes: > Well now, that depends on what you want to use. You can use java, php, or > perl and there are others but make sure your ISP supports the language you > choose. I recommend php as it is the easiest of the three. Their web site > is www.php.net and www

Replacing Content

I am trying to figure out how to change content using wildcards. Something like: if the data in the field "date" in the table products equals 2001*.* change to 200100 Any help/direction is appreciated. Thanks in advance.

Re: importing access db to mysql

Try http://www.accessmysql.com/ - Original Message - From: "Denis L. Menezes" <[EMAIL PROTECTED]> To: "mysql list" <[EMAIL PROTECTED]> Sent: Wednesday, February 21, 2001 10:37 Subject: importing access db to mysql > hello friends. > > I am new to mysql, so pls bear with the silly questi

Problem in a particular Query

we have two tables 1. servicecntr_nm comp_cod int(11) service_nm varchar(70) city_cod varchar(13) addr varchar(100) pin int(11) contact varchar(70) serv_cod varchar(30) 2.service_prod_index serv_cod varchar(30) prod_no varchar(20) now our aim is to find out all the service_nm that have

Newbie Starting MySql

Having problems starting mysql on my linux box. I think I've tried just about everything in the manual within reason. Please help out if anyone has an idea. The other day, mysql died on my system for no apparent reason. When I reboot the machine, based on the script in /etc/rc.d/init.d/mysql, mys

Re: need mysql sample to accomplish existing asp function

- Original Message - From: "Joe and Nancy M" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Sent: Tuesday, February 20, 2001 21:04 Subject: Re: need mysql sample to accomplish existing asp function > Rolf, > > Sorry I worded that email in a confusing manner. You most certai

LOAD_FILE /TEXT

Hi, I'm storing a text file in a TEXT column using the LOAD_FILE function like this: INSERT ... text_col=LOAD_FILE('filename') Each line of the orig file ends with char 10. When I SELECT it like SELECT text_col INTO OUTFILE 'out_filename' ... I find that each line has an extra "\" (char 92)

Query Help Please

Hi all, I was hoping that I could get some help with this query. TABLE: Items FIELDS: ProductDescription, ItemPrice, ItemDate I want to group first by the week day using the WeekDay function, Sum the item price for each Weekday and order next by the sum of the item price for each weekday in D

Re: inserting special characters

At 1:24 AM + 2/21/01, [EMAIL PROTECTED] wrote: >Dear Sirs : > >Please I would want to konw How I can insert special >characters into a table, > >Since the " and ' chars are used for delimiting values into >an insert statement I don¥t know how I can put these as part >the string that I insertin

Compile problems with 3.23.33 on Tru64 4.0G

>Description: Two compile problems. The second one has me stumped. I am pasting in error info on both at the end of this form. Problem #1: snprintf error in client/sql_string.cc. I substituted sprintf, hope it's safe. Problem #2: myisam/mi_ope

Re: inserting special characters

Add \ in front of special chars. eg 'I can\'t do this'. This is explained in the manual. Also, some programs have a function that will add it for you, such as PHP. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, February

inserting special characters

Dear Sirs : Please I would want to konw How I can insert special characters into a table, Since the " and ' chars are used for delimiting values into an insert statement I don´t know how I can put these as part the string that I inserting. I got this putting the data into a file, and then u

Re: need help to set mysql up

>From what you've written, I'm guessing that you're using windoze so, firstly, are you sure you downloaded the Windoze version and not the Unix version? The other is, mysql has a very good manual on their website which describes how to install. - Original Message - From: "Mehmet agar" <

need help to set mysql up

i am a very beginner level and i tried to set mysql up but i failed. i downloaded the software from mysql.com but i couldnot find any setup icon. what kind of compiler do i need? i wonder to know whether you can send me some information how to set mysql up. thank you for your interest. >Fr

Comment field of a table

I would like to see if all the tables in my database have the "comment" field equal to a given value. I understand that "show table status" command is able to show us the "comment" field's value. I was wondering how we can extract only this field when we do conduct our queries from a mysql cli

How secure is MySQL?

Hi, I am not familiar with the current state of MySQL security. I know there were serious problems with previous versions, but that was a year ago. I am planning to install a program that use MySQL as backend on our external server. There are other important database server running on the serve

I NEED YOUR URGENT HELP!

I have big problem, i have installed 3.22.23-1 for linux (cobalt server) mysql works, mysqladmin works but i have a meassage in IE: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /home/sites/site2/web/tepekoy.php on line 28 then

WEALTH ON THE WEB!

Get a FREE copy of the exciting 48-page booklet "Inside Secrets to Wealth on the Web". Just hit Reply and send a blank message with "Inside Secrets" on the Subject line. - Before posting, please check: http://www.mysql.com/

Re: Permissions

mysql caches hostnames, so perhaps 13ave.com is connecting to your database server as well? say for instance: 13ave.com connects, mysql resolves that to $ host 13ave.com 13ave.com has address 12.111.170.18 web.web-ster.com comes along, mysql sees the reverse and says 'Hey, I've seen you before,

RE: So, just how long should it take the "make install" to run?

I've done it on a 486 with 64Mb memory and it took about an hour or an hour and a half or so (it was a long time and I went off and did other things while it was happening so my timing is not precise (oh that's make time for the main part, make install much quicker) - and it was a few versions

mysql daemon problem

Hi mysql support, I got the following error message whenever I tried to run mysqld daemon. It worked before but it's something wrong about getting passwd, I think. What caused this error ? My system is Linux i686 system. mysqld ended on Fri Feb 9 11:44:06 GMT 2001 mysqld started on Fri Feb 9 1

MySQL/Innobase

Hi! We have it running on Linux Compaq Alpha now, on FreeBSD there are problems. Monty has been very very busy today, but maybe he gets a source distribution out tomorrow. Good night now! Heikki - Before posting, please check

Re: How secure is MySQL?

Like pretty much all software, it quite possibly has security flaws. A big bonus though, is that it binds port 3306 by default so you don't need to run it as root. Create a completely seperate user and group for it and run it under that uid/gid. Ensure none of your root system scripts interact wi

Re: So, just how long should it take the "make install" to run?

In the last episode (Feb 20), Jeremy D. Zawodny said: > On Tue, Feb 20, 2001 at 04:41:25PM -0500, Matthew P. Marino wrote: > > Don't laugh, > > > > Intel PI 166MHZ, 32MB RAM,10GB HD > > FreeBSD4 > > MySQL3.23.33 from .tar.gz distribution > > The `make' or the `make install'? > > The `make insta

Re: So, just how long should it take the "make install" to run?

On Tue, Feb 20, 2001 at 04:41:25PM -0500, Matthew P. Marino wrote: > Don't laugh, > > Intel PI 166MHZ, 32MB RAM,10GB HD > FreeBSD4 > MySQL3.23.33 from .tar.gz distribution The `make' or the `make install'? The `make install' shouldn't take more than a few minutes, but the initial `make' will ta

Re: Microsoft Access Error

At 15:16 20/02/2001 -0700, Ryan Stout wrote: Hi! To have an updatable record set on Access, you need to have a primary key or selected a column as primary key when you make the linkage of the table. Regards, Miguel >Hello, > I have setup MySql and MyODBC on an NT4 machine and I have granted >

mysqlimport puzzle

Yesterday, I was having fun writing mysql scripts and importing them. I would do a drop database and re-import, editing the data in the script. Today, I couldn't for the life of me do an import on a mysql export file, even using commands stored from yesterday, in bash_history. I am getting er

Re: mysqlimport puzzle

sounds strange, but if you do it this way, you should have no problems: mysqldump test_database > test_database.dump mysql test_database < test_database.dump will import everything in test_database.dump into your database.. somehow, you had selected your database, but that got dropped ? Atle

Microsoft Access Error

Hello, I have setup MySql and MyODBC on an NT4 machine and I have granted access for several users to a database called test. I can open databases with a link table in access, but I can't export them or edit the databases in design view. When I try to change the database with design view

format masks for a Masked edit control

I am working on an auto-generating form in VB. Its time to add a mask control, if the FieldType is a number. I need input and display masks for each of the numeric field types. (for the Microsoft MaskEdBox control that comes with VB 6). If anyone is any good at masks, please help me out here.

Broken Select/Join

I have recently upgraded from MySQL 3.22.27 to 3.23.33. I'm running Redhat Linux 6.1 on a p2 300 w/128MB of ram. The following select statement worked fine in mysql 3.22.27: SELECT supplier.id,subcatsicbond.sub_catid,subcatsicbond.siccode FROM subcatsicbond LEFT JOIN suppliersiclink ON subcatsic

followup to lockup in test suite on SGI

>Description: On several occasions I reported problems with MySQL and our Webmail installation (using the program IMP). All MySQL processes would lock. No process would be shown to execute. The Only thing to correct the problem was to kill MySQL and restart Apache. People at MySQL poin

So, just how long should it take the "make install" to run?

Don't laugh, Intel PI 166MHZ, 32MB RAM,10GB HD FreeBSD4 MySQL3.23.33 from .tar.gz distribution - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arch

Re: Large Numbers problem

Martin Jeremic wrote: > > I have inserted 1234567890 in a float field. mySQL server rounded this > to 123457. Then i have inserted 99 in same field, and tis > was rounded to 100. Is this a bug or someyhing else? Field is > declared as "field1 float" > > -- > Martin Jeremic -

Re: Can this query not be done in MySQL.

Your question was answered already after you posted it on Saturday by Fred van Engen... Basicaly you should not be able to do a group by without perfoming an aggregate function (max, avg, sum, count) on columsn that do not appear on the "GROUP BY" clause. Richard Reina wrote: > > I posted t

Re: Time between two DATETIMEs

You could use the UNIX_TIMESTAMP() function to easily determine the difference in seconds between the two dates. select UNIX_TIMESTAMP( Datetime_A ) ... and the do the time_a - time_b thing. there might be a simple query that will work as well, but I don't know the mysql date queries that good

RE: Microsoft SQL Server linking to MySQL

This doesn't work, gives the same error. Do we know if Microsoft just doesn't like MySQL? Aaron Weiker Programmer CISP - Changing Internet Speed & Performance Phone: 419.724.5351 [EMAIL PROTECTED] Pager: 419.218.0013 http://www.cisp.cc Cell:419.304.03

Re: Permissions

Yep that was it! Yesterday there was a messup with DNS that caused the reverse DNS to be 13ave.com I quickly changed it, but apparently MySQL cached that entry. It's been 24 hours, but still. As soon as I just did a flush-hosts it came right up. Thanks! At 12:12 PM 2/20/2001 -0800, Atle V

Large Numbers problem

I have inserted 1234567890 in a float field. mySQL server rounded this to 123457. Then i have inserted 99 in same field, and tis was rounded to 100. Is this a bug or someyhing else? Field is declared as "field1 float" -- Martin Jeremic - JSoft http://jsoft.webjump.com/ mailto

Time between two DATETIMEs

I have a table that contains two datetime columns, and I need to determine the time between the two dates. So, what I've been doing is just subtracting what I know is the later date from the earlier date. But that's obviously not the way to do it as my results don't relate to anything. Here's wh

Can this query not be done in MySQL.

I posted this question to this list on Saturday. I realize that not everyone on the list knows whether this query is possible using MySQL. However, if I could please here back from someone who does know, I would appreciate it. I'm getting flack from informix ( and other DBMS ) users on my perl

Permissions

I did the following on my mysql server... GRANT ALL PRIVILEGES ON database.* TO user@'web.web-ster.com' IDENTIFIED BY 'password' FLUSH PRIVILEGES So I know the privileges are current... But when I try and access the database from this IP it says that "host 13ave.com" is not allowed to access

Re: RE: Two query issues -- need help

Alan Halls ([EMAIL PROTECTED]) writes: > Here is what our company uses to do the page division on adoptablekids.com I > have used it for a few other applications with minimum changes > This code would give you five per page. > > > > select * from profile order by id DESC >

Re: Off topic, help please!

Wee Chua wrote: >I am sorry for asking this off topic question but I just need some opinions >or answers from you all. The question is "What are the limitations of >software testing?" You can't demonstrate something is correct; you can only demonstrate if it is incorrect. -- =-=-=-=-=-=-=-=-=

Re: BigInt with primary key

I've seen this problem myself on 3.22.32. The problem is the quotes, remove them and everything works fine. The real pain is that if you are using DBI with Perl and pass the value through the quote function (we pass everything through just out of habit), it adds quotes to the number and you see

Re: DBD::mySQL

cpan.org On Tue, 20 Feb 2001 [EMAIL PROTECTED] wrote: > Where do I get this DBD::mySQL? > > I've been searching for it and can't quite find it. > > Ryan Gamo >Edwards Lifesciences > One Edwards Way >

Compiler error #2

Hi Attempting build on Tru64 V4.x using gcc V2.95.2 and gnumake v 3.x Build mysql is quite troublesome. The latest error appears to be gnu gcc V2.95.2 error. I am attempting build number 7,345 The error I get is. sql_acl.cc in function 'int repla

DBD::mySQL

Where do I get this DBD::mySQL? I've been searching for it and can't quite find it. Ryan Gamo Edwards Lifesciences One Edwards Way Irvine, CA 92614 GO F

RE: Two query issues -- need help

Here is what our company uses to do the page division on adoptablekids.com I have used it for a few other applications with minimum changes This code would give you five per page. select * from profile order by id DESC return if ({sys:num_pages} <= 1)

Two query issues -- need help

Hi all, I have two little problems: 1.In a query, I get errors when a record's field contains the ' character. In fact the query starts like

RE: Slow Select count(*) - Second Post

Thanks for all your help. This has got the query time down to 5 seconds from 2 minutes!! Much appreciated everyone. Robin -Original Message- From: Tibor Simko [mailto:[EMAIL PROTECTED]] Sent: 20 February 2001 16:46 To: Robin Keech Cc: '[EMAIL PROTECTED]' Subject: Re: Slow Select count(

Re: Slow Select count(*) - Second Post

Hello > Is there any way to re-write SQL to force the optimiser to use a certain > index? SELECT foo FROM bar USE INDEX baz WHERE ... See the manual at . cheers -- TS - Before posting,

Trouble w/ DBI/DBD::MySQL and OSX

Has anyone been able to sucessfully make DBI and DBD::MySQL work under OSX - Darwin? I'm not having any luck at all. I'm running Perl v5.6.0 built for darwin. And I'm trying to install the MySQL modules version 1.2215, with DBI version 1.14.0. My mysql database is version 3.23.28. When I run

Once again... quotas...

Hi There, I have recently been asked to implement per database quotas for mysql for a large scale shared webhosting environmnet, from the lists it seems pretty obvious that mysql cant achieve this at the moment (without using filesystem quotas), file system quotaing is pretty awkward with our

Re: Problem with list (fwd)

please unsubscribe me as well. Chris Moore IS Managagement [EMAIL PROTECTED] ItsYourDomain.Com 1005 W. Wise Rd. Suite 200 Schaumburg, IL 60193 www.itsyourdomain.com Phone: (847) 895-4301 Fax: (847) 895-4123 -- Forwarded message -- Date: Tue, 20 Feb 2001 20:38:29 +0800 From: Ro

Help with error

I get these errors after I rebooted this morning. I had no problems last night. I don't see carts.frm anywhere for cityscope. I assume this is a temporary file that is created. Any help would be appreciative. DBD::mysql::st execute failed: Can't find file: './cityscope/carts.frm' (errno: 13) at

Re: MySQL replication

Read the manual on replication, and pay special attention to the warnings. This will not work if you use autoincrement fields, unless you are VERY careful. Then it still may not work. Fredrik Kristiansen wrote: > > Hello, > > Is it possible to enable a MySQL replication between 2 or more sever

RE: Slow Select count(*) - Second Post

Thanks for your replies. Patrick: I will try the combined index, and see if it takes too much disk space. Most queries return within 2 seconds, which is acceptable for me. Therefore I'm not too concerned about the speed increase in using a combined index as such. What I am concerned about

RE: Slow Select count(*) - Second Post

All of your columns are indexed but in an SQL query, only one index can be used... So, if you build an index matching exactly the columns used in your query, you will parse only the lines that match your query... So, if I'm not wrong, you will only parse 11 or 17 lines depending on your query and

Software engineer

Hi: I have got your email from the Web site and I am very interested in working for your company. I have a BS in Electrical Engineering and computer science and worked on my Master degree in Telecommunication engineering (not finished due to the lucrative market!). I have also 7++ years of

MySQL replication

Hello, Is it possible to enable a MySQL replication between 2 or more severs where I can write and read to all servers? I know it is possible to install one master who I can do reading and writing to. And slaves who I only can read from. But I want to write to these slaves as well, and they must

Re: global search and replace

Matt Davis ([EMAIL PROTECTED]) writes: > I have an MySQL table in which one of the fields is a list of different > catergorys. I want to change that catergory name to some thing else however > it appears in my table just over 900 times. Is there any way I can do some > sort of glabal search and r

RE: Slow Select count(*) - Second Post

Thanks for your response, What benefit would that give me? Would a combined index be faster? I have the three columns indexed anyway, and do not really want to dedicate more of my index file to a duplication . it is getting to the 1G mark already, and I have a 2G limit for any one file. I have

Re: MySQLGUI - error executing query's

Luis Pedro writes: > Hi, > > I'd installed MySQLGUI 1.7.4 sucessufuly. After I connect to a database and > when I try to execute a query, the program stops and I get the following error: > > Segmentation fault > > Can you help me with this? > > Thank's > -- > > Luis Pedro > P

New DBTools version Available

There is a new version of DBTools (1.0.8) available for download. For a complete list of changes and download go to http://dbtools.vila.bol.com.br. - This new version comes with an install script. I'd like to thank all the 3rd part effort to make this happens. - Fixed a serious bug in the new my

Isamchk

Hello, Several of my tables are corrupted. I have a Win system. How can I repair my DB's with isamchk. What would I have to enter to the command line if I would like to check all DB's and all tables? The help says that I have to specify the table on the command line - it gives the error "file no

Off topic, help please!

Hi all, I am sorry for asking this off topic question but I just need some opinions or answers from you all. The question is "What are the limitations of software testing?" Thanks for any helps in advance. Calvin - Before post

Re: BigInt with primary key

On Tue, Feb 20, 2001 at 06:56:28PM +0800, chchen wrote: > hi all > > i use mysql-3.23.32 > > my project need to use unsigned Bigint as a primary key. > but when i insert many rows in this table. > sometimes it will error with Duplicate such like > > insert into Table >values('92318521725269771

MySQLGUI - error executing query's

Hi, I'd installed MySQLGUI 1.7.4 sucessufuly. After I connect to a database and when I try to execute a query, the program stops and I get the following error: Segmentation fault Can you help me with this? Thank's -- Luis Pedro Physics Departement of Unoversity of Lisbon -

Re: Compiling

It means you forgot -lz. You also need libz.so Evan James Dembskey wrote: > > Hi, > > While trying to compile a program in C taken from the book Professional > Linux Programming (Matthew, N. & Stones, R. (2000) 155) using this command > (also taken from the same book): > > [root@evan /

Re: Help with access denied

diego López wrote: > > thanks in advice > I already did something like that .. the problem was i erase all the > content of the mysql directory and i creaste a new mysql database, and when > i try to restar the mysql daemon (/etc/rc.d/init.d/mysql start) i get a > message like: > > [root@hal

Re: BigInt with primary key

First, i am really sorry about that. my fields is quite simple. CREATE TABLE TEST ( A bigint(20) unsigned DEFAULT '0' NOT NULL, C0 bigint(20) unsigned DEFAULT '0' NOT NULL, C1 bigint(20) unsigned DEFAULT '0' NOT NULL, C2 bigint(20) unsigned DEFAULT '0' NOT NULL, C3 bigint(20) unsig

RE: New sub-version of Win32 version of mysqlgui

oh god, i think i'm in need of a break sorry 'bout that -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 2:45 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: New sub-version of Win32 version of mysqlgui

Re: mysqldump problems too

jaco wrote: > > I'm having problems with mysqldump too. > > I'm trying it on a Suse Linux 6.2 system, from the /usr/bin directory as root, >typing ./mysqldump --all-databases > backup.sql > > as is explained on http://www.mysql.com/doc/m/y/mysqldump.html > > The response is : ./mysqldump:

RE: New sub-version of Win32 version of mysqlgui

Joris Lambrecht writes: > to wich version are you referring ? 3.23.33 ? > No, mysqlgui 1.7.4. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECT

global search and replace

I have an MySQL table in which one of the fields is a list of different catergorys. I want to change that catergory name to some thing else however it appears in my table just over 900 times. Is there any way I can do some sort of glabal search and replace in My SQL? Mat --

Slow Select count(*) - Second Post

Hi, This is a repost. Can anyone help me? Where can I look for more clues as to why this select is slow? A MyISAMchk will take the database down for too long, so unless I know that it will give me some usefull information I am hesitant to try it. Can anyone please explain the following? I

  1   2   >