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

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: > >

Re: taxes

2001-02-15 Thread denis
Also some states, like California, base their sales taxes for mail-order on the recipients postal code, not the vendors, unless the codes are the same. There are eight or nine different sales tax rates in CA depending on local taxes. Mike Wexler wrote: > Mikel King wrote: > > > > guys I think yo

Re: Converting tables to MyISAM

2001-03-09 Thread denis
Try: alter table [tablename] type = myisam; There is a script that purports to do this for you, but the copy that I had wouldn't run properly, so I just made a file of the SQL needed, and ran it through mysql... Tac/Smokescreen Action Network wrote: > I've searched the MySQL manual and can't f

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

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

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 (

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: >

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: >

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: 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

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]

[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

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]

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

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]

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

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

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

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

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: 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: 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: 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: 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: 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: 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

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]

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: [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

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: 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

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

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: 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

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

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

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

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: 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

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: 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

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

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

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: 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

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-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
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
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
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
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

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

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: 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

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

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

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

AW: Exporting data from MySQL to Oracle

2001-02-13 Thread Denis Mettler
Hi there, please check the oracle migration bench at the oracle technet. http://technet.oracle.com kind regards denis mettler -Urspr?ngliche Nachricht- Von: Noor Dawod [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 13. Februar 2001 17:23 An: Cal Evans; MySQL List Betreff: RE

How to connect MySql with ChiliASP on a Linux Cobalt ?

2001-02-19 Thread Denis Fohl
Hi, i'm a newbe with MySql and the list. I've made an application on my local host using ASP/Access and now i must transpose it on a Cobalt system with Linux and ChiliAsp/Mysql. I'm looking for the connection strings and principles to use but i can't find them. Is there someone to help me ? Th

UPDATE query with ORDER BY and LIMIT

2001-02-21 Thread Denis Gasparin
at line 1. I use Mysql 3.23.30-gamma with MyIsam table format. I have read the manual and the syntax, according to that, seems to be correct... but... nothing is as it seems What is wrong? Thank you to all for the help! Denis [EMAIL PROTECTED] --

RE: UPDATE query with ORDER BY and LIMIT

2001-02-21 Thread Denis Gasparin
rows are updated. If the ORDER BY clause is specified, the rows will be updated in the order that is specified. End From MySQL manual ONLINE *** So i read the manual... but is the manual wrong? Denis At 10.52 21/02/01, Carsten H. Pedersen wrote: > > Hi

Hi,AW: LOOKING FOR A FRONTEND FOR MYSQL

2001-02-26 Thread Denis Mettler
Hi, Check out MysqlGUI at www.mysql.com I think it's the best. But there are a lot of other GUI's. -- Best Regards / Beste Gru?e Denis Mettler http://www.denis-mettler.de -- Unix is an operating system, OS/2 is half an operating system, Windows is a shell, and DOS is a boot parti

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.

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

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

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

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

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

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 .' '.' `.

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

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

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

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 (

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

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

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

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: 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
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
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

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

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

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

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

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

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

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

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

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: 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

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

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

What does this mean ?

2001-01-15 Thread Denis Gasparin
27;db_name' user: 'user' host: `www.host' (Got an error reading communication packets) We have 700-800 contemporary connections to mysql and these warnings are given periodically every 5-10 minutes... Why does Mysql generate these logs? Denis --

RE: What does this mean ?

2001-01-15 Thread Denis Gasparin
I use php 4.0.3 with persistent connections. MySQL is installed on Linux RedHat 7.0. The problem is that the Mysql exists and I don't know exactly what appends to the php process.... Denis At 19.21 15/01/01, Maciek Uhlig wrote: >Could you describe what exactly software connects to

LOAD TABLE FROM MASTER and deleted records

2001-01-17 Thread Denis Gasparin
38 Delete link points outside datafile at 5098388 I suppose that some record that was deleted in the master and LOAD TABLE FROM MASTER tried to read these records... The question is: what does it happen to the table in the slave? It gets corrupted? Or it is sa

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

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

Printed MySQL manual

2001-02-19 Thread Denis L. Menezes
Hello friends. Can anyone please advise how I can obtain a printed copy of the MYSQL manual? thank you. denis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

  1   2   >