InnoDB problem.

2013-07-22 Thread Luis H. Forchesatto
able files (.frm files) are ok, since it recognizes MyISAM tables (they have the same permission). Innodb engine is enabled.. Which can cause the tables to appears as "non existent", as far as they do really exist? -- Att.* *** Luis H. Forchesatto http://br.linkedin.com/pub/luis-henriqu

MySQL crashing.

2013-07-15 Thread Luis H. Forchesatto
one post a troubleshoot for me to follow or contribute with speculations? -- Att.* *** Luis H. Forchesatto http://br.linkedin.com/pub/luis-henrique-forchesatto/73/684/a67

Re: store transaction rollback information

2013-01-21 Thread Luis Motta Campos
ted, the changes are permanent. Rolling it back may still be possible, but it will be complicated and extremely expensive, computationally speaking. I strongly recommend you to review your design choices. I hope this helps. Kind regards, -- Luis Motta Campos is a DBA, Foodie, and Photographe

How to block SELECT * FROM table; but not SELECT * FROMT table WHERE...;

2012-09-23 Thread Luis Daniel Lucio Quiroz
Helo, Just wondering if is possible to block SELECT queries that doesnt have a WHERE statement within. LD -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: large temp files created by mysql

2012-05-24 Thread Luis Daniel Lucio Quiroz
ght improvement (addressing both issues) is to decide which end to > approach from. But scanning from the end needs an ORDER BY, preferably on > the PRIMARY KEY. > > etc. > > > > -Original Message- > > From: Luis Daniel Lucio Quiroz [mailto:luis.daniel.lu..

Re: large temp files created by mysql

2012-05-24 Thread Luis Daniel Lucio Quiroz
I got a solution maybe step 1: mysql> explain select * from users; ++-+---+--+---+--+-+--+--+---+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | ++-+---+--+--

Re: Commit commands with SELECT

2012-04-13 Thread Luis Motta Campos
like I am, benchmark, benchmark, benchmark. My 0.02€. Kind regards, -- Luis Motta Campos is a DBA, Foodie, and Photographer On 9 Apr 2012, at 20:47, Karen Abgarian wrote: > I vote 1) yes 2) no > > It could be result of the app developer's convenience to just wrap anything > they

Re: Tuning mysql

2012-02-08 Thread Luis Motta Campos
(if you're not one of them) and take into consideration all the information you have at hand. I hope this helps with getting started. Good luck, and kind regards. -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

help needed restoring crashed mysql

2011-11-29 Thread Luis Pugoy
Hello. I have the following problem. I was importing a large database to mysql using mysqldump. Unfortunately this filled up the whole disk, and mysqldump exited with an error that the table it is currently writing to is full. Checking df -h it shows that the disk usage is at 100%. I decided to dr

Re: add index to slave but not master

2011-10-31 Thread Luis Motta Campos
tions. Good luck. Cheers! -- Luis Motta Campos is a DBA, Foodie, and Photographer -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: importing mysql structures only or restore ignoring non-existing tables and columns?

2011-10-31 Thread Luis Motta Campos
he trick if I back-up data -> > import structure -> restore the data.) You can use SELECT...INTO DUMPFILE and LOAD DATA INFILE... to achieve what I believe you're asking here, save the eventual misunderstanding. ;-) Cheers -- Luis Motta Campos is a DBA, Foodie, and Photographer -

Re: how to understand seconds_behind_master

2011-10-28 Thread Luis Motta Campos
different indexes than the master; or with locked tables because of long-running-queries), this will be as precise as seconds-behind-master, no more than a lousy estimate. Cheers. -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http:

Re: 5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

2011-10-23 Thread Luis Motta Campos
same for you in the future. Kind regards, -- Luis Motta Campos

Re: 5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

2011-10-23 Thread Luis Motta Campos
and fresh ideas. Kind regards, -- Luis Motta Campos On 23 Oct 2011, at 23:27, Claudio Nanni wrote: > Luis, > > Very hard to tackle. > In my experience, excluding external(to mysql) bottlenecks, like hardware, > o.s. etc, 'suspects' are the shared resources 'guarded

Re: 5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

