Re: best way to copy a innodb table

Hi, You should check pt-archiver. http://www.percona.com/doc/percona-toolkit/pt-archiver.html The goal is a low-impact, forward-only job to nibble old data out of the table without impacting OLTP queries much. This tool can copy data and insert in another table in chunks of data. The

Re: MySQL slave master replication

Hi, MySQL replicate the databases at SQL level, so if the two servers are using the same engine (innodb), they will be replicated without problems. If the BLOB data is big, don't configure the replication over a WAN or you will get too much latency (of course, it depends on your bandwidth).

Re: Can't execute the given command because you have active locked tables or an active transaction

Hi, I am getting Can't execute the given command because you have active locked tables or an active transaction error when I am trying to truncate table. I am unable to understand the error as when I am using the mysql query browser then the same command is working fine but when I am doing it

Re: Compiling mysql-5.1.41 in Fedora 12

Hi, http://bugs.mysql.com/bug.php?id=42039 The --with-mysqld-libs option should be given an argument, something like --with-mysqld-libs=-L/path/to/lib -lfoo -lbar 2009/12/27 Kurian Thayil kurianmtha...@gmail.com: Hi All, I was trying to compile MySQL 5.1.41 in a Fedora 12 box. I don't want

Re: mysql load balancing

Load balancing, or high availability? I do not think there is anything good and simple AND generic out of the box.  As previous posters have noted, you generally have to build something on top of other tools. Hi, I have the HA solved with MMM. Now, I want load balacing, sending read queries

Re: mysql load balancing

Hi, El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón jcre...@warp.es escribió: 2009/12/21 Miguel Angel Nieto cor...@miguelangelnieto.net: Hi, I am searching fot a Mysql Load Balacing tool. I read about mysql proxy, sqlrelay, haproxy... What do you prefer? Hi, The solutions I

mysql load balancing

Hi, I am searching fot a Mysql Load Balacing tool. I read about mysql proxy, sqlrelay, haproxy... What do you prefer? What are the benefits and bugs? :) Thank you. -- Lo que haría sería hacerme pasar por sordomudo y así no tendría que hablar. Si querían decirme algo, tendrían que escribirlo

A first chance exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll

Hi. I have this code: cId = fila(cmbCodigo.SelectedIndex).ToString cMedida = fila(cmbMedida.SelectedIndex).ToString cDenomina = fila(cmbDenominacion.SelectedIndex).ToString oComando.CommandText = INSERT INTO preciodeno(id, medida, denomina ) _ VALUES(?cId, ?cMedida, ?cDenomina)

[ excel to mysql ]

Hi! How i do for transfer data from excel file to mysql? Some example? Thanks

Re: Error compiling source for Win

and started the build using VC++ 6.0. Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http

Re: Bug in MySQL with Correlated Subqueries?

| +--+---+ |2 | 1 | |1 | 2 | +--+---+ 2 rows in set (0.00 sec) Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing

MyODBC and Windows XP

__ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 264 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MyODBC and Windows XP

At 19:14 18/3/2004, José Angel Blanco Linares wrote: Hi, Hi, everybody I have in my office two pc machines. One of them is a Pentium III with Windows 98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP and MyODBC 2.50.39. The MySQL database is running on a linux server

Re: Fw: imposible cargar datos en tablas

, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Fw: imposible cargar datos en tablas

/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Debugging MySql Source in Visual C++

https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Debugging MySql Source in Visual C++

://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replication

Hello list, What is the current replication implementation in mysql: sync or async or both are supported? (and the respective db versions) What are the plans for the future? Thanks -- Best regards, Angel mailto:[EMAIL PROTECTED] -- MySQL General Mailing List

MySQL 5.0

Hello list, Can you tell me when approximately is the 5.0 version of MySQL going to be released? Thanks. -- Best regards, Angel mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Visual Foxpro

Depto. de Sistemas 5480-3886 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ José Angel Blanco Linares Depto Servicios de Apoyo

Perl vs. PHP with MySQL - performance?

Hi, Would like to ask people's thoughts on whether Perl or PHP has higher performance with MySQL. I've heard rumours that DBI is slower than the PHP MySQL driver. What's your experience? Does anyone know of any benchmark data comparing mod_perl and mod_php working with mySQL? Thank you very much.

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

