MySQL 5 ODBC error on Win2K

2005-02-03 Thread Whil Hentzen
1. Windows 2K and MySQL 5 2. Downloaded the 3.51.9 driver (I've seen a number of issues reported with the .10 driver, so avoided it to begin with) and installed it. It shows up in the ODBC admin nicely. 3. Created a new file DSN with the ODBC Admin 4. After I entered a name for the dsn (mysqlf),

MySQL 5.02 on Win2K

2005-02-03 Thread Elim Qiu
Anyone successfully make MySQL 5.02 working on windows2000? I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no success. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.5 - Release Date: 2/3/2005 --

Re: MySQL 5.02 on Win2K

2005-02-03 Thread Whil Hentzen
Elim Qiu wrote: Anyone successfully make MySQL 5.02 working on windows2000? I'm using 5.01 (work fine with me) , and tried 5.02 serveral times with no success. I'm running 5.0.2-alpha-net on W2K. Got it running without any problems. Getting ODBC to work, on the other hand, was a bit of a

Re: MySQL 5 ODBC error on Win2K

2005-02-03 Thread SGreen
Whil Hentzen [EMAIL PROTECTED] wrote on 02/03/2005 11:02:48 AM: 1. Windows 2K and MySQL 5 2. Downloaded the 3.51.9 driver (I've seen a number of issues reported with the .10 driver, so avoided it to begin with) and installed it. It shows up in the ODBC admin nicely. 3. Created a new file

Re: MySQL 5.02 on Win2K

2005-02-03 Thread Elim Qiu
on Win2K I'm running 5.0.2-alpha-net on W2K. Got it running without any problems. Getting ODBC to work, on the other hand, was a bit of a chore, but that seems to be running now too. What specific troubles are you having? Whil -- No virus found in this outgoing message. Checked by AVG

Re: MySQL 5 ODBC error on Win2K

2005-02-03 Thread Whil Hentzen
- SQL command on connect: left empty Note that I can connect to and manipulate the test database interactively (I added a table, inserted records, etc., all as user 'whil') 7. Hit Test Data Source 8. Error message: [MySQL][ODBC 3.51 Driver] Client does not support authentication

Re: MySQL 5.02 on Win2K

2005-02-03 Thread Whil Hentzen
Elim Qiu wrote: Here is where i stuck: I stopped the mysql service, renamed the 5.01 folder(backup), unzip the 5.02 and put it where 5.01 worked. I'm wondering if there are specific folder names that have 5.02 instead of 5.01? Or registry entries? My version of MySQL doesn't have anything

Re: Problems Moving from 3.23 to 4 (Win2k)

2004-12-16 Thread A. Clausen
Victor Pendleton wrote: A. Clausen wrote: I made a copy of my entire Mysql 3.23 data directory and moved it on to a box with a fresh install of MySQL 4. While the NT service starts up fine (I'm using 4.0.22-nt-max), I can't login. I know that there are supposed to be mods made to the mysql

Re: Problems Moving from 3.23 to 4 (Win2k)

2004-12-11 Thread Fredrick Bartlett
Subject: Problems Moving from 3.23 to 4 (Win2k) I made a copy of my entire Mysql 3.23 data directory and moved it on to a box with a fresh install of MySQL 4. While the NT service starts up fine (I'm using 4.0.22-nt-max), I can't login. I know that there are supposed to be mods made

Problems Moving from 3.23 to 4 (Win2k)

2004-12-10 Thread A. Clausen
I made a copy of my entire Mysql 3.23 data directory and moved it on to a box with a fresh install of MySQL 4. While the NT service starts up fine (I'm using 4.0.22-nt-max), I can't login. I know that there are supposed to be mods made to the mysql database tables, but I thought there was at

Re: Problems Moving from 3.23 to 4 (Win2k)

2004-12-10 Thread Victor Pendleton
What errors are being displayed when you attempt to log in? Is anything being written to the error log itself? A. Clausen wrote: I made a copy of my entire Mysql 3.23 data directory and moved it on to a box with a fresh install of MySQL 4. While the NT service starts up fine (I'm using

Looking for libmysqld.dll (embedded server) for MySQL 4.1.1 on Win2k

2004-05-23 Thread mos
I've have been looking for libmysqld.dll so I can test the MySQL embedded server on my Win2k machine. Where can I download it? I've searched www.mysql.com to no avail. TIA Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: MySQL on Win2k Server open to connections from all IPs

2004-04-29 Thread Jigal van Hemert
Victor Pendleton wrote: If you are going to do this, may I suggest starting MySQL with a non standard port number? Yeah, right. And a hacker will not perform a portscan? And he will not recognize a response from that port (e.g. Host 'hostname' is not allowed to connect to this MySQL server)???

MySQL on Win2k Server open to connections from all IPs

2004-04-28 Thread shaun thornburgh
Hi, I have installed mysql 3.23 on our Windows 2000 Server machine. How can I configure the database such that anyone on the internet can connect to this database? I know this sounds dangerous but once this has been configured we will install VPNs on this machine and any machine that we permit

RE: MySQL on Win2k Server open to connections from all IPs

2004-04-28 Thread Victor Pendleton
: 4/28/04 10:12 AM Subject: MySQL on Win2k Server open to connections from all IPs Hi, I have installed mysql 3.23 on our Windows 2000 Server machine. How can I configure the database such that anyone on the internet can connect to this database? I know this sounds dangerous but once this has been

Is it possible to protect MySQL database on a Win2k laptop?

2003-07-23 Thread mos
I want to put a MySQL 4.1 database on a Win2k laptop but the problem is it contains confidential client information. It has to be Window because applications accessing the database are written in Windows. The problem is laptops do get stolen quite often, even when running on someone's

Re: Regarding inoperable symbolic links in Win2K Pro

2003-06-06 Thread miguel solórzano
At 18:06 3/6/2003 -0700, Charles L. Nelson wrote: Hi, I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro ' and I subsequently subscribed to the belief that MySQL would fail when installed in a location that was different that the default location. I tried a myriad of things

Regarding inoperable symbolic links in Win2K Pro

2003-06-04 Thread Charles L. Nelson
Hi, I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro ' and I subsequently subscribed to the belief that MySQL would fail when installed in a location that was different that the default location. I tried a myriad of things to get the database system to function correctly

Re: Regarding inoperable symbolic links in Win2K Pro

2003-06-04 Thread Nils Valentin
:06Charles L. Nelson : Hi, I recently posted an email about 'Inoperable Symbolic Links in Win2K Pro ' and I subsequently subscribed to the belief that MySQL would fail when installed in a location that was different that the default location. I tried a myriad of things to get the database system

MySQL 3.23.39 shuts down by itself on Win2K

2003-04-02 Thread Al Caponi
Hi all, (BI've got a java application running with MySQL 3.23.39 on a Win2K server. (BNo other application uses this MySQL server. (BAnd yesterday it just shut down without any reason. This is the second time. (BThe first time was a few months back and I didn't pay attention to it. (BDoes

Re: MySQL 3.23.39 shuts down by itself on Win2K

2003-04-02 Thread Terrance Win
It seems The client had been sleeping more than wait_timeout or interactive_timeout without doing any requests. From: Al Caponi [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Subject: MySQL 3.23.39 shuts down by itself on Win2K Date: Wed, 2 Apr 2003 18:12:51 +0800 Hi all, I've

RE: MySQL 3.23.39 shuts down by itself on Win2K

2003-04-02 Thread Al Caponi
by itself on Win2K It seems The client had been sleeping more than wait_timeout or interactive_timeout without doing any requests. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

More MYSQL daemon on same WIN2K server

2003-03-28 Thread Geo
Hi, i've a problem. I must put two Mysql server daemon on same WIN2K server, but i don't know set two different my.ini file. If i run the service interactively I'm able to set to the service a different path for my.ini file, but when i start winmysqladmin he create a new my.ini file under c:\winnt

help: innodb crash on Win2k

2003-03-07 Thread Chad Brak
Mysql 4.0.11a gamma is crashing on Windows 2000 with service pack 3 with the following error: MySql: ready for connections 030203 17:39:10 InnoDB: Started 030305 9:32:50 InnoDB: Operating system error number 1450 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for

NET START MYSQL fails after initial installation (4.0.5 onto Win2K)

2003-02-10 Thread Graham Meaden
Hi I am new to MYSQL. I have just installed 4.0.5 onto Win2K and I am having problems getting the thing started. NET START MYSQL starts fine, but it seems to fail with the following contents generated in the mysql.err file (below). Any ideas what I am doing wrong? Thx GM InnoDB: The first

Re: Install on WIN2k

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
- From: Norris, Joseph [EMAIL PROTECTED] To: Mysql_List (E-mail) [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 1:55 AM Subject: Install on WIN2k Hello, I have been running mysql on windows 2000 for about 8 months. Now I have to install it on a new win2k box. I get everything installed

re: Install on WIN2k

2003-01-23 Thread Egor Egorov
On Thursday 23 January 2003 02:55, Norris Joseph wrote: I have been running mysql on windows 2000 for about 8 months. Now I have to install it on a new win2k box. I get everything installed and go to get into mysql and I am getting this error: ERROR 2003: Can't connect to MySQL server

RE: Install on WIN2k

2003-01-23 Thread Norris, Joseph
. -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 2:27 AM To: Norris, Joseph; Mysql_List (E-mail) Subject: Re: Install on WIN2k Norris, ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I remember this well but I

Re: Install on WIN2k

2003-01-23 Thread Stefan Hinz, iConnect \(Berlin\)
- From: Norris, Joseph [EMAIL PROTECTED] To: 'Stefan Hinz, iConnect (Berlin)' [EMAIL PROTECTED]; Norris, Joseph [EMAIL PROTECTED]; Mysql_List (E-mail) [EMAIL PROTECTED] Sent: Thursday, January 23, 2003 5:20 PM Subject: RE: Install on WIN2k Stefan, I have checked these things. To re-state

RE: Install on WIN2k

2003-01-23 Thread Norris, Joseph
Thanks Stefan - I found the problem in my my.ini file. Fixed and on. Thanks for the help. -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 23, 2003 3:15 PM To: Norris, Joseph; Mysql_List (E-mail) Subject: Re: Install on WIN2k

Install on WIN2k

2003-01-22 Thread Norris, Joseph
Hello, I have been running mysql on windows 2000 for about 8 months. Now I have to install it on a new win2k box. I get everything installed and go to get into mysql and I am getting this error: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I remember this well but I don't

win2k update

2002-12-18 Thread John Chang
Is there a patch update from .3 to .4? So that I don't have to reinstall it on my win2k box? If I have to reinstall it do I need to first uninstall .3 first? mysql. - Before posting, please check: http://www.mysql.com

Re: win2k update

2002-12-18 Thread Iikka Meriläinen
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is there a patch update from .3 to .4? So that I don't have to reinstall it on my win2k box? If I have to reinstall it do I need to first uninstall .3 first? You have to reinstall. But that isn't a big problem - after new installation copy

MySQL doesn't use named pipe on Win2K

2002-12-14 Thread Stefan Hinz
Dear list, MySQL 4.0.5 seems to be the first version that does not use named pipes on my Win2K box ... Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 395

Re: MySQL doesn't use named pipe on Win2K

2002-12-14 Thread miguel solórzano
At 00:49 15/12/2002 +0100, Stefan Hinz wrote: Hi, Dear list, MySQL 4.0.5 seems to be the first version that does not use named pipes on my Win2K box ... Use the --enable-named-pipe at command prompt or in your configuration file my.ini/my.cnf: Microsoft Windows 2000 [Versão 5.00.2195] (C

help - build win2k/cygwin

2002-11-25 Thread mysql
Hi, I'm trying to build mysql from the development sources (3.23.54, retreived using bitkeeper) under win2k using cygwin. Following the instructions in the mysql manual, I'm having a problem running aclocal: Dango) aclocal aclocal: configure.in: 450: macro `AM_PROG_AS' not found in library

re: Re: Strange Error with MySQL 4.0.4 under Win2K

2002-11-21 Thread Egor Egorov
Listen, Wednesday, November 20, 2002, 7:31:27 PM, you wrote: LH thanks for your great advice, finally pointing out the reason for the LH problem. SH mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL SH PRIMARY KEY; SH ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to

Re: Strange Error with MySQL 4.0.4 under Win2K

2002-11-20 Thread Listen Hinz
7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 19, 2002 7:52 PM Subject: re: Strange Error with MySQL 4.0.4 under Win2K Stefan, Sunday, November 17, 2002, 5:12:52 PM, you wrote: SH yesterday I

re: Strange Error with MySQL 4.0.4 under Win2K

2002-11-19 Thread Egor Egorov
Stefan, Sunday, November 17, 2002, 5:12:52 PM, you wrote: SH yesterday I imported some tables from MS Access via ODBC into my brand SH new MySQL 4.0.4 server. Everything went fine, but the tables did not SH have a primary key, so I did the following: SH mysql ALTER TABLE auftrag CHANGE Nummer

Strange Error with MySQL 4.0.4 under Win2K

2002-11-18 Thread Stefan Hinz
Dear list, yesterday I imported some tables from MS Access via ODBC into my brand new MySQL 4.0.4 server. Everything went fine, but the tables did not have a primary key, so I did the following: mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL PRIMARY KEY; ERROR 7: Error on

Please help with strange Win2K error

2002-11-18 Thread Stefan Hinz
Dear list, sorry for bothering you again, but no one has answered to my request for help so far, not even Jeremy Z. who *I know* can solve every and any problem remotely ;-) On Win2K with MySQL 4.0.4 I get this error with a MyISAM table: mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT

Re: Please help with strange Win2K error

2002-11-18 Thread Jocelyn Fournier
, November 18, 2002 6:08 PM Subject: Please help with strange Win2K error Dear list, sorry for bothering you again, but no one has answered to my request for help so far, not even Jeremy Z. who *I know* can solve every and any problem remotely ;-) On Win2K with MySQL 4.0.4 I get this error

Re: Please help with strange Win2K error

2002-11-18 Thread Stefan Hinz
Dear Jocelyn, On Win2K with MySQL 4.0.4 I get this error with a MyISAM table: mysql ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL PRIMARY KEY; ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to '.\trainee\#sql2-648-2.MYI' (Errcode: 13) Perror 13 means : perror 13

Re: MySQL Gui Install and Setup for Win2K

2002-09-23 Thread michael . mouer
and Setup for Win2K Don't let them mislead you, MyCC might as well be dead too... there hasn't been an update to it for more than 4 months. Go get MySQL Navigator because at least IT can export to a file that you can then edit. I usually use both though, MyCC is easier to design the basic (and I

Re: MySQL Gui Install and Setup for Win2K

2002-09-23 Thread Matt Hargraves
stuff in MySQL. Matt - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 23, 2002 7:01 AM Subject: Re: MySQL Gui Install and Setup for Win2K And where would one obtain MySQL Navigator? JMichael Matt Hargraves [EMAIL PROTECTED] 09/22/2002 09:14

Re: MySQL Gui Install and Setup for Win2K

2002-09-22 Thread Arthur Fuller
We were told by David Axmark of MySQL AB to stop using MySQLGui and switch to MyCC. MySQLGUI is apparently dead. - Original Message - From: David Kramer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 16, 2002 12:52 PM Subject: MySQL Gui Install and Setup for Win2K Can

Re: MySQL Gui Install and Setup for Win2K

2002-09-22 Thread Matt Hargraves
Subject: Re: MySQL Gui Install and Setup for Win2K Don't let them mislead you, MyCC might as well be dead too... there hasn't been an update to it for more than 4 months. Go get MySQL Navigator because at least IT can export to a file that you can then edit. I usually use both though, MyCC

RE: Japanese Characters in MySQL Win2k

2002-09-19 Thread Dawn Friedland
PROTECTED]] Sent: Wednesday, September 18, 2002 6:25 AM To: Dawn Friedland; [EMAIL PROTECTED] Subject: RE: Japanese Characters in MySQL Win2k Hi, I think Joel Rees wrote an interesting message as well. Hope you read it. I run MySQL on Windows, SuSE 7.3 (Linux) and FreeBSD. Access it through

RE: Japanese Characters in MySQL Win2k

2002-09-18 Thread Shashank Tripathi
: RE: Japanese Characters in MySQL Win2k | | | Thank you Thank you. | | Are you running MySQL on Windows and using ASP on the web | server? | | When I display the data after pulling it out, I use Shift_Jis. | | Yes, I mean the DOS prompt. My default

Re: InnoDB Win2k Service doesn't start

2002-09-17 Thread Heikki Tuuri
Matthew, - Original Message - From: Matthew Fallshaw [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 17, 2002 5:40 AM Subject: Re: InnoDB Win2k Service doesn't start [EMAIL PROTECTED] (Matthew Fallshaw) wrote in message news:[EMAIL PROTECTED]... Now

Japanese Characters in MySQL Win2k

2002-09-17 Thread Dawn Friedland
This is for anyone out there storing Japanese characters along with English characters. I've searched everywhere for anything that has to do with my particular situationwith no progress. I'm stuck. SUMMARY: The client recently requested that Japanese be stored in an otherwise standard

RE: Japanese Characters in MySQL Win2k

2002-09-17 Thread Shashank Tripathi
Storing JP and EN data in the same table has worked for me ever since I started using MySQL. Unlike Oracle, you don't need any specific charset configs (I may stand corrected). The idea is to use the correct character encodings when you *display* the data after pulling it out. In your case, I'd

RE: Japanese Characters in MySQL Win2k

2002-09-17 Thread Dawn Friedland
a deepfry (I can't read Japanese!) -Original Message- From: Shashank Tripathi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 3:36 PM To: Dawn Friedland; [EMAIL PROTECTED] Subject: RE: Japanese Characters in MySQL Win2k Storing JP and EN data in the same table has worked

Re: Win2K Problem?

2002-08-13 Thread Bob Hiller
Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: AOK Lansing [EMAIL PROTECTED] Cc: MySql List [EMAIL PROTECTED] Sent: Tuesday, August 13, 2002 3:47 PM Subject: Re: Win2K Problem? Hello, If you provide the exact error message, it would expedite the solution greatly. However, if you have MySQL

Re: Problem on win2k

2002-08-08 Thread Curtis Maurand
uses PEAR and Mysql as the DB Everything was fine till i notied that when i was trying to lock the tables for WRITE access It showed an error and the table couldnt be locked Is there something i need to do before i lock a table on Win2k Please help i cannot proceed without the Lock

RE: UDF on win2k??

2002-06-24 Thread Mike Grover
I know version 4.0.1 does. I use Delphi 6 to write my UDF's for it. mike -Original Message- From: Inandjo Taurel [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 23, 2002 9:20 PM To: [EMAIL PROTECTED] Subject: UDF on win2k?? hi, i checked the manual, but i want a confirmation here

UDF on win2k??

2002-06-23 Thread Inandjo Taurel
hi, i checked the manual, but i want a confirmation here: Mysql for window doesn't have UDF, right? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Re: Bug related to large tables and it's indexes on Win2k

2002-06-05 Thread Jared Richardson
- Original Message - From: Keith C. Ivey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Jared Richardson [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 5:24 PM Subject: Re: Bug related to large tables and it's indexes on Win2k | On 4 Jun 2002, at 15:43, Jared Richardson wrote

Re: Bug related to large tables and it's indexes on Win2k

2002-06-05 Thread Keith C. Ivey
On 5 Jun 2002, at 7:50, Jared Richardson wrote: This table is part of a product that contains publicly available (and always expanding) publicly avilable biological data in addition to large companies internal data. A one terrabyte cap very well could come back to haunt us one day! (sadly

Bug related to large tables and it's indexes on Win2k

2002-06-04 Thread Jared Richardson
Hi all, When large tables are being addressed, we seem to have encountered a bug related to having large indexes on the table. We have several tables in our system that have reached 4 gigs in size. We altered the table definition to allow it to get larger... this is our current table creation

Re: Bug related to large tables and it's indexes on Win2k

2002-06-04 Thread Jared Richardson
Win2k (at least the version that we are on) does indeed support files much larger than 2 gigs. Another db we use has index files that are 6.8 gigs and 4.7 gigs. - Original Message - From: miguel solorzano [EMAIL PROTECTED] To: Jared Richardson [EMAIL PROTECTED]; [EMAIL PROTECTED

Re: Bug related to large tables and it's indexes on Win2k

2002-06-04 Thread Jared Richardson
The table type is the default, MYISAM - Original Message - From: Schneck Walter [EMAIL PROTECTED] To: 'Jared Richardson ' [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:11 AM Subject: AW: Bug related to large tables and it's indexes on Win2k

Re: Bug related to large tables and it's indexes on Win2k

2002-06-04 Thread Jared Richardson
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 10:20 AM Subject: AW: Bug related to large tables and it's indexes on Win2k | Well, | | im not an expert in MYSQL tabletypes, | but what if seen yet InnoDB is the most | preferred tabletyp for real appis. | if possible

Re: Bug related to large tables and it's indexes on Win2k

2002-06-04 Thread Ian Gilfillan
and it's indexes on Win2k Thanks Walter since their is no reason (that I am aware of) for the system not to handle the current problem, I want to try to solve it if possible. I have been using MySql for a number of years... if this is an actual bug, it will be the first one I've ever

Re: Bug related to large tables and it's indexes on Win2k

2002-06-04 Thread Roger Baklund
* Jared Richardson [...] CREATE TABLE IcAlias( IcAliasID BIGINT NOT NULL PRIMARY KEY, mID VARCHAR(255) NOT NULL, IcEntityID BIGINT NOT NULL, IcTypeID SMALLINT NOT NULL, IcDupSortID VARCHAR(255) NOT NULL, INDEX mIDIdx (mID), INDEX IcTypeIDIdx (IcTypeID), INDEX

Re: Bug related to large tables and it's indexes on Win2k

2002-06-04 Thread Jared Richardson
I replied below - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 3:24 PM Subject: Re: Bug related to large tables and it's indexes on Win2k | * Jared Richardson | [...] | CREATE TABLE IcAlias( | IcAliasID BIGINT NOT NULL

copy osx db to win2k

2002-03-18 Thread jake williamson 28
hello! i've been developing a MySQL database in mac osX - i would like to transfer it to work onto a win2k box running apache and mysql. what files from X do i need to copy over? is this a fairly simple process or am i heading for a world of pain?! cheers, jake p.s. if this is possible, does

Re: copy osx db to win2k

2002-03-18 Thread Joel Rees
jake williamson 28 queried: hello! i've been developing a MySQL database in mac osX - i would like to transfer it to work onto a win2k box running apache and mysql. Have you looked at mysqldump and mysqlhotcopy, in section 4.8 of the manual? what files from X do i need to copy over

mingw, mysql c api, win2k cmd line error

2002-03-15 Thread David Thompson
I am having a heck of a time getting a simple c program up and running using mingw and the mysql c api. My makefile is simple enough I'm not sure what the -lm switch on the search compile line is for but I saw it in someone's makefile on the web so I through it in hoping it would work): #

Problem entering data in Access, win2k default system locale differs from MySQL db locale

2002-03-11 Thread Ness
The problem is following: MySQL 4.0.1 alfa on Win2k machine MyODBC 3.51.01 Access XP I need to migrate my clients database from Access to MySQL server and use Access as a frontend to MySQL for adding data. BUT default system locale is different from MySQL locale (cp1257). My database

Problem entering data in Access, win2k default system locale differs from MySQL db locale

2002-03-11 Thread Ness
The problem is following: MySQL 4.0.1 alfa on Win2k machine MyODBC 3.51.01 Access XP I need to migrate my clients database from Access to MySQL server and use Access as a frontend to MySQL for adding data. BUT default system locale is different from MySQL locale (cp1257). My database

Error 1058 Win2K Server with MySQL

2002-02-19 Thread Gerald Jensen
\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we ... net start mysql we get the following error: System

Re: Error 1058 Win2K Server with MySQL

2002-02-19 Thread Miguel Angel Solorzano
database = Wires queries_root= F:\MYSQL\queries last_database_file= F:\MYSQL\lastdb This system is to use MyISAM tables. From a DOS prompt, we switched into the F:\MYSQL\BIN directory and... mysqld-nt --install Win2K reports the service installed. When we

Re: Error 1058 Win2K Server with MySQL

2002-02-19 Thread Gerald Jensen
Problem is solved ... customer had his server configured so any new services being installed were automatically disabled! That is why the service would not start. We have installed MySQL on about a dozen Win2K Advanced servers ... this is the first time we have encountered this issue. Thank you

Prob with starting MySql service on WIN2k!!!

2002-01-22 Thread ±èÁøÇõ
Hi, i installed mysql-3.23.47-win version on win2k, but i cant start MySql service. When i try to start mysql service, i get an error msg like this; Can't start MySql service on Local Computer Error 1067 : Unexpected process termination. i installed mysql once again and started service

Re: setting root psswd on Win2K ??

2002-01-10 Thread Gerald Clark
You can't login as plain old nobody. The default mysql user is your unix user, so if you are logged into unix as root , and entered mysql you were logged into mysql as root. You appear to have been logged in as mysql. If the user mysql has full privileges, then there was nothing to prevent the

Re: setting root psswd on Win2K ??

2002-01-10 Thread Gerald Clark
However, you are running WIN2K, not unix as i assumed in my previous post. There still must be some default user which apparently has full privileges. Bryan Capitano wrote: Having some problems setting root password on MySQL. Can anybody help me? I've just installed MySQL 3.23.38 on a Windows

RE: setting root psswd on Win2K ??

2002-01-10 Thread Todd Williamsen
Gerald... He isn't on a Unix box, he is on a Win2k box -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 8:46 AM To: Bryan Capitano Cc: [EMAIL PROTECTED] Subject: Re: setting root psswd on Win2K ?? You can't login as plain old nobody

Re: setting root psswd on Win2K ??

2002-01-10 Thread Bryan Capitano
januari 2002 8:51 Aan: [EMAIL PROTECTED] Onderwerp: setting root psswd on Win2K ?? Having some problems setting root password on MySQL. Can anybody help me? I've just installed MySQL 3.23.38 on a Windows 2000 server. I'm following the directions in the documenation for setting the root password

setting root psswd on Win2K ??

2002-01-09 Thread Bryan Capitano
Having some problems setting root password on MySQL. Can anybody help me? I've just installed MySQL 3.23.38 on a Windows 2000 server. I'm following the directions in the documenation for setting the root password: mysql -u root mysql mysqlUPDATE user mysqlSET password=password('mynewpass')

MySQL thread hanging on Win2K

2001-12-01 Thread Chris Withers
Hi, I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables. I'm running an import process which inserts a big set of rows ('bout 27 million), as part of a document indexing process. Each new row uses the AUTO_INCREMENT_ID from the previous row. So, I have a loop which

Re: MySQL thread hanging on Win2K

2001-12-01 Thread Sinisa Milivojevic
Chris Withers writes: Hi, I've got a problem with 3.23.44-max-nt on Windows 2000 using Berkley tables. I'm running an import process which inserts a big set of rows ('bout 27 million), as part of a document indexing process. Each new row uses the AUTO_INCREMENT_ID from the previous row.

Re: MySQL thread hanging on Win2K

2001-12-01 Thread Chris Withers
Hi Sinisa, Sinisa Milivojevic wrote: There are several possibilities. You could be reaching some OS limits or haning user / group permission problems. Don't think its permissions, since I had a similar process which ran fine, but I had to change the schema to use the last insert id for

MySQL still hanging on Win2K :-(

2001-12-01 Thread Chris Withers
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

Re: MySQL still hanging on Win2K :-(

2001-12-01 Thread 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

Help needed with MySql/MyODBC ColdFusion on Win2k

2001-11-14 Thread Markus Wollny
Hi! I am desperately trying to get the following combination to run: MySQL (Win32 3.23.44) on host_1.something.tld ColdFusion Enterprise 4.5.1 SP2 for Windows on host_2.something.tld MyODBC 2.50.39 for NT/2000/XP on host_2.something.tld The MySQL-DB ist hosting one database named TEST with one

Win2k - User defined function - how?

2001-11-10 Thread Dean Attewell
I want to be able to define a user defined function in a Update query eg Update Table Set MyField=MyFunction(TestField1,TestField2); Where Myfunction tests 2 fields to return a result. I am after a quick solution Thanks Dean

RE: persistent shutdown of MySQL 3.23.42 Max on Win2K

2001-10-30 Thread Heikki Tuuri
: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 8:24 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: persistent shutdown of MySQL 3.23.42 Max on Win2K Chris, What does InnoDB print to the error log when it restarts? Run mysql-max-nt.exe from the MS-DOS prompt

Re: Can't get --DataDir to work on Win2k

2001-10-17 Thread Miguel Angel Solórzano
. 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

Win2K/MS Access 2K/My SQL

2001-10-01 Thread Paul @ KB Technology
Hi, I have an application written in MS Access 2000 which has linked tables from a MYSQL database. I'm having a problem running queries which update the linked tables. I can update individual records ok from Access, but as soon as i tried to run a query, the query failes saying X number of

Win2k Replication Problem

2001-09-26 Thread Jared Richardson
Hi all, I've done a decent amount of searching on Deja.com but haven't found anyone with this particular problem. I have two boxes running MySql on Win2k. Replication works great. One box is Master, one is Slave. After the boxes are running, any write to the Master is replicated to the Slave

Re:Can't get MySQL running on Win2K

2001-09-06 Thread Heikki Tuuri
systems! The combined size of data files must be = 10 MB. InnoDB does not create directories: you have to create them yourself. Regards, Heikki http://www.innodb.com Configuration: multiboot system. C: is for DOS and System Commander, R: is for Win2K. \ (Most) applications go on F:, (most) data goes

Re:Can't get MySQL running on Win2K

2001-09-06 Thread Marjolein Katsma
- it actually *should* return to the prompt. Buglet?) Should my.cnf actually be on R:\ on my system since that is the root of the _system_ drive when I run Win2K (while C: definitely isn't)? Cheers, At 15:11 2001-09-06 +0300, Heikki Tuuri wrote: Marjolein, if you do not want to use transactional InnoDB

Re:Can't get MySQL running on Win2K

2001-09-06 Thread Heikki Tuuri
Date: Thu, 06 Sep 2001 17:24:21 To: Marjolein Katsma [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED] Subject: Re:Can't get MySQL running on Win2K X-Attachments: C:\MY.CNF; Hi! I think it is best to have only one my.ini or my.cnf in your system. Otherwise there will be confusion

Help -- can't install mysql as service in win2k

2001-09-06 Thread Michael Tam
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

Re: Help -- can't install mysql as service in win2k

2001-09-06 Thread Miguel Angel Solórzano
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

Re:Can't get MySQL running on Win2K

2001-09-06 Thread Marjolein Katsma
on my web host.) Thanks again - problem solved within one day! At 17:25 2001-09-06 +0300, Heikki Tuuri wrote: Date: Thu, 06 Sep 2001 17:24:21 To: Marjolein Katsma [EMAIL PROTECTED] From: Heikki Tuuri [EMAIL PROTECTED] Subject: Re:Can't get MySQL running on Win2K X-Attachments: C:\MY.CNF; Hi! I

Re: Help -- can't install mysql as service in win2k

2001-09-06 Thread Marjolein Katsma
Michael, Have a look at the thread Can't get MySQL running on Win2K (started by me) - I have it working now (thanks Heikki!) and the solution might be of use to you as well. At 08:27 2001-09-06 -0700, Michael Tam wrote: Hi all, I have uninstall mysql3.23.39 from Win2k and after I install

Startin MySQL upon boot in Win2k

2001-08-22 Thread Mikkel Gravgaard
mysqld --basedir=C:\Program Files\MySQL -- The .bat file is put in the Startup-folder, but this means that when Win2k Professional has booted, I end up with a command-window on my desktop, which I'll have to manually close. Can anyone think of a bit more smooth way to get it all going? /Mikkel

Re: Startin MySQL upon boot in Win2k

2001-08-22 Thread shiuwaitai
22, 2001 5:16 PM Subject: Startin MySQL upon boot in Win2k Since I like my hard drive more tidy than my house, I've put MySQL in C:\Program Files\MySQL. This means that I currently have to start MySQL using a .bat file, since the mysql-daemon won't find the MySQL-directory if I

  1   2   >