Re: Session ID Generation

2013-06-21 Thread Denis Jedig
rs should know their trade and not simply try pressing requirements they've read about in an IT manager magazine. Denis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Session ID Generation

2013-06-21 Thread Denis Jedig
al measure against a number of attack - including eavesdropping and data manipulation. http://www.yassl.com/files/yassl_securing_mysql.pdf Denis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: How can I drop a table that is named “logs/#sql-ib203” and appeared after MySQL crash?

2013-06-20 Thread Denis Jedig
> dump.sql && mysql < dump.sql` for a backup/restore operation at least will help the problem of being unable to run ALTER TABLE commands for the affected main table. Regards, Denis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: SLAVE aware of binary log file switch?

2013-06-17 Thread Denis Jedig
The master does not "inform" the slave via an immediate communication channel, but the slave knows how to keep up because the end of the binary log file contains continuation information - i.e. the name of the next log file to fetch. Denis -- MySQL General Mailing List For

Re: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Denis Jedig
ssions. You might try using low_priority_updates to mitigate this. Regards, -- Denis Jedig syneticon networks gmbh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Performance of delete using in

2013-04-24 Thread Denis Jedig
ent_id for deletion. Kind regards, Denis Jedig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Design help

2013-04-21 Thread Denis Jedig
]. [1] http://en.wikipedia.org/wiki/Denormalization -- Denis Jedig -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Troubleshoot excessive memory usage in InnoDB

2013-04-20 Thread Denis Jedig
ken DBMS". What I still cannot figure out is if the behavior is due to a misconfiguration or a regression / bug to file. And MySQL counters are not exactly helping - it is completely opaque to me where the memory is going. -- Denis Jedig -- MySQL General Mailing List For list archives: http

Troubleshoot excessive memory usage in InnoDB

2013-04-19 Thread Denis Jedig
in memory utilization even after several hours of operation under similar load. I have posted a question to <http://dba.stackexchange.com/questions/40413> which I will update with further information as I get it. Any hints on how to hunt the resource hog greatly appreciated, -- Denis Jedig

Query locked at "Writing to net" state

2010-09-29 Thread Lefebvre Denis
quot;. The same query in MySQL Workbench operates seamlessly in Israel and in France. Do you have an idea or a line of inquiry? Server config: Core2Duo, 4GB, 100Mbps, CentOS5.2. Mysql5 Thank you for your help, Regards, Denis -- Denis Lefebvre

Help me to understand multiple locking the same tables (lock; lock; unlock)

2007-01-10 Thread Denis Solovyov
er threads to update tables between two lockings or not... MySQL 4.1, myisam tables (if it is important). Best regards, Denis Solovyov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

TINYTEXT != VARCHAR(255) ? (Advanced Data Generator related)

2006-06-27 Thread Denis Gerasimov
y? AFAIK some of the developers of this tool are here on the list so any advice from them will be highly appreciated! Have a great day, Denis S Gerasimov Web Developer Team Force LLC Web:<http://www.team-force.org/> www.team-force.org RU & Int'l: +7 8362-213555 email:[EMAIL PROTECTED]

Re[2]: key_buffer_size and memory used by mysqld

2006-03-11 Thread Denis Solovyov
there comes a query which uses one of these indexes, will other 2 indexes be read and cached right now for possible use in future? May key be buffered if it exists in table but is never used by queries (bad but possible example)? KJ> Kishore Jalleda Denis Solovyov -- MySQL Gene

key_buffer_size and memory used by mysqld

2006-03-09 Thread Denis Solovyov
ything else? Do I have to set "key_buffer_size" to a pretty small value if I expect many simultaneous connections? Denis Solovyov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

What binary to choose with glibc 2.3.2 on 2.4 linux kernel?

2006-02-23 Thread Denis Solovyov
nux-i686-glibc23.tar.gz) will both work, so my main question is: Is "Linux (x86)" binary statically linked with glibc 2.3? Or maybe I should choose the one compiled with Intel C/C++ compiler? Is it static? When one should choose it instead of gcc-compiled? Thank you. Denis Solovy

How stable will mysqld [compiled from source] be on linux 2.4 with glibc 2.3.2 (gcc 3.3.4)?

2006-02-23 Thread Denis Solovyov
2.3 as well? Thank you. Denis Solovyov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

[OT] List of countries, regions and cities

2006-01-11 Thread Denis Gerasimov
Hello list, I am in a need of a database that contains the list of all countries, regions and cities in the world, in RUSSIAN language. Does anybody know where can I find it? I searched Google but all of the databases are in English. Have a great day, Denis S Gerasimov Web

RE: The best way to transfer data to another server

2005-03-30 Thread Denis Gerasimov
> > > > Are there any standard MySQL tools available for doing that (I mean > > > MySQL > > > > Administrator/Query Browser etc.) > > Have you looked at mysqldump and mysqlhotcopy? I know about standard mysqldump utility but I actually needed something with GUI interface. > > I assume that tha

RE: The best way to transfer data to another server

2005-03-30 Thread Denis Gerasimov
> > > > Hello list, > > > > I have two MySQL 4.1 servers, one local and one remote. I need to > transfer > > database from one server to another. What actually is the best way of > > handling this task? > > > > Are there any standard MySQL tools available for doing that (I mean > MySQL > > Adminis

The best way to transfer data to another server

2005-03-29 Thread Denis Gerasimov
regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to specify autoincrement primary key value

2005-02-18 Thread Denis Gerasimov
nt to have _one and only_ root category)? > -Original Message- > From: Martijn Tonies [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 10, 2005 2:31 PM > To: Denis Gerasimov; [EMAIL PROTECTED]; 'MySQL General List' > Subject: Re: How to specify autoincrement pr

RE: How to specify autoincrement primary key value

2005-02-10 Thread Denis Gerasimov
> > > > > Hello, > > > > One simple question... AFAIK I can specify value for an autoincrement > > primary key (int) when inserting a record like this: > > > > INSERT INTO `tablename` (`id`, `name`) VALUES (1, 'test') > > > > But it doesn't work for id = 0. Why? > > > > I would like to use some p

How to specify autoincrement primary key value

2005-02-10 Thread Denis Gerasimov
al purpose, e.g. id 0 means root/default record and so on. Is that recommended? Are there any alternative ways? Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

RE: [PHP-DB] mysqli connection problem

2005-02-08 Thread Denis Gerasimov
> > Hello, > > > > This question was asked many times, but I can't find a good answer. > > I am getting this error message while trying to connect to MySQL server > (PHP > > + PEAR::DB_DataObject): > > > > "Can't connect to local MySQL server through socket '' (111)" > > > > (notice '' - is that

mysqli connection problem

2005-02-07 Thread Denis Gerasimov
Hello, This question was asked many times, but I can't find a good answer. I am getting this error message while trying to connect to MySQL server (PHP + PEAR::DB_DataObject): "Can't connect to local MySQL server through socket '' (111)" (notice '' - is that right?) Does anyone have any ideas

Re: 2 gigs limits on MyISAM indexes?

2005-01-28 Thread Frank Denis \(Jedi/Sector One\)
On Fri, Jan 28, 2005 at 04:00:24PM +, Mat wrote: > What Operating System are you running this on? Linux 2.6, 64 bits. MySQL 4.1.9. > Also, is there anything in the errorlog? Nothing, but as soon as I restart the server, it enters a strange state where all slots are full with unauthenti

2 gigs limits on MyISAM indexes?

2005-01-28 Thread Frank Denis \(Jedi/Sector One\)
Is there a limit on the size of .MYI files? I have a database that worked flawlessly until today. I can't restart it, it immediately freezes. I noticed that the .MYI file of a table has reached exactly 2 gigs. May it be related? Is there anything to do in order to recover the data an

AMD64 and thread stack size

2005-01-28 Thread Frank Denis \(Jedi/Sector One\)
It looks like the default thread stack is not large enough for MySQL 4.1 on Linux running on AMD64. With NPTL, the database quickly crashed after a few hours of heavy load (segv). Without NTPL, I believed it wasn't the case. But after one week mysqld process were stuck in a strange state.

Rows_sent vs Rows_examined

2005-01-12 Thread Frank Denis \(Jedi/Sector One\)
Just wondering... I have this simple join: SELECT b.id_commentaire AS id_commentaire, id_skynaute, id_article, created_on, read, expediteur, email, text FROM comment_base AS b LEFT JOIN comment_content AS c USING (id_commentaire) WHERE id_skynaute = 4671022 AND id_article = 58366086; id_com

RE: TINYTEXT field uniqueness question

2004-12-23 Thread Denis Gerasimov
s error in case of duplicate 'abcd' (>= 3 chars). Why? Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru > -Original Message- > From: Chris [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 23, 2004 9:56 PM > To: MySQL Ge

TINYTEXT field uniqueness question

2004-12-21 Thread Denis Gerasimov
Hello, Is that possible to ensure uniqueness for a TINYTEXT field? I tried to create an index (with UNIQUE constraint) but my GUI tool always says me 'Duplicate entry 'X' for key N' Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd. www.vekos.ru -- M

RE: Default connection codepage

2004-12-21 Thread Denis Gerasimov
.0.2 PEAR's DB + DB_DataObject (both latest) Does anybody have the same problem? > > "Denis Gerasimov" <[EMAIL PROTECTED]> wrote: > > > > Hello, > > > > Is there any way to change default MySQL _connection_ codepage? > > (e.g. by ini/cnf

Default connection codepage

2004-12-21 Thread Denis Gerasimov
Hello, Is there any way to change default MySQL _connection_ codepage? (e.g. by ini/cnf files setting, by startup parameters or some other way) Please, do not suggest running SET CHARACTER SET blah123 Thanks. Best regards, Denis Gerasimov Outsourcing Services Manager, VEKOS, Ltd

InnoDB status: why do I see MyISAM requests?

2004-12-12 Thread Frank Denis \(Jedi/Sector One\)
Just curious... While running SHOW INNODB STATUS, the "list of transactions for each sessions" part shows queries that are only related to MyISAM tables. Is it the expected behavior? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://

Re: problems with php 4.3.9 / mysql 4.1.7

2004-12-08 Thread Frank Denis \(Jedi/Sector One\)
On Wed, Dec 08, 2004 at 11:25:55AM +0100, Bogdan TARU wrote: > Everything went > ok, up until the point when I tried linking PHP-4.3.9 against > MySQL-4.1.7. After starting the new Apache/PHP (ldd httpd shows > '/usr/local/mysql-4.1.7/lib/mysql/libmysqlclient.so.14'), I get a > whole lot of Se

Re: Query on multiple table with SUM and GROUP

2004-08-02 Thread Denis Geser
> On Monday 02 August 2004 02:39, Denis Geser wrote: > > I am using MySql to store telephone taxes statistics. > > I have 1 table by month with 60'000 rows each. > > > > My problem is that I need some stats for 3 month. > > For example I need to know th

Query on multiple table with SUM and GROUP

2004-08-02 Thread Denis Geser
", 10, 0.10); insert june values ("501", 10, 0.10); Regards Denis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
On Wed, 2003-11-19 at 15:08, Dan Greene wrote: > one more idea: > > try: > mysql --skip-column-names --raw < test1 | tar xf - no output, mysql --skip-column-names --raw < test1 | more ./test1 > > > > -Original Message- > > From: Denis Mercie

RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
rs > > to see if it works > > > > -Original Message- > > From: Denis Mercier [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 19, 2003 2:41 PM > > To: [EMAIL PROTECTED] > > Subject: Re: piping blob into shell command (tar) > >

RE: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
ng FILE_LOAD(). before: use test; select * from test; after: mysql --skip-column-names < test1 | more use test;\nselect * from test;\n \n's are added? > > -Original Message- > > From: Denis Mercier [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, November 19,

Re: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
On Wed, 2003-11-19 at 14:02, Paul DuBois wrote: > At 13:55 -0500 11/19/03, Denis Mercier wrote: > >On Wed, 2003-11-19 at 12:26, Paul DuBois wrote: > >> At 11:03 -0500 11/19/03, Denis Mercier wrote: > >> > >> > > >> >i also tried: > >>

Re: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
On Wed, 2003-11-19 at 12:26, Paul DuBois wrote: > At 11:03 -0500 11/19/03, Denis Mercier wrote: > > > > >> >i also tried: > >> >> >use my_db; > >> >> >select * from my_table; > >> >> > > >> >>

Re: piping blob into shell command (tar)

2003-11-19 Thread Denis Mercier
17:05 -0500 11/18/03, Denis Mercier wrote: > >On Tue, 2003-11-18 at 16:40, Paul DuBois wrote: > >> At 16:21 -0500 11/18/03, Denis Mercier wrote: > >> >here's what im trying to do, i have a tar file in a blob field > >> >and i'm trying to retr

Re: piping blob into shell command (tar)

2003-11-18 Thread Denis Mercier
On Tue, 2003-11-18 at 16:40, Paul DuBois wrote: > At 16:21 -0500 11/18/03, Denis Mercier wrote: > >here's what im trying to do, i have a tar file in a blob field > >and i'm trying to retrieve it and pipe it directly into tar > >to decompress it, without fir

piping blob into shell command (tar)

2003-11-18 Thread Denis Mercier
able; so when i try shell> mysql --pager < test1 | tar x the tar file does not get written to /usr/local/test1 but i still dont get my untared files? write permissions are ok? what am i missing? any ideas would be appreciated thanks Denis -- MySQL General Mailing List For list archiv

Re: Table is full error

2003-09-05 Thread Denis Mercier
try this link http://jeremy.zawodny.com/blog/archives/000796.html setting avg_row_length at 50 worked for me I tested and got mytable up to 9GB, (large table with variable size records ) the only reason I could see that it would matter to have an accurate value for the avg_row_length would

RE: Table is full error

2003-09-04 Thread Denis Mercier
I also had table is full error, today actually. mysql> alter table mytable max_rows = 2000 avg_row_length=50; mysql> show table status like 'mytable' \G *** 1. row *** Name: mytable Type: MyISAM Row_format: Dynam

4.0.9-gamma problem with max_connections

2003-02-03 Thread Denis V. Lozko aka Talmuth
Hi all please help 19:36:59[p0]talmuth@smtp:~>cat /etc/my.cnf [client] host=localhost user=root [mysqld] max_connections = 5000 19:37:58[p0]talmuth@smtp:~>cat /usr/local/etc/rc.d/mysql.sh #!/bin/sh cd /usr/local/mysql ./bin/mysqld_safe --user=mysql --default-character-set=cp1251 --max_connect ions

Re: database mirroring in mysql

2003-02-03 Thread Denis V. Lozko aka Talmuth
Hi all please help 19:36:59[p0]talmuth@smtp:~>cat /etc/my.cnf [client] host=localhost user=root [mysqld] max_connections = 5000 19:37:58[p0]talmuth@smtp:~>cat /usr/local/etc/rc.d/mysql.sh #!/bin/sh cd /usr/local/mysql ./bin/mysqld_safe --user=mysql --default-character-set=cp1251 --max_connect ions

max-3.23.54a : ERROR 1135 on IRIX 6.5.16

2003-01-13 Thread Denis Pugnere
from whatever config file >Fix: not found >Submitter-Id: >Originator:Denis Pugnere >Organization: -- Denis Pugnère| IGH/CNRS UPR 1142, 141 Rue de la Cardonille Tel : +33 (0)4 9961.9909 | 34396 Montpellier Cedex 5, France Fax : +33 (0)4 9961.9901

Re: Query Problem

2002-05-31 Thread Denis Mcmahon
goryName FROM (People INNER JOIN links ON People.AddressID = links.persid) INNER JOIN Categories ON links.catid = Categories.CategoryID; Rgds Denis -- Denis McMahon / +44 7802 468949 / [EMAIL PROTECTED] sulfnbk is not a virus, see the symantec virus encyclopaedia! Now restocking killfile, new entrants

Building relationships between tables

2002-05-01 Thread Denis L. Menezes
Hello friends, In Access, we build relationships between tables and keys, How do we do this between keys in mysql? Thanks Denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Buliding relationships between tables - how?

2002-04-30 Thread Denis L. Menezes
Hello friends, Can someone tell me how I can build the relationships between tables in mysql? I have tried books and web manuals. Even a link will do. Thanks Denis - Before posting, please check: http://www.mysql.com

Re: general question

2002-04-20 Thread denis
Yes, and it is the same standard used to assign ports -- RFC 1700. Paras Mukadam wrote: > Why only port 3306 is used by MySQL? Is there some standard used like used > for FTP, localhost ports ? > Thanks !!! > -- Paras > > - > B

MYSQL on a Cobalt RaQ4

2002-03-27 Thread Denis Croombs
Hi Will MySQL run on a Cobalt RaQ4 server ? Denis Croombs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e

Re: Problems with grant/permissions

2001-12-18 Thread denis
Check the file ownership, and make sure that its the same as the mysql user. Barry Gold wrote: > I duplicated the mysql database from another machine by copying over the > table files. But now I find myself unable to access the tables. > > I restarted the mysql server using the --skip-grant-tab

Re: Load ODBC Data

2001-12-05 Thread Denis A. Rudakov
Hello ! With M$ Query it's achieved just by executing any modification query (insert,update,create etc). Check the permissions for user from who the ODBC connections is performing. Goodbye. Dannis. On Wed, Dec 05, 2001 at 04:46:22PM +0100, TOMASSONI Dominique wrote: > Hello the list, > > Is it

Re: command line question..

2001-12-05 Thread Denis A. Rudakov
Hello ! I often use that common scheme to parametrize my queries. #!/bin/bash #check parameters most commonly (only number of parameters) if [ $# !=NUMBER_OF_PARAMETERS_NEEDED ]; then echo "Too few parameters";exit 1; fi # these are queries in my "transactional" procedure # $1...$N ar

Re: timely backup

2001-11-29 Thread denis
$ man cron sreedhar wrote: > hi Thomas, > > Thanks for advice. My database is on LINUX. Can give bit details of cron. > Even link regarding that also sufficient. > > thanks in advance. > > regards, > sreedhar > - Original Message - > From: "Thomas Spahni" <[EMAIL PROTECTED]> > To: "sreed

Re: mysqld ends immediately

2001-11-26 Thread denis
check the ownership of the mysql directory and the files within. They should be the same owner/group as your mysql server. Yuriy Salimovskyy wrote: > Dear sirs, > > I'm running MySQL server on local machine (AMD Duron 650, 128 RAM, Linux > RedHat 7.1, MySQL 3.23.36) and have following problem: >

mysqldump question

2001-11-26 Thread Denis A. Rudakov
Hi. Suppose I have dumped all database tables using mysqldump with --tab=... option and I've got some *.sql and *.txt files one per table. Ok, through the some time I want to see how changed a table living in server compared with it's old copy I have dumped early. I've decided to use some of th

Re: Dumb Question: Listing tables in telnet

2001-11-18 Thread denis
-> is a continuatin line for your sql stamement. Remember yo conclude your statement with a semi=colon... Denis Todd Williamsen wrote: > I looked all through the documentation for this and I cannot find the > command for listing tables in mysql in telnet. > > I get this: >

mysql macro

2001-11-16 Thread Denis Rudakov
Hi. Is it planning add macro defintions to MySQL ? Thanx. -- Goodbye. Dannis. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reques

Re: Alphabetizing book titles

2001-11-13 Thread Denis Rudakov
Hi. Try this: SELECT title FROM titles ORDER BY IF(SUBSTRING(title,1,4)="The ",SUBSTRING(title,5), IF(SUBSTRING(title,1,2)="A ",SUBSTRING(title,3), IF(SUBSTRING(title,1,3)="An ",SUBSTRING(title,4), title))); But in version 3.23.36 the next: SELECT title FROM titles ORDER

Re: How to Run SQL Commands from a Text File stably?

2001-11-12 Thread Denis Hammond
ttp://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php One potential error is the lack of quoting in: retai

Re: Problem mysql installation

2001-11-04 Thread Denis Rudakov
On Mon, Oct 29, 2001 at 04:06:39PM -0300, Webmaster wrote: > Hi all; > > i have problem with mysql -3.23.42 installation on my freebsd 4.3-RELEASE, > when I execute a make > i get an error "make: no target to make". > > Thanks and have a great day! > I guess you haven't run the "configure" scri

4.1

2001-11-02 Thread Denis Rudakov
Hi. Question for MySQL developers: when the 4.1 may be released ? Thanx. dannis. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To reques

Pictures in mysql

2001-10-24 Thread denis . menezes
Hello friends. I am a newbie in mysql and web programming. Can someone please tell me where I can find some info on putting pictures into mysql fields and also how I can use a web interface to add the pictures to the database. Thanks Denis

Re: Convert table type

2001-10-03 Thread denis
ue in our particular case. We did it in one fell swoop, had no problems. I would make a backup copy, just in case though. Denis volunteermatch.org - Before posting, please check: http://www.mysql.com/manual.php (

what is the security issue with dynamic format?

2001-10-02 Thread denis mercier
hi I am presently going over the mysql documentation to get familiar with it, It runs great on my development server (linux RH7.1 kernel=2.4.2-2 resin application server), I am in the process of optimizing and testing , I am using blob datatype in my main table, I understand why a fixed-size form

Rubi-con Technology/Security Conference

2001-08-31 Thread Denis Baldwin
ee to e-mail me at [EMAIL PROTECTED] Denis Denis A. Baldwin (A+/MCP/I-Net+/Net+/CCA/CIW) Network Administrator, CAE, Inc. 810-231-9373, ext. 229 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.p

Logging in for the first time

2001-08-17 Thread Denis Baldwin
ogin might be by default? Denis Denis A. Baldwin (A+/MCP/I-Net+/Net+/CCA) Network Administrator, CAE, Inc. 810-231-9373, ext. 229 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manua

Re: Best Operating System

2001-07-28 Thread denis
I would think that most current 2.4 distros, stable of course, should work just fine. BTW- Congratulations (belated) , Jeremy on the Webby. Denis Hammond Systems Administrator VolunteerMatch Jeremy Zawodny wrote: > On Sun, Jul 29, 2001 at 06:05:37AM +0200, Alexander Skwar wrote: > >

Tricky query : help needed !

2001-07-16 Thread Denis BAURAIN
uld like to know if there's any way to force the COUNT(DISTINCT...) construct to ignore NULL values or if it's possible to achieve the same result in a completely reformulated query... Thanks a lot in advance to all SQL experts that could help me. Denis. --- Denis BAURAIN (aka Bob Mora

InnoDB behaviour with multiple clients

2001-07-10 Thread Denis Pithon
ffer size but I noticed onlky small improvements. I'm sure I forgot something, but I don't see what ! does somebody know ?? Denis -- Denis Pithon phone +33 (0) 1 41 40 02 13 Software Engineerfax+33 (0) 1 41 40 02 01 Line

Error: 'Invalid default value for enum_field'

2001-06-20 Thread Denis Simard
é', 'Producteur', 'Actionnaire') not null default 'Employé' produces an error, but if I strip the accents on 'Employe', the command works well. Anyone know if I can bypass this bug in any way? Thanks Denis Simard DBAdmin HEXACTO

Could not start mysql daemon

2001-03-29 Thread Denis Mettler
now i couldn't start the mysql daemon again! The exact error message is: Starting mysqld daemon with databases from /usr/local/mysql/var [2] Donebin/safe_mysqld washington:/usr/local/mysql # mysqld daemon ended ANY IDEAS??? Regards

Could not start mysql daemon

2001-03-29 Thread Denis Mettler
now i couldn't start the mysql daemon again! ANY IDEAS??? Regards Denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Bugs in 3.23.35

2001-03-22 Thread denis
Thanks Sinisa Milivojevic wrote: > denis writes: > > Any ETA on corrected RPM's? > > > > > > Should be out this weekend or in the beginning of next week. > > Regards, > > Sinisa > > __ _ _ ___ == MySQL AB

Bugs in 3.23.35

2001-03-21 Thread denis
Any ETA on corrected RPM's? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubsc

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)

2001-03-21 Thread denis mettler
try: mysql.default_socket= /tmp/mysql.sock the mysql.sock is there! I DON'T HAVE ANY IDEA WHY THIS PROBLEM OCCURS! If u need more Information please let me know.... Please help Regards Denis - Before

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
That was a mistake by myself. it was /tmp/ so, if i make ps i can see that there are 4 mysqld processes are running could this be the problem? And if i use: ps -aux|grep mysqld there is only a difference between the process id. nothing else? ideas??? Regards Denis On Tuesday 20

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
My question is that, why is he trying to connect through socket in /var/lib/mysql cause i have installes in /usr/local and the path to the mysql.sock is in php3.ini /temp/mysql.sock any ideas? regards denis On Tuesday 20 March 2001 14:52, you wrote: > it looks like that: > &g

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
Hi, I did. but the problem is the same. regards denis On Tuesday 20 March 2001 17:45, you wrote: > try: > [mysql] > mysql.default_socket = /temp/mysql.sock > > > Cal > http://www.calevans.com > > > -Original Message- > From: denis mettler [mailto:[

Re: Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
Hi, i deleted mysql in /var and make re-install in /usr/local/ but received the same error. so i make an entry in the php3.ini [mysql] mysql.default_socket = /temp where i found the mysql.sock the error message is still there? Other ideas? regards denis On Tuesday 20 March 2001 14:52

Re: Problem Setting up MyODBC Driver

2001-03-20 Thread denis mettler
u are connecting with from client) clienthostname (hostname of your client) after this is done make the following from your mysql directory: bin/mysqladmin -u root flush-privileges hope that helps regards denis On Tuesday 20 March 2001 15:31, you wrote: > HI > > I am trying to

Can't connect throug socket

2001-03-20 Thread denis mettler
Hi Thanks for the help, I checked again. but i don't have an entry in php.ini [mysql] mysql.default_socket    = So, i did execute the tip from egon. But now, i don't get the content from .php files but i think i'll get it to work today. thanks

Can't connect server through socket /var/lib/mysql/mysql.sock(111)

2001-03-20 Thread denis mettler
cket. any ideas? T.i.a. Regards denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL P

ODBC

2001-03-18 Thread denis mettler
fields! And, i don't know why this happens. Any ideas? with mysql under windows everything works. but with win2000 and linux, it doesn't. regards denis - Before posting, please check: http://www.mysql.com/manual.php (

ODBC // #gelöscht

2001-03-18 Thread denis mettler
Key und ein timestamp Feld. Aber ich weiss einfach nicht was falsch läuft. Kann mir jemand helfen? Danke im voraus. Gruss Denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

MYSQL Connection failed

2001-03-18 Thread denis mettler
Hallo, Kann mir irgend jemand helfen? Ich kann mit der folgenden Meldung nichts anfangen: Anbei die Datei zum verbinden zur Datenbank: _ Yes, we're open! Handle: $conn"; } else { echo "Oops, something goes wrong"; exit; } $select = mysql_select_db("cust

MYSQL Connection failed

2001-03-18 Thread denis mettler
Hallo, Kann mir irgend jemand helfen? Ich kann mit der folgenden Meldung nichts anfangen: Anbei die Datei zum verbinden zur Datenbank: _ Yes, we're open! Handle: $conn"; } else { echo "Oops, something goes wrong"; exit; } $select = mysql_select_db("cust

Persistent connection with php to mysql

2001-03-18 Thread Denis Mettler
Hi, some of you work with php and mysql to connect a website with a mysql database. do u prefer an simple connection or a persistent connection? and if u prefer the last one. how can u make this connection in the index.php3? do u make this with an "./include"? thanks reg

ODBC

2001-03-17 Thread Denis Mettler
The Problem was that i didn't have a primary key in addition to a timestamp field. that's all. regards denis .' '.' `.

