Re: Error compiling source for Win
At 11:50 1/6/2004, Nandan Telang wrote: Hi, Thank you for your bug report. Hi I have been trying to build from the MySQL server source distribution 4.1.2alpha for Windows. I created a Windows source package from the BitKeeper source tree. I then unzipped the mysql-4.1.2-alpha-win-src.zip and started the build using VC++ 6.0. Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bug in MySQL with Correlated Subqueries?
At 13:59 27/3/2004, Ed Smith wrote: Hi, Below the results from a server built with BK 4.1 tree 3 days ago: C:\mysql\binmysqld --standalone --console --ansi --default-table-type=innodb 040328 0:36:59 InnoDB: Started; log sequence number 0 43634 mysqld: ready for connections. Version: '4.1.2-alpha-max-debug' socket: '' port: 3306 C:\mysql\binmysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 4.1.2-alpha-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE TABLE person (pid INTEGER, name CHAR(5)); Query OK, 0 rows affected (0.17 sec) mysql CREATE TABLE phone (pid INTEGER, num CHAR(10)); Query OK, 0 rows affected (0.16 sec) mysql mysql mysql INSERT INTO PERSON VALUES (1, 'Bob'); Query OK, 1 row affected (0.07 sec) mysql INSERT INTO PERSON VALUES (2, 'Jane'); Query OK, 1 row affected (0.05 sec) mysql INSERT INTO PHONE VALUES (1, '12345'); Query OK, 1 row affected (0.07 sec) mysql INSERT INTO PHONE VALUES (1, '23456'); Query OK, 1 row affected (0.05 sec) mysql INSERT INTO PHONE VALUES (2, '34567'); Query OK, 1 row affected (0.06 sec) mysql SELECT PID, (SELECT COUNT(*) FROM PHONE H WHERE - H.pid = P.pid) AS C FROM person P; +--+---+ | PID | C | +--+---+ |1 | 2 | |2 | 1 | +--+---+ 2 rows in set (0.01 sec) mysql SELECT PID, (SELECT COUNT(*) FROM PHONE H WHERE - H.pid = P.pid) AS C - FROM person P ORDER BY pid DESC; +--+---+ | PID | C | +--+---+ |2 | 1 | |1 | 2 | +--+---+ 2 rows in set (0.00 sec) Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC and Windows XP
At 19:14 18/3/2004, José Angel Blanco Linares wrote: Hi, Hi, everybody I have in my office two pc machines. One of them is a Pentium III with Windows 98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP and MyODBC 2.50.39. The MySQL database is running on a linux server, and via MyODBC I connect to the MySQL server to run my Visual FoxPro desk applications. The problem is: the Pentium III machine loads faster the remote tables than the Pentium IV; or better said: the Pentium IV pc loads very very slow the remote tables. I've tried with the two version of MyODBC, and I've got the same result. What can it be? Great chance is to be the SP 1 on XP, that makes MyODBC loss performance when calling setlocal. In this case the work around is to set on XP the MyODBC flag: don't use setlocale. Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fw: imposible cargar datos en tablas
At 15:33 3/3/2004, Marcelo Rodriguez Salinas wrote: Me podrian dcir el por que sucede esto dependiendo de la versión de MySQL es un bug con el wait_timeout al lado del cliente. Usa las últimas versiones. Error Code:2013 Lost connection to Mysql server during query Atentamente Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Fw: imposible cargar datos en tablas
At 16:20 3/3/2004, [EMAIL PROTECTED] wrote: Que es la version de MySQL. De la computadora? 4.0.XX, más especificamente me refiero a la versión 4.0.15. No es la computadora. Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Debugging MySql Source in Visual C++
At 02:13 5/2/2004, Ananth Raghuraman wrote: Hi, Thanks for the info! I am already able to debug the server startup. I would like it to stop at someother point, perhaps a point where a SELECT statement is executed for example.. In this case you can start your debug server (mysqld.exe) with the parameters --console --standalone --debug. The last option will create a file called mysqld.trace in the C:\ root directory, then using the mysql client execute the statement you want to debug. Shutdown the server and open the above file and you should see e.g.: [EMAIL PROTECTED]: dispatch_command [EMAIL PROTECTED]: | query: select * from user [EMAIL PROTECTED]: | mysql_parse [EMAIL PROTECTED]: | | mysql_init_query now opening your VC++ stuff do a search for mysql_parse, open the file and analyze where you can put a break point. Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Debugging MySql Source in Visual C++
At 01:31 5/2/2004, Ananth Raghuraman wrote: Hi, Hi all, I am not part of the official MySql team. I am just a lone developer. I tried debugging MySql source (server) in Visual C++, but it doesn't seem to work. I followed the instructions in the MySql manual and added a few breakpoints at a few random places, but the debugger never stopped there. I would really appreciate if anyone can help.. Most probably the cause for why the debugger doesn't stop in the breakpoint you had configured is because at the start of the server these lines of code aren't called. You need to compile the version debug, press F7 for to compile the whole stuff, then change the path where the server will be linked for the same path you have already the mysql stuff e.g.: c:\mysql this will write the current server. Add as parameters start --console --standalone in the debug tab, then open the file mysqld.cpp, search for the function int main and in the first line create a break point, start the debugger with F5 and using the F11 key do the debug of the rest of the code. The debugger will stop in the point where the server waits for connection. Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Bug
At 21:22 11/04/02 -0500, John D Armstrong wrote: Hi! On my computer both old 'stable' releases and new alpha downloads of MySQL report this error: 020411 21:21:31 Can't find messagefile 'c:\mysqin\share\english\errmsg.sys' 020411 21:21:31 Aborting Although I have checked several times for the files existence. Any Idea? The message error shows that you had installed on another directory than the default c:\mysql, so you need to have the my.cnf or my.ini file with: [mysqld] basedir=c:\mysqin datadir=c:\mysqin\data Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Char set Win1250
At 15:18 10/4/2002 +0200, [EMAIL PROTECTED] wrote: Hi! Thank you for your help, but I know that I must compile kernel (mysqld) with this char set. But, this I can do with Unix (or Linux, etc.). What can I do with kernel for Win32? Is any mysqld with char set win1250 compiled in? The 4.01 Win32 release was compiled with win1250, like you can see below: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. c:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.0.1-alpha-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like character_sets; ++-- -+ | Variable_name | Value | ++-- -+ | character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | ++-- -+ 1 row in set (0.00 sec) mysql Or must I download any other version of MySQL? And which version (where is win1250 compiled in)? Please see above. Regards, Miguel For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.43-nt stop working after approx 10 days.
At 22:21 8/4/2002 +0200, ServiceCenter resources wrote: Hi! I have a problem with my MySQL server, it has started to stop working after approximately 10 days of uptime. Seems to me an issue in your environment, not a MySQL service code issue. Take a look in the properties of the service called MySQL on the screen Recovery or the right of the user who installed the service. Also verify if \mysql\data\mysql.err shows the line with the message like this: 020405 19:56:24 c:\mysql\bin\mysqld-nt: Normal shutdown 020405 19:56:24 c:\mysql\bin\mysqld-nt: Shutdown Complete In the above case the SCM was received the instruction for to stop the service. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL stops suddenly
At 22:50 3/4/2002 -0800, SankaraNarayanan Mahadevan wrote: Hi, I have MySQL 3.23 installed in Windows 2000 Server 4 days ago. It runs as a service of the server. It was working fine. But now it stops abrubtly. When I run the PhpMyAdmin snip I ahve a doubt that it shuts down by itself after a specific period of time.. Is there any such options??? What is that I need to do? There isn't a reason for to the server shutdown itself. Then I guess that your client application sends something to the server which provoke a crash on the server or any issue which control the time of the service releasing the instruction for to stop the service. Take a look in your /mysql/data/mysql.err file on the last lines if you find a message error or the message saying that was made a normal shutdown. Also, to make a test, start the server as standalone e.g.: mysqld-nt --standalone --console and let the console open, for to see the message when the server goes away. If you don't find the same behavior, then there is the possibility that the user which had logged has a out-time defined in his profile for to log off. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL unix vs WinXP case sensitivity
At 11:03 3/4/2002 -0500, Eugene Mah wrote: Hi! Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. C:\c:\mysql\bin\mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.49-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use test; Database changed mysql show variables like lower%; ++---+ | Variable_name | Value | ++---+ | lower_case_table_names | 0 | ++---+ 1 row in set (0.02 sec) mysql create table MyTesT (id int); Query OK, 0 rows affected (0.00 sec) mysql show tables; ++ | Tables_in_test | ++ | MyTesT | ++ 1 row in set (0.00 sec) mysql On the above sample running on Win2K I had set the variable: set-variable= lower_case_table_names = 0 on my.ini file. However, pay attention that the above only works for Win2K and maybe on XP and NT and for read is case insensitive. Regards, Miguel I seem to be having issues with the way MySQL names the table files under Unix and WinXP. I'm not sure if it's a mysql issue or a windows issue. Normally, when I create tables in MySQL, I like to capitalize the first letter. Under unix, it all works fine and dandy. But under WinXP, the table name gets converted to all lowercase, which consequently messes up my php files when I try to go back and forth between unix and windows. I suppose I could switch to all lower case, but old habits die hard and I sometimes forget when I'm typing away some PHP code. The MySQL I installed is from the download page at mysql.com. anybody else run into this issue? Eugene -- - Eugene Mah, M.Sc., DABR [EMAIL PROTECTED] Medical Physicist/Misplaced Canuck[EMAIL PROTECTED] Department of Radiology For I am a Bear of Very Little Medical University of South Carolina Brain, and long words Bother Charleston, South Carolina me. Winnie the Pooh http://home.netcom.com/~eugenem/ PGP KeyID = 0x1F9779FD, 0x319393F4 PGP keys available on request ICQ 3113529 O- - - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 2004 on NT 4. maschine
At 10:05 31/03/02 +0200, Gerd Huber wrote: Hi! hi, i have installed on nt 4.0 sp 6 MySQL Version 3.23.43. After starting the process with mysqld-nt --install, i wanted to start mysql and recived the following error. Error 2004: Can't create TCP/IP socket 10044 Your machine has TCP/IP support installed ? There is a problem with the TCP/IP machine environment ? Do you have a fire wall program which doesn't have configured the MySQL server for to use the TCP/IP support on the machine ? Regards, Miguel what can i do. gerd --- Gerd Huber Eichenweg 23 D-74369 Löchgau Telefon 07143 23985 EMail: [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Coldfusion,Mysql,Myodbc
At 13:29 26/3/2002 +0100, =?us-ascii?Q?Xavier_Prelat?= wrote: Hi, Even if you are using the CFServer 5.0 you will not be able to edit any MySQL DSN with the ColdFusion DSN web admin tool. A clarification here. Is possible ColdFusion to create DSN on the fly using a custom DLL. I did a DLL sometime ago, which you can find it on the contribution page as mydsn with the source for to build on VC++. Regards, Miguel First install the MySQL ODBC on your server, then create any DSN you need using the ODBC Sources tool (administrator tool on Win 2000). Once you created the DSN you want, the CF let you manage the DSN through the web admin interface! hopt it helps. Xavier Xavier Prelat Chief Technical Officer WEBCENTRIC 25 rue de Ponthieu 75008 PARIS - FRANCE http://www.wcentric.com -Message d'origine- De : andy thomas [mailto:[EMAIL PROTECTED]] Envoye : mardi 26 mars 2002 13:14 A : [EMAIL PROTECTED] Cc : [EMAIL PROTECTED]; [EMAIL PROTECTED] Objet : Re: Coldfusion,Mysql,Myodbc On Tue, 26 Mar 2002, [EMAIL PROTECTED] wrote: Hi there . I am new to Mysql.I have to access mysql from coldfusion..and we dont get myODBC as binary for solaris 6 ot 8. so we have to compile them...and i am not able to compile the myODBC bit...its giving compilation problem..Any suggetions from you guys. ColdFusion 4.5.1 and later ship with the Merant ODBC drivers for MySQL and you should be using these. Note that the cfodbc45.so driver shipped with ColdFusion Enterprise Server 5.0 (which lives in ../coldfusion/lib) is broken and you can download a fixed version from Macromedia's web site. Andy - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Query causes Mysql to shut down
At 20:36 26/03/02 +, Richard Prangnell wrote: Hi! Please, Can you send me a test case ? Including the create table statement, some rows for to insert and the queries. Regards, Miguel Dear sirs, I have a situation on my local Windows development platform that is causing the mysql daemon to shut down. I cannot recreate the problem on the web server, which is Linux. The error message (on Windows) is: MYSQLD-OPT caused an invalid page fault in module MYSQLD-OPT.EXE at 017f:00460912. Registers: EAX= CS=017f EIP=00460912 EFLGS=00010206 EBX=018bf5fc SS=0187 ESP=018bf578 EBP=0003 ECX=0003 DS=0187 ESI= FS=5527 EDX=0003 ES=0187 EDI=018bf60f GS= Bytes at CS:EIP: f3 a4 01 6b 04 5f 5e 5d 33 c0 5b c2 08 00 53 55 Stack dump: 00a1c189 018bf5fc 00a1c162 00420801 0003 01446c20 00a1c9a4 00a1c1bc bff7b9c5 00a1c18c 0028 004be901 The query that seems to be 'tender' is: SELECT advert_id, uid, uname, teaser, bodytext, DATE_FORMAT(upload_date, '%d %b %y'), cat_id, DATE_FORMAT(expiry_date, '%d %b %y'), expiry_flag FROM mod_adverts WHERE cat_id = $cat_id AND expiry_flag = 0 OR cat_id = $cat_id AND expiry_flag = 1 AND expiry_date 'datetime(now())' ORDER BY advert_id DESC Now for details of my setup: Hardware: CyrixInstead Cyrix MII (266Mhz) 80Mb RAM OS: Microsoft Windows 98 Series II 4.10. A Web Server: Apache 1.3.20 (Win32) PHP/4.0.6 MySQL: WinMySQLAdmin Ver 1.3 If it is my SQL query that is not quite right, I would have thought that I would have received a different kind of error message - one that doesn't choke the server? Any help with this would be most welcome. Yours sincerely Richard Prangnell www.praggers.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Finally found mysql-nt service error 1061 1067
At 20:02 18/03/02 -0600, Gerald R. Jensen wrote: Hi, For to avoid the install of the service in local account I will add code for to verify if the user that is making the install process has administrator rights and display the error message if he/she doesn't have. Regards, Miguel Alex: I doubt this issue is a 'general mysql-nt problem'. In truth, MySQL is a very well-designed, well-behaved service. I have installed about 80 MySQL servers on customer-owned WinNT/2K servers. If this were a 'general mysql-nt problem', I would have had to set a login account in the SCM for each one. To the best of my recollection, I have only had to do it twice in a little more than two years. I tend to think it has something to do with permissions on the machine or perhaps a general configuration setting in WinNT/2K, but I can't prove/disprove that. Miguel Solorzano is a MySQL full-timer with a good deal of experience in this area ... he reads the list, and may be able to offer some insight here. Gerald Jensen -Original Message- From: Alexander Hampel [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 9:05 AM To: [EMAIL PROTECTED] Cc: Gerald Jensen; [EMAIL PROTECTED] Subject:Finally found mysql-nt service error 1061 1067 Hi Gerald, The 'System-Account' did not work BUT the 'Admin' user account did! You were right :-) How comes? That's what I always do: (1) Install a service on 'System Account' and than (2) change it to an user account of my choice After 2 days wasting time trying to get the installation run, I ask myself how things like this can happen? Seems to be a 'general mysql-nt problem' if I take a look at how many questions arise to this specific issue. Anyway - thanks to all of you helping me by giving me advices :-) Special thanks to you Gerald, so long A:lex -Ursprungliche Nachricht- Von: Gerald Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 15:13 An: [EMAIL PROTECTED] Betreff: Re: NT service problem Then you may have a problem with services running under the System Account on this machine. Try this: - Go into the Control Panel's Service Control Manager - Click on the MySQL service - Click on the 'Startup' button - Make sure 'Automatic' is selected - Select 'This Account' (instead of 'System Account') - Choose an Admin-level user and set the correct password - Click 'OK' then click 'Start' Gerald Jensen - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: Gerald R. Jensen [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:45 AM Subject: AW: NT service problem Thanks - my.ini is used. Tried to use come of your parameters - but nothing changed. The interesting part: the standalone run is fine, the service part is wrong - so it has something todo with the service ?!? So long A:lex -Ursprungliche Nachricht- Von: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 13:40 An: [EMAIL PROTECTED]; [EMAIL PROTECTED] Betreff: Re: NT service problem Check the location of the configuration file (should be either c:\my.cnf ~ OR ~ c:\winnt\my.ini), then edit the contents of that file. Here is a sample: [client] #password=my_password port=3306 #socket=MYSQL # [mysqld] port=3306 #socket=MYSQL skip-locking #enable-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 log=C:/mysql/mysql.log basedir = C:/MYSQL/ # [mysqldump] quick set-variable = max_allowed_packet=16M # [MYSQL] no-auto-rehash # [isamchk] set-variable= KEY=16M # [client_fltk] help_file= C:\\MYSQL\guiclient\MYSQL.help client_file= C:\\MYSQL\mysql.opt history_length=20 database = goetznet queries_root= C:\\MYSQL\queries last_database_file= C:\\MYSQL\lastdb - Original Message - From: Alexander Hampel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 1:37 AM Subject: NT service problem Hi Pierre, Thanks, for your help. That's what I exaclty do and this is for '--standalone' fine. But the point ist, I want to start mysqld-nt as NT service - and this is the problem - it wouldn't let me start it as service: C:\net start mysql System error 1069 Could not start service The service is an important issue. Lets you run a programm under different user rights. Probably I'll find some other solution. Thanks, A:lex -Ursprungliche Nachricht- Von: Pierre du Parte [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 18. Marz 2002 08:04 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: New to MySQL - can't start server :-( Hi Alexander, I use the PHPDEV compilation for local PHP/mySQL development work (http://www.firepages.com.au/devindex.htm for a no-brainer approach to getting PHP/mySQL/Apache up and
Re: it cannot inititate downloads
At 11:17 15/03/02 -0500, alan4100 wrote: Hi! I am trying to download mysql for my windows XP but this url site: Open the URL below: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win.zip Select a mirror site and download it. Unzipped the file and run the setup.exe file. Regards, Miguel http://www.mysql.com/downloads/mysql-3.23.html has been unaccessible for over two weeks. I just could not initiate the download. My provider is Comcast Cable. What is the problem? -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is the new MySQL table cache implemented in InnoDb? #
At 14:20 15/03/02 -0600, BD wrote: Hi! The eWeek article http://www.eweek.com/article/0,3658,s=708a=23115,00.asp that benchmark the various databases including MySQL stated: MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL's performance fell by two-thirds. The query cache feature is independently of the database engine, you can use it with InnoDB, MyISAM and BDB tables. The mentioned benchmark was performed with InnoDB and MyISAM tables simultaneously. Regards, Miguel 1) Has this new caching been implemented for InnoDb tables? 2) If not, will it be implemented for InnoDb tables? Time frame? TIA Brent -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: serious zlib bug discovered - your product MySQL Server 3.23.47-nt may be affected
At 01:30 15/03/2002 +0100, KJK::Hyperion wrote: Hi! Many thanks you for notice us about. We will care it. Regards, Miguel [NOTE: to make the spambot happy, here are sql and query] Hi This is an automated mail I'm sending to all vendors, developers, maintainers, etc. of software I use that, apparently, links statically to the compression library zlib, or to any library that depends from it (f.e. libzip, libpng, libmng, etc.). A serious bug in the deflate algorythm implementation has been found that could lead to heap corruption in response to carefully crafted bogus inflated data, corruption that in turn can be exploited by external attackers for a wide array of remote attacks, including arbitrary code execution, if the affected software is used for a public service on the Internet, or to handle files received by e-mail, or published on the Web or Usenet Zlib has been updated to correct the bug, all vendors should update their products to this release of zlib the soonest possible If you have already been informed of this and/or are already taking appropriate actions, or if this doesn't apply to your product, or if you no longer maintain, or never have maintained the software in question, or if you don't officially maintain this particular version of the product, or if you don't maintain the Win32 binary distribution, please disregard my message, and sorry for the wasted bandwidth. In any case, I'll send no further unsolicited mail on the topic Full information on the bug can be found in the related CERT advisory: http://www.kb.cert.org/vuls/id/368819 The updated zlib can be downloaded from its home page: http://www.gzip.org/zlib/ Thanks for the attention. Best regards, KJK::Hyperion - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql fatal error in mysql-opt.exe
At 22:30 12/03/02 +, Mick wrote: Hi! Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1996. C:\c:\mysql\bin\mysqld-opt --standalone --console C:\MYSQL\BIN\MYSQLD~1.EXE: ready for connections Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1996. C:\c:\mysql\bin\mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.49 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. Then I assume that you have problem to define the basedir and datadir in your configuration file (c:\my.cnf or c:\windows\my.ini). Regards, Miguel Hi, I'm trying to run MySQL ver 3.23.49 on Win98 with Apache, PHP Perl. Apache reports that PHP Perl are running OK. When I try to start MySQL, or let it start on boot, or try to use the WinMySqladmin program, I get a Windows error from MYSQLD-OPT.exe, with the usual Win98 close and details and the console screen for that program reads: c:\serve\MySql\bin\mysql-opt.exe: Fatal error: Can't find messagefile 'C: erve\MySql\share\english\errmsg.sys' It seems the program is looking in C:/ erve when in fact the relevant errmsg.sys file is in the C:/serve folder into which everything was installed, along with the complete MySQL installation. There is no C:/ erve folder. I can't get MySql to run. I assumed a data error, or perhaps a wrong line in a config file somewhere, but I uninstalled and reinstalled MySql twice (including installing to the default folder), no change,. and I can't find any reference to this non-existent folder anywhere in a config file, so I can't correct it. Please help me, it's taken me (admittedly not a networking guru) 3 days to get Apache running happily with Perl and PHP, and this is going to tip me over the edge...! Thanks in advance, Mick. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connect to Mysql Server
At 21:08 12/03/02 -0800, Amit Lonkar wrote: Hi! Hi All!! I have two machines on network System1 and System2. Mysql is installed on System1. On System2 I have a batch file which has the following command:- You need to have a permanent System1 mapped drive on System2, for example F:. Then in your batch file use the path: f:\path_mysql\mysql ... Regards, Miguel --password=amit --host=system1 --port =3306 --database=netaps --execute=LOAD DATA INFILE 'C:\\Amit\\JobBatch.csv' INTO TABLE jobbatch FIELDS TERMINATED BY ','; But when I run the batch file, it generates the error 'mysql' is unknown command, naturally as mysql is not installed here. Now how do I connect to Mysql on System1 using the above command. Thanks Amit Lonkar __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VC++ and mysqlclient
At 18:29 09/03/2002 -0700, Michael Halcrow wrote: Hi! I use standard C++ (with some STL in there) and calls to mysql_real_connect, mysql_query, etc. However, when I tried to import my code into a Microsoft Visual C++ project (copy files in, add a '/Ic:\path\to\header\files\from\http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win.zip;' Why you don't try the source distribution: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win-src.zip Unzipped this file on any working directory. Besides the VC++ 6.0, you should need to install the Preprocessor package for to install the ml.exe assembler compiler, required for to compile the string stuff. This package you can get at Microsoft. Open the mysql.dsw workspace and add a new project for your client. Your client should be linked against the mysqlclient.lib and take a look in the settings of the mysql.dsp for to have some idea how you should set your code. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql won´t connect
At 19:10 05/03/2002 +0100, Othmar Stehlik wrote: Hi! Hi I installed MySql on Win2k and everything worked fine, than I also installed Oracel, mysql refused to work, than I deinstalled Oracle and did a new mysql setup. But when I try to start mysql, with mysql\binmysql mysql.exe is the client program. The server has a name begin with mysqld.exe, mysqld-nt.exe mysqld-opt.exe mysqld-max.. and so on. Then be sure that one of the servers is running before to start the mysql client. Regards, Miguel an error occurs, and mysql can´t connect to localhost. Where is the problem? Thanx in advance -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: win start problem
At 13:22 04/03/2002 -0500, [EMAIL PROTECTED] wrote: Hi! Hi All, New to mysql. Running: Win2k as Administrator mysql-3.23.49-win.zip (binaries) Keep getting error (complete output below sig): mysqld: Table 'mysql.host' doesn't exist Take a look in the \mysql\data\mysql directory if there are the grant tables, like below: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. f:\dir f:\mysql\data\mysql O volume na unidade F é WIN2K O número de série do volume é 8C89-59D6 Pasta de f:\mysql\data\mysql 04/03/2002 10:07 DIR . 04/03/2002 10:07 DIR .. 06/10/2001 19:338.778 columns_priv.frm 06/10/2001 19:330 columns_priv.MYD 06/10/2001 19:331.024 columns_priv.MYI 06/10/2001 19:338.982 db.frm 06/10/2001 19:33 151 db.MYD 06/10/2001 19:333.072 db.MYI 06/10/2001 19:338.641 func.frm 06/10/2001 19:330 func.MYD 06/10/2001 19:331.024 func.MYI 06/10/2001 19:338.958 host.frm 06/10/2001 19:330 host.MYD 06/10/2001 19:331.024 host.MYI 06/10/2001 19:338.877 tables_priv.frm 06/10/2001 19:330 tables_priv.MYD 06/10/2001 19:331.024 tables_priv.MYI 06/10/2001 19:339.148 user.frm 06/10/2001 19:33 428 user.MYD 06/10/2001 19:332.048 user.MYI 18 arquivo(s) 63.179 bytes 2 pasta(s) 17.428.426.752 bytes disponíveis If you don't find them, re-install the MysQL stuff again. Before to run the server, delete the first files that InnoDB has created. Create manually two directories (for the InnoDB data\log files): c:\ibdata and c:\iblogs Now create on \winnt the file called my.ini and edit the below contents: [mysqld] basedir=c:/mysql datadir=c:/mysql/data innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=18M innodb_flush_log_at_trx_commit=0 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=5M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Notice above the files sizes and memory values which you should change according with your machine and necessities. Start the server. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: win start problem
At 18:21 04/03/2002 -0500, [EMAIL PROTECTED] wrote: Hi, Hi Miguel, Yes, they are there. Already had the my.ini set up in c:\winnt since I needed to specify a non-standard location for my data files. (I used the medium conf. file included with the binaries as a starting point). UPDATE: I decided to try the install on a different Win2k machine slightly different build. It worked with files in standard location specified in a my.ini (c:\mysql\data). I added innodb support. Still worked. However, when I tried to change the data output to c:\__work\data\mysql... I need to confess you, that until now I didn't have in my mind to use a directory name like __work. However I created the f:\__work dir (on my machine I have the Win2K on F:), cut/paste the whole directory \mysql\data to \__work and modified the my.ini for to have the datadir like: datadir=f:\__work\data (notice that you did c:\__work\data\mysql). With the changes above, I ran the server without any problem. Regards, Miguel I get the same error. Note: I did copy the c:\mysql\data tree (with all files to the non-standard location and modified the my.ini). Anyway, I went back to the original machine and got it working by pointing back to the standard c:\mysql\data dir for all files I don't like this but, it works Thanks Anyway For Your Response, -Ryan On Mon, 4 Mar 2002, Miguel Angel Solorzano wrote: At 13:22 04/03/2002 -0500, [EMAIL PROTECTED] wrote: Hi! Hi All, New to mysql. Running: Win2k as Administrator mysql-3.23.49-win.zip (binaries) Keep getting error (complete output below sig): mysqld: Table 'mysql.host' doesn't exist Take a look in the \mysql\data\mysql directory if there are the grant tables, like below: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. f:\dir f:\mysql\data\mysql O volume na unidade F é WIN2K O número de série do volume é 8C89-59D6 Pasta de f:\mysql\data\mysql 04/03/2002 10:07 DIR . 04/03/2002 10:07 DIR .. 06/10/2001 19:338.778 columns_priv.frm 06/10/2001 19:330 columns_priv.MYD 06/10/2001 19:331.024 columns_priv.MYI 06/10/2001 19:338.982 db.frm 06/10/2001 19:33 151 db.MYD 06/10/2001 19:333.072 db.MYI 06/10/2001 19:338.641 func.frm 06/10/2001 19:330 func.MYD 06/10/2001 19:331.024 func.MYI 06/10/2001 19:338.958 host.frm 06/10/2001 19:330 host.MYD 06/10/2001 19:331.024 host.MYI 06/10/2001 19:338.877 tables_priv.frm 06/10/2001 19:330 tables_priv.MYD 06/10/2001 19:331.024 tables_priv.MYI 06/10/2001 19:339.148 user.frm 06/10/2001 19:33 428 user.MYD 06/10/2001 19:332.048 user.MYI 18 arquivo(s) 63.179 bytes 2 pasta(s) 17.428.426.752 bytes disponíveis If you don't find them, re-install the MysQL stuff again. Before to run the server, delete the first files that InnoDB has created. Create manually two directories (for the InnoDB data\log files): c:\ibdata and c:\iblogs Now create on \winnt the file called my.ini and edit the below contents: [mysqld] basedir=c:/mysql datadir=c:/mysql/data innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=18M innodb_flush_log_at_trx_commit=0 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=5M set-variable = innodb_additional_mem_pool_size=5M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Notice above the files sizes and memory values which you should change according with your machine and necessities. Start the server. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com || | Ryan Russo | | Academic Computing Web Group, (518) 442-4772 | || - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com
Re: Tuning my production MySQL server (EMERGENCY)
At 21:48 22/02/02 -0800, vijay khanna wrote: Hi! Hiya forum.. I have my site powered by MySQL server running on FreeBSD. The site is facing problems when the traffic increases.Database connectivity is through JDBC.My poolman is managing the database connections with 30 connections set, and is growable.People have started getting error when the rush increases... Error : Communication failure : Bad Handshake. Is there a MySQL server running on the port connectivity error. I suspect the max_connection variable which is default set to 100 reaches and the server refuses further connection.We have probed for any unused database connections hold by the Java.But we have religiously returned the connection back to the poolmanager after its used... I am running my development MySQL server on windows NT. Having gone thru the MySQL manual..for performance tuning the server,we came across many variables which can affect the server performance. So i issue the following commands: c:\ cd mysql\bin start the serverc:\mysqld set the variablec:\mysqld -O back_log=200 --help Looks like it updates the server..but when i see it thru the WinMySQLAdmin ,after restarting the server again ,it does not reflect there and displays the default settings. Set the max_connection variable on \windir\my.ini file for a number greater than 100. If you are using WinMySQLAdmin for to start the server, press the button for to stop the server extended status, that is for the tool not to query the server in the interval specified. We have suspect that this should arise a deadlock. Regards, Miguel We have a production server runningCan any experienced people guide me how to update this server variable onto my remote server. Thanx. Vijay Khanna System Analyst www.spsoftware.com Ph: 09120 - 4006154 INDIA __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INNODB conversion
At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote: Hi! Very strange the printed messages you sent. What MySQL release version are you using ? I did the test with your start InnoDB set with 3.23.48 and got: c:\mysql\binmysqld-max --standalone --console InnoDB: The first specified data file c:\ibdata\ibdata1 did not exist: InnoDB: a new database to be created! 020221 2:42:46 InnoDB: Setting file c:\ibdata\ibdata1 size to 200 MB InnoDB: Database physically writes the file full: wait... 020221 2:42:59 InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be cr eated 020221 2:42:59 InnoDB: Setting file c:\ibdata\ibdata2 size to 200 MB InnoDB: Database physically writes the file full: wait... 020221 2:43:13 InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 30 MB InnoDB: Database physically writes the file full: wait... 020221 2:43:15 InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 30 MB InnoDB: Database physically writes the file full: wait... 020221 2:43:18 InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 30 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 020221 2:43:30 InnoDB: Started mysqld-max: ready for connections Notice the paths of the files. You showed: /home/heikki/data/ibdata1 did not exist: The above is should be the Heikki's Unix machine !. Please send for us the release version and the complete configuration data file (my.ini/my.cnf). Regards, Miguel Dear sir, I am using MySQL database I just wanted to use transaction.so as per manual i have to make table type as Innodb. Then i had set Innodb startup options as follows innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 After this i gave command as mysqld-max --standalone --console Then it printed somthing like this InnoDB: The first specified data file /home/heikki/data/ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file /home/heikki/data/ibdata1 size to 134217728 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /home/heikki/data/ibdata2 did not exist: new to be created InnoDB: Setting file /home/heikki/data/ibdata2 size to 262144000 InnoDB: Database physically writes the file full: wait... InnoDB: Log file /home/heikki/data/logs/ib_logfile0 did not exist: new to be c reated InnoDB: Setting log file /home/heikki/data/logs/ib_logfile0 size to 5242880 InnoDB: Log file /home/heikki/data/logs/ib_logfile1 did not exist: new to be c reated InnoDB: Setting log file /home/heikki/data/logs/ib_logfile1 size to 5242880 InnoDB: Log file /home/heikki/data/logs/ib_logfile2 did not exist: new to be c reated InnoDB: Setting log file /home/heikki/data/logs/ib_logfile2 size to 5242880 InnoDB: Started mysqld: ready for connections After that i tried to create one table by specifying type as Innodb as follows. CREATE TABLE test1 (Id INT, Name CHAR (20)) TYPE = InnoDB; But it is still creating tables in MyISAM? and even i cant't change table type to INNODB using alter query?? so any one can please tell me, if i missed any steps __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
Re: INNODB conversion
At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote: Hi, Now I assume that the text you sent is from our documentation. For to build an InnoDB table: mysql create table table_name (id int)type=innodb; Query OK, 0 rows affected (0.14 sec) Regards, Miguel Dear sir, I am using MySQL database I just wanted to use transaction.so as per manual i have to make table type as Innodb. Then i had set Innodb startup options as follows innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = c:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 After this i gave command as mysqld-max --standalone --console Then it printed somthing like this InnoDB: The first specified data file /home/heikki/data/ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file /home/heikki/data/ibdata1 size to 134217728 InnoDB: Database physically writes the file full: wait... InnoDB: Data file /home/heikki/data/ibdata2 did not exist: new to be created InnoDB: Setting file /home/heikki/data/ibdata2 size to 262144000 InnoDB: Database physically writes the file full: wait... InnoDB: Log file /home/heikki/data/logs/ib_logfile0 did not exist: new to be c reated InnoDB: Setting log file /home/heikki/data/logs/ib_logfile0 size to 5242880 InnoDB: Log file /home/heikki/data/logs/ib_logfile1 did not exist: new to be c reated InnoDB: Setting log file /home/heikki/data/logs/ib_logfile1 size to 5242880 InnoDB: Log file /home/heikki/data/logs/ib_logfile2 did not exist: new to be c reated InnoDB: Setting log file /home/heikki/data/logs/ib_logfile2 size to 5242880 InnoDB: Started mysqld: ready for connections After that i tried to create one table by specifying type as Innodb as follows. CREATE TABLE test1 (Id INT, Name CHAR (20)) TYPE = InnoDB; But it is still creating tables in MyISAM? and even i cant't change table type to INNODB using alter query?? so any one can please tell me, if i missed any steps __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running MySQL on Dos System?
At 10:51 19/02/2002 -0500, Martin Filteau wrote: Hi, Is it possible to port MySql on a Dos Computer ? Sorry no. You need at least a 32 bit OS. Regards, Miguel Computer : 486DX66 OS : DR-DOS 7.03 Ram : 64 Mo HD : 1 Go Martin - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 1058 Win2K Server with MySQL
At 07:49 19/02/2002 -0600, Gerald Jensen wrote: Hi! Did you tried to put the datadir variable too in the my.cnf file ? Anyway, when the service is failing try to start it as console: mysqld-nt --standalone --console In this way you should see the messages errors, also you can see them in the \data\mysql.err file. Regards, Miguel We are trying to install MySQL on a Windows 2000 Server, but are getting 'error 1058' when we try to start the service. The MySQL version is 3.23.47-nt. The MySQL drive is F:, and c:\my.cnf is: [mysqld] port=3306 big-tables skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 set-variable = lower_case_table_names=1 basedir = F:/MYSQL/ console [mysqldump] quick set-variable = max_allowed_packet=16M [MYSQL] no-auto-rehash [isamchk] set-variable= KEY=16M [client_fltk] help_file= F:\MYSQL\sql_client\MYSQL.help client_file= F:\MYSQL\MYSQL.options history_length=20 database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System error 1058 has occurred. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. Anyone had this problem ... found a fix ... have any idea what is wrong??? Any feedback will be appreciated. Gerald Jensen - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Suspected Bug
At 17:59 16/02/2002 +0100, Roger Baklund wrote: Hi, Thanks for the detailed reply. :) I did my tests on a pretty old version, 3.23.30-gamma, on a win2k machine. I was not aware of the lower_case_table_names variable. (This explains why I got lower case filename in my error message, while Fred Lovine got upper case filename... I was a bit puzzled about that.) Can we from this conclude that it is safer to use all lowercase table names when one want to make an application that should run on _any_ platform? In my personal opinion yes, not only this but to use short description names and avoiding blank spaces. However I know that the developer sometimes doesn't have option. That way there should never be an error because of letter casing in table names, regardless of the lower_case_table_names setting, windows version and even mysql version (at least 3.23.6 and later)? There is a phrase about this in the documentation: If you have a problem remembering the used cases for a table names, adopt a consistent convention, such as always creating databases and tables using lowercase names. URL: http://www.mysql.com/doc/N/a/Name_case_sensitivity.html Maybe this should be upgraded to an advise to use lowercase names to assure cross platform and version compatibility? Yes. Regards, Miguel -- Roger query - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: operating system error number 3
At 23:29 16/02/2002 -0500, Loretta wrote: Hi! Hello everyone: I am hoping you can help me. I have Windows 98 SE as my operating system. I have installed MySQL 4.0.1. I originally had Win ME and MySQL 3.23.48 but could not make them work together. Hopefully, someone will be able to help me. Sorry but in Windows you can't to run simultaneously both versions. You only can have one server running. The error I am getting is InnoDB: Warning: operating system error number 3 in a file operation. InnoDB: Cannot continue operation. Because InnoDB found the other server already running. Regards, Miguel I have never used MySQL in my life before this. I have read the manual and done an online search to figure out how to fix this error but have had no luck. If you are able to help me please be detailed in how I am to fix this problem. Any help will be appreciated. I am trying to develop this database for a Church to use. Thank-you, Loretta - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql Installation/Configuration
At 13:35 15/02/2002 -0500, Juwon Aikulola wrote: Hi! Hi Gurus, I downloaded and installed MySql successfully, on a Windows 2000 O/S. I want to locate the my-example.cnf file, copy it to my root directory and rename it my.cnf. However, the my-example.cnf file I locate is a shortcut, pointing to no physical target. The shortcut was created because in your environment the extension .cnf was applied for an MS application. Open my computer. In the Tool menu, open Folder Options. Click the Tab Files Types. Search for the .cnf extension and remove it (if you don't need this set file option). Create the my.cnf file again. Regards, Miguel As a result, after going through this process, I cannot open the file to uncomment and edit the basedir line to point to MySql installation directory. Somebody please help. Thanks Juwon _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help Regarding datadir configuration
At 16:51 14/02/2002 +0530, Asit Satpathy wrote: Hi! Mysql pick up the database list from its default datadir C:/mysql/data as it is mentioned in my.ini file in window. but i want to use my own directory which contains some database , if i am setting the datadir into my directory i am able to use my own directory to which i have to copy the default mysql database; i want to use both data directory of mysql as well as my default directory. if possible then please send a reply how can i set both the directory to datadir. i am sending my.ini file which is being used. You only can use one basedir and one datadir in the my.ini file. However if you want to have others databases in another directory, you can use the symbolic-link feature (read the Manual, how to handle this on Windows). Regards, Miguel #This File was made using the WinMySQLAdmin 1.3 Tool #2/4/02 12:14:58 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=164.100.20.26 datadir=C:/mysql/data datadir=C:/asitdatabase #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=asit password=asit QueryInterval=10 Regards Asit - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Windows Version of MySQL licensing question?
At 20:31 12/02/2002 +, David Ayliffe wrote: Hi! You can assume that the Windows License Terms is the same than Unix version. The shareware is a License option that was abandoned. Regards, Miguel I read in Paul's book that to use MySQL on a Windows platform you need to pay for it. I have downloaded a version of the server and client software from the official MySQL.com site and installed it on XP without incident. Paul also writes that the version for windows will be shareware only. This seems not to be the case I have had my server 3.23.43-nt up and running now for some months. I only use the server for my own uni work but I am curious as to what is the real deal. Anyone? Thanks lots David Ayliffe ICQ# 125646758 Query table database - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems with default-character-set=cp1251
At 09:48 13/02/2002 +0300, =?koi8-r?B?6czY0SDl18fFztjF18neIOvP0s/Cz9c=?= wrote: Hi! I did the test with default-character-set=cp1251 and was not be able to repeat your problem: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\cd\server\usr\mysql\bin C:\server\usr\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.47-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show variables like %character%; ++-- ---+ | Variable_name | Value | ++-- ---+ | character_set | cp1251 | | character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hunga rian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | ++-- ---+ 2 rows in set (0.06 sec) Regards, Miguel Hi. I use mysql 3.26.47, established on Windows 2000 Server Russian. After I set property - default-character-set = cp1251, web-server on a beginning to give out a massage - File ' c:\mysql \\ share\charsets \?.conf ' not found (Errcode: 2) Character set ' .) 14 'is not a compiled character set and is not specified in the' c:\mysql \\ share\charsets\Index ' file If to set default-character-set = latin1, all ok. But I for correct sorting need cp1251. What it is necessary to make? It is my file my.ini from the catalogue winnt # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking character-sets-dir=c:/server/usr/mysql/share/charsets/ default-character-set=cp1251 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/server/usr/mysql/ datadir =C:/server/usr/mysql/data # Uncomment the following rows if you are using InnoDB tables # Create the directories ibdata and iblogs before to start the server. # If necessary, modify the size of the files #innodb_data_file_path = ibdata1:200M #innodb_data_home_dir = c:\ibdata #set-variable = innodb_mirrored_log_groups=1 #innodb_log_group_home_dir = c:\iblogs #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=30M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_arch_dir = c:\iblogs #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=80M #set-variable=lower_case_table_names =0 #set-variable = innodb_additional_mem_pool_size=10M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 # Uncomment the following row if you are using a Max server and you don't want the # InnoDb tables #skip-innodb [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb [WinMySQLAdmin] Server=C:/server/usr/mysql/bin/mysqld-max-nt.exe Best regards, Ilya mailto:[EMAIL PROTECTED] http://www.ilysha.i-am.ru - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__
Re: Network drive for datadir
At 16:00 04/02/2002 +, Neil Freeman wrote: Hi! I did the test in my small network and works. The only care I did is to mapped the network drive, assign a letter (in my case F). Please take a look if effectively you had mapped the drive X (trying to access the X drive with an DOS prompt). Regards, Miguel Hi, Ideally I wish to keep all of my database files on a network drive (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which resides in my WINNT directory. my.ini contents... [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=X:/Shared/MyData/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=guest password=guest Upon starting the MySQL service though I receive the error message Could not start the Mysql service on \\DELL02. Error 1067: The process terminated unexpectedly. I have copied the databases to a local drive (D:\) and altered the my.ini file and all works well. Does anyone know why I cannot use MySQL to access databases on a networked drive??? Neil Email: [EMAIL PROTECTED] [EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Set up help needed
At 14:10 06/02/2002 +1100, WG4- Cook, Janet wrote: Hi, What is the best or easiest client to set up on my NT4 workstation so I can connect to the MySql server and create tables, etc via scripts? I tried downloading one or two from the MySql site but none of them seem to have any instructions as to how to set them up or get the connection going. Read in the Manual, how to set the user privileges (user name, host, password). Having in the Linux server the privileges, from the NT workstation you can connect using the mysql.exe client using the parameters of user, host and password. At the prompt of the mysql client you can type SQL commands or use \. script_file_path to execute script files. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error
At 22:14 19/01/2002 +0200, Saulius Kavoliunas wrote: Hello mysql, I have a problem with starting mysql, I'm using winXP and when I try to start mysql on administrative tools\services I get a box with an error 1067, nothing else is written :(, what is the problem can you suggest me waht to do. Tkank you, -- The above error means that the service was started and the server aborted for some reason. Take a look in the \mysql\data\mysql.err file and try to find what is the reason, or try to start the server as standalone for to see the reason: open a DOS prompt screen: mysqld-max-nt --standalone --console in the above command if you want to use other server, change the executable name. Regards, Miguel Best regards, Saulius mailto:[EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: prob on NT
At 19:29 21/01/2002 +0100, e c h o p l u s A T w o r k wrote: Hi! Try to run the setup program from a DOS prompt: setup -SMS Regards, Miguel Hi Victoria, echoplusAT *I can't run a 16 bit program the file setup.exe is damage. Try to echoplusAT reinstall* (!?!?!?) echoplusAT I've never seen this error ... anyone can help me in order to solve this echoplusAT prob? May be you have a corrupted installation package. Try to download the MySQL 3.32 release again from : http://www.mysql.com/downloads/mysql-3.23.html This seems do not solve my problem ... before I wrote my msg to the list, I've tried to download 3 different package from 3 different mirrors and they always give the same error ... well, now I'll try to install a previous version of the server, but I think that is very strange to have 3 different install. package damaged ... anyway, thanks for your help max - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: max table size on Windows 2000
At 16:58 14/01/2002 +0100, Peter Arnold wrote: Hi! Hi, is it right, that the max. size of a table is 4 GB on WindowsOS ? I am using MySql from a Java - Program for a Log-Database and I get the Message: The table 'LOG4_FFE' is full. For this issue there are two options: 1- Use an OS of the family NT with NTFS file system. The size of the file is limited to the volume size. 2- Use table type InnoDB on FAT32 file system. This table uses the space table architecture. Regards, Miguel Is there another way to get around the Problem as using then to use the MERGE - utility? I am using My Sql 4.0.0-alpha and MyIsam Tables! Best Regards Peter ff-eCommerce softwareengineer Tel.: +49 69 95 63 47 57 http://www.ff-ecommerce.de Mailto:[EMAIL PROTECTED] - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug: BINARY, NULL, and GROUP BY
At 12:13 12/01/2002 +0100, Carl Troein wrote: Hi! Thanks you for the bug report I was be able to repeat in the 4.0.1 Windows release too. Regards, Miguel CREATE TABLE t1 (txt varchar(10) default NULL); INSERT INTO t1 VALUES ('aaa'); INSERT INTO t1 VALUES (NULL); SELECT BINARY txt AS t FROM t1 GROUP BY t; On my Linux systems, and MySQL compiled with gcc 2.95.3, this invariably leads to a segfault. Removing the non-null row from t1 solves the problem, as does removing the row with null. Without BINARY everything works. I'm no longer on the list, so if you reply to this mail with comments or questions that you think I should read, please be sure to include my address. //Carl - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation Problems
At 16:46 12/01/02 -0800, Mark Peterson wrote: I'm having trouble with the installation of MySQL. The database was installed on the C drive. cut Please follow the steps below: - The instructions below assume that you have opened a prompt screen at c:\mysql\bin directory. - After a boot, open the Task Manager (ALT+CTRL+DEL) and verify if exists a process for an MySQL server (mysqld.exe, mysqld-max.exe, mysqld-nt.exe, mysqld-max-nt.exe, mysqld-opt.exe). If yes, stop it with the following command at the prompt: net stop mysql (if the server was started as service) or mysqladmin shutdown (if the server was started as standalone mode). For NT server is necessary to make twice this command due a bug which should be fixed in the next release. - If you had installed the service before, type the command: mysqld-max-nt --remove - Type: mysqld-max-nt --install - Go to c:\winnt directory and create a file named my.ini. Edit the lines below: [mysqld] basedir=c:\mysql datadir=c:\mysql\data skip-innodb Save the file and close it. - Start the server: net start mysql NOTE If you want the support of InnoDB tables (I recommend to test), you should need to read the Manual and remove the line skip-innodb from the my.ini file. Regards, Miguel -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation of mySQL on a Win2000 Pro machine
At 11:57 11/01/02 +, Andrew Aragi wrote: Hi! Thanks for the info Heikki, but life has not got any better. I have bought the mySQL book (Paul DuBois) and I am still baffled. Maybe I am having a blonde week (I am blonde). From the screen shots I have seen of myCC it looks similar to SQL Server. That is what I am looking for. My understanding is that you download mysql-max-3.23.47-win.zip unzip and install. The run the cmd prompt and enter in C:\mysql\bin mysqld-max --standalone and you should get a dos print out. I get an error saying that the cmd is not recognized. What now? Because the path you had typed it isn't correct. The error message is from the Operational System. Are you using a software for to rename the boot hard drive ? Regards, Miguel I what to design and administer mySQL server through myCC, is this possible? Please somebody help Frustrated - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation of mySQL on a Win2000 Pro machine
At 12:40 11/01/02 +, Andrew Aragi wrote: Hi, Hi Miguel. I am not using any software to rename the boot HD. Concerning the path C:\mysql\bin mysqld-max --standalone this is out of the pdf manual. What would be the correct path then? If you had installed with the default path: c:\mysql\bin\mysqld-max --standalone or if you are into the c:\mysql\bin directory: c:\mysql\binmysqld-max --standalone Regards, Miguel Thanks - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Prevent WinMySQLAdmin from auto startup when windows 98 reboots
At 09:04 08/01/2002 -0700, Dan Jordan wrote: Hi! Go to start Menu and remove the Icon of WinMySQLAdmin. Regards, Miguel Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need to do to prevent this, including uninstalling WinMySQLAdmin, which I have not figured out how to do? When I remove my.ini from C:\Windows and reinstall C:\my.cnf, then the my.cnf gets renamed to my_cnf.bak and a minimal C:\Windows\my.ini is created when I reboot. Is there a flag for the [WinMySQLAdmin] section in the my.ini file that I can declare which will instruct WinMySQLAdmin not to auto start when the computer is rebooted? Thanks, Dan Jordan - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Different instances of mysqladmin
At 09:31 08/01/2002 -0700, John Meyer wrote: Hi! Can I have different instances of winmysqladmin start instanciating different mysql's? i want to run one for the stable version, and one for mysql 4.0 Unlucky no. By the way the Windows Server currently doesn't have support for to run several instances. To introduce this is part of my immediately TODO in the 4.0 tree, however I can say for you, that the second instance for 4.0 should be made separately without the support of WinMySQLAdmin. Regards, Miguel - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: General mySQL setup question
At 16:50 08/01/2002 +, Los Morales wrote: Hi! Hi, Would like to know if there is a preferred way of setting up the data directory for mySQL. The default for a database would be in C:\mysql\data. Is this the preferred way or should this be set up in another directory outside of the mysql directory? Does moving the data directory affect performance, security, etc? Most likely there is no difference but would like to see if there is a preferred way of setting this up. Thanks! Take a look in the Manual how to set another location than the default c:\mysql. In advance you will to use my.ini file with the variable datadir and basedir pointing for the new paths. Regards, Miguel -los _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedded MySQL terminate abnormally.
At 23:46 30/12/2001 +0900, Heo, Jungsu Mr. wrote: Hi! Below the patch made by Monty: (/my/mysql) bk diffs sql/net_serv.cc = sql/net_serv.cc 1.32 vs edited = 170c170 #ifndef EXTRA_DEBUG --- #if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY) (/my/mysql) bk diffs -c sql/net_serv.cc = sql/net_serv.cc 1.32 vs edited = *** /tmp/net_serv.cc-1.32-4839 Sat Dec 22 15:13:31 2001 --- edited/sql/net_serv.cc Sun Dec 30 12:43:17 2001 *** *** 167,173 void net_clear(NET *net) { ! #ifndef EXTRA_DEBUG int count; /* One may get 'unused' warn */ bool is_blocking=vio_is_blocking(net-vio); if (is_blocking) --- 167,173 void net_clear(NET *net) { ! #if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY) int count; /* One may get 'unused' warn */ bool is_blocking=vio_is_blocking(net-vio); if (is_blocking) Regards, Miguel I installed Embedded MySQL( compiled --with-embedded-server) And I compiled source code from Manual. (I did not modify the source) compiled nicly, but I run the Embedded MySQL, Segmentation fault occured [wertyu@inos prog]$ ls Makefile mysqld* mysqld.c mysqld.c~ [wertyu@inos prog]$ ./mysqld Segmentation fault [wertyu@inos prog]$ here is output from GDB Program received signal SIGSEGV, Segmentation fault. 0x8051984 in vio_read () (gdb) bt #0 0x8051984 in vio_read () #1 0x807357d in net_clear () #2 0x804857f in simple_command () #3 0x80494f0 in mysql_close () #4 0x80481e8 in main (argc=1, argv=0xb594) at mysqld.c:54 #5 0x8230a51 in __libc_start_main (main=0x80481a0 main, argc=1, argv=0xb594, init=0x80480b4 _init, fini=0x82782d0 _fini, rtld_fini=0, stack_end=0xb58c) at ../sysdeps/generic/libc-start.c:78 (gdb) gcc version = 2.91.66 OS version = Redhat 6.0 Thank you for advanced answer! Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Windows 95 winsock version
At 11:17 21/12/01 +1300, Quentin Bennett wrote: Hi! http://www.microsoft.com/windows95/downloads/contents/WURecommended/S_WUNetworking/dunwinsky2k/Default.asp Regards, Miguel Hi, From the manual: Note that if you are using an old Win95 release (for example OSR2), it's likely that you have an old Winsock package; MySQL requires Winsock 2! You can get the newest Winsock from http://www.microsoft.com/. Win98 has the new Winsock 2 library, so the above doesn't apply for Win98. Can anyone provide a more definitive link for the upgrade, and also how to establish if a win 95 PC is running winsock 1, 2 or whatever. TIA. Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.com - 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php