Re: best way to copy a innodb table

2011-12-01 Thread Miguel Angel Nieto
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 destin

Re: Compiling mysql-5.1.41 in Fedora 12

2009-12-30 Thread Miguel Angel Nieto
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 : > Hi All, > > I was trying to compile MySQL 5.1.41 in a Fedora 12 box. I don't want to do an > RPM  ins

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

2009-12-30 Thread Miguel Angel Nieto
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 doi

Re: MySQL slave master replication

2009-12-30 Thread Miguel Angel Nieto
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). 2009

Re: mysql load balancing

2009-12-25 Thread Miguel Angel Nieto
> 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 que

Re: mysql load balancing

2009-12-22 Thread Miguel Angel Nieto
Hi, El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón escribió: > 2009/12/21 Miguel Angel Nieto : >> Hi, >> >> I am searching fot a Mysql Load Balacing tool. I read about mysql >> proxy, sqlrelay, haproxy... >> >> What do you prefer? > > Hi,

mysql load balancing

2009-12-20 Thread Miguel Angel Nieto
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

2008-05-18 Thread Lord Gustavo Miguel Angel
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 ]

2008-05-08 Thread Lord Gustavo Miguel Angel
Hi! How i do for transfer data from excel file to mysql? Some example? Thanks

Re: Error compiling source for Win

2004-06-01 Thread Miguel Angel Solorzano
c.zip" and started the build using VC++ 6.0. Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano <[EMAIL PROTECTED]> São Paulo - Brazil -- MySQL General Mailing List For lis

Re: Bug in MySQL with Correlated Subqueries?

2004-03-27 Thread Miguel Angel Solorzano
in set (0.01 sec) mysql> SELECT PID, (SELECT COUNT(*) FROM PHONE H WHERE -> H.pid = P.pid) AS C -> FROM person P ORDER BY pid DESC; +--+---+ | PID | C | +--+---+ |2 | 1 | |1 | 2 | +--+---+ 2 rows in set (0.00 sec) Regards, For technical support contracts, visit

Re: MyODBC and Windows XP

2004-03-18 Thread Miguel Angel Solorzano
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

MyODBC and Windows XP

2004-03-18 Thread José Angel Blanco Linares
t be? TIA __ 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: Fw: imposible cargar datos en tablas

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

Re: Fw: imposible cargar datos en tablas

2004-03-03 Thread Miguel Angel Solorzano
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.mys

RE: Debugging MySql Source in Visual C++

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

Re: Debugging MySql Source in Visual C++

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

MySQL 5.0

2003-10-23 Thread Angel Todorov
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

replication

2003-10-22 Thread Angel Todorov
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 For

Re: Visual Foxpro

2003-06-17 Thread José Angel Blanco Linares
) ) > *!* ENDCASE > m.sRet = strtran( m.sRet, '@3', alltrim( str( > m.iYear, 4, 0 ) ) ) > return m.sRet > enddefine && COdbc > * // > > > > * //

Perl vs. PHP with MySQL - performance?

2002-12-10 Thread Angel Flow
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

2002-10-21 Thread Miguel Angel Solórzano
ope 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 do

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

2002-10-19 Thread Miguel Angel Solórzano
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

Re: MySQL 4.0.4 Question

2002-10-19 Thread Miguel Angel Solórzano
-- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil <_

Re: access denied ????

2002-09-25 Thread Miguel Angel Solórzano
- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PRO

Re: winadmin stopped on Beta

2002-09-13 Thread Miguel Angel Solórzano
t; >Adrian Greeman > > >Telephone +44 20 8672 9661 >Mobile +44 780 329 7447 > >e-mail:- >[EMAIL PROTECTED] > >or > >[EMAIL PROTECTED] > > -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano <[E

RE: Windows XP Installation Problems

2002-09-10 Thread Miguel Angel Solórzano
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, __ ___ ___ __ / |/ /_ __

Re: MySQL 4.0.3b Bind-Address Problem

2002-09-03 Thread Miguel Angel Solórzano
"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. -- Reg

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

2002-09-03 Thread Miguel Angel Solórzano
; >Cheers Chuckie -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo

Re: build under Win32

2002-09-02 Thread Miguel Angel Solórzano
ompiler): http://www.mysql.com/doc/en/Windows_source_build.html -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/