- 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

Re: MySQL 4.0.4 Question

, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com

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

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

Re: access denied ????

://lists.mysql.com/ (the list archive) 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

Re: winadmin stopped on Beta

, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com

RE: Windows XP Installation Problems

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

Re: upgrading v3.2.3 to v4.0.2 and An error occurred during the move data process: -103

, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before

Re: MySQL 4.0.3b Bind-Address Problem

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

Re: build under Win32

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

request for support with mysql_store_result() and mysql_field_count() with vbscript

/td/tr % end if % /table % rs2.MoveNext wend rs.movenext wend con.close Set Con = nothing % ANY help would be GREATLY appreciated angel IT Services Trintex Corporation 770-258-5551 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED

Re: MySQL and Service Pack 3

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

how does one successfully use mysql_store_result()?

confusing to me. angel IT Services Trintex Corporation 770-258-5551 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: MySQL Bug

At 21:22 11/04/02 -0500, John D Armstrong wrote: Hi! On my computer both old 'stable' releases and new alpha downloads of MySQL report this error: 020411 21:21:31 Can't find messagefile 'c:\mysqin\share\english\errmsg.sys' 020411 21:21:31 Aborting Although I have checked several times for the

RE: Char set Win1250

At 15:18 10/4/2002 +0200, [EMAIL PROTECTED] wrote: Hi! Thank you for your help, but I know that I must compile kernel (mysqld) with this char set. But, this I can do with Unix (or Linux, etc.). What can I do with kernel for Win32? Is any mysqld with char set win1250 compiled in? The 4.01

Re: MySQL 3.23.43-nt stop working after approx 10 days.

At 22:21 8/4/2002 +0200, ServiceCenter resources wrote: Hi! I have a problem with my MySQL server, it has started to stop working after approximately 10 days of uptime. Seems to me an issue in your environment, not a MySQL service code issue. Take a look in the properties of the service called

Re: MySQL stops suddenly

At 22:50 3/4/2002 -0800, SankaraNarayanan Mahadevan wrote: Hi, I have MySQL 3.23 installed in Windows 2000 Server 4 days ago. It runs as a service of the server. It was working fine. But now it stops abrubtly. When I run the PhpMyAdmin snip I ahve a doubt that it shuts down by itself after a

Re: MySQL unix vs WinXP case sensitivity

At 11:03 3/4/2002 -0500, Eugene Mah wrote: Hi! Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-1999 Microsoft Corp. C:\c:\mysql\bin\mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version:

Re: Error 2004 on NT 4. maschine

At 10:05 31/03/02 +0200, Gerd Huber wrote: Hi! hi, i have installed on nt 4.0 sp 6 MySQL Version 3.23.43. After starting the process with mysqld-nt --install, i wanted to start mysql and recived the following error. Error 2004: Can't create TCP/IP socket 10044 Your machine has TCP/IP support

RE: Coldfusion,Mysql,Myodbc

At 13:29 26/3/2002 +0100, =?us-ascii?Q?Xavier_Prelat?= wrote: Hi, Even if you are using the CFServer 5.0 you will not be able to edit any MySQL DSN with the ColdFusion DSN web admin tool. A clarification here. Is possible ColdFusion to create DSN on the fly using a custom DLL. I did a DLL

Re: Query causes Mysql to shut down

At 20:36 26/03/02 +, Richard Prangnell wrote: Hi! Please, Can you send me a test case ? Including the create table statement, some rows for to insert and the queries. Regards, Miguel Dear sirs, I have a situation on my local Windows development platform that is causing the mysql daemon to

RE: Finally found mysql-nt service error 1061 1067

At 20:02 18/03/02 -0600, Gerald R. Jensen wrote: Hi, For to avoid the install of the service in local account I will add code for to verify if the user that is making the install process has administrator rights and display the error message if he/she doesn't have. Regards, Miguel Alex: I

Re: it cannot inititate downloads

At 11:17 15/03/02 -0500, alan4100 wrote: Hi! I am trying to download mysql for my windows XP but this url site: Open the URL below: http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.49-win.zip Select a mirror site and download it. Unzipped the file and run the setup.exe file. Regards,