2011-10-23 Thread Luis Motta Campos
The data size is about 200 GB. I would have noticed increase on writes. No backup activity is running (actually I don't do conventional backups). Any theories? Thank you for your interest. Kind regards, -- Luis Motta Campos On 23 Oct 2011, at 14:06, Tyler Poland wrote: > Luis,

5.1.51 Database Replica Slows Down Suddenly, Lags For Days, and Recovers Without Intervention

2011-10-23 Thread Luis Motta Campos
sue both on severs with and without workload (apart from the usual replication load). I am sure no changes were applied to the server or to the cluster. I'm looking forward for suggestions and theories on the issue - all ideas are welcome. Thank you for your time and attention, Kind r

Re: Triggers - Accessing all NEW data

2011-09-12 Thread Luis Motta Campos
s this possible or do I > need to write a function? Hi, You'll have to write your own function for that. Cheers -- Luis Motta Campos is a DBA, Foodie, and Photographer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

shall i jump from 5.1 to 5.5

2011-08-16 Thread Luis Daniel Lucio Quiroz
as far as my readings, they claim that 5.5 is the best my question is, shall i jump from 5.1 to 5.5. right now i have a performance problem, would 5.5 help me in that? Regards, LD

Transfer database to MySQL.Huge effort?

2010-09-18 Thread Luis Suzuki
I want to transfer a database(not MySQL) to MySQL(only the tables,not stored procedures,views etc.).Using SQLWays I gotseveral problems(It needs some expertise).Now using SQLMaestro DataWizard I exported some tables to csv format forimporting with mysqlimport,I previously created the database w

RE: Recover accidentally deleted MySQL database files

2010-05-21 Thread Jose Luis Marin Perez
file Version 1 #114487: DBase 3 data file (8960 records) #114488: MySQL table definition file Version 9 #114489: MySQL MISAM compressed data file Version 1 #114490: DBase 3 data file (256 records) There any way to recover these files in its original location? Thanks Jose Luis -Mensaje

Recover accidentally deleted MySQL database files

2010-05-21 Thread Jose Luis Marin Perez
.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3 Thanks Jose Luis

Re: How much memory can mysql 5.1 take advantage of?

2009-02-05 Thread Luis Motta Campos
bugs and half-implemented standards that plague 5.0.45 (the latest pre-compiled stable version available for CentOS 64 bits). Please feel free to address me if you need more information about that, either here or at the FreeNode's #mysql IRC channel (my nick there is LuisMottaCampo

Re: Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Baron Schwartz wrote: > On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote: >> Baron Schwartz wrote: >>> What are the biggest changes you anticipate? I'd say they will be >>> the version upgrade, converting to InnoDB, and using >>> replication. It loo

Re: Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
d definitely experiment with > replication. Thanks for the advice. I will start reading right away. I would like to read more comments from the members of this list. Thank you all for your patience and help. Cheers! -- Luis Motta Campos (a.k.a. Monsieur Champs) is a software engineer, Perl fa

Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
ction Restore Database Using the Restore Procedure Test Database in Production Environment Start Database in Production Environment Database Monitoring Follow Up Database Behavior and Performance - END TASK LIST - -- Luis Motta Campos (a.k.a. Monsieur Champs)

Cluster/replication different table names

2007-05-17 Thread Ezequiel Luis Pellettieri
Hi guys, I wonder if there is any chance to set up replication/cluster with different tables names on the servers (maybe using aliases for tables) eg.. box1: db name: base1 table name: users box2: db name: base1 table name: users_new Any ideas? Thanks in advance -- Regards, Ezequiel L.

Compiling mysql on Solaris 10

2007-02-08 Thread Luis Jeremias
make: Fatal error: Command failed for target `all-recursive' Current working directory /export/home/jerry/installs/mysql-5.0.27 *** Error code 1 make: Fatal error: Command failed for target `all' Does anyone have a hint for what may be missing here ? Thank you, --- Luis Jeremias

Re: automated character set conversions for tables

2007-02-06 Thread Luis Filipe Lobo
Hi You can 'attack' the problem from another perspective :-P I found out a tool (Linux) to convert all characters in a latin1 file to utf8. The command name is 'iconv' and in Debian it is shipped with the libc6 package. So basically dump you DB and convert the file then import it. See the articl

Update not working in a script, but going fine running with MySQL Browser

2006-04-27 Thread luis perez
gsnip=t.radius_NAS_IP_Address and t.noacstart=1 and t.started_in >=0; Same result. Then I run the update from MyQSL Browser and then worked fine...!!? I've run same script and update command thru Browser with same table in both MySQLv4.1 and v5.0. No change. I know it sounds crazy, but can

MySql Query Browser 1.1.15 BUG????

2005-10-06 Thread Angelo Luis
I download MySql Query Browser 1.1.15 and he is leaving me nervous... This is the problem: 1. I have 2 tabsheet result set. 2. I the first i make a query , like select * from table1. 3. In the second i am in the middle of a query, like select * from table1 where id = (What's is the id ??? Fuck, i

Re: I forgot the admin password

2005-09-21 Thread Luis Garay
existing database. No > >>> > offense, but you should have known better as professional. > >>> > > >>> > "--skip-grant-tables" is what the original user wanted to know. > >>> > >>> Well, given that the OP only said &quo

I forgot the admin password

2005-09-21 Thread Luis Garay
hi im pretty newbie in mysql. i installed this in my computer few weeks ago and today i want to begin practicing and i cant log in . i suppose i forget the rigth password, how can a blank this?? thank you lgaray

Question about replication

2005-04-12 Thread Luis Calero
is necessary that only one of them is the master and the other one the slave and change from master to slave manually? Thanks! -- Luis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL SNMP OIDs

2005-03-18 Thread Luis R. Rodriguez
[ This is my second e-mail, the first I forgot to CC me. Please CC me, I am not subscribed ] Are there SNMP OIDs avialble to get MySQL qps, inserts ps, etc? Luis -- GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E pgppLI1O5jxLy.pgp Description: PGP

MySQL SNMP OIDs

2005-03-18 Thread Luis R. Rodriguez
Are there SNMP OIDs available I can use to query MySQL qps, inserts ps, etc? Luis -- GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E pgp7JOjsc3R2E.pgp Description: PGP signature

Eventual connection looses

2004-09-20 Thread Luis Mediero
Hi, I have a web application with servlets and jsp's. I use a connection pool to optimize connections to database. Usualy all works fine but sometimes, after a period of inactivity (30-50 minutes), connections are lossed. This only occurs if mysql and web server are in different machines. In MySql

Script to purge

2004-07-07 Thread Luis Mediero
; because I use the 4.0.20 version. :-( TIA Luis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Purge master logs

2004-07-02 Thread Luis Mediero
ay. TIA Luis Mediero -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Where are BLOBs / TEXTs stored?

2004-06-16 Thread Luis R. Rodriguez
Ts entries stored? Luis -- GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: BLOB's - General Guidance

2004-05-22 Thread Luis R. Rodriguez
On Fri, May 21, 2004 at 08:01:31PM -0400, [EMAIL PROTECTED] wrote: > Luis - you're quite polite so I'll assume that you are ignorant rather than > prejudiced. I'm polite since I wanted to be respectful but honest at the same time. > You have a university email so I

Re: BLOB's - General Guidance

2004-05-20 Thread Luis R. Rodriguez
t this time for making it seem like a troll. It's not, seriously, I'm just being honest. Can anyone non-AOL-lite back up Udikarni's argument? 8) Luis -- GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E pgpyK2Pw5sOiK.pgp Description: PGP signature

Re: 1-Way or 2-Way Replication?

2004-05-17 Thread Luis R. Rodriguez
On Mon, May 17, 2004 at 04:07:53PM -0400, [EMAIL PROTECTED] wrote: > > SORRY > > My typo--- it is NOT ready for any kind of testing. At least I have not > heard of anything Heh :) But do you know if anyone is already working on it? Luis -- GnuPG Key fingerpr

Re: 1-Way or 2-Way Replication?

2004-05-17 Thread Luis R. Rodriguez
king on this already? What release? Who is working on it? Luis -- GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E pgpt1ZTrSTEDW.pgp Description: PGP signature

Re: Using a hardware load balancer in from of MySQL

2004-05-13 Thread Luis R. Rodriguez
t; gotchas. Have you considered the Linux High Availability project: http://linux-ha.org/ We use it for failover at work. It does a good job. Luis -- GnuPG Key fingerprint = 113F B290 C6D2 0251 4D84 A34A 6ADD 4937 E20A 525E -- MySQL General Mailing List For list archives: http://lis

Re: Can I borrow a working model (database/PHP system)?

2004-05-09 Thread Luis R. Rodriguez
Check on sourceforge.net, there's tons of open php/mysql projects. :) Luis On Fri, May 07, 2004 at 11:29:19AM -0700, David Blomstrom wrote: > Is it possible to copy a working MySQL database and a > page driven by that database to another website? If > so, it would a

Re: Two way replication lock protocol

2004-05-05 Thread Luis R. Rodriguez
On Wed, May 05, 2004 at 04:22:12PM -0700, Jeremy Zawodny wrote: > On Wed, May 05, 2004 at 03:44:00PM -0400, Luis R. Rodriguez wrote: > > On Wed, May 05, 2004 at 12:01:27PM -0700, Jeremy Zawodny wrote: > > > On Wed, May 05, 2004 at 01:07:58PM -0400, Luis R. Rodriguez wrote: >

Re: Two way replication lock protocol

2004-05-05 Thread Luis R. Rodriguez
On Wed, May 05, 2004 at 12:01:27PM -0700, Jeremy Zawodny wrote: > On Wed, May 05, 2004 at 01:07:58PM -0400, Luis R. Rodriguez wrote: > > > > Hello, > > > > I am wondering if anyone is currently working on a two way replication > > lock protocol. If so, what&#

Two way replication lock protocol

2004-05-05 Thread Luis R. Rodriguez
Hello, I am wondering if anyone is currently working on a two way replication lock protocol. If so, what's the status. I understand there's little gain in having two way replication but -- I am just curious. If no one is working on it, I may poke at it. Luis -- GnuPG Key f

Embeded MySQL for Java ???

2004-02-29 Thread Luis Duran
Can anyboby tell me wheter exists an embeded MySQL server JDBC implementation ??? Thanks -- Luis Duran signature.asc Description: This is a digitally signed message part

Joined tables still not working

2004-02-03 Thread Luis Lebron
|usedHours 19 |104|28 I have tried joining the tables in a variety of ways but I am still not getting the correct results. I seem to have some problems with the hours alloted calculating correctly. thanks, Luis

RE: Problem with joins and query

2004-02-03 Thread Luis Lebron
: "Luis Lebron" <[EMAIL PROTECTED]> > Select M.Catid, sum(M.Hours) as allotedhours, sum(T.Hours) as usedHours > >From Manhours as M, Tasks as T > Where M.ProjectId=32 > AND T.ChargeNum=M.ChargeNum > AND T.EmployeeID=M.EmployeeID > AND T.Catid=M.Catid > Group by

Problem with joins and query

2004-02-03 Thread Luis Lebron
am getting: Catid |allotedhours |usedHours 19 |184|28 So I imagine that I am missing something in my join syntax, but I haven't been able to figure it out. Luis R. Lebron Sigmatech, Inc

Insert select query problem

2003-11-13 Thread Luis Lebron
users_test Select * users; all the rows are inserted. What am I doing wrong in the first query? thanks, Luis R. Lebron Sigmatech, Inc

Question on slow queries

2003-11-13 Thread Luis Lebron
I just started logging slow queries. Today I found the following lines in the slow query log. # Query_time: 14 Lock_time: 0 Rows_sent: 293 Rows_examined: 293 use storyboards; SELECT /*!40001 SQL_NO_CACHE */ * FROM `rwt_screens`; What exact does the third line mean? thanks, Luis R. Lebron

RE: Creating random data in a test table based on an existing tab le

2003-11-11 Thread Luis Lebron
Thanks for the help. I tried your suggestion but only got 1 row inserted in the test table. Luis -Original Message- From: Olof Tjerngren [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 3:01 AM To: Luis Lebron Cc: Mysql (E-mail) Subject: Re: Creating random data in a test table

Creating random data in a test table based on an existing table

2003-11-10 Thread Luis Lebron
...). Is it possible to do this via a MySQL query? Luis R. Lebron Sigmatech, Inc

Secure way of storing passwords in the database

2003-11-07 Thread Luis Lebron
Any suggestions of a "secure" way of storing membership passwords (for a website) in a mysql database? Should I use sha, aes, des??? thanks, Luis R. Lebron Sigmatech, Inc

RE: Issues with Mysql 4.0 and PHP in a production environment

2003-11-07 Thread Luis Lebron
Anything that breaks a script (unsupported functions, changes, etc.) or that causes performance problems. thanks, Luis -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 4:09 PM To: Luis Lebron Cc: Mysql (E-mail); Php-General (E-mail

Issues with Mysql 4.0 and PHP in a production environment

2003-11-06 Thread Luis Lebron
Are there any issues with running PHP 4.3.X and Mysql 4.0 in a production environment? thanks, Luis R. Lebron Project Manager Sigmatech, Inc

RE: Compiling MySQL 4

2003-11-06 Thread Luis Lebron
True, but the compilation options stated --without-readline . So what is going on? -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 1:25 PM To: Luis Lebron Cc: Mysql (E-mail) Subject: Re: Compiling MySQL 4 On Thu, Nov 06, 2003 at 01:01

Compiling MySQL 4

2003-11-06 Thread Luis Lebron
--localstatedir=/var/lib/mysql \ --with-extra-charsets=none \ --without-bench \ --without-debug \ --without-readline \ --with-mysqld-user=mysql \ --enable-assembler \ --enable-thread-safe-client \ --with-client-ldflags=-all-static Any ideas o

Deleting from multiple tables

2003-10-29 Thread Luis Lebron
messages that are older than 45 days and the corresponding records in the second table. How can I delete matching records from both tables at the same time? thanks, Luis R. Lebron Project Manager Sigmatech, Inc

Updating age based on date of birth

2003-10-22 Thread Luis Lebron
I have a table that contains a date of birth (date) and a age field. How can I create an update query that would calculate the correct age (from the date of birth) and update the age field? I tried doing it with php but ran into problems with persons born before 1969. thanks, Luis R. Lebron

Select query question

2003-08-29 Thread Luis Lebron
this? thanks, Luis

mysqlcheck fail in my.ini

2003-08-01 Thread Luis Lozano
? Thanks luis

Include Check and Repair in my.ini

2003-07-03 Thread Luis Lozano
How can i check and repair DBs, before service in WIN32 started? I try to include group [myisamchk] in my.ini files, but nothing happen. How can i include it? Thanks Luis

Help me!!!

2003-06-19 Thread Luis Enrique Bauzá Peña
Hi, I need some link to a spanish mysql list, would you ...?

Foreign Key

2003-03-24 Thread Luis Matos Lima
i´m having some trouble in creating a table like this one. CREATE TABLE tab3( cod1 int( 3 ) NOT NULL , cod2 int( 3 ) NOT NULL , PRIMARY KEY ( cod1, cod2 ) , FOREIGN KEY ( cod1 ) REFERENCES tab1( cod1 ) ON UPDATE CASCADE ON DELETE CASCADE , FOREIGN KEY ( cod2 ) REFERENCES tab2( cod2 ) ON UPDATE

Slower access from a client some router hops away from mysql server

2003-02-14 Thread Jose Luis Pérez
is located. I assume that the bandwith is not the problem (a wan connnection with 2Mbps circuits is enough) and there is some fine tunning (application, myoledb or mysqlserver) we are not configuring in a proper way. I will appreciate a lot any ideas about this. Thanks José Luis

Portuguese Characters

2002-12-14 Thread Luis Damas
Hi. I'm using MySql+MyODBC. When reading data in VB (ADO) from the database, the Portuguese characteres (çÇáãé, etcc) appear in a strange way. Any Ideas? Regards Luis Damas [EMAIL PROTECTED] - Before posting, please

New to MySQL, ported from MS Access. Using ASP & MyODBC - UPDATE problem...

2002-11-04 Thread Luis Sanches
is it a MyODBC bug? c) could I gain/fix anything by changing over to MySQL 4 ? d) how do YOU normally update MySQL records from within ASP? Many thanks for any insight. As I said, I've made it work, so I'm not too troubled, but I would like to code things in the 'standard' wa

MySQL over NFS

2002-08-20 Thread Luis Calero
Hi... I've got the folowing question, our servers are running pretty busy these days and our main DB server is taking high load peaks (memory is OK but the cpu has almost no idle time). We have another spare server and I'm thinking about mounting the database over NFS (100mb LAN) to the spare s

Re: Problem with subqueries

2002-07-31 Thread Luis Rodrigues
Thanks. On 31 Jul 2002, Martin Waite wrote: > On Wed, 2002-07-31 at 12:03, Luis Rodrigues wrote: > > hi, > > I have some sql code that I need to use with mysql > > it uses nested queries and since mysql doesn't implement them > > I would like to know how to

Problem with subqueries

2002-07-31 Thread Luis Rodrigues
ot;LocalidadeP"]&' ... WHERE Referencia NOT IN ( SELECT Referencia FROM historico_clientes WHERE NumCliente=$id) Best Regards, Luis Rodrigues - Before posting, please check: http://www.mysql.com/manual.php (the manual

Replication on different SQL servers

2002-07-17 Thread Luis Manuel Cova
Hi.. I'm working on a proyect to implement a SQL server with PHP to allow acces to a MySQL server on the web. The Master server (the server everybody work with) is a Windows 2000 CENTURA SQL server. I want to know how i can manage to export a database from that server to another server (The one

Porting from GUPTA-SQL client to PHP - SQL client.

2002-07-05 Thread Luis Manuel Cova
Hi.. I have a client that's been writen in GUPTA and compiled to be used as a cliento to an SQL database that i access using my local Lan and Netbios.. I want to port that client software (i have the source code for the Gupta Cliente) to be used in a PHP server to allow acces to the database fro

Dumping a MySQL DB Out to Access

2002-02-25 Thread Luis Gonzalez
rking in Access. For a detailed guide, check this out: http://www.devshed.com/Server_Side/MySQL/ODBC/page1.html Good luck, LUIS [EMAIL PROTECTED] -- GMX - Die Kommunikationsplattform im Internet. http://www.gmx.net - Before

Re: Newbie install problem

2001-12-26 Thread Luis A
You know what i download a different on. go to rpmfind.net do a mysql search. also down load the client plus the common ... it should work. if you have trouble let me know ok ... Luis On Wed, 2001-12-26 at 10:09, Richard Lyons wrote: > I've just downloaded and installed the rpm (

RE: Downsides of MySQL?

2001-12-18 Thread luis ferro
And on the other hand, with mySQL you can talk with the real developers that make it work while on other "closed source" DBs, with luck, you can get sensible costumer support... Cheers, Luis Ferro -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: terca

Installation trouble with PHP Mysql

2001-12-17 Thread Luis A
I have just installed the current version of php and mysql server plus the client. I had apache running already, so that means that I did not have to install it again. When I did a test on mysql to connect i get this error Fatal error: Call to undefined function: mysql_connect() in /var/ww

RE: MySQL v.s. Oracle

2001-12-13 Thread Luis Ferro
I would like to know one thing... How to make MySQL work with Oracle and viceversa! I'm tired of the treads that reduce technology in cases of one or another... Cheers, Luis Ferro PS- What is the better tool a sand hammer or a nail hammer? answer: depend on what you want to

RE: opinion - voating

2001-11-26 Thread Luis Ferro
This kind of voting is reductive as i for instance would answer both. They both have its uses, and wise is the one that can recognize when to use one or the other... Cheers, Luis Ferro WebDev -Original Message- From: Ken Kinder [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 26 de

RE: Getting to latest 5 Records

2001-11-26 Thread Luis Ferro
The best way is to get the records ordered inverselly by the auto-increment field and then restrict the return to 5 records. Cheers, Luis Ferro WebDev -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 26 de Novembro de 2001 10:02 To: Mysql List Subject

Mysql Lost

2001-11-21 Thread Luis
Hello all, I have just notice that the new Mysql3.23.44.rpm is different. I download the rpm installed it (rpm -ivh Mysql ) installed fine, started the mysql deamon but when i tried to set a passwd for root i could not find mysqladmin it tells me that its located /usr/bins/mysqla

What Licence of Mysql Win32 is Free ?

2001-11-10 Thread Jose Luis Maieron
I'need know what version of MySQL running in Windows, is free licence ? Thanks ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To requ

Linux VM on MySQL Servers...

2001-10-31 Thread Luis Ferro
Hi there, After reading some debate under way in kernel lists, i'm curious regarding performance of MySQL under the two diferent VM currently in the kernels (Linus and Alan Cox kernels). Has anyone any info regarding this? Cheers, Luis

Re: SecureCRT

2001-10-29 Thread Luis
[EMAIL PROTECTED] wrote: > I am using SecureCRT to login to a remove MySQL server. I can get pass the > initial login. However, a login screen displays on the screen asking for a > second password. I have entered all information correctly, but the system is > still requesting another password

Re: Can't download files from MySql.com

2001-07-05 Thread Luis
try going downloading it from www.rpmfind.net thats a good site too bye Luis - Original Message - From: "Michael Tam" <[EMAIL PROTECTED]> To: "mysql" <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 12:36 AM Subject: Can't download files fro

Re: asking for teaching?

2001-07-04 Thread Luis
; ---hit enter one you create it do this # use test;--- this will change to this database after that you will have to create the table # create table art ; this will create the table for you . if i'm wrong let me know bye Luis - Original Message - From: "Shania Qiu" &l

Re: Storing Credit Cards

2001-07-01 Thread Luis
well the one that hold the credit cards. what company do you work for ? - Original Message - From: "Luis" <[EMAIL PROTECTED]> To: "Derick Dorner" <[EMAIL PROTECTED]>; "Chris Cameron" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sun

Re: Storing Credit Cards

2001-07-01 Thread Luis
for what company do you work if you dont mind me asking? - Original Message - From: "Derick Dorner" <[EMAIL PROTECTED]> To: "Chris Cameron" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 01, 2001 3:23 PM Subject: Re: Storing Credit Cards > I am running a website that user

Re: redhat 7.1 setting up mysql

2001-06-27 Thread Luis
Trond Eivind Glomsrød wrote: > "wkd" <[EMAIL PROTECTED]> writes: > > > 1. (*) text/plain > > > > I'm setting up mysql for redhat 7.1 to be used with php and apache. However, in >the past I've had problems with the setup. I had a person come in and setup mysql on >redhat 6.0 ( 2 1/2 days later

user variables

2001-06-12 Thread Luis A. Fdez. de Retana Aguirre
Hello, My problem is about users variables. I want to do a script to create a database so: SET @dbname:="mydbname"; CREATE DATABASE @dbname;# <-- Don´t work CREATE DATABASE (SELECT @dbname);# <-- Don´t Work I have tried to define @dbname=mydbname directly but it blocks.

Driver odbc for mysql

2001-05-28 Thread Luis Carlos Braga
I install the obdc driver for mysql and then anothers database what runing (way others odbc drivers, as infomix) in my computer don´t runing more. Please help

asian charatersets in mysql?

2001-04-30 Thread Luis Hoeks
I would be very pleased, if someone could tell me if MYSQL supports asian character sets like big5 or thai charctersets. If yes, what do I need to install to get it running. Where can I find any help? Any advice is very much appreciated! Kind regards from Luis

Population a database

2001-04-20 Thread Luis
it. is there a how to or a sample of this method Im sorry but I'm new to all this... Thank you very much Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

Help with Mysql inport

2001-04-18 Thread Luis
from the site. Installed it went into ODBS set in the control panel . Here's were I get lost .. First of all I need to move or inport the database to mysql server. How would I do that. Thank you for the help Luis - B

Problem with mysql++, Aborted (core dumped)

2001-04-15 Thread Luis E . Cruz Campos
ion MySQL(db)" and "Connection MySQL(); MySQL.connect();", this like "root" and "common user" i am using: redhat 7.0 gcc 2.96 mysql 3.23.36 mysql++ 1.7.8 Thanks for your help !!! and sorry by my english !!! -- Luis E. Cruz Campos [EMAIL PROTECTED] -

Re: Help with ODBC

2001-04-04 Thread Luis
= > FreeSQL.org offering free database hosting to developers > Visit http://www.freesql.org > > - Original Message - > From: "Luis" <[EMAIL PROTECTED]> > To: "Steve Ruby" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >

Help with ODBC

2001-04-04 Thread Luis
7;m doing wrong. or if someone could show me the right steps on loading it configure the ODBC date plus how to connect threw access. Thank you Luis - Before posting, please check: http://www.mysql.com/manual.php (the manual

  1   2   >