Re: Fw: Which files to download/install - problems running MySQL

[Miguel Angel Solórzano]

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\bin>mysqld-opt --console --standalone
   021022  1:23:47  InnoDB: Started
   mysqld-opt: ready for connections
   --

   ---client prompt screen---
   C:\mysql\bin>mysql
   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\bin>mysqld-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\bin>mysql -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\bin>mysqld-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 

Re: Which files to download/install - problems running MySQL

[Miguel Angel Solórzano]

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\bin>mysqld-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: MySQL 4.0.4 Question

[Miguel Angel Solórzano]

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: access denied ????

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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: MySQL 4.0.3b Bind-Address Problem

[Miguel Angel Solórzano]

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: upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103

[Miguel Angel Solórzano]

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: build under Win32

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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: win32 libmysqld.dll

[Miguel Angel Solórzano]

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: mysqlclient.lib compiling problem

[Miguel Angel Solórzano]

At 16:52 14/12/2001 -0800, Devore, Jacob wrote:
Hi,

You need to specify the  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: MySQL on Win2000

[Miguel Angel Solórzano]

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: MySQL on Win2000

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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: question using mysqladmin with apache on win32 (w2k)

[Miguel Angel Solórzano]

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: Turn off autocommit

[Miguel Angel Solórzano]

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: Replication Problem on MySQL 3.23.45/Win32

