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 enough memory for blob 88602 ... What parameters do I have to change so this can work ? thanks in advance - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innodb Tables in MySql 4.0 ?
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 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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Proposal for two (or more) new time and date functions Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote: I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime) Wouldn't something like SECONDS_DIFF(start,end) make more sense? Or perhaps TIME_DIFF(start,end)? Jeremy It's not the only way, but none of them are as simple as a Jeremy SELECT date1 - date2 The problem with implementing the above simple expression is that you can easily run into problems because of the automatic convert of strings to numbers. For example: What should we do if one of the strings is a date and the other is a number or a string ? If we would do the above, then we would also be able to handle: SELECT 2001-01-01 - date from table_name; SELECT 2001-01-01 - 2000-01-01; One simple solution is to to only do this if both columns are of type DATE. You can always 'cast' a column to date with: SELECT DATE 2001-01-01 - DATE 2000-01-01; How would this sound? Regards, Monty - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 dbname dbname.sql That will dump the database 'dbname' into the file 'dbname.sql' Tyler Longren - Original Message - From: ROGGER ALEXIS VASQUEZ MARTINEZ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 29, 2001 9:40 AM Subject: 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: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Proposal for two (or more) new time and date functions Hi! Jeremy == Jeremy Zawodny [EMAIL PROTECTED] writes: Jeremy On Wed, Nov 28, 2001 at 01:30:42PM -0800, [EMAIL PROTECTED] wrote: I think while you've got the hood up, a better method of doing the difference between two dates should be derived. Unless I'm going about this all wrong, the only way to get the time difference between two values currently is: UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime) Wouldn't something like SECONDS_DIFF(start,end) make more sense? Or perhaps TIME_DIFF(start,end)? Jeremy It's not the only way, but none of them are as simple as a Jeremy SELECT date1 - date2 The problem with implementing the above simple expression is that you can easily run into problems because of the automatic convert of strings to numbers. For example: What should we do if one of the strings is a date and the other is a number or a string ? If we would do the above, then we would also be able to handle: SELECT 2001-01-01 - date from table_name; SELECT 2001-01-01 - 2000-01-01; One simple solution is to to only do this if both columns are of type DATE. You can always 'cast' a column to date with: SELECT DATE 2001-01-01 - DATE 2000-01-01; How would this sound? Regards, Monty - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 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 That will dump the database 'dbname' into the file 'dbname.sql' If using at least version 3.23.25, then you can also use a BACKUP TABLE statement. See Chapter.Section 7.13 BACKUP TABLE Syntax (is pp 244 on my copy) for more details. The question I asked before is which is better? BACKUP TABLE allows for an easier restore perhaps? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 ... What I understand is that MYSQL.COM MYSQL.ORG, but does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies with GPL according to what I read) that support the ACID PROPERTIES ( TRANSACTIONS ) (MyIsam, Inodb ?) ... Sorry if someone already post this Question, and sounds like a echo to all of you, but I am really interest in using MYSQL to develop a project and I am evaluating it ... Thanks a lot - 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 PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php