Re: transactions support in mysql

2001-07-18 Thread Jeremy Zawodny
On Wed, Jul 18, 2001 at 11:40:15AM +0530, Chandrashekhar wrote: Are transactions supported in mysql.Please guide me. They are. See the manual: http://www.mysql.com/doc/ Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408)

re-indexing records

2001-07-18 Thread Rory O'Connor
I'm a bit of a mysql newbie...excuse if this is rudimentary. I imported about 5000 records and realized that the index is a bit scewy since i deleted alot of records while it was in access. rather than fix it in access and re-import it, is there an easy way to re-index the records in mysql?

Default date format

2001-07-18 Thread pak
Is there a default format for Date ? /mm/dd or mm/dd/ or dd/mm/ ? I am not sure which format I should use in SQL. - Before posting, please check: http://www.mysql.com/manual.php (the manual)

RE: Default date format

2001-07-18 Thread Warren van der Merwe
Hi -mm-dd is how it is stored in the db, you have to pass the date like that, and that is how it will be returned. Regards ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31)

Re: re-indexing records

2001-07-18 Thread Carsten Gehling
Drop the index and recreate it alter table you-table drop index your-index; alter table you-table create index your-index(fieldlist); - Carsten - Original Message - From: Rory O'Connor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 7:55 AM Subject: re-indexing

RE: re-indexing records

2001-07-18 Thread Warren van der Merwe
HI You may get other replies to the contrary, but in my knowledge, no you cannot do what you asking. However, I can suggest that you create the table in MYSQL with the auto-number column, then in access delete the auto number column so that when you import into MYSQL no value is passed for that

access denied from java

2001-07-18 Thread shane
i was denied access to the mysql server when i ran the java program. however, using the same password and user id i could access the database from the terminal by executing %root@localhost mysqlbin/mysql -u root -p databaseName and then entering the password indicated in the java code. really do

Re: password-recovery for root-user?