Re: MySQL and Service Pack 3

2002-08-29 Thread Miguel Angel Solórzano
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 A

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

2002-08-29 Thread Angel Moon
; <% end if %> <% if rs2("cfax") > "" then %> <%response.write " "%> Fax: <%=rs2("cfax")%> <% end if %> <% if rs2("cemail"

how does one successfully use mysql_store_result()?

2002-08-28 Thread Angel Moon
quite 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://list

Re: MySQL Bug

2002-04-12 Thread Miguel Angel Solorzano
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

RE: Char set Win1250

2002-04-10 Thread Miguel Angel Solorzano
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 W

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

2002-04-08 Thread Miguel Angel Solorzano
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 calle

Re: MySQL stops suddenly

2002-04-05 Thread Miguel Angel Solorzano
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 >I ahve a doubt that it shuts down by itself after a >sp

Re: MySQL unix vs WinXP case sensitivity

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

Re: Error 2004 on NT 4. maschine

2002-03-31 Thread Miguel Angel Solorzano
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 s

RE: Coldfusion,Mysql,Myodbc

2002-03-27 Thread Miguel Angel Solorzano
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 some

Re: Query causes Mysql to shut down

2002-03-26 Thread Miguel Angel Solorzano
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

RE: Finally found mysql-nt service error 1061 1067

2002-03-19 Thread Miguel Angel Solorzano
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 d

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

2002-03-15 Thread Miguel Angel Solorzano
At 14:20 15/03/02 -0600, BD wrote: Hi! >The eWeek article http://www.eweek.com/article/0,3658,s=708&a=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

Re: it cannot inititate downloads

2002-03-15 Thread Miguel Angel Solorzano
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, Mig

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

2002-03-14 Thread Miguel Angel Solorzano
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 us

Re: Connect to Mysql Server

2002-03-12 Thread Miguel Angel Solorzano
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 yo

Re: MySql "fatal error" in mysql-opt.exe

2002-03-12 Thread Miguel Angel Solorzano
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 Welc

Re: VC++ and mysqlclient

2002-03-09 Thread Miguel Angel Solorzano
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 >'/I"c:\path\to\header\files\from\http://www.my

Re: Mysql won´t connect

2002-03-05 Thread Miguel Angel Solorzano
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\bin>mysql mysql.exe is the clie

Re: win start problem

2002-03-04 Thread Miguel Angel Solorzano
my.ini). > >Anyway, I went back to the original machine and got it working by pointing >back to the standard c:\mysql\data dir for all files > >I don't like this but, it works > >Thanks Anyway For Your Response, >-Ryan > > >On Mon, 4 Mar 2002, Miguel An

Re: win start problem

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

Re: Tuning my production MySQL server (EMERGENCY)

2002-02-22 Thread Miguel Angel Solorzano
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, an

Re: INNODB conversion

2002-02-20 Thread Miguel Angel Solorzano
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 &

Re: INNODB conversion

2002-02-20 Thread Miguel Angel Solorzano
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\bin>mysqld-max --standalone --console InnoDB: The first specified data file c:\

Re: Error 1058 Win2K Server with MySQL

2002-02-19 Thread Miguel Angel Solorzano
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: Running MySQL on Dos System?

2002-02-19 Thread Miguel Angel Solorzano
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: operating system error number 3

2002-02-16 Thread Miguel Angel Solorzano
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 >m

RE: Suspected Bug

2002-02-16 Thread Miguel Angel Solorzano
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 Fr

RE: Suspected Bug

2002-02-15 Thread Miguel Angel Solorzano
At 13:39 15/02/2002 +0100, Roger Baklund wrote: Hi Roger, If I am not wrong after the release 3.23.40 was removed from config-win.h the line below: #define FN_LOWER_CASE TRUE /* Files are represented in lower case */ The above meant that MySQL independently of the OS, always wrote the tables w

