Error repairing: how do you Recreate an Index?

2002-05-01 Thread MySQL
Hi all, I was trying to repair a table with myisamchk and got the following message: "error: 'x.MYD' doesn't have a correct index definition. You need to recreate it before you can do a repair" (If I try to access the table from mysql, it tells me that the file x.MYD

last_insert_id() query

2002-04-24 Thread mysql mailing list user
Hi, I have a big problem with last_insert_id() query. I am adding records to a table with about half a million records in it. The insert takes well under a second. I then call last_insert_id as I need to make a link to another table. The last_insert_id takes around 2 minutes!!! Yes *minutes*

Bienvenue € ¦à mysql-france

2002-04-19 Thread Mod€ ¦érateur de mysql-france
Bonjour, Bienvenue sur la liste de diffusion Mysql-france. Prenez 2 minutes pour lire ce message. Pour vous desinscrire, allez sur le site ONElist, www.onelist.com, et selectionnez les liens My ONElist situé à gauche. Vous pouvez aussi demander à recevoir une fois par semaine l'ensembl

Re[2]: sorting

2002-04-17 Thread mysql
om: Dieter Munnik [mailto:[EMAIL PROTECTED]] GO> Sent: Wednesday, April 17, 2002 8:48 AM GO> To: [EMAIL PROTECTED] GO> Subject: sorting GO> Hi, GO> I'm looking for an easy way to select "room numbers" in a numerical/ GO> alphabetical sequence in Mysql GO> Ex : Th

Sorting alphabetically using charsets other than Latin 1

2002-04-15 Thread mysql
Hello, I have a table with text data in English in one column, same data in Russian (cp1251) in another, and so on. I'd be happy to retrive that data sorted alphabetically according to the *respected alphabets*. I couldn't figure out how to perform this despite I compiled MySQL with a

MSQL mysql-3.23.45 on Solaris 2.6 - not charset at configure

2002-04-03 Thread MySql Dba
Hello I am trying to configure mysql on solaris 2.6 when I run the configure command I use ./conigure --with-prefix=/usr/local/mysql --with-exec-prefix=/usr/local/mysql --enable-thread-safe-client --with-mysql-user=mysqldba configure reports back the following error configure: error: No

RE: Database Catastrophe

2002-04-02 Thread MySQL
[EMAIL PROTECTED] writes: >Not sure what to tell you - check to see if you have logging enabled on your Logging is not enabled. > >This is a longshot, but you might have had a corrupted index that >inaccurately reported 75k records when you really were only at 13k, and >optimizing the table did s

Database Catastrophe

2002-04-02 Thread MySQL
Folks, The database I setup 2 weeks ago was operating fine, if a bit slow. Yesterday, I tried running the OPTIMIZE TABLE command on it, as recommended on this list for improving performance. Yesterday there were 75,000 records in my database. Today, there are 13,000 records. Apart from the Op

Database Design Question

2002-03-28 Thread mysql
Hi all, I am in the process of designing a MySQL database that will run on Redhat 7.1, but I am fairly sketchy on MySQL and performance. What I want to do is have a database that keeps track of large distribution lists. Each list has a unique ID, an owner (which is a reference to an ID in

Newbie Question: MySQLDump Questions

2002-03-23 Thread MySQL
Greetings, This is my first post to this list, hope you can help me. I'm trying to automate nighly exports from MySQL to a Filemaker Pro database. I figured out that the following syntax will get me a tab delimited export file: mysqldump -u root --tab=/directory MyDataBase This is

how to use checker to debug mysql applications

2002-03-22 Thread mysql-return-103913-archive=jab . org
Hi, is there any way to debug a c-programm that uses the mysql c-api? I want to use checker for memleak checking but it seems to be impossible to compile the mysql client libraries using checker. The reason seems to be some assembly language parts. All other libraries I need compile. Did anybody

Error message

2002-03-20 Thread mysql mailing list user
Hi, In my mysql .err file I get a lot of the following error... "Aborted connection 121031 to db: ..connection details... (Got an error reading communication packets)" What does this mean, and is it bad, and what do I do about it? Any help appreciated

Explanation of error message

2002-03-20 Thread mysql mailing list user
Hi, In my mysql .err file I get a lot of the following error... "Aborted connection 121031 to db: ..connection details... (Got an error reading communication packets)" What does this mean, and is it bad, and what do I do about it? Any help appreciated

Re: MySQL Server Installation Problem

2002-03-20 Thread mysql mailing list user
Sounds as though you haven't got Perl installed, or more particularly the DBI modules for MySql. If you on Linux, almost certainly to be found on your Linux CDs. HM Suresh R. Soni writes: > Hi All, > > I am getting following error msg when I try to install > MySQ

Mystery files

2002-03-20 Thread mysql mailing list user
Hi, I my mysql server database directory (that is the directory that holds the .err and .pid files) so strange files have apeared. They look line -bin.001 -bin.002 etc -bin.index Some of them are huge! They seem like binary files, but are full readable SQL commands that could be

Re: Table RAID

2002-03-19 Thread mysql mailing list user
Hi, Thanks I DID read the documentation. BUT there documentation gives no information about how to choose values for these settings. There are no clues at all. What are good values, and/or what is the effect on performance etc. of the values? Howard Egor Egorov writes: > my

Re: Optimization And Memory Size

2002-03-19 Thread mysql mailing list user
You have written the following: I have a mysql database table that is currently 1.5G in size with well over a million records. It is running on a twin pentium 3 1G processor machine with SuSE Linux version 1.4. Recently inserts have become VERY slow (several seconds). As I am adding around

Re: Table RAID

2002-03-19 Thread mysql mailing list user
I have a very large mysql table (1.5G) and so will need to implement the table RAID option soon. How do I pick the CHUNKSIZE and number of chunks values? Howard - Before posting, please check: http://www.mysql.com

printing/Displaying Mysql Database layout

2002-03-15 Thread MySql Dba
Hello all. I am running mysql 3.x on Redhat Linux, and Solaris 2.6 and 8 Most of the development work is done on these servers. I do have a couple of windows developers using tools like mysqlfront Is there way with mysql to print out table structure in a useable text format or maybe even a

How to load binary data with Perl DBI?

2002-03-09 Thread mysql
Hello. How to load binary data into a table using Perl DBI module (the data is uploaded from a HTML form)? I failed to find any information on MySQL site. Thanks in advance. - Before posting, please check: http

Data series selection help

2002-03-07 Thread MySQL
I record some stock data into MySQL, I'm looking for the correct syntax for a SELECT statement. SELECT min(Tmin) FROM quotes WHERE low=min(low) In short, I want the time of the occurance of the low for the day, Tmin is time column. Once the low is achieved, all the remaining data for th

mysql under FreeBSD 4.5

2002-02-21 Thread mysql
grant tables failed! Examine the logs in /var/db/mysql for more information. You can also try to start the mysqld daemon with: /usr/local/libexec/mysqld --skip-grant & You can use the command line tool /usr/local/bin/mysql to connect to the mysql database and look at the grant tables: shell> /

Re: Faxing from MySQL

2002-02-18 Thread MySQL
In Faxing from MySQL, <[EMAIL PROTECTED]> wrote: > >Hi there. Anybody know how I can fax using MySQL? I might have an >application for this. Pretty simple problem for the APIs, you would probably spend longer on a web search for a software package then writing it. Of course, o

Re: Database synchronization

2002-02-17 Thread MySQL
In Re: Database synchronization, <[EMAIL PROTECTED]> wrote: > >On Thu, Feb 14, 2002 at 09:35:58PM -0800, MySQL wrote: > >> I'd like to connect a local sql server to a remote server and get 1 >> database synchronized between them. For various reasons, I need to &g

Case Question

2002-02-16 Thread mysql
I currently have a PHP script performing the following query mysql_query("SELECT * FROM Stuff WHERE Release LIKE \"%$var2%\"",$var1) It works great except that the search is coming out case sensitive. According to the MySQL Docs all searches are done without case se

Re: Selecting records with the highest value no greater than x

2002-02-16 Thread MySQL
In Re: Selecting records with the highest value no greater than x, <[EMAIL PROTECTED]> wrote: > >IMO, there is one, if I did understand the question correctly: > >SELECT * FROM NEWS WHERE RATING <= 4 ORDER BY RATING DESC, RAND() LIMIT 1; > >This give back a random news entry of the highest score

Re: Selecting records with the highest value no greater than x

2002-02-15 Thread MySQL
In Re: Selecting records with the highest value no greater than x, <[EMAIL PROTECTED]> wrote: > >Hi Brent, > >I cannot think of a single query doing your job. But it can be done >with two. > >SELECT @maxrating := MAX(RATING) FROM NEWS WHERE RATING <= 4; >SELECT * FROM NEWS WHERE RATING=@maxrating

Re: Callbacks or External Procedures?

2002-02-15 Thread MySQL
In Callbacks or External Procedures?, <[EMAIL PROTECTED]> wrote: > >Is there _any_ way to do something like Oracle's OCI callback functions? > >What I need to do: >Whenever my MySQL database changes data (inserts, updates, whatever) I need >to call some of my own c

Database synchronization

2002-02-14 Thread MySQL
I'd like to connect a local sql server to a remote server and get 1 database synchronized between them. For various reasons, I need to try to run this from within the sql protocol (i.e. no ftp, etc.). Replication is not the answer, and I can only work with one database at a time, so a SELECT is

Basilix and MySQLhelp

2002-02-04 Thread Lionlike MySQL Email List
I need a little help getting Basilix to run. The one part I can't get is the db connection. Somehow username and password are placed in the basilix.sql file with the command >mysql -u "username" -p "password" < /usr/local/basilix/db/mysql/basilix.sql This c

RE: Help, Root User Password Lost!

2002-02-04 Thread mysql
gt; My root user password get lost. I just can't get in zc> the database again. zc> Anyone know the way to get access to mysql without zc> password. Or is there a way to change the password? zc> I get access denied with the Error No. 1044, and 1045. You will find more about it a

RE: Seeking Database/Scripts

2002-01-30 Thread mysql
s to keep users identified at login, "timers" as to when memberships expire, make easy updates as needed. I am working with a Unix server that runs both PHP and Perl in conjunction with a MySQL database. Please let me know if you have any scripts, tutorials or off-the-shelf software you

SELECT DISTINCT BINARY crashes mysql on null values

2002-01-29 Thread mysql-s-p-a-m
>Description: Executing a SELECT DISTINCT statement in conjunction with the BINARY cast operator will crash MySQL server when the column being cast contains one or more null values. >How-To-Repeat: Executing the following code from a mysql prompt will cause the MySQL ser

show table status

2002-01-29 Thread mysql-max
Hi, my problem is that when i do a show table status like "al%" one of my innodb tables (named 'aluno') says to have 255 rows. But, in fact, it have 286 rows, by: select count (*) from aluno; Someone can help me ? __

Re: Problem with MySQL and SMP?

2002-01-10 Thread Lionlike MySQL Email List
[EMAIL PROTECTED] wrote: > I am having a problem with MySQL that I believe is related to SMP. I > have a machine that is an exact copy of another machine, only > difference is that this one is Dual processor, and the other one is > single. The single one has had no problems fo

SSH tunnel MySQL traffic: BOTH remote & local?

2002-01-03 Thread MySQL baby
If I've got one computer with MySQL client and server on it, running everything localhost, but I want to reach out to another MySQL server, through an SSH tunnel, for some things, does anyone know how to differentiate between the two? Usually, for SSH tunnelling, you access a port

--- query to find records related tables with no match?

2001-12-30 Thread MySQL baby
Ack - sorry - can someone remind me the SQL format for this? if you have a linked CLIENTS and INVOICES table... ...what's the query to find CLIENTS with NO INVOICES? (say 'clientid' is the name of the field in both clients and invoices table) I think it's some kind of join=NULL but I'm stuck.

mysqldump --tab crashes when dumping DB with many tables

2001-12-19 Thread MySQL account
ing dumped is high enough. Have reproduced this problem with the latest stable release, binary package: mysql-max-3.23.46-sun-solaris2.8-sparc >How-To-Repeat: 1. Use a MySQL database with more than 10 tables. 2. Limit the number of open file descriptors for th

Re: Question

2001-12-12 Thread Mysql List
How about going to the dir where the mysql database is then just cp * /backupsqldatabase And just the other way when you want to restore then use fix database. Thats what I have done and it seems to work fine. > Hi, > > I am quite new with MySQL and I have a question. How can I easi

Querry trouble

2001-12-10 Thread MYSQL
I have 2 tables in my mysql database. table1 is a master list with just one field -- email. table2 is smaller, and contains three fields -- date, email, client I need to run a querry to return the following: date, email, client from table2 where the email address in table2 isn't alrea

Re: User issues in installation. New beginner

2001-12-05 Thread Mysql List
In General Terms: Most default linux installs do not allow root user to telnet in to the machine, this is good as a default. You need to add the user that you do logon as to the MySQL permissions. This can be found in the manual. To access your MySQL db from Access, all you need to do is install

Help with Auto Increment

2001-12-05 Thread Mysql List
Hi, How do I start an autoincrement field at a certain value, say 1000? I have a field as: ID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (ID) How do I modify it to start at 1000? These all generate errors: modify mytable ID AUTO_INCREMENT = 1000; modify mytable ID = 1000; modify mytable ID AUTO_INCR

Hacked Servers

2001-12-03 Thread mysql
Hi We have 2 Redhat 6.1 servers and MySQL 3.22.32 and both boxes appear to have been hacked on Friday last and MYSQL client just hangs when connecting to the localhost MYSQL server. MySQL is running on both boxes and suffer the same problems. We also have to use kill -9 pid number to kill the

LEFT JOIN fails to correctly join tables

2001-11-30 Thread dale-list-mysql-bug
>Description: It seems that that the use of LEFT JOIN when the joined table uses multiple primary key conditions fails to include rows which are clearly matching on those conditions. >How-To-Repeat: mysql> create table foo (fooID smallint unsigned auto_

MySQL and RAID question

2001-11-29 Thread Lionlike MySQL Email List
Just one quick question... I've heard that running a database in a system using RAID isn't a good idea on RAID 5, but works fine with mirroring (0, 0/1, 0/5). Does anyone out there have experience with MySQL on RAID 5, or know how MySQL performs in a RAID 5 environment? My conce

[OT] PostgreSQL book

2001-11-26 Thread mysql
Hello, I know this is offtopic, but the new PostgreSQL book from OReilly is in production. You can read it online at http://www.postgresql.info/ . No we are not trying to start a flame war, but there is some really good info on SQL queries in the book. It may be useful to some MySQL folk. J

SV: MySQL Installation on Linux

2001-11-20 Thread MySQL
Hi Donna, Try this. That was the way i've installed Mysql on my server. rpm -ivh MySQL-3.23.44-1.i386.rpm rpm -ivh MySQL-client-3.23.44-1.i386.rpm Please notice, that you have to use the RPM command 2 times. Regards Frank Denmark. <---> http://www.tuffy.dk <--->

Re: How many OR, AND in a query?

2001-09-26 Thread Mysql List
in() is usefull for OR ing, but is there a way to do this AND ing? > You might want to try: > > WHERE mycolumn in (1, 3, 23, ...) > > Or even better, put your thousand records into a temporary table and then just do a join. > > --jfarr > > - Original Messag

How many OR, AND in a query?

2001-09-26 Thread Mysql List
Hi, How many OR or AND can I put in a select query statement? ex: " WHERE mycolumn = 1 OR mycolumn = 3 OR mycolumn = 23 etc . . . " A thousand? How would that affect the database execution time? - Before posting, please chec

Post-install

2001-09-21 Thread mysql mysql
Just installed mssql and in the end of the installation I receive the message taht now is the time to change root password for the db using mysqladmin using the following synthax: /usr/bin/mysqladmin -u root -p password 'new password' So issued the following command: /usr/bin/mysqladmin -u root -p

Re: Question

2001-09-07 Thread Mysql List
t; Auto_Increment=1000, . > > - Deryck H > - http://www.comp-u-exchange.com > - Original Message - > From: "Mysql List" <[EMAIL PROTECTED]> > To: "Deryck Henson" <[EMAIL PROTECTED]> > Cc: "mysql" <[EMAIL PROTECTED]> >

Re: Question

2001-09-07 Thread Mysql List
hange.com > - Original Message - > From: "Mysql List" <[EMAIL PROTECTED]> > To: "mysql" <[EMAIL PROTECTED]> > Sent: Friday, September 07, 2001 3:49 PM > Subject: Question > > > > Hi, > > Why is mysql(ver 3.23.41) complaining about thi

Question

2001-09-07 Thread Mysql List
Hi, Why is mysql(ver 3.23.41) complaining about this: CREATE TABLE mytable(ID INT NOT NULL AUTO_INCREMENT = 1000,PRIMARY KEY (ID), I know it is not the entire statement, but mysql does not like the AUTO_INCREMENT = 1000 part, how do I do that so it is acceptable? Thanks, Chris

User specific queries.

2001-08-17 Thread Mysql Mailing List
Hi all, We want to set up a user in mysql and allow him to send his queries to our database from his server. (PHP) The data in our database contains our other customers' as well as the guy who wants to directly access it. We would like to check his queries before send it to the database.

@HOSTNAME@ ?

2001-08-16 Thread mysql
Hi ! I get: "@HOSTNAME@: command not found" Does anyone know how to solve that ? I didn't find anything on the net or on the mysql.com homepage. Thanks. Jan-Hendrik - Before posting, please check: http://www.mysql.com/man

Re: Teen Hobos having sex? ..no.. but MAYBE

2001-07-27 Thread mysql
, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: Below is the result of your feedback form. It was submitted by ([EMAIL PROTECTED]) on Friday, July 27, 2001 at 05:51:09

could not insert BLOB data type in a table

2001-07-24 Thread mysql
Hi, I just want to know how to insert a BLOB data type in a field of a table. I want to put the binary data stream not the file link in the filed. The language i m using is PERL5. Thanks in advance. Regards, Thakur Gyawali Nepal --

Query Question

2001-07-23 Thread Mysql List
Hi, Can any of you query experts tell me if this is possible in a query? I have 3 tables, categories, products, groups. Groups table consists of categoryid and productid, it just keeps track of which categories have which products. I need a query(if possible) that would basically say: Select al

Problem connecting to db after installation on linux 7.1

2001-07-23 Thread MySQL server
Description: I've installed mysql on my linux 7.1 server (via RPMS) and it self-configured. It is now running however I can not connect to it. I keep getting the followingn error message: mysqladmin: connect to server 'localhost' failed error: 'Access denied for user: &#x

Re: your site

2001-07-15 Thread mysql
, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: We are online advertising company, I just visited your web site and I think you may be interested to have more visitors to deliver to

AC_SYS_LARGEFILE patch for 3.23.39

2001-07-13 Thread mysql
The patch below syncs AC_SYS_LARGEFILE with the version shipping with autoconf 2.50. This is against MySQL 3.23.39. -- albert chin ([EMAIL PROTECTED]) -- snip snip --- acinclude.m4.orig Sun Jul 1 12:51:18 2001 +++ acinclude.m4Sun Jul 1 12:58:47 2001 @@ -1035,122 +1241,85 @@ dnl

Re: problems startting MySQL under R.H. 7.1

2001-07-12 Thread Mysql Mailing List
Hi Andy, Try to kill the process first, then restart mysql server. Hope that helps. Thanks, Xi Jiang ITSportsNet Technical Support - Original Message - From: "Andy De Paoli" <[EMAIL PROTECTED]> To: <[EMAIL PROTECT

Error during compilation.

2001-06-28 Thread mysql novice
llows: /* * program: connect.c * connect to a test database, and try retrieving some * data. */ #include #include #include MYSQL mysql; MYSQL_RES *res; MYSQL_ROW row; void exiterr(int exitcode) { fprintf( stderr, "%s\n", mysql_error(&mysql) ); exit( exitcode ); } int ma

mysql@lists.mysql.com

2001-06-21 Thread mysql
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category:

Bug in Windows version 3.23.37

2001-06-21 Thread MySQL-Mail
"show tables" returns only small letters "tab1 , tab2" but in the database all tables are wir big letter "Tab1, Tab2" the linux version works all right... but this ist a realy problem. that the reasan ,i think, that the revoke not works correkly If i set a Col - Right or a Tab Right , it

ERROR 1030: Got error 127 from table handler

2001-06-20 Thread mysql
Hi folks! I have a question for you all... I've got two separate mysql servers running on one machine. Both are 3.22.23b but used for separate instances of separate webservers. I'm having trouble with the "1030: Got error 127 from table handler" error on only one of th

Fw: confirm subscribe to mysql@lists.mysql.com

2001-06-17 Thread dha siam mysql
o confirm that you would like > >[EMAIL PROTECTED] > > added to the mysql mailing list, please send > an empty reply to this address: > > [EMAIL PROTECTED] > > Usually, this happens when you just hit the "reply" button. > If this does not work, simply copy the a

Fw: confirm unsubscribe from mysql@lists.mysql.com

2001-06-17 Thread dha siam mysql
o confirm that you would like > >[EMAIL PROTECTED] > > removed from the mysql mailing list, please send an empty reply > to this address: > > [EMAIL PROTECTED] > > Usually, this happens when you just hit the "reply" button. > If this does not work, simply copy th

SQL query - not too complex?

2001-06-17 Thread mysql-lists
I need some help with a query to sum data for each id and write it into a new table. I have a source data table for each calendar month containing i.d.'s (not unique) and a value and I need to sum all the values for each i.d. for all months into a new table (where each i.d. will now be unique).

Problems with MyODBC and dateformat

2001-06-11 Thread MySQL-Mail
hallo i use VB6 - ADO 2.6 with the newest MyODBC with options 16834 even when make a select on a date or time type columne i get the windows-format 24.12.2001 , but the format is realy -MM-DD. So i get a lot of trouble.. what i have to do, that i get the right date/time-format(-MM-D

DuBois's book's scripts - where to get them?

2001-06-07 Thread mysql list
ssion to access /pub/mirrors/mysql/Downloads/Contrib/Examples/ on this server." Any other place to get them from? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://per

What is the & for in ' safe_mysqld --log & '

2001-06-06 Thread mysql list
I lost track of the tutorial where I saw the command safe_mysqld --log & What is the & for? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ ---

How to start mysql server as user mysql

2001-06-02 Thread mysql list
In my UNIX (FreeBSD) system the database directories shows up as below. drwx-- 2 mysql mysql512 May 11 11:51 mysql drwx-- 2 mysql mysql512 May 11 22:40 test I guess this means I should only start mysql server by being the user mysql. But how can I become the user mysql? The

Where to get a list of explanations for Errcodes?

2001-06-02 Thread mysql list
When I attempt to get into this database this error comes up, but other databases work ok. I cannot find a reference to 'Errcode: 13' or any 'Errorcode' in the manual or mailing list archives. mysql> use vhosts; Can't read dir of './vhosts/' (Errcode: 13)

help plz.

2001-06-02 Thread mysql novice
hi, I'm using mysql Ver 9.16 Distrib 3.21.33b, for unknown-freebsd3.0 (i386) and i'm using 'C' program to interface with mysql database, I didn't get any compilation errors, but while executing i receive the following error : File '¡$Pè7' not found (Errco

problems with privileges, MySQL for Windows 3.23.xx

2001-05-03 Thread MySQL-Mail
Hello, how I can set Permission on Tables and Columns? I have create a user "Hugo" with no permissions in the user, hosts and db table. Then I type: grant select(Sp1,Sp2), update(Sp2) on MyTestBase.Tab1 to hugo@localhost; grant select on MyTestBase.Tab1 to hugo@localhost; flush privileges; in th

Re: Need help with 23.36

2001-04-24 Thread New Style MySQL Personnel
> mysql> use lum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'users' Database changed mysql> select * from users; ERROR 1017: Can't find file:

Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel
files to /var/lib/mysql where the others are and I get this error. Any idea? mysql> use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'absences' Di

Re: Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel
The location is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files to /var/lib/mysql where the others are and I get this error. Any idea? On Mon, 23 Apr 2001, B. van Ouwerkerk wrote: > > >I copied my database files made

Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel
I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? mysql> use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn&#x

Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel
I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? mysql> use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn&#x

Max sizes?

2001-04-18 Thread mysql
Hello, I am trying to find some information on MySQL. Could you folks help me out. I need: Max Database Size Max Table Size Max Size for a row Max Number of rows Max Number of Columns Max number of indexes per table Thanks! Joshua Drake

Re: Need feedback

2001-04-15 Thread mysql
not require one to be a list member to read or respond to the author. You must be a list member to post to the list, though. Thanks again to those that wrote me and enjoy. David Fordham -- Original Message -- From: "mysql" <[EMAIL PROTECT

Need feedback

2001-04-10 Thread mysql
least a few more months. I have a PHP and a MYSQL list db, here are the URLs: http://www.summittech.com/mysqlmail.php3 http://www.summittech.com/phpgenmail.php3 They are free and I am not doing anything with the data. Let me know, David Fordham

Re: Multi-level JOIN query

2001-04-08 Thread nigga mysql
Your absolutely right, my question was not clearly specified. So here's a concrete problem: Let's say table A has 2 fields: PRODUCT_ID (unique) and PRODUCT_NAME, table B has 3 fields: PRODUCT_ID,COMPANY_ID and LAST_PRODUCTION_DATE, and finally table C : COMPANY_ID and CONTACT_INFO Table A is the m

Re: DSN

2001-04-06 Thread role+mysql-readers
HN> How can I set a datasource name (DSN) for a database in MySQL? Get MyODBC for the platform where you want the DSN available, then enter the MySQL server & database details for a "machine DSN" using your ODBC administration facilities on the platform where you want the DS

Re: Problem migrating from 3.23.29 to 3.23.36

2001-04-05 Thread MySQL Server
On Thu, 5 Apr 2001, Gerald Clark wrote: I forgot to mention that the permisions are already set to mysql:mysql 660 > MySQL Server wrote: > > > > Hy! > > > > I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36. > > It works fine with some datab

Problem migrating from 3.23.29 to 3.23.36

2001-04-05 Thread MySQL Server
Hy! I have this odd problem. I upgraded my MySql from 3.23.29 to 3.23.36. It works fine with some databases I created with 36. But I copied some databases from 29 and I get this mysql> use lumina; Didn't find any fields in table 'absences' Didn't find any fields in tab

Re: beggin, commit, and rollback

2001-04-05 Thread role+mysql-readers
KB> Doesn't mysql support begin and rollback transactions? I *believe* it went like this -- syntax supported and returned success without doing anything in older versions, then functionality was actually *implemented* more recently -- maybe only most recent stable release

Re[2]: Converting Access to MySQL

2001-04-04 Thread role+mysql-readers
L> Ok i'm still a little bit lost. I have a database in MySQL called "irm" L> In the ODBC Data Source 32 bit I went in user dsn and added user data source L> called irm the driver is mysql L> not this is were i dont understand . L> In the field that says Windwos

Re[2]: Converting Access to MySQL

2001-04-04 Thread role+mysql-readers
HHG> You must go to control panel of windows in Data Sources(ODBC) section and add your DSN of you new MySQL database and then you can explor the database by browsing your ODBC avilable databases . HHG> You can check MyODBC manual for this . Yes, this worked for me too. However ...

Re[2]: [couldn't connect to the mysql server]

2001-04-03 Thread role+mysql-readers
U> - Original Message - U> From: James Lyon U> To: [EMAIL PROTECTED] U> Cc: [EMAIL PROTECTED] U> Sent: Tuesday, April 03, 2001 3:56 PM U> Subject: Re: [couldn't connect to the mysql server] U> >>Description: U> umcn>umcn>

update - select query

2001-04-02 Thread mysql m mysql
i need to update a row of a table taking the values of a "select ... from table1, table2 where table1.row=table2.row group by row" query. say: desc source_table; key int(10) FK column_source timestamp desc table_to_update; key int(10) column_to_update datet

Re: How compile a C/C++ program which use API for mysql?

2001-04-02 Thread mysql m mysql
u just have to tell the compiler where ur mysql header (mysql.h) and shared library (libmysqlclient.so) are located, e.g.: gcc -L/usr/local/lib/mysql -lmysqlclient -I/usr/local/include/mysql -o a.out yourprogram.c ... in this case mysql.h is in the directory /usr/local/include/mysql, and the

confirm subscribe to mysql@lists.mysql.com

2001-04-01 Thread mysql-help
Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like archive@jab.org added to the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] Usually, this happens when you just hit the "reply&q

question about NOT IN

2001-03-15 Thread mysql
Please I would want how I can get the list of records from a table1 that do not appears on a table2, supossing a column e.g code is used as connector or joiner present at both tables; Thanks Ernesto - Este mensaje fue enviado a través de Qnet http

Re: Special Character \

2001-03-15 Thread mysql
2:08 PM Subject: Re: Special Character \ > use \\ combination > > > - Original Message - > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, March 15, 2001 11:55 PM > Subject: Special Character \ > > > Can someone tell me how to

Special Character \

2001-03-15 Thread mysql
Can someone tell me how to insert an selct back a directory into mysql using sql? I'm trying to insert and reselect c:\My Documents into a varchar field and I keep having a problem with the special character \ Jeff

Remove or Unsubscribe

2001-03-13 Thread mysql
Remove unsubscribe neither one of the 2 methods listed below for name remove seem to function please remove me from this list ASAP... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

DBI for Windows

2001-03-07 Thread mysql
Dear Sirs: Please can you tell me where I can get the Perl DBI interface for Windows ??? Ernesto - Este mensaje fue enviado a través de Qnet http://www.qnet.com.pe - Before postin

<    2   3   4   5   6   7   8   >