Re: Is the new MySQL table cache implemented in InnoDb? #

At 14:20 15/03/02 -0600, BD wrote: Hi! The eWeek article http://www.eweek.com/article/0,3658,s=708a=23115,00.asp that benchmark the various databases including MySQL stated: MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When

Re: serious zlib bug discovered - your product MySQL Server 3.23.47-nt may be affected

At 01:30 15/03/2002 +0100, KJK::Hyperion wrote: Hi! Many thanks you for notice us about. We will care it. Regards, Miguel [NOTE: to make the spambot happy, here are sql and query] Hi This is an automated mail I'm sending to all vendors, developers, maintainers, etc. of software I use that,

Re: MySql fatal error in mysql-opt.exe

At 22:30 12/03/02 +, Mick wrote: Hi! Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1996. C:\c:\mysql\bin\mysqld-opt --standalone --console C:\MYSQL\BIN\MYSQLD~1.EXE: ready for connections Microsoft(R) Windows 95 (C)Copyright Microsoft Corp 1981-1996. C:\c:\mysql\bin\mysql

Re: Connect to Mysql Server

At 21:08 12/03/02 -0800, Amit Lonkar wrote: Hi! Hi All!! I have two machines on network System1 and System2. Mysql is installed on System1. On System2 I have a batch file which has the following command:- You need to have a permanent System1 mapped drive on System2, for example F:. Then in your

Re: VC++ and mysqlclient

