MyIsam Table Damage

SQL ... I have a myisam table that registers documents in my database .. There is a longtext field for the actual document data in HTML the table (file , MYD) is about 1.2 MB, but from 300 records it had only reports 6 ... I use repair table extended and works fine until I get and error no

Innodb Memory use for a Benchmark...

We are developing a benchmark (only querying) between MySQL, SQLServer2000, and Access 2000 We are using as base, the Database propose by TPC.org (www.tpc.org)... With the records they propose and the indexes they proposed But for the testing we are using INNODB tables, with the

Innodb Memory use for a Benchmark in MySQL...

We are developing a benchmark (only querying) between MySQL, SQLServer2000, and Access 2000 We are using as base, the Database propose by TPC.org (www.tpc.org)... With the records they propose and the indexes they proposed But for the testing we are using INNODB tables, with the

Innodb Tables in MySql 4.0 ?

mysqld-max-nt.exe And starts well if I comment all INNODB features ... I don't want to go on trying, if this Binary Dist. have not been compiled with this feature .. Is there anyway to see if the binary Dist, was compiled with Innodb support ? Rogger

NewBie Question; Backups?

How do I make a Backup of a MYSQL database ,,, It is simple as just copying the files of each table ? or exists a command to make backup ( including TEXT Fields ) ? Thanks -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 10:51 AM To:

RESTORE ??? RE: NewBie Question; Backups?

Thanks and How DO I RESTORE IT ??? -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:43 AM To: ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED] Subject: Re: NewBie Question; Backups? mysqldump -uusername -ppassword -hhostname

RE: NewBie Question; Backups?

Yes I've seen most of MySQL USERS use BACKUP tables instead of mysqldump ... I don't know if it's for the fact the is easieste to restore? -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:59 AM To: MySQL List Cc: ROGGER ALEXIS

How to Get the New Number inserted in a AutoIncrement Field

I know that this is a old question, but I really need to know how can I get the number that Mysql use in a autoincrement field of a record I just inserted ... Is there any function like LAST_INSERTED or something like that ... Thanks a lot

GEMINI Table Type

Hi : First of all I've test for a short period MYSQL, I think is great ,,, recently I was navigating MYSQL.COM and I found and read about the dispute with MYSQL.ORG I enter the site to see what it was ... I notice they promote a type of table name GEMINI ... that support the ACID properties ...

RE: RH Linux 7.1 Binary Install Configure and Auto start/stop

I install MYSQL on Redhat 7.1 using RPMs ... I start the server the same way you do, but to start it automatically, i went to the control panel (GNOME) Programs-System-Control Panel and enter the services and levels configuration (Run level Manager) and move the MSQLD service from NON

RE: deleting dead customers

Hello! I have two tables. One contains invoices, one contains customers. How do I delete customers that are not linked to any invoice. The relation is one to many (invoices -- customers). I can select them with: select customers.* from customers left join invoices on

RE: VB with MySQL

You can use ODBC for mysql ... (download from www.mysql.com ) Install it , then just use it ... To try it, make a Datasource for the ODBC ... In vb make use a Datawizard form, select remote ODBC ... then select the datasource you create it ... and you have a simple maintainance form to a table