2001-07-18 Thread T Halim
Selamat pagi saja. - Original Message - From: Rischbode, Horst [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 3:23 PM Subject: AW: password-recovery for root-user? mit freundlichem Gruss Horst Rischbode --- Deutsche Telekom AG Tel: ++49 431 145 1378

Re: transactions support in mysql

2001-07-18 Thread Chandrashekhar
Thanks for your prompt reply. I would like to know which version of mysql does supports transactions. and is it stable? Thanks again. with regards, chandrashekhar - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Chandrashekhar [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent:

installing berkley db in windows

2001-07-18 Thread suharman
how to installing berkeley db in windows 98 with mysql 3.23.39? thx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

RE: jdbc connectivity

2001-07-18 Thread Kalpesh Modha
Hello. I have the same problem let me know if you find a solution. Mine is on redhat 7.1 Thanks Kal -Original Message- From: raghavan [SMTP:[EMAIL PROTECTED]] Sent: 18 July 2001 06:47 To: [EMAIL PROTECTED] Subject:jdbc connectivity Hi, I am trying to connect mysql

Ynt: installing berkley db in windows

2001-07-18 Thread Yusuf Incekara
install mysql-max edition and read mysql manual for required setting to run bdb. - Original Message - From: suharman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 12:00 PM Subject: installing berkley db in windows how to installing berkeley db in windows 98

connect mysql to java and/or asp

2001-07-18 Thread Hasan
anyone can give me a scoop on how to connect mysql to java and/or asp? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Faults

2001-07-18 Thread Marco Pappalardo
Hi all! I'm thinking about using MySql in an application over an unstable system. Database will probably be subject to system crashes and unexpected lack of power supply. So I need the database has a strong Persistence policy and, if possible, that it allows the user to set some parameters to

SMP+mysql problem

2001-07-18 Thread Jorge Ruiz Martinez
Hello, i have got a A BIG PROBLEM, help me please!!! I've got installed Apache + MySQL in a Sun Enterp. 250 whith two processors and my problem is the next: When I run MySQL only works one processor with mysqld load averages: 0.68, 0.81, 1.02 01:37:45 259 processes: 251

having problem in installation of mysql.

2001-07-18 Thread chetan merai
I have a problem in installing mysql in linux suse version. I am getting error in configure part. I have done it for source distribution.and when I give the command I get the following error. error:can't find in . or .. Please send me the answer of my

Ynt: connect mysql to java and/or asp

2001-07-18 Thread Yusuf Incekara
For mysql and asp : check http://www.avukatpro.com/mysql.html - Original Message - From: Hasan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 12:40 PM Subject: connect mysql to java and/or asp anyone can give me a scoop on how to connect mysql to java and/or

Q: Update statement touches every row twice?

2001-07-18 Thread Stephan
Hello all! How can this happen: - Table with 537 rows - value of column q02 is 10 in all rows - UPDATE table SET q02=q02+20 ; - Query OK, 1074 rows affected (0.19 sec) Rows matched: 1074 Changed: 1074 Warnings: 0 ??? Why 1074 Rows? - Result: all 537 show value 50 in column q02 (!!

Connect Error

2001-07-18 Thread Kishor K
i am getting error 10060 when i try to connect to a remote mysql server. Any idea why this is happening thanx in advance kishor _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

Compiling problems

2001-07-18 Thread Lorenzo De Vito
I'm trying to compile a C file with this: BCC32 -IC:\mysql\include -LC:\mysql\lib\opt -IC:\Borland\BCC55\Include importDB.c but it return me an error: Unable to open file 'COX32.OBJ' What's the better way to compile with 'mysql.h' ?

Re: transactions support in mysql

2001-07-18 Thread Maurice Aubrey
The various table types are discussed here: http://www.mysql.com/doc/T/a/Table_types.html Maurice On Wed, Jul 18, 2001 at 02:12:37PM +0530, Chandrashekhar wrote: Thanks for your prompt reply. I would like to know which version of mysql does supports transactions. and is it stable?

Re: MySQL: my.cnf in Windows 2000

2001-07-18 Thread Dvoek Michal
i have my.ini in %systemroot% directory (eg. winnt) but if you run winmysqladmin an there is my.ini Setup tab, so here you can set anything S pozdravem Michal Dvoracek [EMAIL PROTECTED] - Before

RE: ERROR 1060: Duplicate column name

2001-07-18 Thread Sinisa Milivojevic
Lance Lovette writes: TYPE=PACKED does not seem to be documented in Chapter 7.7 in the online documentation. Where can I find a description of the PACKED option? Also, can it be noted in the documentation that CREATE ... SELECT * FROM ... does not create an exact copy of the table? Had I

Re: seg fault --- HELP!

2001-07-18 Thread Sinisa Milivojevic
[EMAIL PROTECTED] writes: I am hoping the someone may be able to help me. I re-compiled mysql with debug on. The server starts ok .. reports that mysqld is ready for connections. However I cannot use ANY of the client tools .. mysql , mysqladmin etc ... as soon as I try to run any of them it

Re: SMP+mysql problem

2001-07-18 Thread Werner Stuerenburg
What I am stumbling about is this: PID USERNAME THR PRI NICE SIZE RES STATE TIMECPU COMMAND 22889 root 30 330 801M 11M cpu0 23.6H 26.75% mysqld Is this really true: size 801 M How can that be -- Herzlich Werner Stuerenburg

Re: Faults

2001-07-18 Thread Werner Stuerenburg
The main aspect I'm interested in is avoiding data loss. So I want that any change to database must immediatly (or at least on regular intervals) be made persistent. Is there any configurable parameter to do this? You may want to read about transaction services. -- Herzlich Werner

Re[2]: mysql.org

2001-07-18 Thread Werner Stuerenburg
table This statement/release was very ordinary, very normal, very to-the-point for any situation such as this. Condescending, no. Condescension, like beauty, is in the eye of the beholder. Well, I didn't plan to give my opinion on this subject publicly. But, I was alerted by the last post

Re: mysql.org

2001-07-18 Thread B. van Ouwerkerk
As you are aware, we are forming a not-for-profit corporation to focus on building and supporting a larger MySQL development community and promoting MySQL. The mysql.org domain is expected to be transferred to that organization. NuSphere has taken the lead and is covering the costs of forming

Re: AW: password-recovery for root-user?

2001-07-18 Thread Werner Stuerenburg
You can reinstall the complete system from scratch, if you are superuser to that system. Would be the easiest way to do it, I guess. I'm trying to get the root-password to be deleted or set to a new value without knowing the old password. (Forgotten...) table -- Herzlich Werner Stuerenburg

Re[2]: SMP+mysql problem

2001-07-18 Thread Werner Stuerenburg
Sorry, I don't know about Solaris, but I observed that my MySQL processes (Linux) are sometimes from 10 to 25 MB which makes me wonder. I think that a process should reflect the result size, for example. We have all sorts of parameters here to adjust memory usage, and normally there are

MySQl mnoGoSearch

2001-07-18 Thread Frank Gragnano
Anyone ever experience problems with mnoGo writing to the MySQL dB? I posted a misinformed thread yesterday that went unanswered (for obvious reasons). Yet I am still having problems with mnoGo and MySQL. Is there any issues that anyone knows of pertaining to these working together? Thanks.

Re: mysql.org

2001-07-18 Thread Justin Farnsworth
Werner is correct in encouraging all to make up your own mind. And, it is always possible that Orwellian DoubleSpeak is an ingredient of these public statements and posturing. But, a great distinction must be made here, and not tie the idea of DoubleSpeak to a fear of manipulation, unless you,

RE: AW: password-recovery for root-user?

2001-07-18 Thread Andy Tanner
Similarly - how about - take a copy of you original mysql database tables - overwrite the mysql database tables with the original installation tables - login as root (the password will be blank) - import your orignial tables back into the mysql database good luck Andy -Original

RE: AW: password-recovery for root-user?

2001-07-18 Thread Ravi Raman
mysqld --skip-grant-tables section 6.3 on this page: http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h tml -ravi. -Original Message- From: Andy Tanner [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 10:03 AM To: Werner Stuerenburg; Rischbode,

Modifing A Table

2001-07-18 Thread Paul Castiglione
Hello Is there a way to add addition feilds to a table after it been created. Thank in Advance Paul

Re: Modifing A Table

2001-07-18 Thread j.urban
mysql alter table mytable add newcolumn varchar(16); Have a look at the ALTER TABLE syntax in the manual... http://www.mysql.com/doc/A/L/ALTER_TABLE.html On Wed, 18 Jul 2001, Paul Castiglione wrote: Hello Is there a way to add addition feilds to a table after it been created.

Re: MySQL loves FreeBSD (but not NetBSD) ...

2001-07-18 Thread Ken Menzel
Hi Tom, As another user of MySQL on FreeBSD, I can tell you from my own experience that the MySQL Team is dedicated to having MySQL run on as many platforms as possible. I say this as an almost direct quote from e-mail Monty sent me. Things were not always smooth with FreeBSD threads, it is

Re: Modifing A Table

2001-07-18 Thread Jason Burfield
alter table TABLENAME add COLUMN_NAME etc, etc... ie: alter table members add firstname varchar(50) not null; If you want to put it after a specific column you can do the following: alter table members add firstname varchar(50) not null after lastname; -- Jason On 7/18/01 10:32 AM, Paul

Small Problem with a function

2001-07-18 Thread Rick Makla
What can I do to fix this error or can you referance me to a point where I can look at to try to fix the problem. Fatal error: Call to unsupported or undefined function mysql_pconnect() in ./db_mysql.php on line 38 Rick Makla Digital Media P: 803.758.4057 F: 803.779.9455 [EMAIL PROTECTED]

Converting ACCESS or EXCEL Data to MySQL

2001-07-18 Thread Oliver Hohlfeld
Hi there, I'm currently working on a bigger Project. There is a company who want to publicate their article database daily on the internet. The database is located in a Microsoft SQL Server and they use Access as frontend. So, exporting the Data to Excel is no problem. I'm currently thinking

Re: Small Problem with a function

2001-07-18 Thread Mike Baranski
Did you build PHP with mysql support, and are you requring the mysql/php module in your program, something is not set up correctly. On Wednesday 18 July 2001 11:01, Rick Makla wrote: What can I do to fix this error or can you referance me to a point where I can look at to try to fix the

RE: Small Problem with a function

2001-07-18 Thread Sander Pilon
You must compile PHP with the mysql module enabled. See the PHP manual for more information. (Or search the excellent php mailinglist archives at http://www.php.net/support.php) -Original Message- From: Rick Makla [mailto:[EMAIL PROTECTED]] Sent: 18 July 2001 17:02 To: [EMAIL

Re: Small Problem with a function

2001-07-18 Thread Werner Stuerenburg
mysql support should be built into php. I experienced this twice under Winxx. The first time I found a remedy which I don't remember. The second time I upgraded to the newest version of php. Fatal error: Call to unsupported or undefined function mysql_pconnect() in ./db_mysql.php on line 38

BLOB storing

2001-07-18 Thread Damiano Sandei
I'm trying to save BLOB values in a table from a little java application, but i found only null values in the table. I've configured the max_allowed_packet parameter, I've controlled the path of the file I want to save, but nothing. Anyone can help me? Thank you Damiano

Re[2]: AW: password-recovery for root-user?

2001-07-18 Thread Werner Stuerenburg
http://www.mysql.com/documentation/mysql/bychapter/manual_Privilege_system.h FYI: The link you requested was not found. Sie schrieben am Mittwoch, 18. Juli 2001, 16:17:24: mysqld --skip-grant-tables section 6.3 on this page:

ERWIN, stored procedure, release date MySql questions

2001-07-18 Thread Steve Dufrane
I am not a subscriber to this message board, please copy replies to [EMAIL PROTECTED] Greetings, A few questions - *regarding trying to determine how to use stored procedures with Mysql, 1 approach I have heard is to put all your sql in a text file -how does this compare to just embedding

Re: Converting ACCESS or EXCEL Data to MySQL

2001-07-18 Thread Dennis Salguero
- Original Message - From: Oliver Hohlfeld [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 8:13 AM Subject: Converting ACCESS or EXCEL Data to MySQL I'm currently working on a bigger Project. Uh oh, wasn't that the plot to The Spanish Prisoner ?? ;-) I'm

MySQL get COUNT(*) on # rows AND return LIMITed results in 1 query ?

2001-07-18 Thread S A
Is there some way to take the following 2 queries make them into one ? I want to be able to in one query get the # of overall rows and do a LIMITed result set to get the first NN rows. Is it possible to to do this in one query ? Presumable MySQL has to figure out what the overall # is to

RE: Re[2]: AW: password-recovery for root-user?

2001-07-18 Thread Ravi Raman
the link got split over 2 lines when it was copied/pasted... manual_Privilege_system.html instead of manual_Privilege_system.h -ravi. -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:25 AM To: Ravi Raman Cc: [EMAIL PROTECTED];

performances

2001-07-18 Thread safae
Bonjour, Je voudrais avoir une idée sur les performances de MYSQL, du genre capacité maximale , temps de réponse. Et puis comment faire pour modifier les parametres surtout le TIMEOUT. Merci - Before posting, please check:

RE: [PHP] Email Software

2001-07-18 Thread Dave Carter
LOL!!! -Original Message- From: Dan Harrington [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 18, 2001 11:47 AM To: Wee Chua; PHP (E-mail); MySQL (E-mail) Subject: RE: [PHP] Email Software try http://www.spamcop.net, they are experts in it. -Original Message-

Re: Converting ACCESS or EXCEL Data to MySQL

2001-07-18 Thread John Meyer
At 08:47 AM 7/18/01 -0700, Dennis Salguero wrote: Notice that I haven't really mentioned MySQL at all. As much as I like MySQL, if you already have a SQL Server that can connect to the Internet, I don't understand the need to use MySQL in this scenario ??? Obviously, if this is a web page that

How to find the port Mysql listens to?

2001-07-18 Thread Yan Ge
Hi, Guys! I have difficulties to talk to MySql via Java Servlet and Resin. Platform: We use Solaries, and Resin as Servlet container. The server I use and the server with MySql database is connected via LAN. What I have done: 1. I have put resin's mysql jdbc driver in resin/lib, and set

Re: MySQL get COUNT(*) on # rows AND return LIMITed results in 1 query ?

2001-07-18 Thread Dan Nelson
In the last episode (Jul 18), S A said: Is there some way to take the following 2 queries make them into one ? Nope. Do them separately (or do the count(*) once and cache it for the rest of the session). I want to be able to in one query get the # of overall rows and do a LIMITed result

How does this work in MySQL?

2001-07-18 Thread Bryan Coon
I recently got into a discussion with a colleague that was interesing. He is a database warehouse guy, so I assume he knows more than I do on this subject, but he was unable to explain things to me very well :) The question is how does mysql organize data between the physical table, the select

how to elect slave as master?

2001-07-18 Thread Ricardo Kleemann
Hi everyone, I'm wondering how I should configure my.cnf if I have a master-slave scenario where I would like to declare the slave master if the master goes down. What I mean is, let's say I have 2 database servers: server1 = master server2 = slave so normally my.cnf for server2 would have

Replication Load InFile

2001-07-18 Thread Warren van der Merwe
Hi If you use the load infile to insert images into a blob field, and then the path does not exist when the replication takes place, will there be an error, or is it clever enough to get the blob data from the db? THanks ~ Warren van der Merwe Software Director

Re: How does this work in MySQL?

2001-07-18 Thread Dan Nelson
In the last episode (Jul 18), Bryan Coon said: In this paradigm, my colleague says that there are no guarantees that the records will be retrieved in any kind of order, and may in fact be random. How does this work? He also states that auto_increment does not guarantee consistent

Re: Database Replication

2001-07-18 Thread Gerald Clark
Make sure it is world readable. Jeremy Zawodny wrote: On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote: We are looking to replicate a couple of databases on to a second server. Having looked through the manual it says we need to add various commands to my.cnf. It turns out

MySQL or MS SQL?

2001-07-18 Thread Alexander Chernienko
Hi all, I'm currently writing proposals for a customer who want to hire our little programming team for creating corporate information system, wich includes huge database with number of records between 1-10 millions (incl. blobs - pictures). Expected database size is tens of Gb. There is idea

Re: InnoDB logging meachanism (newbie ;)

2001-07-18 Thread Heikki Tuuri
George, the binlog is exactly you must have switched on and you must keep the binlog files. The binlog contains the SQL statements you run into your database, and by re-running it against your database backup you can recover from your backup to the present state. You need the binlogs in

Re: Faults

2001-07-18 Thread Gerald Clark
Werner Stuerenburg wrote: The main aspect I'm interested in is avoiding data loss. So I want that any change to database must immediatly (or at least on regular intervals) be made persistent. Is there any configurable parameter to do this? You may want to read about transaction

Re: How does this work in MySQL?

2001-07-18 Thread Mike Baranski
On Wednesday 18 July 2001 13:32, you wrote: I recently got into a discussion with a colleague that was interesing. He is a database warehouse guy, so I assume he knows more than I do on this subject, but he was unable to explain things to me very well :) The question is how does mysql

Re: mysql.org

2001-07-18 Thread Michael Collins
It seems to me that the bottom line is that any outcome that results in there being a fork in the development of MySQL (with the result being two completely different types of MySQL), or in NuSphere retaining control of the mysql.org domain should be vehemently rejected by the MySQL

RE: how to elect slave as master?

2001-07-18 Thread Warren van der Merwe
Hi Ricardo From my opinion, and yet again the pro's may dispute it, I understand what you actually want is a two way slave situation, in that way, when one goes down the second is there to take over, and when server1 comes back up if will update itself's from server2 and carry on. The rest of

RE: how to elect slave as master?

2001-07-18 Thread Ricardo Kleemann
Thank you. But then how can mysql replication be used for high availability? If I always rely on 1 master only, what happens if the master goes down? I've tried two-way master-slave and I understand there are problems. :-( On Wed, 18 Jul 2001, Warren van der Merwe wrote: Hi Ricardo From

Configuration error

2001-07-18 Thread Informatica UNAN-Leon
Help me: I am install mysql-3.23.39 on BSDI4.1 I have error on configuration: How solution this problem Atte, Cesar real Universidad Autonoma de Nicaragua Leon --- configure:3950: checking for opendir in -ldir configure:3969: gcc -o conftest -O3 -mpentium

RE: MySQL or MS SQL?

2001-07-18 Thread Chris Cameron
I'm sure if done right, MySQL could do whatever you want satisfactorily. Same with MS SQL (ignoring cost). However, something few people seem to know, but I've realized from experience is that when you offer people services based off free software, you get a different kind of customer. And not

Restoring mysql database from backup and logging

2001-07-18 Thread Philip Daggett
When restoring a backup, the binlog will record all of the backup's commands (create tables and insert into's). Would it therefore be a good idea to flush the logs before a restore and then flush the logs immediately after so that the restoration log can be deleted (or ignored)?

Re: innodb on nt4

2001-07-18 Thread Pete Kuczynski
Ok, got the following line working in my.ini, it created a 10mb ibdata file: innodb_data_home_dir=c:/mysql innodb_data_file_path=ibdata1 set-variable=innodb_mirrored_log_groups=1 but, when I add innodb_log_group_home_dir=c:/iblogs mysyl won't start. I created a iblogs directory. Any ideas?

Re: innodb on nt4

2001-07-18 Thread Heikki Tuuri
Hi! You have to specify also the data file size in innodb_data_file_path. The following example is from the manual at www.innodb.com: Suppose you have a Windows NT machine with 128 MB RAM and a single 10 GB hard disk. Below is an example of possible configuration parameters in `my.cnf' for

PLEASE help me!! MySQL Linux Problem

2001-07-18 Thread David Ayliffe
I am having A LOT of trouble compiling the code Simple1.cc which comes with the C++ API for Linux I have extracted the API to a directory in /root/ and MySQL is installed and works in /usr/local/mysql PLEASE someone please help me compile just this simple program. What am I missing? When I

Re: MySQL or MS SQL?

2001-07-18 Thread Michael Bacarella
On Wed, Jul 18, 2001 at 12:38:29PM -0600, Chris Cameron wrote: I think people who use proprietary software systems are just accustomed to being gouged by ridiculous software costs. Not to mention that it also costs us more to accomodate them. Basically, distorting the argument a little, you

Re: innodb on nt4

2001-07-18 Thread Pete Kuczynski
I did, see below from my prev email, that part works fine: innodb_data_home_dir=c:/mysql innodb_data_file_path=ibdata1 like I said, the system created a 10mb file called ibdata1 in c:\mysql But to recap, when I try to add the specifications for logs, it wort start, that's the next line:

Re: PLEASE help me!! MySQL Linux Problem

2001-07-18 Thread Mike Baranski
Read the man page for gcc and note the command line switch to point the linker at specific libraries, then use those switches on the command line. This is a linker error, rather than a compiler error: Example: g++ myGreatProgram.cpp -L/usr/mysql/lib -lmysqlclient On Wednesday 18 July 2001

Replication Offset off by 22 bug fixed

2001-07-18 Thread Sasha Pachev
Hello, everyone: Good news - I was able to repeat and fix the bug that several people have reported but were not able to repeat. No wonder - even after I noticed the problem in the source, it took some creative work to be able to write a test case for it. ( We try to write a test case for

Inserts Broken after database move

2001-07-18 Thread Karim A Nassar
I am using 3.22.32. The directrory where the databases lived was nearly full. Following the instructions in the manual, I stopped mysqld, I tar'd up the db's, moved them to the new location, created symlinks in the original location, restarted mysql (using safe_mysql). I now have the problem that

replication issue with FreeBSD 4.2-RELEASE

2001-07-18 Thread Brian Reichert
I'm exploring mysql replication under FreeBSD 4.2-RELEASE. Two machines, named 'master' and 'slave', each running FreeBSD 4.2-RELEASE and MySQL 3.23.36-debug. I've followed the instructions at http://www.mysql.com/doc/R/e/Replication_HOWTO.html All very straight forward. When I spin

Re: MySQL loves FreeBSD (but not NetBSD) ...

2001-07-18 Thread Brian Reichert
On Tue, Jul 17, 2001 at 10:05:24PM -0400, Haapanen, Tom wrote: ... or should that be FreeBSD loves MySQL? I finally caved in after a year of increasing (and unexplained) MySQL crashes, despite numerous updates to more recent versions of NetBSD and MySQL, and dozens of experiments with

Transaction for MySQL

2001-07-18 Thread Michael Tam
Hi all, I am new using MySQL. I found out that the default table type used in the binary isn't support transaction and would like to make MySQL uses another table type which supports transaction. The following are my questions regarding the issue: 1) which one should I use InnoDB or

Re: MySQL or MS SQL?

2001-07-18 Thread Rich Duzenbury
I like MySQL, and I'm fairly new at it, but if I were to need to store and retrieve tens of Gb's, I would want an IBM AS/400. Base configurations are quite reliable, and you can easily add RAID and other types of redundant support, up to and including redundant machines. I work with numerous

Re: innodb on nt4

2001-07-18 Thread Heikki Tuuri
Hi! I tested what happens if you already have a data file but in my.cnf you have not specified the file size. Then InnoDB just exits because there is a syntax error in innodb_data_file_path You should delete all your data and log files, write your my.cnf or my.ini so that you specify also the

Network connection

2001-07-18 Thread Chuck Lidderdale
Haven't been able to find this in the docs. $db = mysql_pconnect (anothermachine:oracleport, user, passwd) or die .. I need to connect to an oracle DB - can I? Or do I have to run a ?cgi? style script / program to get there? Tks Chuck L.

Re: using InnoDB == transactions (rollback) don't work

2001-07-18 Thread Heikki Tuuri
George, the default in MySQL is set autocommit = 1; To be able to do rollbacks you have to execute set autocommit = 0; Then you can do insert into ...; rollback; I assume you specified in CREATE TABLE ... (...) TYPE=INNODB? Regards, Heikki Copied message: . Hello everybody

Problem with keys in MyISAM tables

2001-07-18 Thread Marek Wojcik
The MySQL documentation says that one can have 32 keys/table for MyISAM table and that this can be extended to 64 keys/table without recompiling myisamcheck. I could not find any info on how to extend this limit. Could anyone help me about it? -- Marek Wjcik [EMAIL PROTECTED]

java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

2001-07-18 Thread Luc Lalancette
I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try to connect I get that message from the Subject. I know I'm suppose to pass the password but can't seem to find a way of doing it. I was wondering if the

MySQL: Multiple INSERTS syntax ...

2001-07-18 Thread Philippe L. Houze
Hi, I found syntax for INSERT command in both Paul DuBois excellent book and online manual but for single insert. And it works... which for a newbie like me is thrilling. But, I am stuck for multiple inserts. I am trying to remove from a database trailing characters (ascii 10) that have shown

RE: MySQL or MS SQL?

2001-07-18 Thread Quentin Bennett
Hi, Agreed Just because software is developed on a 'Free' platform, doesn't mean that the customer expects the application to be free, or even cheap. Our experience is that if you give something away, then people expect the support/upgrades/customisations to be free to. If you charge, even a

Buffering SELECT results without using temporary tables; Locked tables while 'Sending data' revisited

2001-07-18 Thread Martin Ling
We are currently working with a table containing ~650MB of data in 700,000 rows. In attempting to select from this, we would typically find long holdups with process states listed as creating temporary tables. By using SQL_SMALL_RESULT we were able to greatly reduce the time taken for select

how to give database connection to oracle and mysql

2001-07-18 Thread uma
My application is to give database connection to oracle which is in sun solaris machine and to mysql which is in windowsNT machine. How to write a java program to establish connection. please help me.

RE: FreeBSD issues

2001-07-18 Thread Institute For Social Ecology
Ken, Thank you for your very helpful notes. We took your advice and updated to FreeBSD 4.3 and the last version of MYSQL. We are still experiencing problems with MYSQL, though. We installed it fresh, with no freeBSD tweaks. I was not able to locate the email you referred to regarding FreeBSD

RE: MySQL loves FreeBSD (but not NetBSD) ...

2001-07-18 Thread Haapanen, Tom
Ken, I have absolutely no complaints at all about the support I got on this mailing list from the MySQL team -- they were very helpful, and provided many good suggestions. Unfortunately none of them worked, but such is life. I am happy that MySQL is stable on FreeBSD -- I was ready to go all

select field(3)

2001-07-18 Thread Kay Bowen
Hello all, I haven't been using MySQL very long. I'm more in the 'playing with it' stage, trying to learn all the in's and out's. So, here is my current dilemma: I want to be able to reference (select) a field/column by it's position in the table rather than by the field's name. Is there a

Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-18 Thread Carsten Gehling
Finally I was able to produce a complete step-by-step to corrupt the index ;-) Do the following in the mySQL console (with e.g. a fresh and empty table): mysql insert into visitkort (kategori_id) values (108); Query OK, 1 row affected (0.01 sec) mysql select last_insert_id();

using mysql to build a delphi program

2001-07-18 Thread Ricardo Striquer Soares
well well, as seen i brought the delphi and mysql power to built an application wich i am installing myself in the client nowadays although i'd like to make a more friendly installation pack in wich the client does not need to install the mysql and afther that install the program, i am using the

query.preview() stored in an edit box

2001-07-18 Thread Örjan Björk
Hi, I recently downloaded mysql++ and the tutorial that came with it. Unfortunately they used cout in the examples... they used the following code coutquery.preview(); and that worked great but... How do I get the result back as a string which I can store in a CString or char variable??

Re: FreeBSD issues

2001-07-18 Thread Michael Caplan
Ken, Thank you for your very helpful notes. We took your advice and updated to FreeBSD 4.3 and the last version of MYSQL. We are still experiencing problems with MYSQL, though. We installed it fresh, with no freeBSD tweaks. I was not able to locate the email you referred to regarding FreeBSD

Solution (but only a temporary one) Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-18 Thread Carsten Gehling
After the latest post, curiosity got the better of me (which is always good in a debug situation). I tried to change all 6 fields that compose the FULLTEXT index, so that they accept NULL values. The result? The error is gone. Is this a valid solution however? I've never been a great fan of the

Re: Network connection

2001-07-18 Thread Werner Stuerenburg
How about using Ora_Logon to connect to an oracle db? It is the prescibed procedure. mysql_pconnect ist used to connect to mysql dbs. $db = mysql_pconnect (anothermachine:oracleport, user, passwd) or die .. I need to connect to an oracle DB - can I? Or do I have to run a ?cgi? style

Problem compiling with GCC 3.0

2001-07-18 Thread Devendra Narayan
Would appreciate any help / tips regarding the following problem : Trying to compile mysql-3.23.39 with GCC 3.0 ( on Solaris 8 ) and the following configuration options : CC=gcc CFLAGS="-O1" CXX=gcc CXXFLAGS="-O1 -felide-constructors -fno-exceptions -fno-rtti" \ ./configure

  1   2   >