Re: MySql Installation/Configuration

2002-02-15 Thread Miguel Angel Solorzano
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, p

Re: Help Regarding datadir configuration

2002-02-14 Thread Miguel Angel Solorzano
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

Re: problems with default-character-set=cp1251

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

Re: Windows Version of MySQL licensing question?

2002-02-13 Thread Miguel Angel Solorzano
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: Retrieving a numeric series from a SELECT

2002-02-13 Thread José Angel Blanco Linares
, 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 --

Retrieving a numeric series from a SELECT

2002-02-12 Thread José Angel Blanco Linares
, 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

Re: Retrieving a numeric series from a SELECT

2002-02-08 Thread José Angel Blanco Linares
, 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 --

Retrieving a numeric series from a SELECT

2002-02-08 Thread José Angel Blanco Linares
, 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

Re: Set up help needed

2002-02-05 Thread Miguel Angel Solorzano
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

Re: Network drive for datadir

2002-02-05 Thread Miguel Angel Solorzano
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). Reg

RE: mySql and Visual FoxPro

2002-01-23 Thread José Angel Blanco Linares
Hi! I was using MySQL and Visual FoxPro but I don't know if exists an API to do it with. I had working with MyODBC and I have no problem at all. With VFP I use to work with both Remote Views and SQL Pass Throu. Bye. :- ) __ José Angel Blanco Linares

Re: prob on NT

2002-01-21 Thread Miguel Angel Solorzano
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* (!?!?!?) > >> > >

Re: error

2002-01-21 Thread Miguel Angel Solorzano
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

Re: max table size on Windows 2000

2002-01-14 Thread Miguel Angel Solorzano
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

Re: Installation Problems

2002-01-12 Thread Miguel Angel Solorzano
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. 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

Bug: BINARY, NULL, and GROUP BY

2002-01-12 Thread Miguel Angel Solorzano
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 t

Re: Installation of mySQL on a Win2000 Pro machine

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

Re: Installation of mySQL on a Win2000 Pro machine

2002-01-11 Thread Miguel Angel Solorzano
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 Serv

Re: General mySQL setup question

2002-01-08 Thread Miguel Angel Solorzano
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

Re: Different instances of mysqladmin

2002-01-08 Thread Miguel Angel Solorzano
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: Prevent WinMySQLAdmin from auto startup when windows 98 reboots

2002-01-08 Thread Miguel Angel Solorzano
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 n

Time and dates with Access.

2002-01-08 Thread Angel Gabriel
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 this

Re: Embedded MySQL terminate abnormally.

2001-12-30 Thread Miguel Angel Solorzano
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.c

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

2001-12-21 Thread angel
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:angelos Vasdaris >Organization: >MySQL support: [none] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.46-max (Source distribution)

Re: Windows 95 winsock version

2001-12-20 Thread Miguel Angel Solorzano
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 h

Re: Help Password Problems!!

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

Re: win32 libmysqld.dll

2001-12-14 Thread 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 serv

Re: mysqlclient.lib compiling problem

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

Re: MySQL on Win2000

2001-12-13 Thread Miguel Angel Solórzano
> >- 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

Re: MySQL on Win2000

2001-12-13 Thread Miguel Angel Solórzano
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 WinMySQLAdmi

Re: MySQL on Win2000

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

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

2001-12-10 Thread 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 WinMySQLA

Newbie!

2001-12-09 Thread Angel Gabriel
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 runni

Re: Turn off autocommit

2001-12-07 Thread 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 q

Re: Replication Problem on MySQL 3.23.45/Win32

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

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

Re: can't connect to server

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

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

2001-11-26 Thread 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

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

2001-11-25 Thread 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

Re: Mysql & Win200 problem (telnet localhost)

2001-11-22 Thread 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.

Re: Mysql Daemon not starting

2001-11-20 Thread 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 /

  1   2   3   >