[Miguel Angel Solórzano]

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: MySQL still hanging on Win2K :-(

[Miguel Angel Solórzano]

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: can't connect to server

[Miguel Angel Solórzano]

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: F/U @ Re: * reiteration re: (re)starting MySQL

[Miguel Angel Solórzano]

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:\WINDOWS>cd c:\mysql\bin\
>
>C:\mysql\bin>mysqld --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\bin>mysqld --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 

Re: mysql win32 binary w/ innodb: error number 3

[Miguel Angel Solórzano]

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 & Win200 problem (telnet localhost)

[Miguel Angel Solórzano]

At 10:04 22/11/2001 +, Sandeep Murthy wrote:
Hi,

When you are having problems for to start the server as service on
NT/Win2000 machine. Follow the below troubleshooting:

1- Enter in the \mysql\bin directory opening a DOS prompt screen.
2- Execute the remove service command with any server e.g.:
mysqld-max-nt --remove
Even the service doesn't exist, this command doesn't create any
problem.
IMPORTANT: When performing command for install and remove the
   MySQL service in the shell prompt, the SCM (Service
   Control Manager) should be closed.
3- Now with the SCM (Service Control Manager) take a look if effectively
the service called mysql doesn't exists.
If you see, the service above this means that for any reason your
SCM is in bad state, so you need to re-boot the machine.
4- If you are using any Max server:
mysqld.exe
mysqld-max.exe
mysqld-max-nt.exe
You should need the use of the /winnt/my.ini file for to set the
variables for InnoDB table or adding the variable skip-innodb if
you don't want to use this type of table. You need to read
complementary instructions for to set the InnoDB in our Manual.
Also if you installation directory is other than the default
c:\mysql, you need to set the variables basedir and datadir.
Below I show you, the my.ini file that there is on my machine,
as a sample:

[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 = innodb_additional_mem_pool_size=10M
set-variable = innodb_file_io_threads=4
set-variable = innodb_lock_wait_timeout=50

You should use the notepad.exe or other ASCII editor like the
edit.exe or Xemacs for Win32 for to create the my.ini file.
5- Back for the DOS screen shell.
Do the below command with the server you want, e.g.:

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>cd\mysql\bin

C:\mysql\bin>mysqld-max-nt --standalone --console
011122 21:54:27  InnoDB: Started
mysqld-max-nt: ready for connections

In the sample above I had a successfully start. However below I
show you, a failed start:

C:\mysql\bin>mysqld-max-nt --standalone --console

mysqld-max-nt: Fatal error: Can't find messagefile
'c:\mysql\share\english\errmsg.sys'

011122 21:57:03  Aborting

Then how you can guess that the purpose to try the server as
standalone mode is to find the message error which cause the
failed start. Also you can find in the /mysql/data/mysql.err
file, useful information about.
6- If necessary fix the problems found in the step above.
7- Stop the server using the mysqladmin tool:
mysqladmin shutdown
Maybe you need to perform twice the command above. This problem
should will fixed as soon as possible.
8- Install the service:
mysqld-max-nt --install
9- Start the service:
net mysql start

I hope this help you.

Regards,
Miguel

>hi,
>
>I had posted a few days back regarding having problems running MySQL on WIN
>2000...
>
>I forgot to add before, I can ping my localhost but unable to do a telnet
>localhost too...
>I had installed and was running MySQL and PHP with IIS successfully for
>nearly 2 mths now... All of sudden since a few days back the MySQL service
>refuses to start and keeps giving various errors such as unable to find path
>etc...
>
>I uninstalled and reinstalled MySQL a couple of times all in vain..
>
>What could have happened and how may I rectify this problem...
>
>Would appreciate much if anyone can help me out on this..
>
>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 req

Re: Mysql Daemon not starting

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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\bin>mysqld-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:

Re: deadlock - Innodb Monitor

[Miguel Angel Solórzano]

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\bin>mysqld-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

[Miguel Angel Solórzano]

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: DATA DIRECTORY bug on Win32

[Miguel Angel Solórzano]

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\bin>mysqlc 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

[Miguel Angel Solórzano]

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: Help turning on raid on MySQL windows version

[Miguel Angel Solórzano]

At 20:29 22/10/2001 -0400, Butch Bean wrote:
Hi!

I had consulted the MySQL developer Tonu the responsible of the
RAID code about the use of RAID on Windows and he said me that
wasn't tested it on Win32. Then I will need to do the test and
discuss with him the results.

However if your problem is the file size, you can use and test
the option to use InnoDB tables, this tables uses table space
feature and you put the files in different drive location too:

innodb_data_file_path=C:\ibdata\ibdata1:2G;D:\ibdata\ibdata2:2G

Now I can't to say for you when the RAID test on Win32 will be
made.

Regards,
Miguel



>Has anybody turned on raid for the windows version?
>
>Turning this feature on in Unix appears simple, but what about windows...
>
>I have MySQL version 3.23.43 Linux & windows and I need them both configured
>the same way.
>
>Butch Bean
>
>
>-
>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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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\bin>mysqld-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\bin>mysqld-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: DISTINCT

[Miguel Angel Solórzano]

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: Mysql 3.23.41 fails to install as service on Win 2000 Professional

[Miguel Angel Solórzano]

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: confirmation of transferred records from myodbc

[Miguel Angel Solórzano]

At 14:18 01/10/2001 -0400, melissa allman wrote:
Hi,
If you link the MySQL table using MyODBC you can build an Append
Query on Access which inform you the number of rows from the
record set and at the end the number of rows which had successfully
processed.
If you want to avoid duplication of records, you need to define a
simple or compound primary key in the Access table.
Also before to do the Append Query you can build using the Query
Wizard of Access for build a query to find duplicate rows.

Regards,
Miguel

Regards,
Miguel
>Hi,
>
>I am working on a project that involves using a form to populate a MYSQL
>table.
>I then need to transfer these records to an Access database. I want to have a
>flag on the MYSQL table to indicate that the record was successfully sent to
>Access.
>It could be an on/off or Y/N value. I am trying to avoid duplication of
>tranfereed records. Has anyone done this?
>
>Thanks,
>Melissa
>
>---
>The Fastest Browser on Earth.
>Get your FREE download of Opera at http://www.opera.com/download/
>---
>
>
>-
>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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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: Win32 Mysql 3.23.41 will not start anymore

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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: Help -- can't install mysql as service in win2k

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

Re: Error when opening mysqld.exe

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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: Building on Win32

[Miguel Angel Solórzano]

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: MSAccess --> MySQL - append query slows, then dies

[Miguel Angel Solórzano]

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: Cannot build with C++

[Miguel Angel Solórzano]

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 
>#include "mysql.h"
>#include 
>
>//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: Problem with user rights

[Miguel Angel Solórzano]

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\bin>mysql
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: Case-preserving is not consistent

[Miguel Angel Solórzano]

At 04:23 19/08/2001 -0700, Lars Bruun Hansen wrote:
Hi,

This behavior is fixed in the release 3.23.41. Into
the next 6 hours I will send the distribution files
for our Web master, so maybe at Monday or Tuesday
you can get it from our download page.

Take a look in the printed samples below, how is
the new behavior having lower_case_table_names=0.

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

c:\mysql\bin>mysql test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.41-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table MyTable (x char(1));
Query OK, 0 rows affected (0.02 sec)

mysql> show tables;
++
| Tables_in_test |
++
| MyTable|
++
1 row in set (0.00 sec)

mysql> alter table MyTable add (y char(1));
Query OK, 0 rows affected (0.03 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show tables;
++
| Tables_in_test |
++
| MyTable|
++
1 row in set (0.00 sec)

mysql> alter table MyTaBLE add (z char(1));
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show tables;
++
| Tables_in_test |
++
| MyTaBLE|
++
1 row in set (0.00 sec)

mysql>

Regards,
Miguel



>Version:   MySQL  v. 3.23.40  (Windows NT)
>
>Hello,
>
>I would like MySQL to preserve the case of my table names and therefore I 
>have set
>lower_case_table_names=0 in my configuration. I use Windows NT.
>
>This works fine for CREATE TABLE statements but the moment I use a ALTER 
>TABLE statement the name of the table will be converted to lowercase. My 
>conclusion is that CREATE TABLE respects lower_case_table_names but ALTER 
>TABLE does not and this seems like a bug to me?
>
>See example:
>
>
>mysql> create table MyTable (x char(1));
>mysql> show tables from test;
>++
>| Tables_in_test |
>++
>| MyTable|
>++
>
>mysql> alter table MyTable add (y char(1));
>mysql> show tables from test;
>++
>| Tables_in_test |
>++
>| mytable|
>++
>
>If this is not a bug how do I then get MySQL to be case-preserving for the 
>table names?
>
>Hope somebody can help.
>
>Lars Bruun Hansen
>Denmark

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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
>[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?)

[Miguel Angel Solórzano]

x27;D:\MSDEV\VC98\bin\link.exe'
> >>   Creating library release/libmySQL.lib and object release/libmySQL.exp
> >>Move DLL export lib
> >>Overwrite D:\compile\mysql\lib_release\libmySQL.lib (Yes/No/All)? ?N(
> >>Overwrite D:\compile\mysql\lib_release\libmySQL.lib (Yes/No/All)?
> >>Error executing c:\winnt\system32\cmd.exe.
> >>
> >>mysqld-max-nt.exe - 1 error(s), 0 warning(s)
> >>
> >>Possible solution: add the Y option to the xcopy command
> >>
> >>Also, the debug build installs libmysql.lib in C:\winnt\system32\ !
> >>(libmysql/libmysql.dsp, that is)
> >>1) you cannot assume that NT is installed in that location
> >>2) it should not do it in the first place
> >>
> >>I'd like to help you guys with this, so if you decide HOW things
> >>should be done, I can do the grunt work.
> >>
> >>Best regards
> >>
> >>At 09:00 3/16/2001, John Dean wrote the following:
> >>--
> >>>Hi
> >>>At 11:13 15/03/2001 +0100, Cynic wrote:
> >>>>Hi Joachim & Jorge,
> >>>>
> >>>>I had the same problem. Looks like it's not possible to build
> >>>>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=22&site=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 Programmer’s
> >>>>>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 Microsoft’s Linker
> >>>>>version 5.63 that is available from Microsoft’s FTP site.
> >>>>
> >>>>BTW, the Processor Pack I installed contains MASM (

Re: mysql-max-nt, missing files in the intel/windows distrib

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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:  
> >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: Placing database on a novell disk

[Miguel Angel Solórzano]

At 09:17 13/07/2001 +0200, Järkeborn Joacim wrote:
Hi,

The question here, is if Novell mapped drives have the same
behavior of Windows mapped drives. Sorry but I don't have
experience with Novell, however taking a look on Win2k Server,
the client for Novell is mentioned how a gateway and perhaps
is used a layer for the IPX protocol that our code it isn't
able to recognize for mapped drives.
Then in my opinion you need to find literature, how the mapped
drives for Novell are handled by a Win machine and if exist a
way to handle like a Win mapped drive.

Regards,
Miguel

>Hi,
>
>After installation in 'C:\mysql' I moved the 'C:\mysql\data' directory to 
>'C:\mysql-data'. That means that all databases where moved (mysql, test 
>and my own). The same was to the Novell drive.
>
>I need to do this since I'm going to insert approx. 3.4 GB of data and I 
>have not that much space left on my local drives.
>
>BR
>Joacim
>
> > -Original Message-
> > From: Miguel Angel Solórzano [mailto:[EMAIL PROTECTED]]
> > Sent: den 12 juli 2001 18:54
> > To: Järkeborn Joacim; mySql Mailing List
> > Subject: Re: Placing database on a novell disk
> >
> >
> > At 15:01 12/07/2001 +0200, Järkeborn Joacim wrote:
> > Hi,
> >
> > Did you had moved the mysql database (together with the grant tables)
> > for the new location ?
> > I can't to test Novell mapped drive on Win32, however I didn't find
> > problems with mapped drives on Win32:
> >
> > E:\mysql\bin>mysql
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 9 to server version: 3.23.39-max
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql> show variables like "datadir";
> > +---+--+
> > | Variable_name | Value|
> > +---+--+
> > | datadir   | h:\data\ |
> > +---+--+
> > 1 row in set (0.00 sec)
> >
> > mysql>
> >
> > Regards,
> > Miguel
> > >Hi there,
> > >
> > >I have installed the Win32 mySQL binaries on 'C:\mysql' and
> > databases on
> > >'C:\mysql-data'. I have also an configuration file
> > 'C:\my.cnf' containing
> > >(and other things):
> > >
> > >basedir = c:/mysql/
> > >datadir = c:/mysql-data/
> > >
> > >- Now I want to move the databases to a mapped novell disc 'K:\' and
> > >changes the 'C:\my.cnf' according to the new path. When
> > trying to start
> > >the NT service I gets an error
> > >
> > >C:\mysql>NET START mysql
> > >The MySql service is starting.
> > >The MySql service could not be started.
> > >A system error has occurred.
> > >System error 1067 has occurred.
> > >The process terminated unexpectedly.
> > >
> > >
> > >What dependicies have mySQL?
> > >- Can I move the installed 'C:\mysql' dir, databases and
> > 'C:\my.cnf' to
> > >another machine and get it to work?
> > >- Has it keys in the registry and/or files in some windows
> > system directory?
> > >
> > >BR
> > >Joacim
> > >
> > >-
> > >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: Placing database on a novell disk

[Miguel Angel Solórzano]

At 15:01 12/07/2001 +0200, Järkeborn Joacim wrote:
Hi,

Did you had moved the mysql database (together with the grant tables)
for the new location ?
I can't to test Novell mapped drive on Win32, however I didn't find
problems with mapped drives on Win32:

E:\mysql\bin>mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 3.23.39-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show variables like "datadir";
+---+--+
| Variable_name | Value|
+---+--+
| datadir   | h:\data\ |
+---+--+
1 row in set (0.00 sec)

mysql>

Regards,
Miguel
>Hi there,
>
>I have installed the Win32 mySQL binaries on 'C:\mysql' and databases on 
>'C:\mysql-data'. I have also an configuration file 'C:\my.cnf' containing 
>(and other things):
>
>basedir = c:/mysql/
>datadir = c:/mysql-data/
>
>- Now I want to move the databases to a mapped novell disc 'K:\' and 
>changes the 'C:\my.cnf' according to the new path. When trying to start 
>the NT service I gets an error
>
>C:\mysql>NET START mysql
>The MySql service is starting.
>The MySql service could not be started.
>A system error has occurred.
>System error 1067 has occurred.
>The process terminated unexpectedly.
>
>
>What dependicies have mySQL?
>- Can I move the installed 'C:\mysql' dir, databases and 'C:\my.cnf' to 
>another machine and get it to work?
>- Has it keys in the registry and/or files in some windows system directory?
>
>BR
>Joacim
>
>-
>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.

[Miguel Angel Solórzano]

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:\mysql>cd bin
>
>C:\mysql\bin>mysqld --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.
>07/09/2001  11:59a..
>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 

Re: Innodb does not work with NT Max 3.23.39

[Miguel Angel Solórzano]

At 12:51 10/07/2001 +0300, Leo Vanhatalo wrote:
Hi,

Did you had created manually the directories:

e:\innodb\data and e:\innodb\logs ?

because InnoDB doesn't create the directories, only the data
and logs files.

Regards,
Miguel

>Hi!
>
>I wanted to use row level locking. I modified the my.ini as follows :
>#This File was made using the WinMySQLadmin 1.1 Tool
>#7/10/2001 10:59:39 AM
>
>[mysqld]
>basedir=C:/mysql
>datadir=C:/mysql/data
>innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
>innodb_data_home_dir = e:\innodb\data
>set-variable = innodb_mirrored_log_groups=1
>innodb_log_group_home_dir = e:\innodb\logs
>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 = e:\innodb\arch
>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
>
>[WinMySQLadmin]
>Server=C:/mysql/bin/mysqld-max-nt.exe
>user=system
>password=manager
>QueryInterval=10
>
>---
>But when I try to start the db with winmysqladmin, it does not start. No 
>error is given. According innodb documentation starting the database 
>should create innodb tablespaces, but nothing is created.
>Mysql gives this error message :
>ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)
>---
>Please help. And please send the message also directly to me because I am 
>not in the list.
>
>Leo
>_
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Hi,sir.I have a question!

[Miguel Angel Solórzano]

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: Unlock tables when process has killed.

[Miguel Angel Solórzano]

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\bin>mysql 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)
   ht

Re: Unlock tables when process has killed.

[Miguel Angel Solórzano]

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\bin>mysql 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


-
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

[Miguel Angel Solórzano]

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: MySQL HELP -- Unable to start Win2k service

[Miguel Angel Solórzano]

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: How to make symbolic link under windows

[Miguel Angel Solórzano]

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: system error 1067

[Miguel Angel Solórzano]

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: bug please help

[Miguel Angel Solórzano]

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: MySql in Win32 stop after 5 minutes.

[Miguel Angel Solórzano]

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: Newbie problem with winmysqladmin

[Miguel Angel Solórzano]

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: MYSQL errmsg.sys

[Miguel Angel Solórzano]

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: install service on nt

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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: Error/crash with InnoDB if table name = database name

[Miguel Angel Solórzano]

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: mySQL on Win2K Need Assistan

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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: odbc on WinME

[Miguel Angel Solórzano]

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 REGEDIT4>myodbc.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






>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:Error I'm receiving

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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:\WINDOWS>mysqld
>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

[Miguel Angel Solórzano]

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   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  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: Borland C++Builder compile error

[Miguel Angel Solórzano]

At 10:03 07/06/2001 -0700, Jay Stewart wrote:
Hi!

Please add #include  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: Help required for OLEDB on win32 for MySQL(linux)

[Miguel Angel Solórzano]

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: VB3 and mysql

[Miguel Angel Solórzano]

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: Getting Error 1067 when trying to start MySQL as service on NT 4.0

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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", , "auto_increment"
"name", "char(50)", "YES", "", , ""
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: DROP TABLE problem!

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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\bin>mysql
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\bin>mysqld-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

Re: Mysql and Windows ME?

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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\bin>mysqld
>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

[Miguel Angel Solórzano]

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: 请求帮助

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

Compiling InnoDB on Win32

[Miguel Angel Solórzano]

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

[Miguel Angel Solórzano]

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

Re: Making MySQL DB Remotely Accessible

[Miguel Angel Solórzano]

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