Re: Fw: Which files to download/install - problems running MySQL
At 20:22 21/10/2002 +0100, Nikki Mason wrote: Hi, My email below was rejected for some reason, so I am trying again to send it. No problems, but I need to clarify you that behavior: 1- When you start the server with: name_server --standalone --console. The DOS prompt screen is owned by the MySQL server process, in another words the behavior you saw is correct. You minimized this screen and open another DOS prompt session for to work with the mysql.exe client. ---server prompt screen--- C:\mysql\binmysqld-opt --console --standalone 021022 1:23:47 InnoDB: Started mysqld-opt: ready for connections -- ---client prompt screen--- C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.53-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql -- 2- If you don't want to see the screen used to start the server, only issue the command: name_server. In this case you should see the MySQL server process in the ALT+CTRL+ DEL screen and also open another DOS prompt for to work with the mysql.exe client. 3- For to shutdown the server, you use the mysqladmin.exe tool: mysqladmin shutdown. Hope now is clarify for you: Regards, Nikki - Original Message - From: Nikki Mason [EMAIL PROTECTED] To: Miguel Angel Solórzano [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, October 20, 2002 8:41 AM Subject: Re: Which files to download/install - problems running MySQL Miquel, I tried what you suggested, but still it didn't work properly. For the server: C:\cd mysql\bin C:\mysql\binmysqld-opt --standalone --console 021020 8:20:30 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. The cursor did not return to the prompt to allow anymore commands to be typed. (I haven't created a c:\my.cnf or c:\windows\my.ini) For the client: C:\mysql\binmysql -uroot -p Enter password: Again, nothing more was displayed on the screen and the cursor did not return to the prompt to allow anymore commands to be typed. Regards, Nikki Mason - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Nikki Mason [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, October 19, 2002 9:29 PM Subject: Re: Which files to download/install - problems running MySQL At 15:16 19/10/2002 +0100, Nikki Mason wrote: Hi, Hi, I wish to learn SQL, and as some of my friends already use MySQL, they recommended that I too use it. Please can you tell me what I need to download and install to get me going. I have: Pentium III 450Mhz, 256Mb Ram Windows 98 I don't have a C or C++ compiler installed. My PC is not connected to a network - it is standalone. I had earlier downloaded just the zip file for version 4.0.4-beta (Windows). I unzipped it and ran the 'setup' program. Once setup had completed I tried the test on the server - at no point had I run the Admin program or created the my.cnf or my.ini. I opened a dos window and from the directory c:\mysql\bin entered: mysqld --standalone No other text was shown in the dos window and it appeared to hang. The whole computer also seemed to 'hang'. I had to use ctrl C to kill the application and get back normal operation to my PC. Why you had killed the mysqld server ?. The mysqld.exe is a console application that when started with --standalone option it works in the background. If you want to see the console screen then issue: C:\mysql\binmysqld-opt --standalone --console 021019 17:25:31 InnoDB: Started mysqld-opt: ready for connections and for to work with the mysql client: C:\c:\mysql\bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.53-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql after a fresh installation left the root password blank. for to shutdown the server: C:\c:\mysql\bin\mysqladmin shutdown 021019 17:27:27 mysqld-opt: Normal shutdown 021019 17:27:27 InnoDB: Starting shutdown... 021019 17:27:29 InnoDB: Shutdown completed 021019 17:27:29 mysqld-opt: Shutdown Complete I then tried manually creating the file c:\my.cnf and populated with the information given in the installation instructions. The server still hung. I then tried using the admin program with the similar results - the green traffic light was showing, but the dos window that was displayed appeared 'hung
Re: MySQL 4.0.4 Question
At 17:23 18/10/2002 -0400, Fernando Grijalba wrote: Hi, You guy recommend that I download the binaries instead of the source code. In the Win32 version of 4.0.4 is SSL enabled or do I need to download the source code and apply the flags that you mention in your sort version of the SSL Documentation so far. Sorry but the SSL stuff is only supported on Unix versions. Also I would like to know if the Pro version has support of InnoDB or do I have to download the Max version The normal release already contents the Max stuff. Thank you, JFernando ** sql ** -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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: Which files to download/install - problems running MySQL
At 15:16 19/10/2002 +0100, Nikki Mason wrote: Hi, Hi, I wish to learn SQL, and as some of my friends already use MySQL, they recommended that I too use it. Please can you tell me what I need to download and install to get me going. I have: Pentium III 450Mhz, 256Mb Ram Windows 98 I don't have a C or C++ compiler installed. My PC is not connected to a network - it is standalone. I had earlier downloaded just the zip file for version 4.0.4-beta (Windows). I unzipped it and ran the 'setup' program. Once setup had completed I tried the test on the server - at no point had I run the Admin program or created the my.cnf or my.ini. I opened a dos window and from the directory c:\mysql\bin entered: mysqld --standalone No other text was shown in the dos window and it appeared to hang. The whole computer also seemed to 'hang'. I had to use ctrl C to kill the application and get back normal operation to my PC. Why you had killed the mysqld server ?. The mysqld.exe is a console application that when started with --standalone option it works in the background. If you want to see the console screen then issue: C:\mysql\binmysqld-opt --standalone --console 021019 17:25:31 InnoDB: Started mysqld-opt: ready for connections and for to work with the mysql client: C:\c:\mysql\bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.53-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql after a fresh installation left the root password blank. for to shutdown the server: C:\c:\mysql\bin\mysqladmin shutdown 021019 17:27:27 mysqld-opt: Normal shutdown 021019 17:27:27 InnoDB: Starting shutdown... 021019 17:27:29 InnoDB: Shutdown completed 021019 17:27:29 mysqld-opt: Shutdown Complete I then tried manually creating the file c:\my.cnf and populated with the information given in the installation instructions. The server still hung. I then tried using the admin program with the similar results - the green traffic light was showing, but the dos window that was displayed appeared 'hung' and again the PC itself seemed to have hung - it operated extremely slowly. The task manager showed the admin tool as 'not responding'. What have I/am I doing wrong? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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: access denied ????
At 15:08 25/9/2002 +0300, Iikka Meriläinen wrote: Hi, Only for to clarify: There is a rename table bug for some NT family (Win2k I tested) when is used at the command rename tables names with uppercase and the default lower_case_tables_names =1. This is already fixed in the next releases. On Wed, 25 Sep 2002, toby - wrote: thnx iikkaa im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 all workin fine . my mysql4.0.1 alfa is givin me these night-mares cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess not the source but a binary . plz do lemme know what can i do n thnx a lot again toby .. Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) perror 13 -- Permission denied So it's probably due to your NTFS file/directory permission on Windows. Please try this if _nothing_ else seems to help: grant Everyone RWXD (full) rights to the whole data directory. This has, of course, a major problem with security but that way you could check if it's really a permissions problem. Also, a more secure way to accomplish this is to run the MySQL service as a ordinary user (rather than the SYSTEM account) and grant that user full rights to the whole data directory structure (make sure the subdirectories and files get their correct permissions, too). Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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: winadmin stopped on Beta
At 08:13 13/9/2002 +0100, Adrian Greeman wrote: Hi, Sorry to inform you that I got a library corruption in my working machine where I built that tool and makes not to work well on Win9x machine. This will fixed in the next release, however you can use the tool shipped in your old version. Regards, Miguel Hello everyone - I saw that the beta version of 4 was available and so I uninstalled my alpha (I only footal with the database at present on my own computer) and put on the beta. It starts fine and I have loaded my dumped database into it MySQLFront and PHP My Admin seem to connect to it and it runs But WinMySQLadmin no longer shows a little green light. It sits there in the tray of the bottom resolutely informing me that the server is not running and with the pullup menu asking if I want to start the server No info is displayed about the server either. Can any one help - what might I have done wrong? Or is theresome reason why WinSQLadmin will not pull running information out of the beta version Thanks Regards Adrian Greeman Telephone +44 20 8672 9661 Mobile +44 780 329 7447 e-mail:- [EMAIL PROTECTED] or [EMAIL PROTECTED] -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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 XP Installation Problems
At 16:40 10/9/2002 -0700, Lukoni, Bryan AG:EX wrote: Hi, Thanks Michel: Enabled the error reporting, but no luck. I'm stumped why I am not seeing any error messages when it fails to install. Do you know if the MYSQL installation makes any modifications to the registry or adds files to the system directory. Nothing is copied to registry. If not I could probably just copy the complete directory from the other computer onto a CD and recopy to the problem computer. The above will works. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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: upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103
At 08:41 03/09/02 +0100, Chuck Amadi wrote: Hi, Well Well Well , I proceeded in upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103 Shutdown the current installed server or install 4.0.X on another directory. Component Servers File Group: File: Thus i unzipped mysql-4.0.2-alpha-win.zip into C:\mysql and the above happened I am using excessivly MyODBC to connect to M$ Access 2000 front-end. Please point me in the righrt direction as i really need to get version 4 up and running for transactions (innodb) Cheers Chuckie -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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 4.0.3b Bind-Address Problem
At 14:25 03/09/02 -0400, Tam, Michael wrote: Hi, I just tried 4.0.3beta and it doesn't seem to address the bind-address problem at all. When I include the option in the ini file and run mysql-max-nt --help, it stops showing the variables when it reaches bind-address variable and a window pops up with the following message: The instruction at 0x005c89eb referenced memory at 0xb000a8c0. The memory could not be read. Thanks you for the bug report. I was able to repeat it. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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: build under Win32
At 16:14 02/09/02 +0300, Nick Kostirya wrote: Hi, Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Please read the instructions at (you need the assembler compiler): http://www.mysql.com/doc/en/Windows_source_build.html -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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 and Service Pack 3
At 14:29 29/08/02 -0500, Marc Hus wrote: Hi, Hello, I have a very strange problem with all of the Windows versions of MySQL. I upgraded to Service Pack 3 for Windows 2000 Server and now MySQL will not work period. Has anyone ran into this problem and or know of a fix? Some users had reported before this issue, for someone the remove and re-install the MySQL service had resolved the issue. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ 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 Password Problems!!
At 16:57 15/12/2001 -0500, Gary Wheeler wrote: Hi, shell BINDIR/safe_mysqld --skip-grant-tables shell BINDIR/mysql -u root mysql Make sure you run mysqladmin flush-privileges or mysqladmin reload afterward to tell the server to reload the grant tables. Regards, Miguel Hi All, I've done a fool thing and changed the root password to mysql server, and evidently miss typed, because now it will not let me in. How can I get back into mysql to change this?? Please help as this is a production server!! Thanks, Gary - 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: mysqlclient.lib compiling problem
At 16:52 14/12/2001 -0800, Devore, Jacob wrote: Hi, You need to specify the winsock.h header in your code and the wsock32.lib in the link libraries. Regards, Miguel I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - 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: win32 libmysqld.dll
At 22:22 14/12/2001 -0500, Edward Meyer wrote: Hi, This you will get with the Win32 4.0.1 release in the next weeks. Regards, Miguel Has anybody built the embedded server libmysqld.dll for windows 2000? I downloaded the source code, however there is not a project file for the embedded server. I have compiled the rest of the code, but I would like to get the embedded server compiled also for a project I am thinking about. Any help would be great. Edward - 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 on Win2000
At 14:51 13/12/2001 -0500, Alex Shi wrote: Hi! The development of WinMySQLAdmin was stopped since other client cross platform is in the works. However you can use MySQLGUI that provides you with a complete set of features (you can download it from our site). Also you can use clients programs like Perl, PHP, Python, any one which uses ODBC driver (you need to download MyODBC driver from our site), C/C++, Delphi, VB. Regards, Miguel Hello, I installed MySQL 3.23.46 on Windows2000. The mysql-nt started on Windows startup, and MysqlAdmin is also running well. I tried to create a database with it and it works! Everything looks perfect except I want to do something more than this admin tool can. What I need is to create/drop table, add/drop user for a certain database, and place query statement, etc.. However in MysqlAdmin I didn't see those I expectedDo I need to login to mysql from dos terminal for the admin job? Can I use phpmadmin for Win2k/apache/ php/mysql platform? I'm totally new for mysql on Windows, please help me out if anyone is familiar with this issue. Thanks in advance! Alex - 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 on Win2000
At 15:50 13/12/2001 -0500, Etienne Marcotte wrote: I never used any kind of ODBC and can connect to mySQL with the mysql.exe from c:/mysql/bin/ also with perl/apache locally installed I can make perl script to play intop the DB without even thinking about ODBC Good. However is useful for a new user to know What options he should have for to work with MySQL. Regards, Miguel my 2 cents Etienne Miguel Angel Solórzano wrote: At 14:51 13/12/2001 -0500, Alex Shi wrote: Hi! The development of WinMySQLAdmin was stopped since other client cross platform is in the works. However you can use MySQLGUI that provides you with a complete set of features (you can download it from our site). Also you can use clients programs like Perl, PHP, Python, any one which uses ODBC driver (you need to download MyODBC driver from our site), C/C++, Delphi, VB. Regards, Miguel Hello, I installed MySQL 3.23.46 on Windows2000. The mysql-nt started on Windows startup, and MysqlAdmin is also running well. I tried to create a database with it and it works! Everything looks perfect except I want to do something more than this admin tool can. What I need is to create/drop table, add/drop user for a certain database, and place query statement, etc.. However in MysqlAdmin I didn't see those I expectedDo I need to login to mysql from dos terminal for the admin job? Can I use phpmadmin for Win2k/apache/ php/mysql platform? I'm totally new for mysql on Windows, please help me out if anyone is familiar with this issue. Thanks in advance! Alex - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 -- 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 on Win2000
At 15:23 13/12/2001 -0500, Alex Shi wrote: Okay, I will try MySQL GUI later BTW, do I have to use ODBC if I use PHP? I'm told PHP has its own very API for MySQL... No you don't need. I only mentioned it for you know other client option. Regards, Miguel Alex - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Alex Shi [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 13, 2001 3:12 PM Subject: Re: MySQL on Win2000 At 14:51 13/12/2001 -0500, Alex Shi wrote: Hi! The development of WinMySQLAdmin was stopped since other client cross platform is in the works. However you can use MySQLGUI that provides you with a complete set of features (you can download it from our site). Also you can use clients programs like Perl, PHP, Python, any one which uses ODBC driver (you need to download MyODBC driver from our site), C/C++, Delphi, VB. Regards, Miguel Hello, I installed MySQL 3.23.46 on Windows2000. The mysql-nt started on Windows startup, and MysqlAdmin is also running well. I tried to create a database with it and it works! Everything looks perfect except I want to do something more than this admin tool can. What I need is to create/drop table, add/drop user for a certain database, and place query statement, etc.. However in MysqlAdmin I didn't see those I expectedDo I need to login to mysql from dos terminal for the admin job? Can I use phpmadmin for Win2k/apache/ php/mysql platform? I'm totally new for mysql on Windows, please help me out if anyone is familiar with this issue. Thanks in advance! Alex - 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 -- 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: question using mysqladmin with apache on win32 (w2k)
At 19:10 10/12/2001 +0100, MOWE (Michael Owens) wrote: Hi! Quick question for someone if they can pass along a little knowledge from their experiences: I am dabbling in MySQL and Apache on a Win2K box and most of it seems to work fine. The one thing I can't figure out is that when WinMySQLAdmin launches at startup, I am not able to use the functions of the program b/c it keeps telling me that The server must be connected first. This means that the user and password that WinMySQLAdmin writes on the my.ini files were removed or not exist anymore in the grant tables. The tool tries to make a connection for to query the server, if the connection doesn't exist, then the tool only has the function for start and stop the server. Regards, Miguel My question is, Do I have an Apache thing or MySQL thing that is not setup right?. I have the Apache.exe file launching at startup also. Any advice on how to remedy the situation would be much appreciated. Thanks, NZNA:Pilot:::mike_owens - 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: Replication Problem on MySQL 3.23.45/Win32
At 12:04 07/12/01 -0800, A. Clausen wrote: Hi, Does print the command show databases the db in question ? and you are able for perform commands on the tables using the mysql client tool ? Regards, Miguel I have been using replication for several months between to Win2k machines. Last week I upgraded to MySQL 3.23.45, and everything continued working fine. Yesterday, I put the line use-symbolic-links in the my.cnf file because I've created a very large database that I have another drive reserved for. Since that time, when I enter show processlist the top line shows: |1 | system user | none | NULL | Connect | 88449 | connecting to master | NULL | Of course, the replicating server is not getting through at all. Anybody know what could be causing this? A. Clausen [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: Turn off autocommit
At 17:13 05/12/01 -0600, Demirchyan Oganes-AOD098 wrote: Hi, Hi everyone, I'm using InnoDB tables, and I would like to turn the auto commit off. I do SET AUTOCOMMIT=0 in my.ini file. And when I restart the server, it won't start. This condition should be executed by the client which is querying the server, in this way the server attends others clients simultaneity with a different condition. Regards, Miguel Does anyone know why? Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 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: can't connect to server
At 16:11 30/11/2001 +0100, [EMAIL PROTECTED] wrote: Hi, I don't understand very well your problem, anyway here some informations: Using the MySQL Server as Service To start/stop options: 1- net start mysql/net stop mysql 2- using the SCM (Service Control Manager) 3- using the WinMySQLAdmin When the server is running as service you can't to use the tool mysqladmin with the parameter shutdown Setting the MySQL environment Creating and editing either c:\my.cnf or c:\windir\my.ini, not both. Using the MySQL server at the DOS prompt To start/stop options mysqld --standalone --console/mysqladmin shutdown In the start you can use others parameters (see the manual) or the server should read the configuration file above mentioned too. Using the mysql.exe client tool mysql -u user_name -p Enter password: the_password_for_the_user_name If you have a fresh install, the server permits the mysql client connection without any user and his password. Regards, Miguel I'm running MySQL on Windows2k. The service is installed and I can start it with the WinMySQLAdmin Tool, but I have trouble to shutdown the server on a DOScommand window with 'mysqladmin shutdown'. I also can't connect to the server at localhost, and I can't start MySQL as a service with 'mysqld -l' - only as standalone. What is wrong with it? Any help is appreciated. Nils -- 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: MySQL still hanging on Win2K :-(
At 22:00 01/12/01 +, Chris Withers wrote: Hi, I have a Win2000 machine and I would like to do a test with your problem. Please can you send me more specify details (definition table and SQL statements) so as I can build a C/C++ client program for try to repeat the issue ?. Regards, Miguel Hi again, Sinisa... Chris Withers wrote: Okay, table_cache increased from 64 to 256... * check free disk space on all drives Well, it got up to indexing 10,000 documents this time but then hung again. Now, I don't know if this is because increasing the table_cache made a difference or because it was just lucky and got further this time. Looking at 'mysqladmin processlist', it has hung on 'Opening table' again, if that helps... I'm gonna try table_cache at 1024 to see if that is the cause. If it is, what could I be doign that needs this number to be so high? Of course, it also brings my following questions back into play: * starting / stopping MySQL as a service only Well, I run MySQL in a DOS box not as a service. Would running it as as service help? If so, why? Hope you can help... cheers, Chris - 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: F/U @ Re: * reiteration re: (re)starting MySQL
At 20:24 26/11/2001 -0800, gx-inc wrote: Hi! I'd appreciate note-by-note directions. The my.cnf file wasn't to be found on my system (odd), though I did find the my.ini file (in the main Windows directory). In short: you can use either c:\my.cnf or \windir\my.ini file, not both. For not to use the WinMySQLAdmin, remove the shortcut from the start menu, delete the \windir\my.ini file and create\edit the c:\my.cnf file. Regards, Miguel Some other directions stated that I could edit the my.cnf *or* my.ini file(s) for essentially the same results, though I wouldn't presume to know which is which and/or what specific editing particulars are involved. Appended are the contents of the my.ini file (omitting the user name and password for display purposes herein): = #This File was made using the WinMySQLadmin 1.1 Tool #9/25/01 11:43:37 AM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/MYSQL #bind-address=208.187.244.66 datadir=C:/MYSQL/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-opt.exe user= password= = At this juncture I'd just as soon *not* use InnoDB, but just go with plain MySQL. I do *not* want to use WinMySQLadmin but instead want to use the DOS prompt for command-line access and database processing (if I'm being clear?). Appended below are the specifics that appeared at the DOS prompt when I tried to access MySQL: = C:\WINDOWScd c:\mysql\bin\ C:\mysql\binmysqld --standalone Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = /mysql/data/ibdata1:20M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 7.6 at http://www.mysql.com/doc/ C:\mysql\bin = Being completely new to MySQL specifically (and relational databases in general) means I really have no idea just *where* to edit/insert what when; even most of the manual is Greek to me (at this preliminary point). This is very frustrating, especially since I believe MySQL to be an excellent database to learn by -- if indeed I can get the bugger actually going for me to learn by! Thanx to all for all assistance. :-) mhw (-: + At 08:35 AM 11/26/01, you wrote: try opening my.cnf file and see if you find s.thing with InnoDB - Original Message - From: gx-inc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 26, 2001 5:31 PM Subject: * reiteration re: (re)starting MySQL * reiteration re: (re)starting MySQL Just recently started seriously studying the infernal trio of Apache, MySQL PHP and got off to a decent start, but for reasons unknown can no longer get MySQL to start up from the DOS prompt. I keep getting the following error message when I enter the C:\mysql\binmysqld --standalone command: Can't initialize InnoDB as 'innodb_data_file_path' is not set This command had previously worked without problems -- e.g., accessing MySQL to commence database construction; now it doesn't. One day it worked, and the next it didn't despite not havng done anything in the interim to the best of my knowledge: weird. Rather than using WinMySQLadmin I'd prefer to start up MySQL from the DOS prompt primarily for the sake of learning proper command-line procedures in anticipation of our pending migration to Linux as our primary OS. Would appreciate whatever guidance (debugging?) that the more experienced users may have to offer. Thanks in advance. :-) mhw (-: - 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. - 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
Re: mysql win32 binary w/ innodb: error number 3
At 20:45 25/11/01 -0800, Bryan Chong wrote: Hi, Hi folks, I need help to start my server with InnoDB. I have manually created innodb_data_home_dir, which is c:\mysql\ibdata. The mysql server is running on Windows ME platform. my.cnf is Notice that beside the c:\mysql\ibdata directory you need to create the c:\mysql\iblogs too. Before to try again the first start, delete the files created in c:\mysql\ibdata. Regards, Miguel as follows: # 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 default-character-set=latin1 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:/mysql/ datadir = c:/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:\mysql\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\mysql\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 #.._arch_dir must be the same as .._log_group_home_dir innodb_log_arch_dir = c:\mysql\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-innobd [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 The error I am getting is as follows: C:\c:\mysql\bin\mysqld-max --standalone InnoDB: Warning: operating system error number 3 in a file operation. InnoDB: Cannot continue operation. I appreciate your great help. 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: Mysql Daemon not starting
At 15:06 20/11/2001 +, Sandeep Murthy wrote: Hi, Every time you have problems to start the server, the best way to find the problem is try the start in the prompt DOS mode using the parameters --standalone --console. In this way you should see the message error and fix it. Also you find at /mysql/data/mysql.err file useful information. Regards, Miguel Hi all, Am facing a strange problem... I am running MySQL on a WIN 2000 server and was running fine till this morning.. I am using PhpMyAdmin to administer the databases.. Suddenly all of a sudden I could no longer connect to the databases and keep getting an error saying Can't connect to MySQL server on 'localhost' (10061) I checked to c if the mysql daemon was alive but it isnt... Further I am even unableto do a Telnet Localhost What cud hv happened and how may i resolve this!!?? I intend to reinstall MySQL to c if it sets everything ok but would like to c if anyone has some suggestions.. TIA, sandeep - 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: Win32 mysqld-opt: Invalid page fault on certain query
At 19:10 02/11/2001 -0500, Ken wrote: Hi Ken, Unlucky with your report I can't able to begin any test for fix this behavior. Try to make notes about every step until reach the crash, then send me the notes and the structure of the tables. Regards, Miguel I'm running MySQL 3.23.41 on Win95 (just upgraded from an earlier 3.23 beta, in case that would solve the problem). I have a moderately complex query that causes the MySQL server to crash when I execute it. (invalid page fault in module MYSQLD-OPT.EXE) The same query works fine on a Redhat version of MySQL I have access to. It's definitely not a syntax error (not that a syntax error should crash the database server). It even gives me the correct results. If I systematically remove a piece at a time from the SELECT portion, I can eventually come up with a working query. But I can't narrow it down to one part in particular. Certain combinations work, and certain ones lead to this consistent crash. I just haven't identified a pattern. I tried dropping the database, then rebuilding it from a txt dump I made from my production version of the database (the Redhat one). Didn't help. The same query causes the same crash in Win95. I'm stumped. Does anyone know of a known issue with Win32 MySQL that would cause this? Is there some way I can re-order my query to avoid this problem? I'm paralyzed, now not being able to run my application in my development environment. Thanks immensely to anyone who can help! - Ken - 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: deadlock - Innodb Monitor
At 10:48 31/10/2001 -0800, Gisella Saavedra wrote: Hi! Take a look at /mysql/data/mysql.err for to see the output for innodb_monitor. I guess that you need to stop the server, for open this file. Regards, Miguel Heikki, thanks for the reply. Regarding the trace output, My test has been bombarding the db server with 15 simultaneous clients, each generating up to 1000 transaction sets. I still do not get any output from Innodb Monitor. I created table innodb_monitor in the database that I'm accessing. Should it be created instead in the database mysql?? Is there any sample that I can look at regarding avoiding deadlock, like for the semaphore rows, and the predefined order of accessing tables that you mentioned? Thanks, Gisella - 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: deadlock - Innodb Monitor
At 22:52 31/10/2001 +0200, Heikki Tuuri wrote: Heikki, For you to have at the shell prompt the output is necessary the command: mysqld-max-net --standalone --console Like I show below: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. C:\cd\mysql\bin C:\mysql\binmysqld-max-nt --standalone --console 011031 19:08:59 InnoDB: Started mysqld-max-nt: ready for connections = 011031 19:11:05 INNODB MONITOR OUTPUT = -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 4, signal count 4 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 4, OS waits 2; RW-excl spins 2, OS waits 2 TRANSACTIONS Purge done for all trx's with n:o 0 1795, undo n:o 0 0 Total number of lock structs in row lock hash table 0 FILE I/O I/O thread 0 state: wait windows aio for n pages I/O thread 1 state: wait windows aio for n pages I/O thread 2 state: wait windows aio for n pages I/O thread 3 state: wait windows aio for n pages Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 61 OS file reads, 3 OS file writes, 0 OS fsyncs 0.48 reads/s, 0.02 writes/s, 0.00 fsyncs/s - INSERT BUFFER - Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges --- LOG --- Log sequence number 0 49463 Log flushed up to 0 49463 Last checkpoint at 0 47975 0 pending log writes, 0 pending chkp writes 8 log i/o's done, 0.06 log i/o's/second -- BUFFER POOL AND MEMORY -- Total memory allocated 112635463; in additional pool allocated 177568 Free list length 5082 LRU list length 37 Flush list length 10 Buffer pool size 5120 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 36, created 1, written 0 0.28 reads/s, 0.01 creates/s, 0.00 writes/s Buffer pool hit rate 798 / 1000 -- ROW OPERATIONS -- InnoDB main thread state: sleeping Number of rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s END OF INNODB MONITOR OUTPUT Regards, Miguel Gisella, Heikki, I looked at the mysql error log and all the stuff was there. I was expecting it on the standard output as the documentation said. it should come to the standard output. I am sending a copy of this email to Miguel of MySQL AB. He should check why mysqld started as --standalone redirects stdout to mysql.err. When mysqld is run as a service it should go to mysql.err, but not when run as standalone. By the way, are you sure you did not have two mysqlds running in your computer? What does the processlist in the Task Manager say? Thanks again. I'll have to restart the server again since the innodb monitor output on the error log says that I'm not running a debugable version, so there is no information about locking. So, I should issue It actually means 'no information about semaphore locking'. You will get the user lock info with innodb_lock_monitor not with plain innodb_monitor. mysqld-max-nt --debug --standalone Nothing was printed on stdout when I issued mysqld-max-nt --standalone Gisella Regards, Heikki -- 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: deadlock - Innodb Monitor
At 13:50 31/10/2001 -0800, Gisella Saavedra wrote: Gisella, The 3.23.xx tree wasn't compiled with flag for to shows the semaphores section. The sample I sent was using the 4.0.0-alpha release. Why you don't try this release ? Regards, Miguel Miguel Heikki, I tried mysqld-max-nt --standalone --console and now get the output on stdout, and mysql.err is not created. BUT I still get the message non-debug version under the SEMAPHORES section. Gisella -Original Message- From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 1:15 PM To: Heikki Tuuri; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Gisella Saavedra Subject: Re: deadlock - Innodb Monitor At 22:52 31/10/2001 +0200, Heikki Tuuri wrote: Heikki, For you to have at the shell prompt the output is necessary the command: mysqld-max-net --standalone --console Like I show below: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. C:\cd\mysql\bin C:\mysql\binmysqld-max-nt --standalone --console 011031 19:08:59 InnoDB: Started mysqld-max-nt: ready for connections = 011031 19:11:05 INNODB MONITOR OUTPUT = -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 4, signal count 4 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 4, OS waits 2; RW-excl spins 2, OS waits 2 TRANSACTIONS Purge done for all trx's with n:o 0 1795, undo n:o 0 0 Total number of lock structs in row lock hash table 0 FILE I/O I/O thread 0 state: wait windows aio for n pages I/O thread 1 state: wait windows aio for n pages I/O thread 2 state: wait windows aio for n pages I/O thread 3 state: wait windows aio for n pages Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 61 OS file reads, 3 OS file writes, 0 OS fsyncs 0.48 reads/s, 0.02 writes/s, 0.00 fsyncs/s - INSERT BUFFER - Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges --- LOG --- Log sequence number 0 49463 Log flushed up to 0 49463 Last checkpoint at 0 47975 0 pending log writes, 0 pending chkp writes 8 log i/o's done, 0.06 log i/o's/second -- BUFFER POOL AND MEMORY -- Total memory allocated 112635463; in additional pool allocated 177568 Free list length 5082 LRU list length 37 Flush list length 10 Buffer pool size 5120 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 36, created 1, written 0 0.28 reads/s, 0.01 creates/s, 0.00 writes/s Buffer pool hit rate 798 / 1000 -- ROW OPERATIONS -- InnoDB main thread state: sleeping Number of rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s END OF INNODB MONITOR OUTPUT Regards, Miguel Gisella, Heikki, I looked at the mysql error log and all the stuff was there. I was expecting it on the standard output as the documentation said. it should come to the standard output. I am sending a copy of this email to Miguel of MySQL AB. He should check why mysqld started as --standalone redirects stdout to mysql.err. When mysqld is run as a service it should go to mysql.err, but not when run as standalone. By the way, are you sure you did not have two mysqlds running in your computer? What does the processlist in the Task Manager say? Thanks again. I'll have to restart the server again since the innodb monitor output on the error log says that I'm not running a debugable version, so there is no information about locking. So, I should issue It actually means 'no information about semaphore locking'. You will get the user lock info with innodb_lock_monitor not with plain innodb_monitor. mysqld-max-nt --debug --standalone Nothing was printed on stdout when I issued mysqld-max-nt --standalone Gisella Regards, Heikki -- 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano
Re: DATA DIRECTORY bug on Win32
At 14:24 24/10/2001 +0400, Mike Blazer wrote: Hi Mike, Thanks for the bug report. The explanation why the insert command doesn't works on Win32, is because the link file pointing for the DATA DIRECTORY wasn't created in the create table command, like the Unix version does. The Win32 OSs don't have a native symbolic link feature and the today symbolic link support on Win32 is made creating a plain text file with the extension *.sym on \data directory and contains the path of the whole database. Then DATA DIRECTORY feature should be handled in a different way on Win32 than is made on Unix. Regards, Miguel Hello guys! I'm sorry to report a small problem with the newest MySQL-4.0.0 that looks like a bug for me. This is a very-very nice and awaited feature DATA/INDEX DIRECTORY in the CREATE TABLE statement. On my Win95 it creates .MYD file but immediatelly fails in the 1st INSERT statement reporting g:\mysql-4.0.0\binmysqlc ranks G:\_patrick\test1.sql ERROR 1105 at line 32: File '.\ranks\test1.MYD' not found (Errcode: 2) Line 32 is the first INSERT. I tried to import an SQL file with CREATE TABLE test1 ( ... )TYPE=MyISAM MAX_ROWS=4294967295 PACK_KEYS=1 DATA DIRECTORY=G:\\mysql-4.0.0\\data\\r2; INSERT INTO test1 VALUES ('referer - pages per visitor',998092800,1,1,28,38,6,26); etc. The file was created by mysqldump - so, no errors, I just added DATA DIRECTORY=G:\\mysql-4.0.0\\data\\r2; Yes, I tried it both in Win32 and forward-slash form like DATA DIRECTORY=G:/temp; same error. And it kinda could not understand any relative path at all DATA DIRECTORY=./r2; gives ERROR 1103 at line 11: Incorrect table name './r2' DATA DIRECTORY=r2; gives ERROR 1103 at line 11: Incorrect table name 'r2' In the last two cases even .MYD file has never been created. That's it. Thanks... and many thanks - to all of you at Mysql AB Mike Blazer /Perl developer/ - 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: Problem with WinMySQLAdmin on NT
At 08:31 22/10/2001 -0700, [EMAIL PROTECTED] wrote: Hi! So why won't WinMySQLAdmin work for a different user? The user in the my.ini file does exist in mysql.user with Host='%' and %_priv ='Y'. The error file contains 'MySql: ready for connections' but none of the other tabbed pages have any information. Unlucky the WinMySQLAdmin uses the user which was inserted at first time and with all the privileges granted. When I did the code I assumed the Administrator user is the one to be used. For example if you remove, the my.ini file, the tool should ask for you the name and password to be used. Regards, Miguel Is this a bug or a feature? ^ Martin Austin martin(at)fsc.co.uk Formal Software Construction Ltd+44 (0)29 2064 6084 (direct voice mail) CBTC+44 (0)29 2064 6080 (main office) Senghenydd Road +44 (0)29 2064 7009 (fax) Cardiff, CF24 4AY, UK The views of the author may not necessarily constitute the views of Formal Software Construction Limited. Nothing in this email shall bind Formal Software Construction Limited in any contract or obligation. - 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 2000
At 19:10 18/10/2001 +0200, [EMAIL PROTECTED] wrote: Hi! I am guessing that you are run the client tool called mysql.exe. The servers of MySQL begin with the name mysqld, then you have in your /mysql/bin directory the following servers: mysqld-opt.exe mysqld-max.exe mysqld-nt.exe mysqld-max-nt.exe I recommend you to use the mysqld-max-nt.exe running as service on Win2K. This server has the InnoDB table, which provides you with transaction support and other features, however this tables need some configuration variables. Now, create with the notepad.exe, a file on \winnt\my.ini with the following section and keys: [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=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 Notice above that there are some variables where are specified the size of the data and logs files that InnoDB will creates at the first start. Set them, according with your necessities. Now, create manually the directories for to hold the InnoDB stuff: c:\ibdata and c:\iblogs. Install the server as service, with a DOS prompt shell: \mysql\bin\mysqld-max-nt --install Now start the service: net start mysql If you don't want to use InnoDB tables, your my.ini file should be: [mysqld] basedir=c:/mysql datadir=c:/mysql/data skip-innodb You should notice that the sample above, contains paths that you can modify according with your environment. Regards, Miguel I am a new mysql user. I have been unable to start mysql on my laptop running Windows 2000. Each time I start mysql, I get the following error: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061). I have searched through the archive for earlier mails on this problem. This looks like a known problem that has been there for a long time. Is there a solution? Thanks in advance! Mohamed ** This footnote confirms that this email message has been swept by MIMEsweeper for the presence of known computer viruses. Denne mailen er sjekket for kjente virus, uten at noen ble funnet. http://www.hydrotexaco.no ** - 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: Can't get --DataDir to work on Win2k
At 17:39 17/10/2001 -0500, BD wrote: Hi! For to clarify: the command prompt \mysql\bin\mysqld-max-nt --install should be executed only to install the service, without any order parameter. If you want to run the server, as service the configuration variables, should be made through a configuration file named my.ini at \winnt\my.ini In this file, you create a section called [mysqld] and the keys that you need, for example: [mysqld] basedir=c:/mysql datadir=F:/Apache Group/Apache/htdocs/data How you are running a Max server, if you don't want the InnoDB tables, you need to add the following keys: [mysqld] basedir=c:/mysql datadir=F:/Apache Group/Apache/htdocs/data skip-innodb Otherwise, if you want these tables, create 2 directories for hold the data and log files for InnoDB, e.g:: F:\ibdata and F:\iblogs. Now you should have the following variables as example: [mysqld] basedir=c:/mysql datadir=F:/Apache Group/Apache/htdocs/data innodb_data_file_path = ibdata1:200M innodb_data_home_dir = f:\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = f:\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 = f:\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 Notice that the first time that the server is run, will create the InnoDB files, according with the sizes specified. Now you can start the server, in 2 ways: Like service: mysqld-max-nt --install net start mysql Like standalone: mysqld-max-nt --standalone Of course if you don't want to create, the configuration file, you can run the server, how I did: E:\mysql\binmysqld-max-nt --standalone --datadir=e:\dbdata\data --basedir=e:\mysql --skip-innodb --console mysqld-max-nt: ready for connections Of course that the best way to run the server is as service. Regards, Miguel I'm trying to move some of my MySQL data files to the directory of my apache web server htdocs directory for testing which is on the same machine as MySQL. This is on the same machine and all access is done through http://localhost. So I'm just trying to test it locally. But I'm getting ahead of myself here. I want to use the --DataDir option of mysqld-max-nt to look for the data in the F:\Apache Group\Apache\htdocs\data\ directory. Simple, right? Here's what happens: (BTW, this is a Win2k machine) mysqld-max-nt --datadir=F:\Apache Group\Apache\htdocs\data\ --install mysqld-max-nt: Can't change dir to 'F:\Apache Group\Apache\htdocs\data --install\' (Errcode: 22) 011017 17:24:53 Aborting Now if I remove the trailing slash from ...data\ and use ...data, it comes back with: F:\mysql\binmysqld-max-nt --datadir=F:\Apache Group\Apache\htdocs\data --install mysqld-max-nt: unrecognized option `--install' mysqld-max-nt Ver 3.23.42-max-nt for NT on i32 Yet, if I take off the --datadir option, it recognizes the --install option and runs the server. Does anyone know why this is happening? TIA Brent - 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 3.23.41 fails to install as service on Win 2000 Professional
At 18:39 04/10/2001 +0300, Jari Aalto+mail.linux wrote: Hi! Only to clarify about the configuration files on Windows. MySQL should use either the c:\my.cnf or \winnt\my.ini file. In your case the best option is g:/winnt/my.ini. Regards, Miguel * Sun 2001-09-02 Dmitry Mityugov [EMAIL PROTECTED] mail.default | [+] | I'm using Ver 3.23.41-max-debug for Win95/Win98 on i32 And command mysqld-nt --install Displays error dialog box Failed to install service In Event viewer the messages simply says: The MySql service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in 0 milliseconds: No action. How Can I help to debug this further? I'm always logged in as | Administrator, | and W2k inlcudes service pack 2. | Make sure C:\MYSQL is not encrypted (this is only one possible reason for | this problem from many but it is still fresh in my memory as I had this | problem just yesterday). Unfortunately this cannot be the problem, because I'm running with FAT32 partitions witout any encryption or compression software on the disks. There are no NTFS partitions. The machine contains disk layout for multi-boot system: Win98, Win2000, Debian Linux. Total 200 G c: Win98 d: data e: data f: data g: Win 2000 Professional (g:/winnt) h: /bin/sql/mysql-w2kInstall root + other disks I have put my.cnf to c:/my.cnf, although this does violate the multiboot system, since I don't use C: at all when I'm running Win2000. Running mysqld from command line works ok, but the --install option always fails, no matter what I put into c:/my.cnf. Attached. Is there no way to debug the problem? Does mysql have internal debug options that could collect the call progress in the C++ code? Jari --- MySQL # 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 skip-innodb ansi default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following row if you move the MySQL distribution to another # location basedir = H:\bin\sql\mysql-w2k [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= H:\bin\sql\mysql-w2k\sql_client\MySQL.help client_file= H:\bin\sql\mysql-w2k\MySQL.options history_length=20 database = test queries_root= H:\bin\sql\mysql-w2k\queries last_database_file= H:\bin\sql\mysql-w2k\lastdb - 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: DISTINCT
At 09:57 04/10/2001 +0800, Osman Omar wrote: Hi! Hi, I have a table like this model color - 135 blue 135 red 135 green 235 black 235 green How do I get how many row in each distinct model eg model 135 have 3 color model 235 have 2 color mysql select model, count(color) from product group by model; +---+--+ | model | count(color) | +---+--+ | 135 |3 | | 235 |2 | +---+--+ 2 rows in set (0.00 sec) 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: Prob mysql win2000
At 17:48 25/09/01 +, [EMAIL PROTECTED] wrote: Hi! Are you sure that the server was started ? otherwise: Run the server as standalone disabling the grant tables with the argument --skip-grant-tables. If you aren't able to access the server with the client, maybe you got a corrupted file through the copy between the files systems involved. In this case you should re-install the grant tables on Win2000 and do again the user's privileges. Regards, Miguel Upgraded win98 to win2000. Now unable to log onto mysql as previously did mysql -h localhost -u me -p. Have tried several diff host names to no avail. How can I correct? Frank - 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: command prompt
At 04:03 24/09/01 -0700, John Nyukuri wrote: Hi! I downloaded the installation.zip mysql version onto a windowsNT machine on a network.I installed it as a standalone server unfortunately I am unable to find the command prompt inorder to begin executing commands,can you specify for me the file I should open. After the MySQL server is running, you should use the \mysql\bin\mysql.exe client tool, to execute commands. Regards, Miguel -- For a few bucks, you can save hundreds! Right now, CollegeClub.com members can get a Student Advantage Membership for ONLY $10. Save on everything students want! http://www.collegeclub.com/sacard - 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: Still about WinMySqladmin and MySqlManager
At 22:50 22/09/01 +, [EMAIL PROTECTED] wrote: Hi! Hello again... Sorry I ask again, are there complete tutor about WinMySqladmin and MySqlmanager, expecially to Miguel A. Solarzo Thanks If you want to know how to use the WinMySQLAdmin, you can see the help file at \mysql\bin directory. If you want other information please let me know. Regards, Miguel Regard Feny Soeha --- Runbox Mail Manager - www.runbox.com Online email application - 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 ME
At 17:24 09/09/2001 -0400, Doug V wrote: Hi, Personally I didn't tried on Win ME. However some users had reported it use without problem. To avoid the problem to start without the DOS prompt screen, use WinMYSQLAdmin.exe which you find at \mysql\bin directory. Regards, Miguel Will mysql run on Microsoft's windows ME operating system ? Thank You, Doug V. - 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: Win32 Mysql 3.23.41 will not start anymore
At 16:43 09/09/2001 -0500, Ken Sorenson wrote: Hi, Follow the step below: - Install the MySQL stuff. - Go to \mysql\bin directory with a DOS prompt screen. - Type the command: mysqld-nt-max --remove (Even you don't have the service, this don't provoke any problem). - With the explorer open or create the \winnt\my.ini file - Edit the following keys: [mysqld] basedir= yourdirpath e.g.: c:\mysql datadir= c:\mysql\data skip-innodb If you want to use InnoDB table, read the manual about the variables you need and the directories that you need to create manually. - At the DOS prompt type: mysqld-max-nt --standalone - Take a look in the messages errors that you got. Try to resolve or send me the printed messages. - If you want to use the server as service. Do: mysqladmin shutdown - mysqld-max-nt --install - net start mysql Regards, Miguel I have a V. 3.23.41 sql db installation on Windows 2k server.. Just stopped and refuses to restart.. I have looked at just about everything. Uninstalled and reinstalled, restored backups ... Nothing seem to be working.. Checked through the registry, nothing seems to be off.. Any ideas were to look? It was running fine for over two weeks.. Thanks! Ken - 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 -- can't install mysql as service in win2k
At 08:27 06/09/2001 -0700, Michael Tam wrote: Hi, When you get this type of error, do the following process: - Verify in your SCM the state of the service. You should see that it isn't initiated. - Open a DOS screen at \mysql\bin - Remove the service: mysqld-max-nt --remove - Start the server as standalone: mysqld-max-nt --standalone - Take a look in the message error. Correct them. - Install again the service and start it as usual. Also, before to do the above, you can find the problem in the \mysql\data\mysql.err file. If you aren't able to resolve the problem. Send me the print of the message errors when you start the server as standalone and the last lines from mysql.err. Regards, Miguel Hi all, I have uninstall mysql3.23.39 from Win2k and after I install mysql3.23.41-max ... I was unable to run it as service. When I tried to start the service I receive the following message ... Could not start the MySql service on Local Computer Error 1067: The process terminated unexpectedly. Any idea how I can fix this? Many thanks to any suggestions. Michael - 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: bug report / source compile error
At 10:33 05/09/2001 +0200, abadon wrote: Hi, Hi, I have Windows NT 4.0 (build 1381/SP6a) running IIS4 Webserver ( http://www.abadon.net or 212.30.85.173 ) connected via CableModem/LAN to Internet. I have also PHP ( Version 4.0.6 )scripting engine and MySQL server ( Client API version 3.23.32 said PHP info page, but in WinMySQL admin Ver 1.3 is : Server : 3.23.41-nt Client: 3.23.36 - This means that the server is 3.23.41 release and the WinMySQLAdmin that is the client was compiled with the 3.23.36 library. I will update the libraries for the next release. but It doesen`t matter - MySQL working perfect without any problems or bugs ( info page is: http://212.30.85.173/phpinfo.php with UN info and PW guest, `cause my server is not public, only developing ...). But my problem is: I have downloaded SourceCode for MySQL ( mysql-3.23.41-win-src.zip ), unzip and open workspace with Visual C++ ( part of MS VisualStudio 6 Pro with SP 4 ) and rebuild all - without problem, excepcion one with describe: Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm The name specified is not recognized as an internal or external command, operable program or batch file. Error executing e:\winnt\system32\cmd.exe. This means that you don't have the MS Macro Assembler Compiler in your environment to perform the custom build of strxmov.asm file. In your strings project file you have instructions for the MASM 5.0 and if you don't have it, your options are: - Change the strings.dsp and strings dsw files by the files you find in \strings\NOMASM directory. In this case you won't compile the strings stuff with the assembler. - Get the Masm 6.x from Microsoft and change the custom command. You find instructions about at: http://msdn.microsoft.com/vstudio/sp/vs6sp5/faq.asp - If you have the MASM 6.x: - Right click over the strings project and click Set as Active Project. - Right click again and click Settings. - Open the strings tree. - Click over the Strings.asm file and at right side click the tab Custom Build. In the windows Commands, change the line: masm -Mx -t -DDOS386 -DM_I386 $(InputPath),$(Outdir)\$(InputName).obj,,, by the line below: ml /Cx /nologo /DDOS386 /DM_I386 /Zm /coff /c /Fo $(Outdir)\$(InputName).obj $(InputPath) - Do the same with the file Strxmov.asm. - Change the assembler command for the Win32 debug and release trees. Regards, Miguel mysqld.exe - 1 error(s), 0 warning(s) I haven`t idea what`s that: bug or is something wrong with my machine or IDE ( my knowledge is not so perfect... )... regards ps - I haven`t any problems with other sources codes, like Macromedia SWF flash source, etc sorry to my bad english language... Slevec Brane, Slovenia mailto:[EMAIL PROTECTED] Here is complete log: Deleting intermediate files and output files for project 'heap - Win32 Debug'. Deleting intermediate files and output files for project 'isam - Win32 Debug'. Deleting intermediate files and output files for project 'merge - Win32 Debug'. Deleting intermediate files and output files for project 'mysys - Win32 Debug'. Deleting intermediate files and output files for project 'regex - Win32 Debug'. Deleting intermediate files and output files for project 'strings - Win32 Debug'. Deleting intermediate files and output files for project 'dbug - Win32 Debug'. Deleting intermediate files and output files for project 'zlib - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlclient - Win32 Debug'. Deleting intermediate files and output files for project 'mysql - Win32 Debug'. Deleting intermediate files and output files for project 'mysqladmin - Win32 Debug'. Deleting intermediate files and output files for project 'mysqldump - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlimport - Win32 Debug'. Deleting intermediate files and output files for project 'MySqlManager - Win32 Debug'. Deleting intermediate files and output files for project 'mysqlshow - Win32 Debug'. Deleting intermediate files and output files for project 'libmySQL - Win32 Debug'. Deleting intermediate files and output files for project 'myTest - Win32 Debug'. Deleting intermediate files and output files for project 'thr_test - Win32 Debug'. Deleting intermediate files and output files for project 'replace - Win32 Debug'. Deleting intermediate files and output files for project 'myisam - Win32 Debug'. Deleting intermediate files and output files for project 'myisammrg - Win32 Debug'. Deleting intermediate files and output files for project 'innobase - Win32 Debug'. Deleting intermediate files and output files for project 'bdb - Win32 Debug'. Deleting intermediate files and output files for project 'mysqld - Win32 Debug'. Configuration: heap - Win32 Debug Compiling... _check.c _rectest.c
Re: Error when opening mysqld.exe
At 12:25 03/09/2001 -0500, Deryck Henson wrote: Hi! I get this every time I try to start up MySQLD.exe:: Can't initialize InnoDB as 'innodb_data_file_path' is not set This message is from InnoDB table. If you don't want the InnoDB table, create the /windir/my.ini with the section and key below: [mysqld] skip-innodb Otherwise if you want the InnoDB table, take a look in the Manual how to set the InnoDB variables in the my.ini file before the start. Regards, Miguel Someone help. Thnx! - Deryck H - http://www.comp-u-exchange.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: Building on Win32
At 08:02 23/08/2001 -0400, [EMAIL PROTECTED] wrote: Hi! Are instructions available for building the MySQL source tree on a Win32 platform for a Win32 target? Not yet. However here the basic steps. Minimal Requirements: - VC++ 6.0 compiler - MySQL source distribution: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.41-win-src.zip Optional Requirements (recommended) - The MS macro compiler 5.0 (masm.exe) or 6.x (ml.exe). If you don't have either the Masm 5.x or Masm 6.x you can obtain the last one from Microsoft according with the instructions in the URL below: http://msdn.microsoft.com/vstudio/sp/vs6sp5/faq.asp Notice that you need to download the Service Package 4 or 5 and the Macro Assembler Package. Also after the update verify, if you need to set again the environment paths for Visual Studio. - Set the macro assembler in the environment path. Building the MySQL Stuff - Create a work directory (e.g.: workdir). - Unpacked the source distribution in the above directory. - Run the VC++ 6.0 compiler. - Using the Menu File. Click on Open Workspace. - Open the mysql.dsw Workspace that you find on the work directory. - Preparing the strings.lib compilation - If you don't have any macro assembler or you don't want to use it, close the workspace, using the explorer go to \workdir\strings\NoMASM directory and copy the strings.dsp and strings.dsw files and rewrite the ones them on \workdir\strings directory. After this repeat the steps before and go ahead. - If you have the MASM 5.x, do nothing. Go ahead. - If you have the MASM 6.x: - Right click over the strings project and click Set as Active Project. - Right click again and click Settings. - Open the strings tree. - Click over the Strings.asm file and at right side click the tab Custom Build. In the windows Commands, change the line: masm -Mx -t -DDOS386 -DM_I386 $(InputPath),$(Outdir)\$(InputName).obj,,, by the below line: ml /Cx /nologo /DDOS386 /DM_I386 /Zm /coff /c /Fo $(Outdir)\$(InputName).obj $(InputPath) - Do the same with the file Strxmov.asm. - Change the assembler command for the Win32 debug and release trees. - Now from the Build menu, select the Set Active Configuration menu. - Clicking over the screen select mysqld - Win32 Debug and click Ok. - Press F7. To begin the build of the debug server and libs and some client applications. - When the compilation finish, copy the libs and the executables for a separate directory. - Compile the release versions that you want, in the same way. - Create the directory for the MySQL stuff: e.g. c:\mysql - From the workdir directory copy for the c:\mysql directory the following directories: - Data - Docs - Share - Create the directory c:\mysql\bin and copy all the servers and clients that you had compiled before. - If you want create also the lib directory and copy the libs that you had compiled before. - Make a clean using the Visual Studio. Only this. Regards, Miguel - 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: Building on Win32
At 19:51 23/08/2001 -0400, [EMAIL PROTECTED] wrote: Thanks for the info. You refer to file mysql.dsw for the 3.23.41 distribution. Yes. Just now I am working in the 4.0 tree. When I finished it I will send an e-mail for our lists, how to do. Regards, Miguel I was specifically interested in building the 4.0 distribution downloaded using BitKeeper. There is no mysql.dsw file in that source tree. The only workspace file is mysql-4.0/bdb/build_win32/Berkely_DB.dsw. Is that the file to use and are the build instructions the same? Thanks. - 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: Problem with user rights
At 14:01 2001-08-22 +0200, Yarek wrote: Hi I wanted to install MySQL under Windows 2000 with default-charset=latin2. I cannot use binary distribution because it is not compiled with this charset. So, I loaded and compiled source for MySQL 2.3.41 under Cygwin (Win32, POSIX compatible). I received no errors. My problem is, that I can run /usr/mysql/bin/mysql but I cannot do anything more because I have no user rights for it. I launched /usr/mysql/bin/safe_mysql -u mylogin. When you have a fresh installation, there is an user for localhost with all the rights, this is for you do the users rights with an easy way, then you only need to run the mysql.exe client without any user and password, how I show you below: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. d:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.41-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Regards, Miguel I changed mylogin to other users on my workstation. All in vain. :( -- Yarek - 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: Cannot build with C++
At 11:50 2001-08-21 +0200, ARAKON wrote: Hi! Try to put the header windows.h before mysql.h and add the header for the winsock if you are using it. Regards, Miguel i'm using mysql 3.23.40 for windows, when i try to build one very simple application, it shows me that error: e:\pere\mysql 3.23.40 server\include\mysql_com.h(115) : error C2146: syntax error : missing ';' before identifier 'fd' e:\pere\mysql 3.23.40 server\include\mysql_com.h(115) : error C2501: 'SOCKET' : missing storage-class or type specifiers e:\pere\mysql 3.23.40 server\include\mysql_com.h(115) : error C2501: 'fd' : missing storage-class or type specifiers The line it marks is: typedef struct st_net { Vio* vio; my_socket fd;/* For Perl DBI/dbd */ int fcntl; unsigned char *buff,*buff_end,*write_pos,*read_pos; char last_error[MYSQL_ERRMSG_SIZE]; unsigned int last_errno,max_packet,timeout,pkt_nr; unsigned char error; my_bool return_errno,compress; my_bool no_send_ok; /* needed if we are doing several queries in one command ( as in LOAD TABLE ... FROM MASTER ), and do not want to confuse the client with OK at the wrong time */ unsigned long remain_in_buf,length, buf_length, where_b; unsigned int *return_status; unsigned char reading_or_writing; char save_char; } NET; I've tried to cancel it marking as comment, but compiler still searches it (i cannot understand it, but it does, when marked with // or /* as a comment, there's also the error) The cpp i'm trying to compile is this: #include stdio.h #include mysql.h #include windows.h //NULL siempre mayusculas #define def_host_name NULL //host al que conectamos, predeterminado localhost #define def_user_name NULL //nombre de usuario, predeterminado el propio #define def_password NULL //contraseña, predeterminada ninguna #define def_db_name NULL //base de datos a usar, predeterminada, ninguna. MYSQL* conn;//puntero al manejador(estructura) de conexion //global para evitar desconexion al salir de una funcion int main(int argc, char *argv[]){ conn=mysql_init(NULL); //inicializa la estructura conn mysql_real_connect( //establece la conexion con el server conn, //puntero al manejador de conexion def_host_name, //host al que conectar def_user_name, //nombre de usuario def_password, //password del usuario def_db_name,//base de datos a usar 0, //puerto de conexion,0=usar predeterminado NULL, //socket, usamos predeterminado 0); //modificadores, no usamos ninguno mysql_close(conn); //cierra la conexion apuntada por el manejador de conexion return 0; } As you can see, i'm just learning sql, and i was trying to connect from C. I'm sure that error is in my_socket, that's not a class nor var of program, and i've not found it anywhere, but i don't know the correct word. Help me plz. Thanks in advance. Pere ___ Consigue tu e-mail gratuito TERRA.ES Haz clic en http://www.terra.es/correo/ - 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: MSAccess -- MySQL - append query slows, then dies
At 15:45 2001-08-22 -0400, Ide, James J Mr CMH/LGB wrote: Hi! My guess is that the append query is too much heavy for Access, then try to emigrate the data (if possible) using filter on the append query to make it with several steps. Other option is to use, other goods clients programs that you find in our contribution page. Regards, Miguel My setup: Dell PowerEdge 4200 with 512 mb ram, plenty of free disk space WinNT Server 4.0 with sp6 MS Access 97 MySQL 3.23.38-nt (installed binany from mysql-3_23_38-win.zip) MyODBC 2.50.38 (installed from myodbc-2_50_38-nt.zip) My objective: Copy data from two large MS Access 97 to MySQL tables. The structure of the two Access tables is identical. Both have about 100 fields, of which 20 are MEMO. One table has about 60,000 rows, and the other has about 500,000 rows. How I'm doing it: The server is running standalone (ie. it is not connected to a network, and I am the only user). I have run 'compact' and 'repair' on the Access database file. I have installed MySQL and MyODBC according to the directions. I have created an Access Append query which copies all columns from the Access table to the MySQL table. Note that MS Access and MySQL are running on the same machine. The problem: When I run the Append query, the query starts appending rows from the Access table to the MySQL table as expected. I have an MS-DOS window open with 'mysql' (the command line utility) running, and I occasionally type 'select count(*) from TheTable;'. The count increases steadily, generally appending 200-300 records per second. Without warning, the number of records appended per second suddenly drops to about 1-2 and stays at this rate. If I start up the NT Task Manager, it reports the CPU usage at 0-3%, and lists the status of task 'Microsoft Access' as 'Not Responding'. Nothing changes after 10-20 minutes, so I type 'drop table TheTable;' , re-create an empty MySQL table, and run the Append query again. The point at which the Append query slows to a crawl varies - sometimes immediately, sometimes part way through the append, and on _rare_ occasions, the query will finish successfully. I have tried this with MySQL running on Linux and OpenBSD, and I get the same result, so I'm confident that the problem is not with MySQL. Any ideas? Thanks - Jim - 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: Explanation: Problems with MYSQL-D-MAX for win 98 DROP TABLE
At 08:52 16/08/2001 +0200, Luciano Pulvirenti wrote: Hi! Sorry but I wasn't able to repeat the bug reported. However I did my tests with the DOS mysql client and others GUI clients, since the Mascom trial package that I have denied the start on my Win9x machines, so I assume you have an environment issue or Mascom behavior. Regards, Miguel I will try of to be clearer. Operating system: WIN98 Version of Mysql 3.23.40 EXE : Mysql-d-max I create a table of example. Create table test ( Field1 tinyint not null ) type=BDB The table is created regularly. The statement DROP TABLE testresponds Error 1051 - Unknown table test The only way to delete the table is: alter table test , type=MyISAM DROP TABLE test The tests have been effected with Mascon. - 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: BDB and InnoDB in windows nt versions
At 11:50 17/08/2001 +0100, Bruce Scharlau wrote: Hi! Thanks for the input Heikki, I got it the right version mysql-max-nt going now. The problem was that winmysqladmin automatically started the wrong service- mysqld - so I had to uninstall that service before it would recognise any changed I made in the my.ini file done with winmysqladmin. Now I can use bdb, and show variables gives InnoDB as disabled. I've tried setting up the InnoDB variables in winmysqladmin like this, but the server won't start: [mysqld] basedir=C:/mysql #bind-address=139.133.200.222 datadir=C:/mysql/data language=C:/mysql/share/english #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M # startup parameters for InnoDB tables innodb_data_file_path = ibdata1:5M You need to use a data file = 10 MB and = 2GB Stop the server. Delete all the files from ..\ibadata and ..\iblogs. Change the value above and restart the server. Regards, Miguel innodb_data_home_dir = C:\mysql\data\bruce\ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = C:\mysql\data\bruce\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=5M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:\mysql\data\bruce\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 I created all the directories mentioned, but something is preventing it working. If I comment out the InnoDB lines mysql starts. Thanks in advance. At 03:16 PM 8/16/2001 +0100, you wrote: Hi all, I'm trying to work out which distribution of mysql supports BDB or InnoDB tables. I've downloaded 3.23.40 and checked 'show variables' asnd it says these tables are not supported. I know the docs say they should be available in the distro, but it seems not in this version. So, who can tell me which one does? Cheers, Bruce - 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 Cheers, Dr. Bruce A. Scharlau Dept. of Computing Science Aberdeen University Aberdeen AB24 3UE [EMAIL PROTECTED] 01224 272193 - 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: WinMySQLAdmin 1.0
At 09:40 14/08/2001 -0600, Dan Haynes wrote: Hi! This problem will be fixed in the next release Win32 3.23.41. Instead of integer will use float number and a handle exception to avoid the box message error when a not valid value is retrieved from the server. Regards, Miguel Having trouble with e-mail servers this morning and not sure if my subscription request made it. If this has been reported already or is the incorrect mailing list for this issue, please excuse and point me in the right direction. Had a internet connection failure last night and due to what appears like it could be a bug in YATS32, it set the clock on my server ahead by about 3500 seconds every hour, putting my real time clock into na-na land. The server thought it was Aug 17th. This server also happens to run the mySQL server. I corrected the internet connection problem and rebooted the machine. It got hold of the time host and everything is back to normal except that now I have dozens and dozens of system message windows from WinMySQLAdmin 1.0 saying: '4294683874' in not a valid integer value. Where the number is a constantly decreasing value. A new message is created every server query interval time, which by default is ten seconds. It seems that WinMySQL Admin doesn't like calculating server up time backwards and it never corrects itself. Needless to say this results in a lot of system message dialog boxes marching across the screen if one doesn't sit there and dismiss them as they pop up! :\ I set the server query interval to 5000 seconds and I'm hoping that it will correct itself when Friday rolls around. If anyone knows any magic registry manipulation I could safely do to correct this before Friday, I'd appreciate any pointers to FAQ entries or whatever. Thanks in advance, Dan Haynes - 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: HOWTO enable InnoDB
At 19:27 10/08/2001 +0900, =?euc-kr?B?vcnD5rq4?= wrote: Hi! Are you set the my.cnf file for the InnoDB variables and created the data and log directories before the start of the server ?. Take a look in the server_name.err file if you find the message of InnoDB mentioning that wasn't be able to init the database. If true, read the Manual about. Regards, Miguel Hi everyone. I uninstalled mysql and reinstalled using --with-innodb configuration. After install completed, I entered the command mysqladmin variables and found that value of have_innodb is DISABLED. So when I create table with type=InnoDB, this table has type=MyISAM. That is failure to create InnoDB type table. Mysql version is 3.23.40. Please answer to me. Thanks in advance!! - 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: missing setup.dll
At 18:29 04/08/2001 +0300, Hiba Muhrez wrote: Hi, When you unzipped the 3.23.40 distribution file you should have the following files: 02/08/2001 00:31 128 DATA.TAG 02/08/2001 00:31 11.535.662 data1.cab 30/05/1997 11:314.557 lang.dat 02/08/2001 00:31 386 layout.bin 06/05/1997 14:15 417 os.dat 08/02/2001 04:07 62.646 SETUP.BMP 19/11/1997 16:09 59.904 SETUP.EXE 02/08/2001 00:31 90 SETUP.INI 14/06/2001 03:56 57.122 setup.ins 02/08/2001 00:31 49 setup.lid 19/11/1997 16:05 300.178 _INST32I.EX_ 19/11/1997 16:058.192 _ISDEL.EXE 19/11/1997 16:08 11.264 _setup.dll 02/08/2001 00:31 186.302 _sys1.cab 02/08/2001 00:31 45.137 _user1.cab Compare the size with your ones. If you see different sizes, means that your download got a corrupt file. Regards, Miguel please, i downloaded the mysql 3.23 from your site and i made the unzip and when i begin to make setup i found error: missing setup.dll what can i do? please reply fast mailto:[EMAIL PROTECTED][EMAIL PROTECTED] yasmeen - 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: Fwd: Re: win32 build process docs (was: Re: Why can't I compile the mysql workspace?)
MySQL with MASM 6.xx. I got to the point where it actually seems to assemble the asm files just fine, but the assembler invokes linker with garbage for options, and the link fails. The problem is with the linker that comes with MASM because it can do file/directory names which contain spaces. The updates in SP3 overcome this problem I include a mail I sent to Miguel Angel Solórzano, I haven't heard from him since then, but maybe you can figure it out. At 20:59 27.2. 2001, Miguel Angel Solórzano wrote the following: -- At 20:37 27/02/2001 +0100, you wrote: Hi! Hi Miguel, thanks for the reply. I will eventually go that route, but would nevertheless like to compile MySQL with the ASM code. Can you tell me where can I get MASM if not from the Processor Pack package? Microsoft Product Catalog entry for MASM at http://www.microsoft.com/catalog/display.asp?subid=22site=10547 links to Macro Assembler 6.15 Web Site at http://msdn.microsoft.com/vstudio/downloads/ppack/default.asp which is titled Visual C++ 6.0 Processor Pack, and I have already downladed and installed it. I thought that the macro assembler package is a commercial product and not a free package. Anyway if you have it on hands, install the masm package for example at c:\masm. Open the strings tree and complete the setting of the *.asm files adding to the command of the Custom Build the path: c:\masm\masm -Mx... I am using the version 5.10, so I can't to say you if exists any problem to compile our stuff with the new version. Hi Miguel, Microsoft both sells and gives away MASM. The free version is, of course, stripped down a bit, but AFAICT not in a way so as to render it useless with regards to compilation of MySQL: http://www2.dgsys.com/~raymoon/faq/masm.html#9 9.2 WHAT THIS MASM IS NOT This is not the same as purchasing MASM product. The linker is 32 bit and will not create 16-bit DOS programs. Also, the Programmers Work Bench nor CodeView for debugging are included in the full DDK. NOTE: The linker that comes with the DDK will not produce 16-bit applications for DOS. To do this, you must have Microsofts Linker version 5.63 that is available from Microsofts FTP site. BTW, the Processor Pack I installed contains MASM (or should I rather say ml.exe?) v 6.15. I poked around the web some more, and found the following info: The MASM program converts command-line options from MASM style to ML style, adds options to maximize compatibility, and calls ML.EXE. Note MASM.EXE is provided to maintain compatibility with old makefiles. For new makefiles, use the more powerful ML driver. Well, the free version doesn't contain masm.exe, only ml.exe. Looks like ml supercedes masm. I changed the custom build steps for strings/strings.asm and strings/strxmov.asm to reflect ml's parameter syntax, i. e. masm -Mx -t -DDOS386 -DM_I386 $(InputPath),$(Outdir)\$(InputName).obj,,, = ml -Cx -Zm -nologo -DDOS386 -DM_I386 $(InputPath) $(OutDir)\$(InputName).obj and got this: Configuration: strings - Win32 Release Performing Custom Build Step on .\Strings.asm Assembling: .\Strings.asm Microsoft (R) Incremental Linker Version 6.00.8447 Copyright (C) Microsoft Corp 1992-1998. All rights reserved. /z2 Strings.obj+ .\release\Strings.obj Strings.exe NUL LINK : warning LNK4044: unrecognized option z2; ignored LINK : fatal error LNK1181: cannot open input file Strings.obj+ Error executing c:\winnt\system32\cmd.exe. mysqld-nt.exe - 1 error(s), 1 warning(s) Note the + sign appended to strings.obj name. I'm not faimiliar with VS enough to solve this. If this is solved, people interested in building MySQL on win32 machines will be able to benefit from the assembler code without the need to buy the commercial version of MASM. And that would be a Good Thing(tm), IMO. BTW, the -Zm option is required for compatibility with MASM 5.x, otherwise it emits A2032 on these lines (except ecx,P+SIZEPTR*2[ebp] is actually A2026): mov edi,P-SIZEPTR[esp] ;p1 mov edi,P-SIZEPTR[esp] ;to mov edi,P-SIZEPTR[esp] ;p1 mov edi,P-SIZEPTR[esp] ; str mov edi,P-SIZEPTR[esp] ; s1 mov ecx,P+SIZEPTR*2[ebp]; Length of memory-area mov edi,P-SIZEPTR[esp] ; EDI - s1 (see http://support.microsoft.com/support/kb/articles/Q119/8/72.asp) The index operator '[]' is now at the very top of the MASM operator precedence list, while the binary + and - operators are in the lower half. HTH, Cynic At 00:39 15.3. 2001, Jorge del Conde wrote the following: -- Hi, You need to have MASM installed. The easiest way to compile mysql in windows is to copy all the files from mysql\strings
Re: mysql-max-nt, missing files in the intel/windows distrib
At 15:09 30/07/2001 -0500, steph wrote: Hi, The 3.23.39 distribution was substituted by 3.23.39a because the setup program doesn't rewrite the share directory. That is the reason for your error message. To fix: stop the server, remove the share directory and run again the setup program. Regards, Miguel Hello, I am working on a windows 2000 server, SP 1. Until now, I used mysql 3.23. 2? with no problem I just downloaded 3.23.39 max, I stop the mysql service, then I installed it in the same directory: c:\mysql Last, I tried to start again the service (so mysqld-nt.exe) But it doesn't want to start, with no error message Then, I used winmysqdadmin to change it to mysqld-max-nt. I tried also the mysqld-max-nt --remove mysqld-max-nt --install -- that works well but mysqld-max-nt doesn't show me anything, and mysql is not running. finally, I tried: mysqld-max-nt --standalone And I got: mysqld-max-nt: Fatal error: Error message file 'c:\mysql\share\english\errmsg.sy s' had only 198 error messages, but it should have at least 208 error messages. Check that the above file is the right version for this program! I checked the last time this file has been changed, and it was 6 months ago, so it seems that these files are missing in the binary? By the way, in the binary distribution, there is no mysqlbug program I would appreciate your help Stephane - 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 Crash with show logs queries
At 23:21 13/07/2001 -0300, Gustavo Vieira Gonçalves Coelho Rios wrote: Hi, Thanks for the bug report. I was be able to repeat and the issue should be fixed in the next release. Regards, Miguel Description: MySQL Daemon crashes when a user with the necessary privileges issue a query show logs How-To-Repeat: Start your daemon with the option --skip-bdb: your-shell safe_mysqld --skip-bdb Then, issue a show logs using mysql utility, for instance. Fix: MySQL admins: don't use the --skip-bdb option when starting the daemon. MySQL Developer: Be more carefull when coding (How much would i have to pay - since mysql is free - to get this advice seen) I'll be waiting for some feedback (Not only developer but the user comunity too) Submitter-Id: submitter ID Originator:Gustavo Vieira Gonçalves Coelho Rios Organization: Ifour Sistemas. MySQL support: none Synopsis: MySQL Crash with show logs queries Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.39 (yes) Environment: System: FreeBSD etosha.ifour.com.br 4.3-STABLE FreeBSD 4.3-STABLE #1: Tue Jul 10 04:36:12 BRT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/ETOSHA i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 [FreeBSD] 20010315 (release) Compilation info: CC='cc' CFLAGS='-O -pipe -march=pentiumpro' CXX='c++' CXXFLAGS='-O -pipe -march=pentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1187948 10 Jul 04:17 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 10 Jul 04:17 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 574912 10 Jul 04:17 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --with-comment --with-raid --with-berkeley-db --with-innodb --enable-assembler --with-berkeley-db --prefix=/usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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: Unable to install mysql version 3.23.39a (min) on a Win2000P work station.
At 14:54 09/07/2001 -0400, Khuon, Dave wrote: Hi, Please, read the Manual \mysql\docs\manual.html section 8.7.2 InnoDB startup options. Regards, Miguel I recently downloaded the latest MYSQL version 2.23.39a (from page http://www.mysql.com/downloads/mysql-3.23.39a.zip), and installed it as directed by the instructions: * install directory: c:/mysql, * datadir: c:/mysql/data, * and created the config file: c:/my.cnf (see below). When I typed to start mysql: mysqld --standalone, I got error (see below), and the DOS session hangs. My workstation is a Thinkpad 760ED, running Win2000 Professional, SP2. Please help. Error: Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. U:\c: C:\cd mysql C:\mysqlcd bin C:\mysql\binmysqld --standalone Can't initialize InnoDB as 'innodb_data_file_path' is not set File: c:/my.cnf # 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 password=my_password port=3306 #socket=MySQL 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 socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ basedir=c:/mysql/ datadir=c:/mysql/data/ [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 Bin Dir: Directory of C:\mysql\bin 07/09/2001 11:59a DIR . 07/09/2001 11:59a DIR .. 06/13/2001 07:40p 1,101,824 mysqld-opt.exe 06/13/2001 08:10p 1,880,064 mysqld-max.exe 06/13/2001 07:15p 1,880,064 mysqld-max-nt.exe 06/13/2001 06:40p 1,101,824 mysqld-nt.exe 06/13/2001 01:55p 2,756,653 mysqld.exe 06/13/2001 08:54p 262,144 isamchk.exe 06/13/2001 08:51p 323,584 myisamchk.exe 06/13/2001 08:55p 253,952 myisamlog.exe 06/13/2001 08:43p 249,856 myisampack.exe 06/13/2001 06:25p 266,289 mysql.exe 06/13/2001 06:25p 229,376 mysqladmin.exe 06/13/2001 08:50p 208,896 mysqlbinlog.exe 10/30/1998 02:06a 334,712 mysqlc.exe 05/12/2001 01:13a 221,184 mysqlcheck.exe 06/13/2001 06:25p 229,376 mysqldump.exe 06/13/2001 06:25p 217,088 mysqlimport.exe 06/13/2001 06:26p 512,000 MySqlManager.exe 06/13/2001 06:26p 221,184 mysqlshow.exe 06/13/2001 08:48p 28,672 mysqlshutdown.exe 06/13/2001 08:49p 32,768 mysqlwatch.exe 06/13/2001 08:56p 217,088 pack_isam.exe 06/13/2001 08:58p 139,264 perror.exe 06/13/2001 06:28p 159,744 replace.exe 06/19/2000 03:51a 818 winmysqladmin.cnt 04/18/2001 08:18p 1,168,896 winmysqladmin.exe 06/19/2000 03:52a 1,856,816 WINMYSQLADMIN.HLP 26 File(s) 15,854,136 bytes 2 Dir(s) 108,232,704 bytes free C:\mysql\bin Regards, Dave Khuon Electronic Data Systems E.Solution 1900 Springer Road Lombard, Illinois, 60148 * +1 (312) 419-7984 (8*539) Fax +1 (312) 345-5057 (8*539) * [EMAIL PROTECTED] ...OLE_Obj... - 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: Hi,sir.I have a question!
At 16:11 06/07/2001 +0800, rqhuang wrote: Hi, I would like to ask you a favour for to make a test when you not are able to stop the slave. There is a tool called NETWATCH.EXE from Microsoft to be used on Win9x machines, this tools it isn't installed by the default and you can find instructions how to install it at: http://msdn.microsoft.com/library/en-us/dnwinpro99/html/netwatch.asp Please see if the tool identifies the thread from the slave and try to remove the thread. Send for us the results of this test. Regards, Miguel Hi,Sir I encounter a problem while using mysql. My Mysql version is Mysql 3.23.38! I'm in WindowsMe system. I encouter a problem in Replication. I set master/slave replication according to the manual in your website(chapter 11).It works, but I have trouble to stop the slave thread. I set the server not to start the slave on the startup.At a certain time, I use slave start to start the slave. I can properly start and load updates from the master. but if I use slave stop command in mysql, it takes quite a long time to stop the slave thread.It takes more than 20 minutes, some times it even not any response. I'm in a lan, I wander why it takes so many time to stop the slave thread I check the processlist, the state is always waiting for slave to stop. I wonder how to accelerate the speed of stopping master/slave replication. thx ¨¨¡î¨¨¡î¨¨ ËÍÐÇÐÇǧ°Ù¿Å... rqhuang ¨¡î¡î¡î¡î¡î¡î¨ ¨¨¡î¡î¡î¡î¨¨ ÉúÃü»îµÃ¾«²Ê²ÓÀÃ... [EMAIL PROTECTED] ¨¨¨¡î¡î¨¨¨ ¨¨¨¨¨¨¨¨ Ô¸Äã¿ìÀÖ ^_^01-7-6 15:28:57 - 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 subdir for database
At 12:10 05/07/2001 +0800, Jaime Teng wrote: Hi, You can simulate the symbolic link on Windows using the today Win32 MySQL 3.23.39 distribution. You have in this distribution the following Max MySQL servers: 1- mysqld.exe the debug version. 2- mysqld-max.exe the optimized version for Win9x and NT/Win2k. 3- mysqld-max-nt.exe the optimized version for NT/Win2k with support for named pipes. The Max stuff besides the support of symbolic links has the support of transactional tables InnoDB and BDB. Below the instructions how to use the symbolic link. Notice if you don't want the support of InnoDB and BDB tables un comment the variables skip-innodb and skip-bdb. Otherwise read the item 8.7.2 InnoDB startup options of the \mysql\docs\Manual.html. 1- Create the configuration file c:\my.cnf or \windir\my.ini.file. 2- Edit the configuration file: [mysqld] basedir=c:/mysql datadir=c:/mysql/data use-symbolic-links #skip-innodb #skip-bdb Notice that in the sample above, you have the grant tables on c:\mysql\data. If you want to have all the databases on d:\ecom, so you don't need to use symbolic link, you only need to move the all c:\mysql\data\mysql directory to d:\ecom\mysql and modify the variable datadir=d:/ecom. Now assuming that you want a database called mylink on d:\ecom. First create on c:\mysql\data directory a file called mylink.sym. Edit this file with the text: d:\ecom\mylink Create the directory d:\ecom\mylink Regards, Miguel Hi, I have mysql on NT4 (soon to be win2000). one question is that the database files all reside under drive c. NT does not have symbolic link is there a way to tell mysql that a particular database is located on a different folder? where is the documentation for this one? jaime - 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: Unlock tables when process has killed.
At 14:09 05/07/2001 +0300, Nick Kostirya wrote: Hi Nick, One more thing: the client application is running locally in the same computer of the MySQL server or remotely connected ?. What type of table you are using: MyISAM, BDB or InnoDB. Regards, Miguel Thanks, Miguel. I understand. If after killing a process, program of this process come to the end incorrectly (fail), then the table remains locked. Something like have than mysql.exe after killing process don't touch. Other mysql.exe will wait for this process killed, but it doesn't kill while mysql.exe executed. Sorry for my English. Nick. At 12:26 05/07/2001 +0300, Nick Kostirya wrote: Hi! Nick I have interest how you did the lock and how the table remains locked on NT. Below I show you a sequence on Win2k machine and how you see after a kill I was able to insert a new row to the table. The client was put down without to close the connection ? E:\mysql\binmysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.39-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql lock tables mm1 read; Query OK, 0 rows affected (0.00 sec) mysql insert into mm1 values ('',more one test); ERROR 1099: Table 'mm1' was locked with a READ lock and can't be updated mysql show processlist; +++---+--+-+--+---+- -+ | Id | User | Host | db | Command | Time | State | Info | +++---+--+-+--+---+- -+ | 1 | miguel | localhost | test | Sleep | 0| | NULL | | 7 | ODBC | localhost | test | Query | 0| NULL | show processlist | +++---+--+-+--+---+- -+ 2 rows in set (0.00 sec) mysql kill 7; Query OK, 0 rows affected (0.00 sec) mysql unlock tables; ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:8 Current database: test Query OK, 0 rows affected (0.22 sec) mysql insert into mm1 values ('',more one test); Query OK, 1 row affected (0.05 sec) mysql Regards, Miguel Sorry. It's possibly a bug under WinNT (version 3.23.39). For Linux (debian) is OK (version 3.23.39).! Now KILL id_process executed and executed hitherto. - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nick Kostirya [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, July 05, 2001 11:24 AM Subject: Re: Unlock tables when process has killed. On Thu, Jul 05, 2001 at 10:55:33AM +0300, Nick Kostirya wrote: Hello, All. Help me. One process locks a table. Then it has been killed. The table remains locked. How unlock the table if the process is not exist? If that's what happened, you've found a bug in MySQL. Can you reliably reproduce it? What version are you using? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 18 days, processed 141,137,801 queries (86/sec. avg) - 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 - 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 -- 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: How to make symbolic link under windows
At 17:16 03/07/2001 +0800, tpchan wrote: Hi, You can simulate the symbolic link on Windows using the today Win32 MySQL 3.23.39 distribution. You have in this distribution the following Max MySQL servers: 1- mysqld.exe the debug version. 2- mysqld-max.exe the optimized version for Win9x and NT/Win2k. 3- mysqld-max-nt.exe the optimized version for NT/Win2k with support for named pipes. I recommend to you the 3 option. The Max stuff besides the support of symbolic links has the support of transactional tables InnoDB and BDB. Below the instructions how to use the symbolic link. Notice if you don't want the support of InnoDB and BDB tables un comment the variables skip-innodb and skip-bdb. Otherwise read the item 8.7.2 InnoDB startup options of the \mysql\docs\Manual.html. 1- Create the configuration file c:\my.cnf or \windir\my.ini.file. 2- Edit the configuration file: [mysqld] basedir=c:/mysql datadir=c:/mysql/data use-symbolic-links #skip-innodb #skip-bdb Notice that in the sample above, you have the grant tables on c:\mysql\data. If you want to have all the databases on d:\ecom, so you don't need to use symbolic link, you only need to move the all c:\mysql\data\mysql directory to d:\ecom\mysql and modify the variable datadir=d:/ecom. Now assuming that you want a database called mylink on d:\ecom. First create on c:\mysql\data directory a file called mylink.sym. Edit this file with the text: d:\ecom\mylink Create the directory d:\ecom\mylink Regards, Miguel Dear all, Did anyone now how to make symbolic link for mysql data directory under Windows NT 4.0. Mysql data directory sits on C:\mysql\data\ecom and I would like to transfer it to D:\ecom. My Mysql version is 3.23.32, installed using the '.exe' file. I would like to know if this is possible? If so, how? Thank you in advance. Emanduel Chan Tain Por System Engineer DotCom Consulting Sdn Bhd DID : 603-62763230 ext. 112 - 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 HELP -- Unable to start Win2k service
At 03:45 03/07/2001 -0700, Michael Tam wrote: Hi, Take a look on \mysql\data\mysql.err file and see if exists a message error like that server doesn't find a grant tables. Otherwise, try to run the server standalone to see in the screen the error message: yourservername --standalone Fix the possible issues before to run the service. Regards, Miguel Hi all, I have beening running mysql on my win2k for awhile. This afternoon, I have restarted my pc and the next thing I notice mysql service was unable to start. The following is the message I got: Could not start the Mysql service on Local Computer. Error 1067: The process terminated unexpectedly. I have tried to remove the service, uninstalled the mysql and reinstalled it. I got the same result. Any help would be appreciated. Regards, Michael -- 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: bug please help
At 14:58 29/06/2001 -0500, Jose Garcia wrote: Hi, Please read the Manual on \mysql\docs the chapter: 8.7.2 InnoDB startup options Notice that you need to create 2 directories before the start called c:\ibdata and c:\iblogs in the sample. I you don't want the support of tables InnoDB use the below variable in the configuration file: skip-innodb Regards, Miguel I was trying to install Mysql in win 98 and after several attempts all I got was: (using mysqld command) (I also send you the my.cnf file I had to edit several times) Please help InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata2 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 3145728 InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 3145728 InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 3145728 Innobase: Assertion failure in thread 4294055337 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010629 14:51:37 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010629 14:51:37 Aborting InnoDB: Warning: shutting down not properly started database 010629 14:52:12 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete - 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: system error 1067
At 23:46 29/06/2001 -0500, Tyler Longren wrote: Hi, The 1067 error, means an MySQL server aborted. The cause should be: - Missed (dropped) or corrupted MySQL grant tables. - Problems with the \share directory or errmsg.sys files. - Wrong variable(s) on the configuration file (my.ini\my.cnf) Troubleshooting: - Take a look at \mysql\data\mysql.err file if the last lines you find the cause of the abortion. - Rename the my.ini/my.cnf file and try to start the service using the defaults values. If well success, then the problem is a variable(s). If the 2 items above, don't resolve the problem. Do: - Remove the service: mysqld-max-nt --remove - Start the server in standalone mode to see the message errors: mysqld-max-nt --standalone --skip-innodb Try to correct the errors show by the last command and re-install the service. Regards, Miguel Hello everyone, I have mysql-3.23.39 installed on a Win2k Pro box (not sure why!). It had been running just fine, then all of a sudden stopped working. When I try a 'NET START mysql', I get the below error: ---Begin Error The MySql service is starting. The MySql service could not be start A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. ---End Error Has this happened to anyone else? Or am I just the unlucky one? Tyler - 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 in Win32 stop after 5 minutes.
At 12:08 29/06/2001 -0300, Marcio - ProgMar wrote: Hi! Are you using PHP or Apache ? Because this behavior was already reported only for Win98 and until now I wasn't be able to repeat the same behavior on my machine. The possible cause should be an environment situation that make MySQL to loss, maybe the correct paths. Some users fixed the problem with a new installation of Windows, however a detailed description of your environment is useful for me to try to repeat the problem and find the cause. Regards, Miguel I am use the MySQl Win 32 in win98 version 3.23.27-beta and too in 3.23.39. After 5 minutes the server stop, but MySqlAdmin don't show it stopped, then I stop it in MySqlAdmin and restart, again I have more 5 minutes. This is only for developer, no my server, but this problem is annoying. This in an AMD Durom 700 Mhz with 128 of ram and in an Athlon 850 with 128 of ram. I saw the my.ini and is all ok. Tanks.. -- 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 errmsg.sys
At 18:18 28/06/2001 +0200, PABLOSKY® wrote: Hi, Thanks for the bug report. Sorry for the inconvenience with the partial translation of the errmsg.sys file. I will the translation and send you the new errmsg.sys as fast as possible. Regards, Miguel Dear friends, I'd like to know how to compile my own 'errmsg.txt' to 'errmsg.sys'. I know that there is an utility called 'comp_err' but i dind'nt find it in the Windows distribution of MYSQL. The matter is that the error message file for spanish language in the last distribution isn't completely translated, that is, it's wrong translated. If anyone know about the correct spanish 'errmsg.sys' or know how to compile the text file from Windows, or has the 'comp_err' utility please answer me or send me it. Thanks in advance. Luis Martin-Caro SPAIN -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: Newbie problem with winmysqladmin
At 12:28 28/06/2001 -0700, Michael Tam wrote: Hi, WinMySQLAdmin only shows for you the db and table info, when is able to do a connection using an user name and his password which are edited at first start and when the my.ini file exist. So, if you are not using my.ini file, then the tool doesn't make the connection or when you are removed the data above mentioned or changed the data. Regard, Miguel Hi All, I am new to MySQL and have a problem using winmysqladmin. MySQL is working fine, which I can access the database from my Java apps. However, when I tried to use winmysqladmin to obtain my db and table info, winmysqladmin never connects with MySQL and I can't obtain the info. In addition, beside winmysqladmin, what other gui program will allow me to obtain those info? If anybody can give me a direction to where I should look into, that would be great and appreciated. Thank you. Best regards, Michael Tam -- 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: install service on nt
At 19:33 27/06/2001 +0100, Maria Aurora VT de la Vega wrote: Hola, Verifica primero si en el SCM ya existe el servicio llamado mysql instalado. Si existe, entra en el prompt del DOS, y remueválo con el comando: d:\mysql\bin\mysqld-nt --remove Después de eso, edita el archivo my.cnf de la siguiente manera: [mysqld] basedir=d:/mysql datadir=d:/mysql/data Entra de nuevo en el prompt de comando e instala el servicio: d:\mysq\bin\mysqld-nt --install Dá el arranque al servicio: net start mysql Solo eso, Abrazos, Miguel i've been trying to install mysql as service on nt... mysql is currently working fine without it installed as a service... mysql is installed in D:\mysql tried the following in vain... 1. mysqld-nt --basedir=d:\mysql --install -- not valid 2. copy and edit c:\my.cnf and set basedir=d:\mysql\ and try mysqld-nt --install and then net start mysql -- specified file not found error 3. try set basedir=d:\mysql as environment variable and try mysqld-nt --install and then net start mysql -- specified file not found error help! 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: BUG?: Creating a copy of a database with InnoDB tables
At 12:11 27/06/2001 +1000, Jonathan Arthur wrote: Hi, Take a look in the err file and if you see an error like this: Innobase: error: table dbname/tablename already exists in Innobase data dictionary Means maybe you had created before the table in InnoDB and made a drop database command, which don't remove the table from InnoDB data dictionary and thereafter generates the error for you mentioned. The fix of the problem is already in the work by Heikki, the main InnoDB developer. Regards, Miguel I have a database with a mix of myisam and innodb tables. I want to create a copy of this database (ie the database name is different but the table names and structures are the same) on the same server. When I issue the create table command I get the following error: ERROR 1005: Can't create table './new_database_name/same_table_name.frm' (errno: 137) and the table is not created. If I change the type to myisam, with everything else the same, it works fine. Similarly if I use a different table name for the new table it works fine. But if I then try to use alter table to either change the type back to InnoDB or change the name back to match the table name in the original I get the error: ERROR 2013: Lost connection to MySQL server during query and the table remains unaltered. I need InnoDB type tables for transactional support and I want the same database name so my application can refer to either database without having to search and replace all the table names. I can't find anything in the manual about this. Is it impossible to have two InnoDB tables of the same name in different databases on the same server? or is this a bug? I am using Linux kernel 2.2.17-21mdk and MySQL version 3.23.37 on off-the-shelf Intel hardware. Thanks for you help. Jonathan - 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: Upgrading MySQL on Windows Platform
At 14:32 21/06/2001 -0700, Martin Tunggorono wrote: Hi! Hi everyone, I'm kinda new with MySQL and I have a question about upgrading MySQL to a newer version on Windows 2000 OS. Is there any special command that I should run or should I just re-install the latest version 3.23.39. Will it overwrite the old version automatically while preserving all the tables and databases? Please help. Thanks. The databases aren't overwrite. However before to run the setup, in the today distribution delete the older share directory for the err files to be updated. This distribution should be changed by one identify by the mysql-3.23.39a-win.zip. However, is always a good safe to make the backup of the databases, to avoid problem outside of the setup program. Regards, Miguel 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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 on Win2K Need Assistan
At 00:57 21/06/2001 +0700, Aa wrote: Hi, First create the my.ini file at /WINNT directory. Edit the following section and keys [mysqld] basedir=e:/_db/mysql datadir=e:/_db/mysql/data If you want the InnoDB table, below the samples of the keys for the [mysqld] section: [mysqld] basedir=e:/_db/mysql datadir=e:/_db/mysql/data innodb_data_home_dir = c:\ibdata innodb_data_file_path = ibdata1:2000M;ibdata2:2000M 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 Pay attention in the following variable: nnodb_data_file_path = ibdata1:2000M;ibdata2:2000M The above sample will do InnoDB to create 2 files with 2GB each. Change the size according with your necessities, so as the maximum size is 2000M and the minimum is 10M. Now create the directories for InnoDB's data and logs files: e:\ibdata and e:\iblogs for example and edit the path for the variables: innodb_data_home_dir = e:\ibdata innodb_log_group_home_dir = e:\iblogs Now for safe: net stop mysql mysqld-max-nt --remove mysqld--max-nt --install net start mysql To understand well all the variables involved, read the Manual before to do the instructions above. Regards, Miguel Hi, This is my first comeback to install mySQL on Windows 2000 Server and have some trouble on installing mysqld-nt as a service as told in readme and looking for some assistant from the expert. I have download the latest version of mySQL that is version : 3.23.39-max-nt. I try to follow step-by-step from the guidance with following sequence : ** change basedir : mysqld-nt --basedir=e:\_db\mysql ... and got the following message : Can't initialize InnoDB as 'innodb_data_file_path' is not set ** I skip those sequence, continue with registering mysql as a service : mysqld-nt --install We I check on Service Manager, I can see that mysql service is there but not started. When I try to start this service, I got this message : The MySql service could not be started A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. I've been try for couple of times, but still have the same result!, but when I try the Testing Sequence : - mysqladmin version - mysqlshow -u root mysql - mysql mysql - event I can use mysqlmanager and grant some user Stranger!!. Please advice, if I did the wrong task or sequence. Thank you and looking forward for your assiatance. regards Aa -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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/crash with InnoDB if table name = database name
At 20:41 20/06/2001 +0200, Markus Wichitill wrote: Hi, Thanks for the bug report. I was be able to repeat the issue after I dropped the already existing database test. The problem is InnoDB applies the following error: Innobase: error: table test/test already exists in Innobase data dictionary The above should be analyzed by Heikki. Regards, Miguel Hi, I'm using MySQL 3.23.39-log compiled from sources on SuSE Linux 6.4. When I create an InnoDB table with the same name as the database, I get the following error message: mysql create database test; Query OK, 1 row affected (0.01 sec) mysql create table test (x int) type=innodb; ERROR 1005: Can't create table './test/test.frm' (errno: 0) Creating an InnoDB table with a different name works fine, as does creating a MyISAM table with the same name: mysql create table test2 (x int) type=innodb; Query OK, 0 rows affected (0.01 sec) mysql create table test (x int); Query OK, 0 rows affected (0.00 sec) When I try to convert the MyISAM table to InnoDB, the server crashes and the table is lost: mysql alter table test type = innodb; ERROR 2013: Lost connection to MySQL server during query I could provide additional information and maybe a stacktrace if necessary, but I'd prefer not to recompile the server etc. in case this problem is already known or easy to fix without. - 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: Pregunta
At 17:12 13/06/2001 -0400, Anita Rafaela Carrillo wrote: Hola, Usted puede usar MySQLGUI hecha por nuestro programador Sinisa. La puede encontrar en: http://www.mysql.com/downloads/gui-clients.html Creo que debe preferir la opción ya compilada. Saludos, Miguel Hola. Hola. Soy estudiante de Sistemas y necesito ayuda por favor. En que sitio puedo encontrar un frontal gráfico de MySql para Linux, necesito generar mi base de datos y diseñar las tablas de un sistema. At. Anita C. Gracias _ http://www.latinmail.com. Gratuito, latino y en español. - 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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 I'm receiving
At 15:04 11/06/2001 +0300, Heikki Tuuri wrote: Hi, Only to complete the Heikki's instructions, also you need to edit on /my.cnf the variables: [mysqld] basedir=F:/mysql datadir=F:/mysql/data The above is necessary when MySQL was installed on different location than the default c:\mysql. Regards, Miguel Saleel, mysqld.exe was accidentally compiled with __NT__ defined. You should use mysqld-max.exe. The next version .39 will ask from the OS if it is Win 95, ..., and this problem will not appear any more. I am sorry for the inconvenience. Regards, Heikki Tuuri Innobase Oy Hello, I was wondering if you could help me on a problem I am having with mySQL. I've installed MySQL (Win32) on F:\mysql. I've placed my.cnf on C:\. This is the contents of my.cnf:---# 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_passwordport=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=MySQLskip-lockingdefault-character-set=latin1 set-variable = key_buffer=16Mset-variable = max_allowed_packet=1M set-variable = thread_stack=128Kset-variable = flush_time=1800 innodb_data_file_path = ibdata1:20M;ibdata2:20M # Uncomment the following row if you move the MySQL distribution to another # location#basedir = d:/mysql/[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.optionshistory_length=20database = test queries_root= c:\mysql\querieslast_database_file= c:\mysql\lastdb My system is a PII 400MHz with 128mb RAM and plenty of hard disk space. (F:\ alone has 17GB free, C:\ has 5.7GB free). It is running Win ME. I fire up a MS-DOS window, navigate to f:\mysql\bin and type mysqld. This is what happens: InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file .\ibdata1 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Data file .\ibdata2 did not exist: new to be created InnoDB: Setting file .\ibdata2 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5242880 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5242880 Innobase: Assertion failure in thread 4294430293 in fileM:\mysql-3.23\innobase\ os\os0file.c line 187Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010610 22:46:17 F:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010610 22:46:17 Aborting InnoDB: Warning: shutting down not properly started database 010610 22:46:17 F:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete--- And I have no clue what to do next. Doing a Ctrl+Alt+Del to see the tasks shows me that myslq is *not* running (not in programs list). I don't think it matters, but I am running Apache/1.3.19 (Win32), PHP/4.0.5 and ActiveState Perl (F:\php and F:\perl). Before attempting to start mysql, I did close done Apache.Any help would be much appreciated.Thanks.--- Saleel [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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: odbc on WinME
At 07:39 11/06/2001 -0700, Bob Andrews wrote: Hi, Assuming that: 1- You have the ODBC Data Source Administrator, means that your machine has already the ODBC core installed. 2- You ran the MyODBC setup for Win9x and something wrong happened. If the item 2 is true, verify if the myodbc.dll exists at /windows/system directory and apply the below batch file, editing the correct path for your machine environment: C:\\WINDOWS\\SYSTEM\\. Regards, Miguel rem -Author: Jim Michaels if errorlevel 1 goto bye rem create a .REG file to make registry entries echo REGEDIT4myodbc.reg echo.myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL]myodbc.reg echo APILevel=2myodbc.reg echo ConnectFunctions=YYNmyodbc.reg echo Driver=C:\\WINDOWS\\SYSTEM\\myodbc.dllmyodbc.reg echo DriverODBCVer=02.50myodbc.reg echo FileExtns=*.txtmyodbc.reg echo FileUsage=0myodbc.reg echo Setup=C:\\WINDOWS\\SYSTEM\\myodbc.dllmyodbc.reg echo SQLLevel=1myodbc.reg echo.myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]myodbc.reg echo MySQL=Installedmyodbc.reg echo.myodbc.reg rem -install the registry entries by executing the .REG file start /wait myodbc.reg rem clean up after we are done installing del myodbc.reg :bye I recently downloaded the ODBC client software for windows, ran setup, then went into the 'ODBC Data Source Administrator' from the control panel per the readme. I tried to add a new datasource, but MySQL was not in the list so apparently the setup program didn't work as expected. Any suggestions on what to check? (Just saying that this worked for you is not what I am looking for.) Perhaps there's a registry entry I should check? 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: bug report
At 00:13 10/06/2001 +0900, atsushi wrote: Hi, The problem reported happens on Win9x and ME platform because mysqld.exe was compiled accidentally with a __NT__ define for the InnoDB library. Use instead the mysqld-max.exe server on these OSs. This issue is already fixed for the next release. Regards, Miguel hello, I've encountered the following message after I've set inodb_file_path. C:\WINDOWSmysqld Innobase: Assertion failure in thread 4293055721 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010602 7:39:48 D:\HTTPD\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010602 7:39:49 Aborting InnoDB: Warning: shutting down not properly started database 010602 7:39:55 D:\HTTPD\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete My computer's spec is pentiumII 366khz with 128kb memory, windows98 servicepack1, apache1.3.20, mysql3.23. I'm now using mysql without innobase so I always see the message, 'inodb_file_path is not set'. Is this ok to use mysqld? Or am I supposed to use mysql after inodb_file_path is set? I don't know what to do. also I don't know what country this message will go. Atsushi Nakasugi in Japan. - 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: Question About Compiling
At 21:38 08/06/2001 -0500, Adam Clauss wrote: Hi, If you are compiling a console application without the support of MFC add the #include windows.h line, otherwise when using MFC during the wizard process, check the support for sockets. Regards, Miguel I am using VC++ 6 on Win2K. What is the exact process I need to go through to set this up to use it? I compiled the original project in the root directory. I then setup one of my programs to include the mysql.h as the example had. I also have the lib file included to link in the project settings. But when I compile I get several errors... c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2146: syntax error : missing ';' before identifier 'fd' c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2501: 'SOCKET' : missing storage-class or type specifiers c:\my documents\my c++\mysqlapi\mysql\include\mysql_com.h(114) : error C2501: 'fd' : missing storage-class or type specifiers What do I need to do? Adam [EMAIL PROTECTED] -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: VB3 and mysql
At 10:53 07/06/2001 +1000, Hillier wrote: Hi! My answer is a guess, because I can't install my VB3 because the floppy install disks are damaged. My guess is you can't to use VB3 because its ODBC support is 16 bit since MySQL is a 32 bit application. Anyway take a look on Microsoft support if you find a way to use ODBC 32 bits for VB3, then you can. Regards, Miguel To whom it may affect Jonas Norrman pass this question on to you Is VB3 compatiable for mysql * Visual Basic Thanks Brett Hillier -- For technical support contracts, go to https://order.mysql.com/ __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ Developer - 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 required for OLEDB on win32 for MySQL(linux)
At 20:56 07/06/2001 +0530, asit wrote: Hi, Please take a look on the help file, where you should find that your connection string is wrong. You find the instructions of the connection string just below of Overview item. server=192.168.100.101 ? Regards, Miguel Hi, I am facing problem while connecting to MYSQL server (linux) from Win32 VB client through OLEDB provider from MYSQL. I am successfully connecting to server through MyODBC using DSN but unable to connect to through OLEDB provider ( downloaded from www.MYSQL.com) Following is the script in VB MySQL server is on 192.168.100.101 and database is Test . This is allowed to be connected from any IP and any user Private Sub Form_Load() Dim dcncentral As ADODB.Connection Set dcncentral = New ADODB.Connection Dim str1$ str1 = Provider=MySQLProv;Data Source=192.168.100.101;DB=Test dcncentral.Open str1- Giving Catastrophic Error End Sub This function is not opening the database and giving Catastrophic Error. What should be the connection string for database ? Please help. Kindly note that I want to connect to MYSQL database without a DSN Thanks in Advance Asit Saha -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: Borland C++Builder compile error
At 10:03 07/06/2001 -0700, Jay Stewart wrote: Hi! Please add #include winsock.h at your main unit. Regards, Miguel I am attempting to add SQL client-server functionality to a Window's (2000) app I am developing in Borland's C++Builder v5. After installing the mysql C API, including the mysql.h header and setting my include and library paths appropriately, I was unable to compile the API code. The compiling error occurs in mysql_com.h at line 115 which reads my_socket fd; the compiling error is type name expected, followed by a second error Declaration missing ';'. I've looked at the code which I can see, and there doesn't seem to be any syntax errors. Has anyone seen something like this occur before?? I may need to change some settings or macros to get this to compile, but I don't know where to start. Any suggestions for getting around this problem? Thanks in advance, Jay - 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/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. 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: bug!
At 14:37 06/06/2001 +0200, ran wrote: Hi, When you have an issue involving: client_application MyODBC MySQL The best thing to do is to test the MyODBC and MySQL isolating the client application. For example in your case of describe table_name, I create a small table with the following structure: mysql describe mytest; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | name | char(50) | YES | | NULL|| +---+--+--+-+-++ 2 rows in set (0.00 sec) Then I built a DSN file, to test the same command using MyODBC with the tool ODBCTE32.EXE shipped together with the MyODBC setup. Below the result: Get Data All: Field, Type, Null, Key, Default, Extra id, int(11), , PRI, Null, auto_increment name, char(50), YES, , Null, 2 rows fetched from 6 columns. So I guess that the problem is your application or the machine environment. Notice for example that VB doesn't support BIGINT as column type on auto_increment. Regards, Miguel To MySql Team. I am trying mysql version 3.23.38 for win 2000 and linux. I use VB and VC++ to develop. There are 2 major problem i have encounter. 1) If i ask for describe [tablename] into a Datagrid, I do not get the info back when the tables has an auto_increment field. 2) I use ODBC to access the database. It talks about 2-3 seconds to open / update a recordset using the mysql for windows AND msql for linux. I do not know what is the problem, and why it takes me about 5 seconds to open a recordset and update. I will appreciate it, if you will reply with an answer. P.S I used earlier version of mysql ( 1.6 i think ) for linux and These problems NEVER occur. there for i am sure that my code is correct ( i tried the same code on this DB) Best Regards Ran Salomon E-mail: [EMAIL PROTECTED] --- -- For technical support contracts, go to https://order.mysql.com/ __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ Developer - 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: Getting Error 1067 when trying to start MySQL as service on NT 4.0
At 17:07 06/06/2001 -0400, [EMAIL PROTECTED] wrote: Hi, Did you tried to run /mysql/bin/winmysqladmin.exe to correct the problem ? Regards, Miguel Listers, Apologies in advance for the cross-post. I've run into a problem starting MySQL on a Windows NT 4.0 workstation machine. Installation appears to have gone fine, but I cannot start MySQL as an automatic service. MySQL is listed in the Services panel, but it's currently inactive. When I select MySQL in the Services panel and click start I get a message saying Attempting to start they MySQL service on... A second or two later, I get an error message: Could not start the MySQL service on Error 1067: The process terminated unexpectedly. Any suggestions? Thanks in advance, Andy = Andy Crain The Sarasota Herald-Tribune 941-957-5199 [EMAIL PROTECTED] = - 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, go to https://order.mysql.com/ __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ Developer - 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: DROP TABLE problem!
At 12:37 31/05/2001 +0200, Vili Germic wrote: Hi! The issue mentioned is relative to the Windows security privileges. If the workstation connected or the local user doesn't has privileges to delete files on the /mysql tree, that error message is launches. Click over the MySQL folder icon with the right button and selecting the properties menu option, take a look if the folder has a sharing definition. The best way to install the MySQL Server on NT/Windows 2000 machines, is to do the install as Administrator, create a workgroup and add the users for that group. Then define individually the privileges for every user. Add the folder MySQL to the workgroup. After this use the GRANT command to edit the privileges for every user/host/db on the MySQL server. Regards, Miguel Hello everybody, MySQL - 3.23.38 Win MyODBC - 2.50.37 I'm using MySQL on local machine with Win2000 plattform, using MyODBC(ver. 2.50.37) to connect to db trought ODBC. Things works well, except for dropping table. I'm using ODBC API in MS Visual C++ 6.0 to connect to ODBC. Trought SQL statements I can create table well. But when I use sql statement DROP TABLE, I get error: Error on delete of 'xxx.MYI' (Errcode:13). Note, that things works well if I'm connected from Win2000 to MySQL server that runs on Linux, trought the same MyODBC driver (2.50.37), with the same ODBC DSN settings! So I think (maybe I'm wrong), that the problem must be in MySQL-Win server (not in ODBC driver)! Do you have any idea about the problem? I would apreciate any help from you! Best Regards, Vili Germic. -- For technical support contracts, go to https://order.mysql.com/ __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ Developer - 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
Explanations about the start up of MySQL 3.23.38 on Windows
Hi! We have noticed some mails posted by Windows users having problem in the first start of mysqld.exe on Windows platforms. Then, below the explanations how to avoid the problems reported: 1- According with our MySQL-Max download page is noticed that the regular distribution 3.23.38, contains the MySQL-Max stuff. The MySQL-Max stuff has additional features: - Support for transactions with two types of tables: InnoDB and BDB. - Support for symbolic links to have databases on another place than the default one. - The servers which have the MySQL-Max support are: mysqld.exe mysqld-max.exe mysqld-max-nt.exe 2- When the MySQL-Max servers are started, the InnoBD routines tries to found the paths for its data and log files. When aren't specified that data on the \my.cnf or \WindDir\my.ini file, the server launches the following warning message: Can't initialize InnoDB as 'innodb_data_file_path' is not set The above means that the InnoDB tables are disabled, however the server is ready for the others tables. C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.38-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show variables like have_innodb; +---+--+ | Variable_name | Value| +---+--+ | have_innodb | DISABLED | +---+--+ 1 row in set (0.05 sec) If you don't want the InnoDB tables support and to avoid the above warning message, you could create the \my.cnf or \WindDir\my.ini file and add the below variable: [mysqld] skip-innodb Otherwise if you want the InnoDB tables support, you need to read in our Manual how to prepare the configuration file. Below the preliminaries instructions: - Create the log and data directories, for example: c:\ibdata and c:\iblogs. - Create the configuration file and edit the variables according with the Manual instructions. Notice that the sizes of the files can't exceed 2000M. - Start the server and you will see, the messages that InnoDB are creating the files: C:\mysql\binmysqld-max --standalone InnoDB: The first specified data file c:\ibdata\ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 26214400 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata2 size to 38797312 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata3 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata3 size to 104857600 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata4 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata4 size to 314572800 InnoDB: Database physically writes the file full: wait... InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 5242880 InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 5242880 InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 5242880 InnoDB: Started Notice that you can to start the server as service on WinNT and Win2k OSs. The server should be used is the mysqld-max-nt.exe 3- The mysqld.exe on Win9x How mentioned above, this server has the Max stuff, however on the 3.23.38 distribution was compiled with the InnoDB library with a pre-processor define option for NT platform, which cause a handle exception when tries to create the data and log files. If you want to use InnoDB tables on Win9x, use instead the mysqld-max.exe server. Also this server doesn't has the symbolic link support. Those problem already are fixed and in the next release, the mysqld.exe should be able to run on Win9x with the InnoDB and symbolic link supports. 4- Using Symbolic Links To use this support we explains it with a sample: Do you want a database called mylink on the d:\mydata directory. First create on \mysql\data directory a file called mylink.sym. Edit this file with the text: d:\mydata\mylink\ Notice the trailing backlash in the end of the path. This is important only in the 3.23.38 distribution. In the next MySQL release will added code to handle a path like: d:\mydata\mylink Create the directory d:\mydata\mylink Add to configuration file the variable use-symbolic-links. If you aren't starting the server as service you should use the
Re: Mysql and Windows ME?
At 00:18 26/5/2001 -0500, Paul DuBois wrote: Hi, Only to complete the Paul's instructions, use mysqld-max.exe on Win ME, because mysqld.exe (only for this distribution) doesn't run on Win9x and Win ME OSs. If you don't want InnoDB tables, use mysqld-opt.exe. Regards, Miguel At 5:13 AM + 5/26/01, tu tuande wrote: Hello, Does Mysql run on Windows ME? I have tried to start mysql, version 3.23.38, by mysqld but I got the error message: Can´t initalize InnoDB as 'innodb_data_file_path' is not set. How could I solve this problem? Thank Frank Tu http://www.mysql.com/doc/W/i/Windows_installation.html says: NOTE: If you want to use InnoDB tables, there are certain startup options that must be specified in your `my.ini' file! See section 8.7.2 InnoDB startup options. Section 8.7.2 is http://www.mysql.com/doc/I/n/InnoDB_start.html -- Paul DuBois, [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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: mysqlbug
At 13:53 24/5/2001 +0200, Catherine Vi Clausen wrote: Hi! The mysqld.exe was compiled with an instruction for NT/Win2k platforms. Then instead of it, use mysqld-opt.exe or mysqld-max.exe for to have support for tables BDB and InnoDB. If you want to use mysqld-max.exe, read the instructions about the my.ini/my.cnf file sets for InnoDB tables. In the next release the mysqld.exe will work on Win9x OS too. Regards, Miguel Hi! My name is Cathy and I have a problem after installing MySQL. I cannot get connection to the localhost. Whenever I type mysqld I get this message: C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set. I'm using Microsoft Windows 98 and the version of MySQL is 3.23. I hope you can help as soon as possible. Thank you. Regards, Cathy __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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 bug
At 18:10 23/5/2001 +0300, Heikki Tuuri wrote: Hi, Claudio, in the source distribution the macro __NT__ is defined. That makes it work only on NT and 2000. You should compile without __NT__ . See a posting by Miguel about 5 days ago. If you don't have the VC++ compiler use mysqld-max.exe instead of mysqld.exe on Win9x and ME machines. Don't forget also to create first the log and data directories for InnoDB and write on my.ini/my.cnf the key variables for InnoDB. Regards, Miguel Regards, Heikki Downloaded latest version of MySQL for Win95 (3.23.38-win) on May 21st. After mysqld command this is the response: C:\cd mysql|cd bin|mysqld Innobase: Assertion failure in thread 4293273545 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010523 15:51:48 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010523 15:51:48 Aborting InnoDB: Warning: shutting down not properly started database 010523 15:51:51 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete Can someone help me ? Thanks Claudio - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: Re:
At 15:47 22/5/2001 +0800, Rolf Hopkins wrote: Hi, Please translate for him, to use on Win98 the mysql-opt.exe if he wants to use the MyISAM table, otherwise to use mysqld-max.exe to have support of InnoDB and BDB and to include on my.ini/my.cnf file the keys for InnoDB. The mysqld.exe has problems to run on Win9x (the InnoDB lib was compiled with the NT pre-processor define). Regards, Miguel I do not know the answer myself as I am using linux, not windoze. I'm only translating it into English. Hi, I'm a newbie. I have followed the procedure in the manuals and installed mysql-3.23.38-win.zip onto a Win98 system. I am now getting the following problem. when running C£º\MYSQL\BIN MYSQLD I get the following error can't initialize innodb as 'innodb_data_file_path' is not set What configuration options do I need to set to fix this problem? - Original Message - From: tsqvictor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 22, 2001 15:33 Subject: ÇëÇó°ïÖú ÄãºÃ£¬´òÈÅÄúÁË£¬ÎÒÊÇÒ»ÃûÐÂÊÖ£¬ÏÖÔÚÎÒ°´ÊéÉϵIJ½ÖèÔÚWIN98Ï°²×°ÁË mysql-3.23.38-win.zip£¬ÏÖÔÚ³öÕâÑùµÄÎÊÌâ µ±ÔÚC£º\MYSQL\BIN MYSQLD Ö´ÐÐʱ³öÏÖ´íÎó can't initialize innodb as 'innodb_data_file_path' is not set ÇëÎÊÎÒÓ¦¸Ã ÔõÑùÉèÖᣠ__ === ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) Ñ°ÕÒÐÂÏÊ, Ó®¿ÆÁú±ùÏä! (http://ad.doubleclick.net/clk;2847753;5579344;y?http://gd.sina.com.cn/ad/ke lon) ʹÓÃÊÖ»ú¶ÌÐÅ¡°ÓʼþÌáÐÑ¡±¹¦ÄÜ£¬ËæʱÁ˽âµÄÊÕÐÂÐÅÇé¿ö£¡ (http://sms.sina.com.cn/docs/sina_mailalert.html) - 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 - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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 a drive other than root
At 20:05 19/5/2001 +0100, James Cox wrote: Hi! Remove the service first: mysqld-nt --remove Create /winnt/my.ini file with the following section and keys: [mysqld] basedir=G:/mysql datadir=G:/mysql/data Install the service: g:\mysql\bin\mysqld-nt --install start the server: net start mysql Regards, Miguel Hi, I have been running an old version of the mySQL-nt server on my Windows 2000 box for some time now. It was installed on C:\ , as suggested in the install instructions. Now, I have a new disk, and so want to put the server on a partition, G:\ . After removing the service - I tried to reinstall it... but try as I might, I can't seem to get the thing to run. any suggestions? Thanks, James Cox __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: NT installation / port issues
At 11:36 18/05/2001 -0400, Michael Britton wrote: Hi, That error message should means: the server wasn't started or the client wasn't able to connect for privileges issues. The server you should use is: mysqld-nt.exe The recommended way on NT is as service so install it by: \mysql\bin\mysqld-nt --install to start the server at first time, type: net start mysql to stop the server: net stop mysql When you install the service, thereafter at every boot the server is started. To be sure it isn't exist other process, using the port 3306, you can list all the ports with (before start the MySQL server): netstat -a In the remote case that port is used by other process than MySQL server, you can specify other port like 3307..3309, using the my.cnf/my.ini file with the variable port=3308. Take a look in the Manual about the use of the configuration file. Also read about the GRANT/REVOKE commands. Regards, Miguel System: NT 4.0 mysql Ver. 8.2 Distrib 3.22.34, for Win95/Win98 on i586 I'm unable to access mysql server on port 3306. Error reads: Can't connect to MySQL server on 'localhost' (10061). Does this mean it's not on 3306? How do I get it there? Do I have the wrong version and do I need to download an NT version? Thanks, Michael Britton Mike Britton Web Developer LIPSinc http://www.lipsinc.com http://www.lipsinc.com/ We Have Ways of Making You Talk. __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: Innobase
At 09:12 17/05/2001 -0300, Paulo Arantes de Azambuja wrote: Hi, Thanks for the bug report, I was able to repeat the same behavior on Win9x. We will fix this ASAP, while this please use mysqld-max.exe instead of mysqld.exe. Regards, Miguel Got the following message after starting mysqld on WinME: Innobase: Assertion failure in thread 4294849841 in file M:\mysql-3.23\innobase\ os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010517 9:07:55 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010517 9:07:55 Aborting InnoDB: Warning: shutting down not properly started database 010517 9:08:03 C:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete Thanks, Paulo Arantes de Azambuja Diretor de Tecnologia Freedom2buy - F2b Tel: 55 11 3079-2229 r116 Fax: 55 11 3079-5599 - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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
Compiling InnoDB on Win32
Hi! To compile the Win32 Debug version of mysqld with support of InnodB, you need to remove the preprocessor definition __NT__ from the innobase - Win32 Debug configuration. The above is to avoid an insertion error message on Win9x and Win ME OSs when the server is started. For NT/Win2k OSs it isn't necessary. This care is only valid for the today Win32 source distribution: mysql-3.23.38a-win-src.zip. In the next release should be fixed. Regards, Miguel __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: Making MySQL DB Remotely Accessible
At 09:42 15/05/2001 -0700, Ray Pollard wrote: Hi, There are several ways to do this. For example you can use script languages like PHP (you find in our contribution pages applications ready), also you can use SSH (maybe you need a commercial SSH server to run on Windows) or you can use telnet together the MySQL clients. Anyway you need to study first the MySQL security system, to know how to connect with the server from a remote machine. You find in our Manual all the relevant informations. Regards, Miguel I am new to the world of mySQL and have just installed it on a Windows 2000 Advanced Server and I need to figure out how make the db accessible from a remote PC for administration. Can anyone provide me with some direction in that area? Bear in mind, I am a newbie. Thanks very much, Ray __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: Newbie win 2000 install question (reprise)
At 12:49 30/4/2001 -0400, Rhasaun Campbell wrote: Hi! To install and start up MySQL is easy and fast on Win2000, below you see the commands I had, before the setup: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. C:\cd\mysql\bin C:\mysql\binmysqld-nt --install C:\mysql\binnet start mysql O serviço de MySql foi iniciado com êxito. C:\mysql\binmysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql You see the message of the service start in Portuguese, because my Win2k Server version is Portuguese. After this, every machine boot the service is started automatic. Notice also that you need to login with administrator rights to set a service on NT/Win2k machines. Take a look in the Manual at \mysql\docs The setup and start I did ~ 2 min. Regards, Miguel Ok I tried both of your suggestions but no dice. I actuall failed to mention that once I got into the bin i tired to start the service by typing mysld--standalone, but it returned an error stating: mysqld--standalone is not recognized as an internal or external command, operable program or batch file... so I physically went to the bin and looked at files where there, I saw mysql.exe to I tired to start mysql server that way but i got another error stating Can't connect to MySQL server on'localhost' 10061 Basically I know my problem lies in starting the service, because i tried pinging localhost 3306 and it timed out, So do you have any other suggestions? ohh btw I just picked up a book PHP fast and easy web development by Julie C Melonie, and with it came a CD-Rom with mysql-shareware-3_22_34-win.exe, I checked the site and saw that they had newer versions of MySQL out, so maybe that is my problem thanks for your help already anymore will be greatly appreciated -Original Message- From: Michael Tefft [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 29, 2001 10:25 PM To: Rhasaun Campbell Subject: RE: Newbie win 2000 install question Well, just typing cd c:\mysql\bin does not do anything. You are just going to the mysql bin directory. To start mysql try doing mysqld . Better yet, run winmysqladmin and start it from there. -Original Message- From: Rhasaun Campbell [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 29, 2001 9:48 PM To: mysql list Subject: Newbie win 2000 install question Ok so here's the deal, I'm trying to check if mysql is working on my machine so I open up the dos command prompt, type cd c:\mysql\bin and everything's fine then it try to create a test database by typing mysqladmin create testDB, it try's to connect but it gives me an error message Can't connect to mySQL server on 'localhost' 10061' then it says check that mysqld is running on localhost and that the port is 3306 I tried to telnet to 3306 and of course iut's not running, so here's my question How do I get the mySQL server to start running on my machine. ohh btw I'm on a w2k workstation. I know it's something that's probably simple, which I'm overlooking, but I could use some help figuring it out. The install went fine, I just need some help with starting mysql...please tia Rhasaun Campbell Web Consultant Urban Graphics 110 Camden St. Roselle Pk, NJ 07204 c. 908.531.9418 t.908.245.1161 [EMAIL PROTECTED] www.urbangraphics.tv - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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 can't create database (error 13)
At 20:45 26/04/01 -0700, Brent and Maria wrote: Hi, I guess that your problem is the permission of the user that you made the login. Take a look to permission properties in the \mysql\data directory. Regards, Miguel Hello List, I have recently installed mysql 3.23.33 on my windows 2000 machine. I don't see anything in the documentation that I need to do to my machine for setup (after the installation). I can run mysql fine, but it seems to be only able to read. I want to create a new database. I try to do this in mysql and using mysqladmin create dbName. I get the error: mysqladmin: Create failed; error: 'Can't create database 'dbName'. (errno: 13)' Has anyone run into this? I am making a beginner mistake? I would appreciate any one to point me in the right direction. Thanks, Brent - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: Berkelely MYSQL
At 21:28 23/04/01 +0200, Warren van der Merwe wrote: Hi, Hi there I have managed to download the Berkeley for Windows installation, however I have noted that MYSQL will not run without a patched version of berkeley's. Where can I obtain such a installation to run on Windows? Download our source distribution for Unix and you should find a directory called BDB, inside it you find the build_win32, follow the instructions to build the static release. You only need the lib: libdb32s.lib. Regards, Miguel Kind Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767-0249 - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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: Compiling MYSQL for Win32 Platform BDB
At 00:27 24/04/01 +0200, Warren van der Merwe wrote: Hi! Below the instructions that I sent some time ago, only change the version mentioned by the new ones that you have. Regards, Miguel Assuming that you have on hand: - The db-3.2.9 source stuff - The MySQL 3.23.36 source stuff - The VC++ 6.0 compiler 01.- Unpacked the db-3.2.9.zip file e.g.: c:\db-3.2.9 02.- Unpacked the mysql-3.23.36-win-src.zip file e.g.: c:\3.23.36 03.- Create the directory: c:\3.23.36\lib_release 04.- Build the BDB stuff: Run the VC++ Compiler. Using File/Open Workspace menu, open the workspace c:\db-3.2.9\build_win32\Berkeley_DB.dsw. When prompted to convert the project for the new version, click Yes. Open the screen Options by selecting: Tools/Options menu. Click the Directories tab and you add the below directories: C:\DB-3.2.9\BUILD_WIN32 C:\DB-3.2.9\INCLUDE Now open the Set Active Project Configuration screen by selecting the Build/Set Active Configuration menu. Select the configuration called: db_buildall - Win32 Release Static pressing the Ok button. Press the F7 button to begin the compile process until see the message: db_buildall.exe - 0 error(s), 0 warning(s). Close the workspace. Copy the lib c:\db-3.2.9\build_win32\Release_static\libdb32s.lib to the directory c:\3.23.36\lib_release. 05.- Build the MySQL Server Open the workspace c:\3.23.36\mysql.dsw. You need to have the Microsoft Macro Assembler compiler 5.10 already in the environment path. That is necessary to build the Strings.asm and the Strxmov.asm from the strings tree. Otherwise, if you don't have the masm.exe compiler, remove these 2 files from the strings tree and add the following files to the strings project: \strings\strmov.c \strings\strend.c \strings\strxmov.c \strings\strmake.c \strings\is_prefix.c \strings\strnmov.c \strings\strnlen.c \strings\bmove_upp.c \strings\strcend.c \strings\strfill.c Now, select the active configuration called mysqld- Win32 nt. You can select other configuration option e.g.: mysqld. Right click the mysqld files project and select Add Files to project. Add the file c:\3.23.36\sql\ha_berkeley.cpp Open the mysqld files settings screen. Click over the C/C++ tab. Add the Preprocessor definition: HAVE_BERKELEY_DB Now click the link tab and change the name for the output file e.g.: ../client_release/mysqld-max-nt.exe On the Object/Library modules, add the ..\lib_release\libdb32s.lib Close the last screen mentioned. Press F7 to build the MySQL Stuff and wait until see the message that the mysqld-max-nt.exe file was copied. 3. Working with the MySQL Server If you have already a server running, stop it and remove its service: C:\mysql\binnet stop mysql The MySql service is stopping The MySql service was stopped successfully. C:\mysql\binmysqld-nt --remove Copy the mysqld-max-nt.exe to the /mysql/bin directory. C:\mysql\binmysqld-max-nt --install C:\mysql\binnet start mysql The MySql service was started successfully. C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.35a Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql use test; Database changed mysql create table mybdb (id int not null primary key, idname char(50)) - type=bdb; Query OK, 0 rows affected (0.77 sec) Hi there I have both the patched source for BDB and the Win32 source for MySql. So now the next logical step is to compile them right? So I compile them, but one thing is lurking in the back of my mind, how do I set the MYSQL up to use the BDB table type? When I try and create a table and set the type to BDB, it defaults to MYISAM. What am I missing. In all honesty this has been a huge learning curve for me, I feel like I am almost there, and just need a little more help. Anymore's assistance will be greatly appreciated Thanks Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Cell (083) 262-9163 Office (031) 767-0249 - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solórzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ São Paulo, Brazil ___/ Development Team - 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:
MyODBC Installation Troubleshooting
Hi, We have noticed that some MySQL users are having problems to install the MyODBC driver, receiving errors messages like this: An error occurred while copying C:\windows\system\mfc30.dll. Restart windows.. Generally this happens because the ODBC core stuff is ready installed and the MyODBC setup doesn't have the support to verify this and tries to re-write the files. The best work around for this problem is to copy the myodbc.dll on \windows\system ; \winnt\system32 and make its registry in the Windows system registry. To make the MyODBC registry you could use a batch file sent for us by Jim Michaels (see below) and take up the following steps: Create on the same directory which there is the myodbc.dll a batch file e.g: my.bat. Paste the command lines showing below and edit the lines with the Windows\system directory with the correct path of your machine environment. Run the bat. If the myodbc.dll already exists on the system directory, remove the line copy myodbc.dll C:\WINDOWS\SYSTEM. Put attention that every echo line should be not split. Regards, Miguel rem -Author: Jim Michaels rem -copy the drivers where all good little ODBC drivers go if errorlevel 1 goto bye copy myodbcd.dll C:\WINDOWS\SYSTEM if errorlevel 1 goto bye rem create a .REG file to make registry entries echo REGEDIT4myodbc.reg echo.myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL]myodbc.reg echo "APILevel"="2"myodbc.reg echo "ConnectFunctions"="YYN"myodbc.reg echo "Driver"="C:\\WINDOWS\\SYSTEM\\myodbc.dll"myodbc.reg echo "DriverODBCVer"="02.50"myodbc.reg echo "FileExtns"="*.txt"myodbc.reg echo "FileUsage"="0"myodbc.reg echo "Setup"="C:\\WINDOWS\\SYSTEM\\myodbc.dll"myodbc.reg echo "SQLLevel"="1"myodbc.reg echo.myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]myodbc.reg echo "MySQL"="Installed"myodbc.reg echo.myodbc.reg rem -install the registry entries by executing the .REG file start /wait myodbc.reg rem clean up after we are done installing del myodbc.reg :bye __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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: col_name(length) index and INNOBASE problem
At 12:30 12/04/2001 +0200, BAUMEISTER Alexandre wrote: Hi, Maybe this issue is relative at your compiled version or platform because I wasn't be able to repeat: Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. c:\mysql\binmysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create table test ( - symbole char(20) not null primary key, - libelle char(100) not null, - index id_lib (libelle(1)) - ) TYPE=INNOBASE; Query OK, 0 rows affected (0.06 sec) mysql insert into test values('A','ABCDEF'); Query OK, 1 row affected (0.03 sec) mysql select * from test; +-+-+ | symbole | libelle | +-+-+ | A | ABCDEF | +-+-+ 1 row in set (0.00 sec) mysql show index from test; +---++--+--+-+---+-- ---+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardi nality | Sub_part | Packed | Comment | +---++--+--+-+---+-- ---+--++-+ | test | 0 | PRIMARY |1 | symbole | A | NULL | NULL | NULL | | | test | 1 | id_lib |1 | libelle | A | NULL |1 | NULL | | +---++--+--+-+---+-- ---+--++-+ 2 rows in set (0.00 sec) mysql select * from test where libelle like 'A%'; +-+-+ | symbole | libelle | +-+-+ | A | ABCDEF | +-+-+ 1 row in set (0.00 sec) mysql select * from test where libelle like 'a%'; +-+-+ | symbole | libelle | +-+-+ | A | ABCDEF | +-+-+ 1 row in set (0.02 sec) mysql Regards, Miguel Bonjour, We found a bug in INNOBASE tables with col_name(length) indexes. Here is the table : create table test ( symbole char(20) not null primary key, libelle char(100) not null, index id_lib (libelle(1)) ) TYPE=INNOBASE; For the test I insert one row but there can be many, the result is the same : insert into test values('A','ABCDEF'); I check that the row is in the table : mysql select * from test; +-+-+ | symbole | libelle | +-+-+ | A | ABCDEF | +-+-+ 1 row in set (0.00 sec) I check the indexes in the table : mysql show index from test; +---++--+--+--+---+-+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +---++--+--+--+---+-+--++-+ | test | 0 | PRIMARY |1 | symbole | A |NULL | NULL | NULL | | | test | 1 | id_lib |1 | libelle | A |NULL |1 | NULL | | +---++--+--+--+---+-+--++-+ 2 rows in set (0.00 sec) But here is the problem : mysql select * from test where libelle like 'A%'; Empty set (0.00 sec) mysql select * from test where libelle like 'a%'; Empty set (0.00 sec) This bug does not occur with a MyISAM table. We use Myslq-3.23.26 with latest Solaris patch from Heikki, under Solaris 2.8 and SPARC 4 CPU. Regards, Alex. - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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: beggin, commit, and rollback
At 14:52 4/4/2001 -0700, Kristopher Briscoe wrote: Hi, See the sample below: C:\mysql\binmysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.36 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql create table host_info (hostname char(50)) type=innobase; Query OK, 0 rows affected (0.05 sec) mysql insert into host_info values ("Kris"); Query OK, 1 row affected (0.05 sec) mysql set autocommit=0; Query OK, 0 rows affected (0.00 sec) mysql select * from host_info; +--+ | hostname | +--+ | Kris | +--+ 1 row in set (0.00 sec) mysql delete from host_info where hostname="Kris"; Query OK, 1 row affected (0.00 sec) mysql select * from host_info; Empty set (0.00 sec) mysql rollback; Query OK, 0 rows affected (0.03 sec) mysql select * from host_info; +--+ | hostname | +--+ | Kris | +--+ 1 row in set (0.00 sec) mysql Regards, Miguel Sorry if this is mundane for some, but I have searched the manual and I cannot find the answer to itTwo issues here . 1) Doesn't mysql support begin and rollback transactions? If so what is the correct procedure to make it happen. I logged in and ran my query.. select * from host_info; saw what I expected. Then I did a begin statement begin; then I entered a delete statment delete from host_info where hostname='kris'; then did a select select * from host_info where hostname='kris'; my row had disappeared. Then I tried to implement a rollback. rollback; all returned a success, but when I ran my query again the data was still gone. This is probably something simple that I am missing. Any help is greatly appreaciated. 2) Where can I find refernce to setting up and using joins? Thanks, Kris- _ Get your FREE download of MSN Explorer at http://explorer.msn.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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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: Cold Fusion
At 13:53 08/03/2001 -0800, Andrew Staples wrote: Hi! I did a CF tag for Coldfusion to build and remove DSN files for MyODBC. The dll is called mydsn.dll and you find it at our contribution page and you can get the source code for VC++ too. Regards, Miguel New to list, and to mySQL. If there are archives available, please let me know--I'll search them. I have a client who is building a new win2k server, and wants to use ColdFusion to connect to a mySQL db, instead of MS SQL7.0. Docs show it will work with myODBC, but gives examples for Unix. 1. Can CF work with mySQL via myODBC on win2k? 2. Is there a better way to use CF and mySQL? 3. Any other gotchas? Thanks, Andrew Staples Snow Day -- stay home. - 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 __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - 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