MyIsam Table Damage

2002-10-29 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
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 Tables in MySql 4.0 ?

2002-02-21 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
Ive just downloaded Mysql Max 4.0 binary distribution for Windows ... Does this distribution supports Innodb tables ? How do I turn on this feature ? I follow the instruction (modifying my.ini to include support for innodb ) buy Mysql does not start ( I am using Winmysqladmin ) and I am using

NewBie Question; Backups?

2001-11-29 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
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?

2001-11-29 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
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?

2001-11-29 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
VASQUEZ MARTINEZ Subject: Re: NewBie Question; Backups? - Original Message - From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED] How do I make a Backup of a MYSQL database ,,, At 9:42 AM -0600 11/29/01, Tyler Longren wrote: mysqldump -uusername -ppassword -hhostname dbname dbname.sql

How to Get the New Number inserted in a AutoIncrement Field

2001-11-13 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
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

2001-09-10 Thread ROGGER ALEXIS VASQUEZ MARTINEZ
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 ...