Re: Character Set Settings

Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the ".configure" parameters the followi

Re: MyISAM / Performance / Nb of table per DataBase

DB> I found my problem and why Mysql lock my table for a select. In DB> fact, mysql sometimes don't use the right index and so does a 'Table DB> sort' that lock my table. I modify the query to add USE INDEX DB> clause and now, all seems to work well ... I just need to test DB> during several da

RE: Character Set Settings

Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql> select * from test -> ; +--+ | data

installing mysql together with application

Hello I want to distribute my java database application together with mysql, and I want to make it as easy as possible. Right now a new user has to: - download and install mysql - run the mysql server with mysqld --standalone or a similar command - download my program and run it. To make this e

Re: MySQL as a desktop DB

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | I currently use MS Access as a single-user desktop database. The database is | getting quite large. The largest table has 300,000 rows. Definately a case when an upgrade would help, but maybe it's not essential. We used to use a system here that ma

OT Re: Mysql, PHP and a wrapper

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Filter: query , sql Hi Brian, | I'm running apache-1.3.23-14 on a redhat 7.3 system. | I have installed the php-rpm and the php_mysql.rpm from Redhat. | installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4. | | Cannot connect to my mysql-3.23.49

RE: Character Set Settings

Check out this article in MSDN: http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml /reference/charsets/charset4.asp It describes how to set the character set for Internet Explorer. I'm not sure of an equivalent for Netscape, but I assume there is one... Dean Harding. > -

Re: Character Set Settings

What you mean by explorer pages? Browser? If so you have to set the correct character set at the beginning of each place, whether asp, jsp, php or html. regards - Original Message - From: <[EMAIL PROTECTED]> To: "Nikolaos Georgiafentis" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: We

RE: Character Set Settings

No In the explorere I can see Greek when I do the same with asp and access db. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece

RE: Character Set Settings

Fear George, try putting '' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: >Dear Nikos > >I run the below --defult-character-set=ISO-8859-7 and when I insert into the >database like > insert into test values('ÄÕÏ'); >when I select: >

Re: installing mysql together with application

It is obvious, even in windows you have to set the configuration files atleast. It is the privilege of the user to install the stuff anywhere in his computer and so he has to change the .inf or .cnf accordingly Why not you try onething called the embedded mysql. If you just want to go with your

RE: Character Set Settings

Dear Nikos I did that I nothing. I am sending you also the php script I run: /* Free resultset */ George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97

Not able to insert data

I have installed MySQL 3.23.47 in a Windows 98 machine and created a a table "count". I have installed Apache Server on 98 machine and try to execute the following PHP script to insert the data. I was not able to post the data and got an error Method Not Allowed The requested method POST is

choosing datadir from create-statement

Hello , i have version 3.23.52 Why CREATE TABLE user4( id INTEGER , passwort VARCHAR(10) ) DATA directory="/usr/local/mysql/data/test"; doesent works (Syntax Error : because of DATA ..) - Before posting, please check:

Re: Re: Create Tables Dynamically

Hello William, Tuesday, September 24, 2002, 9:56:49 AM, you wrote: William, don't send me your questions in private mail. We provide support in public list. For commercial support, go to https://order.mysql.com/. WM> Thank you for your responses. How do I delete a table if I do not need to WM

Re: RE: Character Set Settings

Dear Gorge, the page you have sent me is included in an other page? If is not then try to put also all the required html tags (i.e , etc.) If it is then try to put the correct page encoding in the main page that includes the page you have sent me. At 11:48 AM 9/25/2002 +0300, you wrote: >Dear Ni

RE: RE: Character Set Settings

Dear Nikos The charset is ISO_8859-7 not greek8 In you system the greeks work fine? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece

re: choosing datadir from create-statement

Hussein, Wednesday, September 25, 2002, 11:42:00 AM, you wrote: HM> i have version 3.23.52 HM> Why HM> CREATE TABLE user4( HM> id INTEGER , HM> passwort VARCHAR(10) HM> ) DATA directory="/usr/local/mysql/data/test"; HM> doesent works (Syntax Error : because of DATA ..) It works only in 4.0