At 18:29 09/03/2002 -0700, Michael Halcrow wrote: Hi! I use standard C++ (with some STL in there) and calls to mysql_real_connect, mysql_query, etc. However, when I tried to import my code into a Microsoft Visual C++ project (copy files in, add a

Re: Mysql won´t connect

At 19:10 05/03/2002 +0100, Othmar Stehlik wrote: Hi! Hi I installed MySql on Win2k and everything worked fine, than I also installed Oracel, mysql refused to work, than I deinstalled Oracle and did a new mysql setup. But when I try to start mysql, with mysql\binmysql mysql.exe is the client

Re: win start problem

At 13:22 04/03/2002 -0500, [EMAIL PROTECTED] wrote: Hi! Hi All, New to mysql. Running: Win2k as Administrator mysql-3.23.49-win.zip (binaries) Keep getting error (complete output below sig): mysqld: Table 'mysql.host' doesn't exist Take a look in the

Re: win start problem

it working by pointing back to the standard c:\mysql\data dir for all files I don't like this but, it works Thanks Anyway For Your Response, -Ryan On Mon, 4 Mar 2002, Miguel Angel Solorzano wrote: At 13:22 04/03/2002 -0500, [EMAIL PROTECTED] wrote: Hi! Hi All, New to mysql. Running

Re: Tuning my production MySQL server (EMERGENCY)

At 21:48 22/02/02 -0800, vijay khanna wrote: Hi! Hiya forum.. I have my site powered by MySQL server running on FreeBSD. The site is facing problems when the traffic increases.Database connectivity is through JDBC.My poolman is managing the database connections with 30 connections set, and is

Re: INNODB conversion

At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote: Hi! Very strange the printed messages you sent. What MySQL release version are you using ? I did the test with your start InnoDB set with 3.23.48 and got: c:\mysql\binmysqld-max --standalone --console InnoDB: The first specified data file

Re: INNODB conversion

At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote: Hi, Now I assume that the text you sent is from our documentation. For to build an InnoDB table: mysql create table table_name (id int)type=innodb; Query OK, 0 rows affected (0.14 sec) Regards, Miguel Dear sir, I am using MySQL database I

Re: Running MySQL on Dos System?

At 10:51 19/02/2002 -0500, Martin Filteau wrote: Hi, Is it possible to port MySql on a Dos Computer ? Sorry no. You need at least a 32 bit OS. Regards, Miguel Computer : 486DX66 OS : DR-DOS 7.03 Ram : 64 Mo HD : 1 Go Martin

Re: Error 1058 Win2K Server with MySQL

At 07:49 19/02/2002 -0600, Gerald Jensen wrote: Hi! Did you tried to put the datadir variable too in the my.cnf file ? Anyway, when the service is failing try to start it as console: mysqld-nt --standalone --console In this way you should see the messages errors, also you can see them in the

RE: Suspected Bug

At 17:59 16/02/2002 +0100, Roger Baklund wrote: Hi, Thanks for the detailed reply. :) I did my tests on a pretty old version, 3.23.30-gamma, on a win2k machine. I was not aware of the lower_case_table_names variable. (This explains why I got lower case filename in my error message, while Fred

Re: operating system error number 3

At 23:29 16/02/2002 -0500, Loretta wrote: Hi! Hello everyone: I am hoping you can help me. I have Windows 98 SE as my operating system. I have installed MySQL 4.0.1. I originally had Win ME and MySQL 3.23.48 but could not make them work together. Hopefully, someone will be able to help me.

Re: MySql Installation/Configuration

At 13:35 15/02/2002 -0500, Juwon Aikulola wrote: Hi! Hi Gurus, I downloaded and installed MySql successfully, on a Windows 2000 O/S. I want to locate the my-example.cnf file, copy it to my root directory and rename it my.cnf. However, the my-example.cnf file I locate is a shortcut, pointing to

Re: Help Regarding datadir configuration

At 16:51 14/02/2002 +0530, Asit Satpathy wrote: Hi! Mysql pick up the database list from its default datadir C:/mysql/data as it is mentioned in my.ini file in window. but i want to use my own directory which contains some database , if i am setting the datadir into my directory i am able to

Re: Retrieving a numeric series from a SELECT

. it was only a SELECT something, and it returns a consecutive serie from 1 to 100. Thanks again. __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 266

Re: Windows Version of MySQL licensing question?

At 20:31 12/02/2002 +, David Ayliffe wrote: Hi! You can assume that the Windows License Terms is the same than Unix version. The shareware is a License option that was abandoned. Regards, Miguel I read in Paul's book that to use MySQL on a Windows platform you need to pay for it. I

Re: problems with default-character-set=cp1251

At 09:48 13/02/2002 +0300, =?koi8-r?B?6czY0SDl18fFztjF18neIOvP0s/Cz9c=?= wrote: Hi! I did the test with default-character-set=cp1251 and was not be able to repeat your problem: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\cd\server\usr\mysql\bin

Retrieving a numeric series from a SELECT

, somebody wrote a sample that do exactly what I need. In fact, I took that sample and saved it to my HD, but i can't find it, hehehe. TIA __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 266

Retrieving a numeric series from a SELECT

, somebody wrote a sample that do exactly what I need. In fact, I took that sample and saved it to my HD, but i can't find it, hehehe. TIA __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 266

Re: Network drive for datadir

At 16:00 04/02/2002 +, Neil Freeman wrote: Hi! I did the test in my small network and works. The only care I did is to mapped the network drive, assign a letter (in my case F). Please take a look if effectively you had mapped the drive X (trying to access the X drive with an DOS prompt).

Re: Set up help needed

At 14:10 06/02/2002 +1100, WG4- Cook, Janet wrote: Hi, What is the best or easiest client to set up on my NT4 workstation so I can connect to the MySql server and create tables, etc via scripts? I tried downloading one or two from the MySql site but none of them seem to have any

Re: error

At 22:14 19/01/2002 +0200, Saulius Kavoliunas wrote: Hello mysql, I have a problem with starting mysql, I'm using winXP and when I try to start mysql on administrative tools\services I get a box with an error 1067, nothing else is written :(, what is the problem can you suggest me

Re: prob on NT

At 19:29 21/01/2002 +0100, e c h o p l u s A T w o r k wrote: Hi! Try to run the setup program from a DOS prompt: setup -SMS Regards, Miguel Hi Victoria, echoplusAT *I can't run a 16 bit program the file setup.exe is damage. Try to echoplusAT reinstall* (!?!?!?) echoplusAT

Re: max table size on Windows 2000

At 16:58 14/01/2002 +0100, Peter Arnold wrote: Hi! Hi, is it right, that the max. size of a table is 4 GB on WindowsOS ? I am using MySql from a Java - Program for a Log-Database and I get the Message: The table 'LOG4_FFE' is full. For this issue there are two options: 1- Use an OS of the

Bug: BINARY, NULL, and GROUP BY

At 12:13 12/01/2002 +0100, Carl Troein wrote: Hi! Thanks you for the bug report I was be able to repeat in the 4.0.1 Windows release too. Regards, Miguel CREATE TABLE t1 (txt varchar(10) default NULL); INSERT INTO t1 VALUES ('aaa'); INSERT INTO t1 VALUES (NULL); SELECT BINARY txt AS t FROM t1

Re: Installation Problems

At 16:46 12/01/02 -0800, Mark Peterson wrote: I'm having trouble with the installation of MySQL. The database was installed on the C drive. cut Please follow the steps below: - The instructions below assume that you have opened a prompt screen at c:\mysql\bin directory. - After a boot, open

Re: Installation of mySQL on a Win2000 Pro machine

At 11:57 11/01/02 +, Andrew Aragi wrote: Hi! Thanks for the info Heikki, but life has not got any better. I have bought the mySQL book (Paul DuBois) and I am still baffled. Maybe I am having a blonde week (I am blonde). From the screen shots I have seen of myCC it looks similar to SQL Server.

Re: Installation of mySQL on a Win2000 Pro machine

At 12:40 11/01/02 +, Andrew Aragi wrote: Hi, Hi Miguel. I am not using any software to rename the boot HD. Concerning the path C:\mysql\bin mysqld-max --standalone this is out of the pdf manual. What would be the correct path then? If you had installed with the default path:

Time and dates with Access.

I'm having difficulty handling data and time with access. I'm using the ODBC driver from the MySQL site to link the tables, and I can view and manipulate the data. the problem comes when I save a time, it is displayed incorrectly in access. Is this a known problem? If so, how do I work around

Re: Prevent WinMySQLAdmin from auto startup when windows 98 reboots

At 09:04 08/01/2002 -0700, Dan Jordan wrote: Hi! Go to start Menu and remove the Icon of WinMySQLAdmin. Regards, Miguel Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need

Re: Different instances of mysqladmin

At 09:31 08/01/2002 -0700, John Meyer wrote: Hi! Can I have different instances of winmysqladmin start instanciating different mysql's? i want to run one for the stable version, and one for mysql 4.0 Unlucky no. By the way the Windows Server currently doesn't have support for to run several

Re: General mySQL setup question

At 16:50 08/01/2002 +, Los Morales wrote: Hi! Hi, Would like to know if there is a preferred way of setting up the data directory for mySQL. The default for a database would be in C:\mysql\data. Is this the preferred way or should this be set up in another directory outside of the mysql

Re: Embedded MySQL terminate abnormally.

At 23:46 30/12/2001 +0900, Heo, Jungsu Mr. wrote: Hi! Below the patch made by Monty: (/my/mysql) bk diffs sql/net_serv.cc = sql/net_serv.cc 1.32 vs edited = 170c170 #ifndef EXTRA_DEBUG --- #if !defined(EXTRA_DEBUG) !defined(EMBEDDED_LIBRARY) (/my/mysql) bk diffs -c sql/net_serv.cc

[log.cc error in function stops mysqld on every connection!!]

Description: Whenever mysqld starts (seems ok) and on every connection it stops and I'm getting the following message: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly

Re: Windows 95 winsock version

At 11:17 21/12/01 +1300, Quentin Bennett wrote: Hi! http://www.microsoft.com/windows95/downloads/contents/WURecommended/S_WUNetworking/dunwinsky2k/Default.asp Regards, Miguel Hi, From the manual: Note that if you are using an old Win95 release (for example OSR2), it's likely that you have an

Re: Help Password Problems!!

At 16:57 15/12/2001 -0500, Gary Wheeler wrote: Hi, shell BINDIR/safe_mysqld --skip-grant-tables shell BINDIR/mysql -u root mysql Make sure you run mysqladmin flush-privileges or mysqladmin reload afterward to tell the server to reload the grant tables. Regards, Miguel Hi All, I've done a

Re: mysqlclient.lib compiling problem

At 16:52 14/12/2001 -0800, Devore, Jacob wrote: Hi, You need to specify the winsock.h header in your code and the wsock32.lib in the link libraries. Regards, Miguel I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error

Re: win32 libmysqld.dll

At 22:22 14/12/2001 -0500, Edward Meyer wrote: Hi, This you will get with the Win32 4.0.1 release in the next weeks. Regards, Miguel Has anybody built the embedded server libmysqld.dll for windows 2000? I downloaded the source code, however there is not a project file for the embedded server.

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

Re: MySQL on Win2000

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

Re: MySQL on Win2000

- 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

Re: question using mysqladmin with apache on win32 (w2k)

At 19:10 10/12/2001 +0100, MOWE (Michael Owens) wrote: Hi! Quick question for someone if they can pass along a little knowledge from their experiences: I am dabbling in MySQL and Apache on a Win2K box and most of it seems to work fine. The one thing I can't figure out is that when WinMySQLAdmin

Newbie!

Thanks for reading this. I'm new to the whole world of linux, and MySql, but I decided to get my hands dirty, and learn the whole thing. I have just installed corel linux, and I'm quite happy that the whole thing is working, and is visable on my network. Next I'm trying to get apache up and

Re: Replication Problem on MySQL 3.23.45/Win32

At 12:04 07/12/01 -0800, A. Clausen wrote: Hi, Does print the command show databases the db in question ? and you are able for perform commands on the tables using the mysql client tool ? Regards, Miguel I have been using replication for several months between to Win2k machines. Last week I

Re: Turn off autocommit

At 17:13 05/12/01 -0600, Demirchyan Oganes-AOD098 wrote: Hi, Hi everyone, I'm using InnoDB tables, and I would like to turn the auto commit off. I do SET AUTOCOMMIT=0 in my.ini file. And when I restart the server, it won't start. This condition should be executed by the client which is

Re: can't connect to server

At 16:11 30/11/2001 +0100, [EMAIL PROTECTED] wrote: Hi, I don't understand very well your problem, anyway here some informations: Using the MySQL Server as Service To start/stop options: 1- net start mysql/net stop mysql 2- using the SCM (Service Control Manager) 3- using the WinMySQLAdmin

Re: MySQL still hanging on Win2K :-(

At 22:00 01/12/01 +, Chris Withers wrote: Hi, I have a Win2000 machine and I would like to do a test with your problem. Please can you send me more specify details (definition table and SQL statements) so as I can build a C/C++ client program for try to repeat the issue ?. Regards, Miguel

Re: F/U @ Re: * reiteration re: (re)starting MySQL

At 20:24 26/11/2001 -0800, gx-inc wrote: Hi! I'd appreciate note-by-note directions. The my.cnf file wasn't to be found on my system (odd), though I did find the my.ini file (in the main Windows directory). In short: you can use either c:\my.cnf or \windir\my.ini file, not both. For not to

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

At 20:45 25/11/01 -0800, Bryan Chong wrote: Hi, Hi folks, I need help to start my server with InnoDB. I have manually created innodb_data_home_dir, which is c:\mysql\ibdata. The mysql server is running on Windows ME platform. my.cnf is Notice that beside the c:\mysql\ibdata directory you

Re: Mysql Daemon not starting

At 15:06 20/11/2001 +, Sandeep Murthy wrote: Hi, Every time you have problems to start the server, the best way to find the problem is try the start in the prompt DOS mode using the parameters --standalone --console. In this way you should see the message error and fix it. Also you find at

Re: Win32 mysqld-opt: Invalid page fault on certain query

At 19:10 02/11/2001 -0500, Ken wrote: Hi Ken, Unlucky with your report I can't able to begin any test for fix this behavior. Try to make notes about every step until reach the crash, then send me the notes and the structure of the tables. Regards, Miguel I'm running MySQL 3.23.41 on Win95

Re: deadlock - Innodb Monitor

At 10:48 31/10/2001 -0800, Gisella Saavedra wrote: Hi! Take a look at /mysql/data/mysql.err for to see the output for innodb_monitor. I guess that you need to stop the server, for open this file. Regards, Miguel Heikki, thanks for the reply. Regarding the trace output, My test has been

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

RE: deadlock - Innodb Monitor

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

  1   2   3   >