Re: opaque error message [2]

2002-12-08 Thread Dennis Allison
I have found a work around, but I do wonder what the problem is with MySQL and BDB tables. When I rerun the load with the table type set to ISAM it all works. Looks like there may be some limitation of the BDB implementation I am triggering. In my previous post, I reported receiving an Error

No Ä, Ö, Ü, etc.

2002-12-08 Thread Sollinger Rainer (dienstlich)
All 'ä', 'ö', 'ü', etc. are changing in ?,!   What can I do against it?   Rainer Sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Replication between Windows MSSQL and UNIX MYSQL

2002-12-08 Thread Iikka Meriläinen
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 8 Dec 2002, shawn xu wrote: > We have an application software which uses MSSQL 7.0 > or 2000 server on Windows. Now we want to use the > MSSQL as a master, and MYSQL on UNIX as a slave. How > can we configure Windows MSSQL and UNIX MYSQL both

Re: INSERT

2002-12-08 Thread Iikka Meriläinen
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sun, 8 Dec 2002 [EMAIL PROTECTED] wrote: > I have a ntext data type on SQLServer7, and I have the following statement: ^^ First, cross-posting like this is stupid. Second, it's not needed. Third, (could be 1. +

Opaque mysql error ...

2002-12-08 Thread Dennis Allison
I have a moderately large database (150K records of nine fields, a bit under 500 bytes per record with a primary key. The database is of Type BDB. To improve query performance I concluded I needed to add a three element index. Running alter table foo add index udex( w_1, w_2, w3 );

Re: Select * From table where name Like 'help'; Help

2002-12-08 Thread Beauford.2003
I am doing this search from a website, and from what I can tell there is no way to use a variable (i.e. $var) with REGEXP as the $ sign has a special meaning to REGEXP. Any other suggestions, or would you know a way around this. TIA - Original Message - From: "Robert Citek" <[EMAIL PROTEC

UNION

2002-12-08 Thread D Bamud
MySQL 3.23.53 I have a table T1 and want to do something like SELECT * FROM T1 WHERE A = 1 AND xxx... UNION SELECT * FROM T1 WHERE A = 2 AND yyy... Don't read to much in the WHERE clause, this is just for question purpose. Also I know that UNION is available in MySQL 4.x but need to have the REP

Quota Support

2002-12-08 Thread Steven Adams
Hey, I was wondering if its possible to implant a quota system where i can give a user just say access to 2 databases which is allowed to grow to 30Mb bewteen the two of them.. What i would really like is if its possible to make mysql use the disk quota limits.. So i can give the uses say

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Daevid Vincent
Yes. I can not connect remotely using ANY Microsoft Windows clients/tools EXCEPT "Mascon" -- which for some strange reason works just fine. Yet EVERY OTHER WINDOWS mySQL PROGRAM fails with the same error message (10061 Can't connect...) I'm 98% positive my 'permissions' are correct in the mysql da

Re: E-Commerce, db-clustering and MySQL?

2002-12-08 Thread Dietrich Speer
Hello Bjorn: Thanks for the encouragement. There are a lot of questions I still have, though. I am constantly working on moving the sql code into stored procedures in order to improve speed. I'd like to keep asp on 2000 servers. Doesn't the lack of stored procedures force me to go back to parsed

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Michael She
Sorry for jumping in late, but are you saying that you can't connect from a remote machine? Did you add a Host '%' to your username in the users table? At 07:36 PM 12/8/2002 -0800, Daevid Vincent wrote: *I* am the admin. I don't have a command line utility on my WinXP box. The command line uti

Re: Error: Can't lock file

2002-12-08 Thread Geetika Tewari
In answer to Paul's response: Line 54 does the following: $sth->execute() or die $sth->errstr; in the following chunk of code that is in my Perl script: # update the gpa of 1000 random students for ($i = 1 ; $i <= $num_updates ; $i++) {

Re: Error: Can't lock file

2002-12-08 Thread Paul DuBois
At 23:09 -0500 12/8/02, Geetika Tewari wrote: Hi, I am getting the following error while trying to do read-write queries on MySQL. Does anyone know what this error means? The name of the script that generated this error is called randomreadwrite.pl. Can't lock file (errno: 12) at ./randomreadwr

Error: Can't lock file

2002-12-08 Thread Geetika Tewari
Hi, I am getting the following error while trying to do read-write queries on MySQL. Does anyone know what this error means? The name of the script that generated this error is called randomreadwrite.pl. Can't lock file (errno: 12) at ./randomreadwrite.pl line 54. Thanks very much.

mysql_errno and mysql_error disagree on INSERT DELAYED

2002-12-08 Thread chris
>Description: On an unsuccessful INSERT DELAYED using mysql_query(), there is disagreement between the two functions mysql_error() and mysql_errno(). Specifically, mysql_errno() will return 0 (indicating no error), whereas mysql_error() will return what really happened, e.g. "Table 'foo' doesn

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Daevid Vincent
*I* am the admin. I don't have a command line utility on my WinXP box. The command line util on Linux works just fine for itself (localhost, daevid.com, 192.168.1.254, etc) MySQL *is* configured properly otherwise "mascon" would not be able to connect either. I've done this for a while. The prob

Re: Want to create mySQL user through phpMyAdmin

2002-12-08 Thread Manisha
oh! god! - Thanks a lot, I have a root access and with that I could create a user directly from command line. I was thinking that thr phpMyAdmin 2.1.0 I can do it (New version can - but seems not this version) Thanks once again Manisha At 10:21 PM 12/8/02 -0500, Joe Stump wrote: It's not a

Re: Want to create mySQL user through phpMyAdmin

2002-12-08 Thread Manisha
I am using phpMyAdmin 2.1.0. I created user from this (mysql.user) but do not know how to reload it ? I am not finding any such option on it. Can u please tell me more about it. Thanks, Manisha At 09:45 PM 12/8/02 -0500, Joe Stump wrote: Did you reload the privileges? --Joe On Sunday, Decemb

Re: Want to create mySQL user through phpMyAdmin

2002-12-08 Thread Joe Stump
Did you reload the privileges? --Joe On Sunday, December 8, 2002, at 09:21 PM, Manisha wrote: I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program $conn = @mysql_connect ("localhost:/usr/home/nets/mysq

Re: Replication between Windows MSSQL and UNIX MYSQL

2002-12-08 Thread Michael She
Did you read the Replicatoin Manual? http://www.mysql.com/doc/en/Replication.html At 09:15 PM 12/8/2002 -0500, shawn xu wrote: We have an application software which uses MSSQL 7.0 or 2000 server on Windows. Now we want to use the MSSQL as a master, and MYSQL on UNIX as a slave. How can we confi

Re: Date conversion

2002-12-08 Thread Michael She
You need to convert the date format to: -MM-DD: http://www.mysql.com/doc/en/Using_DATE.html At 08:38 PM 12/8/2002 -0500, [EMAIL PROTECTED] wrote: Hi all, I have a datetime data field in SQLServer7, and I am trying to get a recordset according to criteria that the CallDate field in the da

Want to create mySQL user through phpMyAdmin

2002-12-08 Thread Manisha
I want to create mySQL user thr phpMyAdmin. I inserted one record in mysql.user table and one in mysql.db table, testing with following program $conn = @mysql_connect ("localhost:/usr/home/nets/mysql/mysql-demo.sock", "manisha", "pass"); echo("before conn a"); if ($conn){ mysql_select_db ("demo"

Replication between Windows MSSQL and UNIX MYSQL

2002-12-08 Thread shawn xu
We have an application software which uses MSSQL 7.0 or 2000 server on Windows. Now we want to use the MSSQL as a master, and MYSQL on UNIX as a slave. How can we configure Windows MSSQL and UNIX MYSQL both sides to implement replication? Any idea? Thanks in advance. Shawn __

Re: Problem compiling mysql-3.23.53

2002-12-08 Thread Pierre
I tried mysql-4.0.5a-beta, and same error... Pierre. On 2002.12.08 02:36 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql' g++

Question

2002-12-08 Thread Johan
Hello, every body I have 2 database server. the second is a copy of the first. It's replication. But there is no connection line because it is not necesery to have an identical copy. Every day, i have to update the second using a self made program. To identified which record has changed,inserted or

Date conversion

2002-12-08 Thread Sam4Software
Hi all, I have a datetime data field in SQLServer7, and I am trying to get a recordset according to criteria that the CallDate field in the database equals todays date 09/12/2002 Dim TodaysDate TodaysDate= cDate(Date) sCallsSQL = "SELECT CallBacks.CallDate,CallBac

Re: Error compiling mysql 3.23.53

2002-12-08 Thread Pierre
For information, same error with mysql-4.0.5a-beta Pierre. On 2002.12.09 02:11 Pierre wrote: Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in isam gmake[2]: Entering directory `/tm

Re: Select * From table where name Like 'help'; Help

2002-12-08 Thread Robert Citek
Try the REGEXP modifier. For example: mysql> select "Another One" regexp "[[:<:]]One[[:>:]]" ; mysql> select "Fashioned" regexp "[[:<:]]One[[:>:]]" ; The format differs from that used in sed, grep, awk, perl, python, etc. http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Re

Error compiling mysql 3.23.53

2002-12-08 Thread Pierre
Hi, I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : [...] Making all in isam gmake[2]: Entering directory `/tmp/mysql-3.23.53/isam' /bin/sh ../libtool --mode=link gcc -s -O3 -DDBUG_OFF -O3 -march=i686 -L/

Re: Re: alter table syntax

2002-12-08 Thread kayamboo
Thanks for the suggestions. (BIt worked fine (B (B (Bregards (B (B- Original Message - (BFrom: "Egor Egorov" <[EMAIL PROTECTED]> (BTo: <[EMAIL PROTECTED]> (BSent: Friday, December 06, 2002 11:36 PM (BSubject: re: Re: alter table syntax (B (B (B> kayamboo, (B> Friday, December

Re: alter table syntax

2002-12-08 Thread Dan Nelson
In the last episode (Dec 09), kayamboo said: > I don't get you. > But when I executed the drop table syntax fromt he command line, the result > was this error > > mysql> alter table town_db drop primary key ; > ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db' > (errno: 150

Re: Can u us a "source code" file to setup a db in MySQL ?

2002-12-08 Thread Gerald R. Jensen
Try: mysql -u{username} -p {databasename} To: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 6:43 PM Subject: Can u us a "source code" file to setup a db in MySQL ? When created a complicated db in MySQL can you first create a "source file" with all the MySQL commands...

Re: Select * From table where name Like 'help'; Help

2002-12-08 Thread Jocelyn Fournier
Hi, A "dirty" solution would be to search : field LIKE '% one %' or field LIKE 'one %' or field LIKE '% one' or field='one'; Regards, Jocelyn - Original Message - From: "Beauford.2003" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, December 10, 2002 12:50 AM

Select * From table where name Like 'help'; Help

2002-12-08 Thread Beauford.2003
Hi, Hey, did this list change their spam filters? Now every time I send an email it gets bounced unless the word MySQL or Query is in the email. Anyway, Please read below for a recent problem I am having. I want to be able to search on my database and be able to get the following, but running i

Can u us a "source code" file to setup a db in MySQL ?

2002-12-08 Thread TopMailBox
When created a complicated db in MySQL can you first create a "source file" with all the MySQL commands... and then either pipe them to MySQL or have MySQL read the "source file" and then create the db accordingly ?? Or, must you input/key in one command at a time to the program in real time? Tha

Re: alter table syntax

2002-12-08 Thread kayamboo
I don't get you. But when I executed the drop table syntax fromt he command line, the result was this error mysql> alter table town_db drop primary key ; ERROR 1025: Error on rename of '.\forest\#sql-cc_1' to '.\forest\town_db' (errno: 150) mysql> Can you make me clear? regards - Origina

Re: Desc question

2002-12-08 Thread Jocelyn Fournier
Hi, if ($var=='grade_num') $filter='DESC'; else $filter='ASC'; $fetch = mysql_query("SELECT * FROM players ORDER BY $var $filter"); should work. Regards, Jocelyn - Original Message - From: "Alex Behrens" <[EMAIL PROTECTED]> To: "MYSQL" <[EMAIL PROTECTED]> Sent: Monday, December 09

Desc question

2002-12-08 Thread Alex Behrens
hey all, I have a quick question. I'm trying to display a list of players by their name, number, position, and grade. Name, number, and position all display properly. However, grade (which is sorted grade number) is backwards, since 12th grade is after 11, 10, etc. How can I make it so only one fo

desc question

2002-12-08 Thread Alex Behrens
hey all, I have a quick question. I'm trying to display a list of players by their name, number, position, and grade. Name, number, and position all display properly. However, grade (which is sorted grade number) is backwards, since 12th grade is after 11, 10, etc. How can I make it so only one fo

FULLTEXT

2002-12-08 Thread Steffan A. Cline
Hello Everyone! I am a member of the Lasso list and heard this would be a good place to ask about a few things about MySQL. 1. In a few places I read about FULLTEXT searches. In one place I saw it said 16 columns and in another 15. But, I am finding that when using 15 I get an error but then

Re: INSERT

2002-12-08 Thread A. Berger -- Onlynux
Should Be sCVInsertSQL = "INSERT INTO CVs (CV) VALUES ('" & strCV & "')" Regards Andres Berger -- Gerente de Marketing -- OnLynux Hosting por $14.99 Anual -- www.onlynux.com/hosting ---

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Daevid Vincent
[root@daevid]# mysqladmin ping -h daevid.com -uroot -p Enter password: mysqld is alive [root@daevid]# mysqladmin ping -h 192.168.1.254 -uroot -p Enter password: mysqld is alive > -Original Message- > From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] > Sent: Su

INSERT

2002-12-08 Thread Sam4Software
Hi, I have a ntext data type on SQLServer7, and I have the following statement: sCVInsertSQL = "INSERT INTO CVs CV VALUE '" & strCV & "'" Whats wrong with that please ? Ps. strCV is a complete CV contains many lines. - Befo

Re: Password protection

2002-12-08 Thread Stefan Hinz, iConnect \(Berlin\)
Dear Bjoern, > I have completed a new setup on WinXP, with Mysqld-nt as a service, and > assigned a new password to root. However I am able to connect as root > without password, alter and even drop tables and complete databases with > the tool MySQLFront !!! After setting up MySQL under Windows,

Re: MyISAM -> InnoDB

2002-12-08 Thread Stefan Hinz, iConnect \(Berlin\)
Dear Dan, > I have a database that, I now realize, could use the benefits of > row-locking and non-blocking SELECTs. So, I guess I need to change over > to InnoDB tables. How do I convert my existing data structures (and the > data they contain) into InnoDB tables? ALTER TABLE mytable TYPE=innodb

Password protection

2002-12-08 Thread Bjørn Stave
Hi MySQL I am a new user of your product, and so far everything looks great, except for password protection... I have completed a new setup on WinXP, with Mysqld-nt as a service, and assigned a new password to root. However I am able to connect as root without password, alter and even drop tab

Re: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Stefan Hinz, iConnect \(Berlin\)
Dear Daevid, > Can't connect to MySQL server on 'daevid.com'(10061) Try "mysqladmin ping -h mysql_host_name". This is the most basic thing I can think of to connect to a MySQL server. It should report "mysqld is alive". If even that doesn't work, try "mysqladmin ping -h 192.168.1.1" (or whatever

Re: E-Commerce, db-clustering and MySQL?

2002-12-08 Thread Lou Scalpati
Bjorn - you state to use auto_increment in 2-way replication. Others have said that this could cause a crash if the auto_increment field is duplicated. Have experienced any problems with it? - Original Message - From: "Björn Pålsson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sun

MyISAM -> InnoDB

2002-12-08 Thread Dan Cumpian
Hello, I have a database that, I now realize, could use the benefits of row-locking and non-blocking SELECTs. So, I guess I need to change over to InnoDB tables. How do I convert my existing data structures (and the data they contain) into InnoDB tables? Also, Is there anything that MyISAM tables

Re: E-Commerce, db-clustering and MySQL?

2002-12-08 Thread Björn Pålsson
First, I wish to say that you are making the right descision leaving M$ and taking a step into MySQL. Currently, I'm working on a project involving +500.000 rows and estimated 30.000 visitors / day on a 2 x dual 2.8 GHz Xeon dedicated for SQL. Additional servers are for HTTP and other tasks. There

Date field

2002-12-08 Thread Sam4Software
Hi. I am trying to store a date in the following format '08/12/2002' pr '08/12/2002' or any other format if I have to ...on SQLServer 7. Basically I want to use TodaysDate = Date' Date is the system date function strSQL = "SELECT * FROM CallBacks WHERE CallDate =" & TodaysDate Is there a

RE: May someone try this script under Mandrake 9 and Mysql 4.0.5

2002-12-08 Thread Adolfo Bello
Thanks a lot. I´ll stick to 3.23.53 until 4.0.6 appears. Adolfo > -Original Message- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 08, 2002 4:21 PM > To: [EMAIL PROTECTED] > Subject: Re: May someone try this script under Mandrake 9 and > Mysql 4.0.5 > > > Ad

Re: mi_test_all error help

2002-12-08 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, please do not send questions to me directly - send them to our mailing list instead (Cc:ed on this message again). On Thu, 5 Dec 2002, shawn xu wrote: > I am new to MySQL, and I don't know what you said > about GNU version. Would you please expa

RE: Can't connect error 10061 - nothing but Mascon works remotely.

2002-12-08 Thread Daevid Vincent
Error No. 2003 Can't connect to MySQL server on 'daevid.com'(10061) This is the same error I get with all the other programs too... No SSH or SSL. I'm connecting from my WinXP box to my Linux server over my local LAN. > -Original Message- > From: Karam Chand [mailto:[EMAIL PROTECTED]]

Re: May someone try this script under Mandrake 9 and Mysql 4.0.5

2002-12-08 Thread Heikki Tuuri
Adolfo, - Original Message - From: ""Adolfo Bello"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, December 08, 2002 12:47 AM Subject: May someone try this script under Mandrake 9 and Mysql 4.0.5 > I have used a database creation script for months under 3.23.53a. >

RE: mysql_installdb crashes on RedHat 8.0 ?

2002-12-08 Thread Brian Ipsen
Hi, Just for information - the stack trace gives: 0x808fdfc _Z15handle_segfaulti + 460 0x815adb8 __pthread_sighandler + 116 0x8171636 __strtol_internal + 1390 0x8098378 _Z17add_field_to_listPc16enum_field_typesS_S_jP4ItemS_P10st_typelib + 344 0x809aacb _Z7yyparsev + 3419 0x8092cdd _Z16handle_boo

Re: Reading logs

2002-12-08 Thread Heikki Tuuri
Amittai, - Original Message - From: ""Amittai Aviram"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, December 08, 2002 9:46 PM Subject: Reading logs > In both the MySQL manual and Paul DuBois superb _MySQL_, I find information > about turning logging on, rotating l

Re: Question about SLAVE STOP

2002-12-08 Thread Heikki Tuuri
Hi! I was able to break replication with a single SLAVE STOP command in 4.0.6. I ran an InnoDB stress test ibtest17. >From the printout below we see that after SLAVE START immediately we got a foreign key error in the slave. That shows the slave no longer was identical to the master, since only

mysql_installdb crashes on RedHat 8.0 ?

2002-12-08 Thread Brian Ipsen
Hi! I just compiled 3.23.53 on my RedHat 8.0 box - but when trying to start the mysql daemon, my init.d script tries to initialize the required tables. But this fails: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_

Reading logs

2002-12-08 Thread Amittai Aviram
In both the MySQL manual and Paul DuBois superb _MySQL_, I find information about turning logging on, rotating log files, and maintaining log files -- but I still do not understand how I am supposed to _read_ a log file. I am running MySQL 4.0.5-max-debug under Windows XP. If I issue the bare com

Re: MySQL user privilages

2002-12-08 Thread Paul DuBois
At 9:25 -0800 12/8/02, Ryan McDougall wrote: Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creati

Re: E-Commerce, db-clustering and MySQL? Thanks to all!

2002-12-08 Thread Dietrich Speer
Thanks to everybody who helped me with this! - Original Message - From: "Brian P. Austin" <[EMAIL PROTECTED]> To: "Dietrich Speer" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 9:01 AM Subject: RE: E-Commerce, db-clustering and MySQL? > There is no clusteri

Exam takers near Columbia, SC

2002-12-08 Thread Amittai Aviram
Anybody out there planning to take the new MySQL Core Certification Exam anytime soon and anywhere near Columbia, South Carolina, USA? It might be nice to chat on the phone and compare notes or whatever. Thanks! Amittai - Bef

Re: Record Lock?

2002-12-08 Thread Richard Reina
Benjamin Pflugmann wrote: Hello. On Sat 2002-12-07 at 14:15:59 -0800, [EMAIL PROTECTED] wrote: I would like to lock a specific record in a MySQL table so that no other user can update it while another user is is update the record via the user interface. Can someone please tell me the easie

Re: MySQL user privilages

2002-12-08 Thread Ryan McDougall
Hi thanx for the details... Ok I know I am thick... and for some reason I cannot get my head around this, let me try to explain what I want to do then maybe you can tell me its possible and how it is possible. I want to create a user that can be creative as he wants... allow him to create ANY data

Re: LOAD DATA command

2002-12-08 Thread Beauford.2003
If your using a Linux machine try using this when logging on to mysql: mysql --local-infile=1 -u username -p Not sure about Windows. There is apparently a security issue with this so it is not enable by default. Can't remember where I read this, but the above works for me. Beauford - Origi

Fw: Thanks

2002-12-08 Thread Beauford.2003
Thanks to all who recently answered some of my MySQL questions, although I am still having some problems with the concept of joins, but what I have figured out certainly does make it more efficient and versatile. I have managed to eliminate two tables (actually combine them into one) which made my

RE: How is DBTools Software?

2002-12-08 Thread Michael She
MySQL-Front isn't being developed anymore right? Anyhow, the last version I used was very very buggy. At 06:37 AM 12/8/2002 -0400, Chris Mason wrote: I've found mysql-front to be far superior, in fact, I can't complain about it at all. -Original Message- From: Michael She [mailto:[EMA

Re: How is DBTools Software?

2002-12-08 Thread Insanely Great
Greetings I like SQLyog. http://www.webyog.com/sqlyog/download.html Rgds Insane - Original Message - From: "Chris Mason" <[EMAIL PROTECTED]> To: "'MySQL List'" <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 4:07 PM Subject: RE: How is DBTools Software? > I've found mysql-front

RE: E-Commerce, db-clustering and MySQL?

2002-12-08 Thread Brian P. Austin
There is no clustering in MySQL. Replication features allow something similar. In my opinion, the reason I prefer MySQL is the fact that the basics are there to do what ever you need to. You are responsible for making the solution, not the vendor. Multiple MySQL slave servers, and multiple webse

Re: Question about SLAVE STOP

2002-12-08 Thread Heikki Tuuri
Hi! - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, December 07, 2002 4:59 PM Subject: Re: Question about SLAVE STOP > Hello. > > On Sat 2002-12-07 at 14:26:00 +0100, [EMAIL PROTECTED] wrote: > > Hello. > > > > On Fri

Re: Order By or Group By Help Please

2002-12-08 Thread Bill Easton
SOLUTION 1: It's probably simplest, conceptually, to build a temporary table which provides the proper ordering. The "ordering" column below is a computed value which determines the desired orderint of the File's. Then, you can join with an ORDER BY clause that gives the desired order. mysql> c

Re: Error in Query

2002-12-08 Thread Doug Thompson
MySQL doesn't accept variables for field length values. Your query should look something like this: CREATE TABLE `db` (`host` VARCHAR(localhost) NOT NULL, `db` VARCHAR(64) NOT NULL, `user` VARCHAR(64) NOT NULL, `select_priv` CHAR(1) NOT NULL, `insert_priv` CHAR(1) NOT NULL, `update_priv` CHAR(1

Re: Innodb row locking question

2002-12-08 Thread Heikki Tuuri
Mike, - Original Message - From: "Mike Gohlke" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, December 07, 2002 6:44 PM Subject: Re: Innodb row locking question > > > Benjamin Pflugmann wrote: > > >Hello. > > > >On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTE

Re: Record Lock?

2002-12-08 Thread Heikki Tuuri
Hi! - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, December 08, 2002 3:14 AM Subject: Re: Record Lock? > Hello. ... > With InnoDB you can lock a row by selecting it: > > SELECT * > FROM your_table > WHERE > FOR

mysql_install_db crashed

2002-12-08 Thread shivaken
>Originator: >Organization: >MySQL support: none >Category: mysql >Release: mysql-3.23.53 (Source distribution) >Environment: System: Linux cj1398237-a 2.5.49-ac1 #3 SMP Sun Dec 8 17:01:39 JST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /u

Re: MySQL user privilages

2002-12-08 Thread Stefan Hinz, iConnect \(Berlin\)
Dear Ryan, have a look at the manual: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management With the exception of Paul's book on MySQL, you probably won't find a better explanation of the MySQL privilege system. > PLEASE I'M GOING

RE: How is DBTools Software?

2002-12-08 Thread Chris Mason
I've found mysql-front to be far superior, in fact, I can't complain about it at all. -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 07, 2002 3:27 PM To: Will Standley Cc: Sandeep Murphy; Crercio O. Silva; MySQL List Subject: Re: How is DBTools So