Re: RE: RE: Character Set Settings

Sorry the correct charset is ISO_8859-7. Is the problem resolved? At 12:45 PM 9/25/2002 +0300, you wrote: >Dear Nikos > >The charset is ISO_8859-7 not greek8 > >In you system the greeks work fine? > >George Nikoloudis > >INTRACOM S.A. >Telecom Business Support Systems > >19.5 km, Markopoulou Ave.

Re: Not able to insert data

VINOD wrote: > I have installed MySQL 3.23.47 in a Windows 98 machine and created a a table >"count". I have installed Apache Server on 98 machine and try to execute the >following PHP script to insert the data. I was not able to post the data and got an >error > > > Method Not Allowed > >

re: save meeeeeeeeee

antispam, Tuesday, September 24, 2002, 8:30:35 PM, you wrote: aafdn> I dont know what exactly happened but suddenly one tables just went back 10 days.. it only has 10 days back information.. please help me.. what happened with mysql ?? how can i retrieve those aafdn> information... I also don

re: UPDATE help

Steven, Tuesday, September 24, 2002, 7:03:15 PM, you wrote: SK> I am currently working on a table that has a column called state and a SK> column called stateid. All 42,000 records in this table have a 2 Letter SK> abbreviation for that state (NY, CA, NV, etc) however. To eliminate SK> redunda

RE: RE: RE: Character Set Settings

Nothing I did it. I will try to install againthe PHP. I will come back. Thanks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece

REPAIR TABLE

