InnoDB problem.

(.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-henrique-forchesatto/73/684/a67

MySQL crashing.

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

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 Photographer -- MySQL General Mailing

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

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

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: large temp files created by mysql

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...@gmail.com] Sent: Thursday, May 24, 2012 12:00 AM To: Jan Steinman Cc: mysql@lists.mysql.com

Re: Commit commands with SELECT

, 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 submit to the database

Re: Tuning mysql

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

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

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

- 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 -- MySQL General Mailing List For list archives: http

Re: add index to slave but not master

. 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: how to understand seconds_behind_master

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://lists.mysql.com

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

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 tpol...@engineyard.com wrote

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

ideas. Kind regards, -- Luis Motta Campos On 23 Oct 2011, at 23:27, Claudio Nanni claudio.na...@gmail.com 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' by unique mutexes

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

in the future. Kind regards, -- Luis Motta Campos

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

(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 regards, -- Luis Motta Campos is a DBA, Foodie

Re: Triggers - Accessing all NEW data

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.mysql.com/mysql?unsub=arch

shall i jump from 5.1 to 5.5

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?

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

Recover accidentally deleted MySQL database files

4.1.20, for redhat-linux-gnu (i686) using readline 4.3 Thanks Jose Luis

RE: Recover accidentally deleted MySQL database files

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

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

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 LuisMottaCampos). Cheers -- Luis Motta Campos is a software engineer, Perl Programmer, foodie and photographer. -- MySQL

Database Migration Path / Activity List?

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

Re: Database Migration Path / Activity List?

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 fanatic evangelist, and amateur {cook, photographer} -- MySQL General

Re: Database Migration Path / Activity List?

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 looks like you have planned well for all but using

Cluster/replication different table names

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

; \ fi; test -z $fail 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

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

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

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 anyone add some light on this? TIA. Luis

MySql Query Browser 1.1.15 BUG????

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 forgot the admin password

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

Re: I forgot the admin password

ago and now I want to start practicing , it doesn't really matter... Just reinstall it and you're fresh to go, right? NO! depending on how the Luis installed MySQL in the first place (which method was used), the uninstaller may not remove or overwrite the mysql.user table rendering

Question about replication

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

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

MySQL SNMP OIDs

[ 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

Eventual connection looses

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

Script to purge

Luis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Purge master logs

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?

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

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'll also assume you're a student

Re: BLOB's - General Guidance

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?

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: 1-Way or 2-Way Replication?

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 fingerprint = 113F B290 C6D2

Re: Using a hardware load balancer in from of MySQL

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://lists.mysql.com/mysql To unsubscribe

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

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 great learning resource

Two way replication lock protocol

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 fingerprint

Re: Two way replication lock protocol

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's the status. I understand there's little gain

Re: Two way replication lock protocol

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: Hello, I am

Embeded MySQL for Java ???

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

Problem with joins and query

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

RE: Problem with joins and query

: 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 M.Catid Order by M.Catid It might be more

Joined tables still not working

|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

Question on slow queries

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

Insert select query problem

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

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

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

...). Is it possible to do this via a MySQL query? Luis R. Lebron Sigmatech, Inc

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

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

Secure way of storing passwords in the database

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

Compiling MySQL 4

\ --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 on what is wrong or missing? Luis R

RE: Compiling MySQL 4

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

Issues with Mysql 4.0 and PHP in a production environment

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

Deleting from multiple tables

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

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

this? thanks, Luis

mysqlcheck fail in my.ini

? Thanks luis

Include Check and Repair in my.ini

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

Hi, I need some link to a spanish mysql list, would you ...?

Foreign Key

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

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

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 check

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

it work, so I'm not too troubled, but I would like to code things in the 'standard' way. Luis. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

MySQL over NFS

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

Problem with subqueries

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

Re: Problem with subqueries

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 do this. SELECT * FROM apartamentos

Replication on different SQL servers

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.

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

Dumping a MySQL DB Out to 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 posting, please

Re: Newbie install problem

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 (to RH7.1

RE: Downsides of MySQL?

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-feira, 18

RE: MySQL v.s. Oracle

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 pound

RE: Getting to latest 5 Records

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

RE: opinion - voating

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

Mysql Lost

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

What Licence of Mysql Win32 is Free ?

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

Linux VM on MySQL Servers...

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 Ferro

Re: SecureCRT

[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

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 from MySql.com Hi all, Did anyone experience any

Re: asking for teaching?

; ---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 [EMAIL PROTECTED

Re: Storing Credit Cards

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 users enter a

Re: Storing Credit Cards

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: Sunday, July 01, 2001 3:51 PM Subject: Re: Storing Credit Cards

Re: redhat 7.1 setting up mysql

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 he had it

user variables

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.

asian charatersets in mysql?

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

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.mysql.com

Help with Mysql inport

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

Problem with mysql++, Aborted (core dumped)

ot;Connection 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] ---

Help with ODBC

omeone 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) http://lists.mysql.com/

Re: Help with ODBC

developers Visit http://www.freesql.org - Original Message - From: "Luis" [EMAIL PROTECTED] To: "Steve Ruby" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, April 04, 2001 9:59 PM Subject: Help with ODBC Thank you for all the help on MyODBC but I can't c

Re: Converting Access to MySQL

Good morning all, last night I installed MyODBC on my laptop. What i dont understand is how do i connect threw access now? I'm a little confuse, can anyone help me understand how MyODBC works. luis - Before posting, please

Re: Converting Access to MySQL

; MySQL I put the ip address were mysql is located. user name I put :root the password : password then i sayed ok. after this what do I do. Do i go to access and try to connect that way or how do i connect to the database irm that i

  1   2   >