2 Tables

2001-03-17 Thread Denis Mettler
(Business, privat...) but how can i link these tables for a query. i ask because i know that mysql doesn't support foreign keys. thanks in advance denis - Before posting, please check: http://www.mysql.com/manual.php (the m

MySQl // Access // ODBC

2001-03-16 Thread Denis Mettler
ed with #deleted. i don't have fields with float and i have the new mdac from microsoft. So, i don't know why this happens any ideas??? regards denis - Before posting, please check: http://www.mysql.co

Access & MySQL --> a new feature

2001-03-16 Thread denis mettler
ere ID<10; got the result. everythings fine. so, here comes the clou. if i make an odbc connection from access to mysql and link the table... the content of every field is '#deleted' any ideas why this happens? Regards Denis

Error: MYSQL Connection failed

2001-03-16 Thread denis mettler
8. This is the text from dbopen.php3: Yes, we're open! Handle: $conn"; } else { echo "Oops, something goes wrong"; exit; } $select = mysql_select_db("name_of_db",$conn); ?> Any Ideas? Thanks in advance Regards from cologne denis

Primary Key

2001-03-16 Thread denis mettler
Hi, Can i add the Primary key for a table after i created a table? and if this column is not null and auto_increment will there occur an error? t.i.a. regards denis - Before posting, please check: http://www.mysql.com

MySQL over ODBC

2001-03-15 Thread denis mettler
Hi there, i received the following message: [TCX][MyODBC] Host 'XYZ' is not allowed to connect to this MySQL Server (#1130) any ideas regards denis - Before posting, please check: http://www.mysql.com/manual.

  1   2   >