Please help me "alter table": ___ | | CREATE TABLE `f_ivairus_bodies` ( `id` int(11) NOT NULL default '0', `body` text NOT NULL, `thread` int(11) NOT NULL default '0', PRIMARY

ALTER TABLE

Please help me "alter table": ___ | | CREATE TABLE `f_ivairus_bodies` ( `id` int(11) NOT NULL default '0', `body` text NOT NULL, `thread` int(11) NOT NULL default '0', PRIMARY

'load data local infile' works on command line, but fails in php scripts

I'm having problems with php scripts that use 'LOAD DATA LOCAL INFILE'. Each time I run a script, I get an error in the server log saying MySQL query failed: "LOAD DATA LOCAL INFILE " : The used command is not allowed with this MySQL version. We're using php version 4.1.2 and MySQL 3.23.49,

ALTER TABLE

Please help me "alter table": ___ | | CREATE TABLE `f_ivairus_bodies` ( `id` int(11) NOT NULL default '0', `body` text NOT NULL, `thread` int(11) NOT NULL default '0', PRIMARY

make install problems

Hi mysql people, I am trying to install mysql on SuSE-8 from source. everything goes fine untill make install. It then exists with the following errors: make[2]: *** [install-benchSCRIPTS] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.52/sql-bench' make[1]: *** [install-am] Error 2

RE: RE: RE: Character Set Settings

Hi, Have you tried just putting greek characters directly in the page? That way you can at least find out if the browser is at fault. Then try something like: to rule out whether it's PHP. It's probably not MySQL if you can see them when just using the command-line client... Dean Harding

Re: access denied ????

thnx guyz i ve win2k pro, apache 1.3.24 n php 4.2.2 i dont know how you managed to configure your system on the root only since i need multiple users each with its own set of database and tables .. heres a piece from my config.inc file . $i++; $cfgServers[$i]['host'] = '

Re: access denied ????

thnx iikkaa im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 all workin fine . my mysql4.0.1 alfa is givin me these night-mares cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess not the source but a binary . plz do lemme know what can i do ??

how to show chinese in mycc

hi,I'm new programmer using mysql , I have download mycc for mysql client, I really like it very much. But I need insert some records which have some chinese ,but in mycc I can't see any chinese (the chinese show as ??? )in the record I inserted before. I don't know how to set up mycc to make i

index with enum as first column

>How-To-Repeat: drop table if exists t1; create table t1 ( e enum('N', 'Y') not null, i int not null, c1 char(255), c2 char(255), c3 char(255), c4 char(255), c5 char(255), c6 char(255), c7 char(255), c8 char(255), primary key (e, i) ); insert into t1 (e, i) values ('N', 1), ('Y', 2),

Re: How much stable is MySQL in a production environment?

How stable is MySQL? Here's a quick case study ... Our clients are organizations involved in Electronic Journalism ... Radio and TV news. We produce a suite of applications that permit them to do word processing, document organization, data management (from news wire services), archives, planning

Mysql Error

I have got apache and mysql running on my linux server. When connecting to my web site I get the following error: Fatal error: Call to undefined function: mysql_close() in /usr/local/www/vantweststamps/databaselogin.php on line 15 Does this mena the apache server has not been linked to the mysql

The record_buffer ,join_buffer, sort_buffer

The variables record_buffer,join_buffer and sort_buffer are alocated every "user connect" ? ex: join_buffer=6M record_buffer=7M sort_buffer=9M max_connection=200 in final case the mysql stored in memory is: (6+7+9)*200 = 1813MB ??? or the variables in this case is to "global opera

Re: Formatting data in a query

> Hello all, is it possible to select only a certain > number of characters from a field when running a query > in MySQL? For example I would like to select the > password and then the first 6 characters of the > username in the username field (which is of type > varchar). Thanks in advance!

how to create host table?

Hi there I am using MacOSX SERVER. When I want to start MySQL it says: [HostPowerBook:/] ilyas% mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) According to Mysql documentation this means that mysqld doesn't started. Just when I want to start mysql

Re: access denied ????

On Wed, 25 Sep 2002, toby - wrote: > thnx iikkaa > > im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 > all workin fine . > > my mysql4.0.1 alfa is givin me these night-mares > > cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess > not the source but

Re: Mysql Error

it sounds more like the php-built has not been linked against the mysql-libraries. but before a close there should have been a "mysql_connect" which should bring up the same error. Thomas On Wed, 25 Sep 2002 21:39:51 +1000 "Peter Goggin" <[EMAIL PROTECTED]> wrote: > I have got apache and mysql

Re: access denied ????

thnx Iikka pardon my ignorance but i ve no clue as how to give RWXD except through phpmyadmin and this is the situation there on the home of phpmyadmin ... Edit Delete Grants % root No Select Insert Update Delete Create Drop Reload Shutdown Process File Grant References Index

Re: access denied ????

No. Not in MySQL or phpMyAdmin but on the operating system / file system level instead. Open up the data directory in "My Computer" on your server, then right-click that directory, select "Security" tab, there add Everyone or the use that MySQL service runs as to the list and select "Full Access".

Re: 3.23.52 hangs sometimes

Hi Andrew, Did you try switching into InnoDB tables, or which table type are you using? Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Tue, 24 Sep 2002, Andrew Maltsev wrote: > Date: Tue, 24 Sep 2002 20:21:36 -0700 > From: Andrew Maltsev <[EMAI

Re: Mysql Error

Hello, Your Apache is OK, but you've got a PHP version that's not configured with the --with-mysql option. You need to recompile PHP if you've installed from the source. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: > I have got apache and mysql running on my linux server. When conne

Re: Mysql, PHP and a wrapper

On 9/24/02 3:04 PM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: > can someone tell me how to preinclude /DB/* functions in my Zend engine so I > do not have to "include_once" in every script. You could set auto_prepend_file in php.ini, httpd.conf, or in a .htaccess file:

Re: MySQL as a desktop DB

I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you can try SQLyog at http://www.w

re: ALTER TABLE

tl, Wednesday, September 25, 2002, 1:29:07 PM, you wrote: t> Please help me "alter table": t> ___ t> | | t> CREATE TABLE `f_ivairus_bodies` ( t> `id` int(11) NOT NULL default '0', t

re: problems with mySQL and server

Nir, Tuesday, September 24, 2002, 6:21:39 PM, you wrote: NG> I am trying to get mySQL set up and am having problems. I am using Win2000. NG> I am using the Apache server and believe I have that set up properly as the NG> server is in the running state. When I type "mysql" in the DOS prompt, the N

re: index with enum as first column

Julian, Wednesday, September 25, 2002, 2:20:05 PM, you wrote: JL> drop table if exists t1; JL> create table t1 ( JL> e enum('N', 'Y') not null, JL> i int not null, JL> c1 char(255), c2 char(255), c3 char(255), c4 char(255), JL> c5 char(255), c6 char(255), c7 char(255), c8 char(255), JL>

re: Select with order by clause on a MySQL BDB table returning incorrect

Sridhar, Wednesday, September 25, 2002, 12:23:29 AM, you wrote: SP> One of our MySQL db's containing BDB tables is exhibiting a strange SP> behavior. SP> A query consisting of an ORDER BY clause is returning wrong result set. SP> The SP> same query when used without an ORDER BY clause returns the

Re: Mysql Error

The php is as installed from the redhat distribution for 7.3 from the Next handbooks. Do I need to down load a later version of PHP or cn I modify what is already installed? Regards Peter Goggin - Original Message - From: "Iikka Meriläinen" <[EMAIL PROTECTED]> To: "Peter Goggin" <[EM

Re: Mysql Error

Hi, Getting a bit off-topic... I'm not sure whether you can add functionality to an already compiled PHP installation. Maybe your best bet is to recompile your PHP, that way you can get the latest version, and with only the functionality you want. Just remember to enable --with-mysql during the c

Sorting the query results of a MySQL BerkeleyDb Table produces incorrect results

Dear List, Sorry for reposting the issue, once again One of our MySQL db's containing BDB tables is exhibiting a strange behavior. A query consisting of an ORDER BY clause is returning wrong result set. The same query when used without an ORDER BY clause returns the correct result set. Environm

Re: installing mysql together with application

- Original Message - From: "Martijn van Iersel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 2:45 AM Subject: installing mysql together with application > Hello > > I want to distribute my java database application > together with mysql, and I want to

RE: MySQL as a desktop DB

Oh fiddle sticks! I just noticed mySQL-Front has been discontinued. I love that program :( Oh well, I'll check out this SQLyog. Thanks for the tip. Mike -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject:

re: how to create host table?

Ilyas, Wednesday, September 25, 2002, 3:09:34 PM, you wrote: IK> I am using MacOSX SERVER. When I want to start MySQL it says: IK> [HostPowerBook:/] ilyas% mysql IK> ERROR 2002: Can't connect to local MySQL server through socket IK> '/tmp/mysql.sock' (61) IK> According to Mysql documentation t

re: Restart of mysqld processing a specific query

jn, Tuesday, September 24, 2002, 5:55:00 PM, you wrote: ja1dc> Running a specific query makes the mysqld goeing away... >How-To-Repeat: ja1dc> Under the following URL you find a partial mysqldump to repeat the error: ja1dc> http://1net.ch/mysqlerr/err.sql It's know bug

Re: Performance whil Building Indices -- how does it scale?

Yes, I increased this to 512M, as suggested in another answer, and the perfomance improved dramatically. Thanks for the tip. Jeremy Zawodny wrote: >On Mon, Sep 23, 2002 at 07:25:17AM -0500, Chris Stoughton wrote: > > >>Joseph, >> >>Thanks for the quick answer. >> >>Very nice to know that add

Re: Temporary tables

On 25 Sep 2002, at 0:57, John Coder wrote: > So it's probably the fact that I didn't make the connection > persistent that screwed me up sometimes I feel so stupid. I don't think that will help. Read Paul's message again. Even if you make the connection persistent, you can't be sure you'll ge

No my.cnf file on Linux?

I use mysql 3.23.4 max on linux and it have worked just fine. Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. Trouble is there is no my.cnf file on my computer. Do I have to create the file myself ? or is the InnoDB settings configured right by d

MyISAM or InnoDB

We are moving a databse over from Oracle to MySQL 4.0.3 and I was wondering if I should use MyISAM or InnoDb. The databse currently has 800-900 updates and inserts done to it in a day along with about 1000 selects. Would I run in to any table locking problems with MyISAM? Thanks in advance. --

Set Path Environment

Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\> prompt, I get the following error: C:\>mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open.

Updating blob from command line

Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to b

Re: Mysql Error

if I remember right, there is a php-mysql*rpm package for redhat which corrects this problem. Thomas On Wed, 25 Sep 2002 23:23:07 +1000 "Peter Goggin" <[EMAIL PROTECTED]> wrote: > The php is as installed from the redhat distribution for 7.3 from the Next > handbooks. Do I need to down load a

Re: Spam

It seems they are using SPEWS (www.spews.org). A rude way to find out that our ISP has a problem with the IP address they gave us :-{ -- From: MySQL <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Spam Reply-To: [EMAIL PROTECTED] Message-Id: <[EMAIL PROTECTED]> Date: Tue, 24 Sep

Re: 3.23.52 hangs sometimes

On Tue, Sep 24, 2002 at 08:21:36PM -0700, Andrew Maltsev wrote: : Any suggestions how to approach the problem? How and what to test? It : happens randomly, can work for a day or two with no problems and then : hang three times in one hour. And obviously I can't reproduce it in my : test environmen

Fw: Set Path Environment

This is more information regarding the Path for my machine. It shows the default PATH information and the PATH information after I perform the SET PATH command. It also shows how MySQL responds after I type MySQL at the command prompt. Thanks in Advance, William C:\>path PATH=C:\WINNT\system

Re: Select with order by clause on a MySQL BDB table returning incorrect

[EMAIL PROTECTED] wrote: > > Sridhar, > Wednesday, September 25, 2002, 12:23:29 AM, you wrote: > > SP> One of our MySQL db's containing BDB tables is exhibiting a strange > SP> behavior. > SP> A query consisting of an ORDER BY clause is returning wrong result set. > SP> The > SP> same query when

InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Heikki and others, One of my slaves is dying frequently. It runs MySQL 4.0.4 (pulled yesterday) on FreeBSD. I'm getting an assertion failure on line 2180, which appears to be: case HA_READ_PREFIX_LAST: ut_a(0); return(PAGE_CUR_LE); What can I do to help debug this? Thanks, Jeremy -- J

Max NB of MyISAM tables / DB ( Ext3 & linux )

Hi list, I've just a little question for the end. I planned to have around 10K tables under a DB and this number surelly grow up to 20K. I know that a database is a directory and a table is 3 files. I just want to know is mysql have a limit in the number of table per database. If not, i know tha

Re: MySQL as a desktop DB

MySQL is much faster that Access when dealing with large databases. However, 300,000 records is actually quite small, so you may not see any speed difference. I wouldn't be surprised if Access would even be faster at that level. Putting 10 times that amount of records or adding users would con

Re: No my.cnf file on Linux?

> I use mysql 3.23.4 max on linux and it have worked just fine. > > Now I want to use Transactions so I thougt that I should use the my.cnf > to configure for that. > > Trouble is there is no my.cnf file on my computer. > > Do I have to create the file myself ? > or is the InnoDB settings config

Re: No my.cnf file on Linux?

At 16:17 +0200 9/25/02, Lindberg, Petrus wrote: >I use mysql 3.23.4 max on linux and it have worked just fine. > >Now I want to use Transactions so I thougt that I should use the >my.cnf to configure for that. > >Trouble is there is no my.cnf file on my computer. > >Do I have to create the file

Re: No my.cnf file on Linux?

Hi, >I use mysql 3.23.4 max on linux and it have worked just fine. >Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. >Trouble is there is no my.cnf file on my computer. >Do I have to create the file myself ? >or is the InnoDB settings configured righ

Re: Temporary tables

At 10:12 -0400 9/25/02, Keith C. Ivey wrote: >On 25 Sep 2002, at 0:57, John Coder wrote: > >> So it's probably the fact that I didn't make the connection >> persistent that screwed me up sometimes I feel so stupid. > >I don't think that will help. Read Paul's message again. Even if >you make t

RE: No my.cnf file on Linux?

Hi - they're located in the mysql support-files dir. Choose from small, medium, large or huge depending on how you're going to use mysql. Copy & rename to /etc EG: cp /usr/local/mysql/support-files/my-large.cnf /etc/my.cnf Cheers, Andrew -Original Message- From: Lindberg, Petrus [mail

Re: Set Path Environment

Hello, On Windows 9x edit your c:\autoexec.bat On Windows NT/2000/XP/.NET, right-click My Computer, then Properties, then on XP click Advanced tab and then "Environment Variables". On NT/2000 this procedure is about the same, only the Environment stuff is on a different tab. Then re-run autoexe

Re: MyISAM or InnoDB

> We are moving a databse over from Oracle to MySQL 4.0.3 and I was > wondering if I should use MyISAM or InnoDb. The databse currently has > 800-900 updates and inserts done to it in a day along with about 1000 > selects. Would I run in to any table locking problems with MyISAM? If you want t

Re: MySQL as a desktop DB

David Lloyd wrote: >MySQL in a single user environment is a pain in the arse because of its >lack of an Access Like front end that is actually useful and featureful >(Access is crap, but it's a better database frontend than currently >exists). > > I've never done it, but have you tried Access l

Re: 3.23.52 hangs sometimes

On Wed, Sep 25, 2002 at 10:02:52AM -0500, Philip Molter wrote: > On Tue, Sep 24, 2002 at 08:21:36PM -0700, Andrew Maltsev wrote: > : Any suggestions how to approach the problem? How and what to test? It > : happens randomly, can work for a day or two with no problems and then > : hang three times

Multiple Referral Levels

I have a question regarding tracking multiple referral levels in a database. The number of referral levels tracked needs to be at least 4, but should be able to be expanded later (without modifying the database). The first design I considered was: table: id int(8) unsigned not null auto_incremen

Re: Set Path Environment

Try to modify the autoexec.bat if you are using Win9x or the Path User env in Winnt. Another choice in some systems is to modify DOSTART.bat or something like that in "\windows". A way to keep the previous setting of the PATH env is to issue a stat like SET PATH=%PATH%;c:\mysql; ... I hope this h

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Hi Jeremy, Same problem for me, I submitted a bug report with a repeatable testcase yesterday to the bugs list. Reading the source code and changeset 1.1287, it appears this part of the source code should be desactivated ? (ChangeSet 1.1287 02/09/15 02:23:53 [EMAIL PROTECTED] +2 -0 ha_innodb

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Jeremy, Jocelyn, can you try the following this patch? The flag which bans MySQL using a descending cursor to calculate column LIKE 'jhghj%' ORDER BY column DESC queries was apparently put to the wrong place in ha_innodb.h. The assertion I had added to 4.0.4 revealed this hidden bug. The patc

RE: MySQL as a desktop DB

I use MySQL as a desktop db. It is alot faster than access, and much more efficient. A great front end I use is phpMyAdmin. www.phpMyAdmin.org -Steve. -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject: R

Re: Max NB of MyISAM tables / DB ( Ext3 & linux )

In the last episode (Sep 25), David Bordas said: > I've just a little question for the end. I planned to have around 10K > tables under a DB and this number surelly grow up to 20K. I know that > a database is a directory and a table is 3 files. I just want to know > is mysql have a limit in the nu

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

On Wed, Sep 25, 2002 at 08:09:08PM +0300, Heikki Tuuri wrote: > Jeremy, Jocelyn, > > can you try the following this patch? I'm building a new binary row. > The flag which bans MySQL using a descending cursor to calculate > > column LIKE 'jhghj%' ORDER BY column DESC > > queries was apparently

Meidumtext vs. varchar

Hi All, I've built a survey application in MySQL that allows people to enter free-form comments. In processing the input, if the comments string is less than 256 characters long, I save it to a varchar column; if longer, I use a mediumtext. This works fine, but I'm wondering if I'm getting any r

Re: Max NB of MyISAM tables / DB ( Ext3 & linux )

Hello, If the number of files is your concern, have you considered using InnoDB? It spans tables across any number of data files you want. The performance is great, too. Best regards, Iikka On Wed, 25 Sep 2002, David Bordas wrote: > Hi list, > > I've just a little question for the end. > I pla

phpMyAdmin/MySQL Question

Maybe someone else can come up with an answer for me on this question. I am getting the following error when I try to run my index.php file. I think I have configured it correctly, but obviously I haven't. And my host basically told to go shove it. >>Welcome to phpMyAdmin 2.3.1-rc1 >>Error >>MySQ

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

Hi Heikki, The query doesn't crash anymore, but the ORDER BY doesn't work at all (I tested it on a table with data). How-to-repeat : INSERT INTO threadhardwarefr13 (pseudo,date,numreponse) VALUES ('kytine','2002-09-18 20:37:31','1360'),('joce','2002-09-18 20:42:20','1361'),('kytine','2002-09-18

I want to unsubscribe but the freaking commands don't work

Help! The following works are required so that this mail goes through sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

load data

> > I load a table whit the query: > > > > LOAD DATA INFILE 'a.txt' INTO TABLE table FIELDS TERMINATED BY '\t' LINES > > TERMINATED BY '\n'; > > > > the file: > > > > 211ppp222 > > 222ooo333uuuo > > > > and more > > > > the problem is, the last field in the table

Re: Set Path Environment

Under NT and XP you set the environment variables by clicking on the My Computer icon and selecting Properties, then clicking the Environment variables on the Advanced tab. Make sure you set the PATH under the System Variables instead of User Variables if you want MySQL to be available to all

Re: access denied ????

At 15:08 25/9/2002 +0300, Iikka Meriläinen wrote: Hi, Only for to clarify: There is a rename table bug for some NT family (Win2k I tested) when is used at the command rename tables names with uppercase and the default lower_case_tables_names =1. This is already fixed in the next releases. >On We

I want to unsubscribe but the freaking commands don't work

Help! The following works are required so that this mail goes through sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reque

RE: Win32::ODBC Question (Oracle)

This email leads to a question I have about SQL. I have been accustomed to Mysql with all of its nifty little extensions - like describe. Now I have a project with MSSQL (not because I wanted it - politics). Does any one now how to describe a table structure with standard SQL. Even more importan

RE: Win32::ODBC Question (Oracle)

Hi, Use the following: SELECT * FROM sysobjects WHERE type='U' This will show you all of the user tables And then select * from syscolumns where ID = (select ID from sysobjects where name = 'your_tablename' and type = 'U' This should get you started! HTH Ian. -Original Message-

RE: Win32::ODBC Question (Oracle)

Ian's help worked great. I have one question. How do I specify the DB? I mean in the query analyzer I can select a db from the pulldown box - is there a way to specify the db in the statements below? Thanks. -Original Message- From: Ian Robertson [mailto:[EMAIL PROTECTED]] Sent: Wedne

RE: Win32::ODBC Question (Oracle)

Figured it out. just use the "use name_of_db" and you can switch to another DB. thanks. -Original Message- From: Norris, Joseph Sent: Wednesday, September 25, 2002 9:02 AM To: 'Ian Robertson'; Norris, Joseph; 'Peter van der Goes'; 'Thomas R Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List (

  1   2   >