RE: AUTOEXTEND

2003-07-08 Thread Subhakar Burri
in the future. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Transactions, foreign keys, and a hot backup tool for MySQL Order MySQL technical support from https://order.mysql.com/ - Original Message - From: Subhakar Burri [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED

RE: creating table type innodb

2003-07-08 Thread Subhakar Burri
There'z no InnoDB mode for a database, it's only for tables and you can create InnoDB tables in any database as long as it supports InnoDB features. Do you have mysqld-max running? HTH, SB -Original Message- From: azamka [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 11:38 AM

RE: backup / superuser only

2003-07-08 Thread Subhakar Burri
did you try the --skip-networking option? This option still allows local connections, so, not sure if it serves your purpose though... HTH, SB -Original Message- From: Rudy Metzger [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 10:08 AM To: [EMAIL PROTECTED] Subject: backup /

AUTOEXTEND

2003-07-07 Thread Subhakar Burri
Hi, I have a couple of questions, and really appreciate your help ... How can I find out if a data file is set to auto-extend without looking in my.cnf file? ie.. is there any variable that stores this information inside a database that I can query? I need the table_name table_type of all

RE: Newbie questions (3) - listeners / BLOB / PHP

2003-07-07 Thread Subhakar Burri
-Original Message- From: Jeremy [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 12:49 PM To: [EMAIL PROTECTED] Subject: Newbie questions (3) - listeners / BLOB / PHP Hi I'm from an Oracle background and wanted to ask a couple of questions: 1) Have installed mysql 4 on a linux

AUTOEXTEND

2003-07-07 Thread Subhakar Burri
Sorry to post the same question again .. last time when I sent I received a couple of mails with some error messages .. so, not sure if my question was posted ... Here we go again .. Hi, I have a couple of questions, and really appreciate your help ... How can I find out if a data file is set

RE: AUTOEXTEND

2003-07-07 Thread Subhakar Burri
, - Original Message - From: Subhakar Burri [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Monday, July 07, 2003 11:52 PM Subject: AUTOEXTEND Sorry to post the same question again .. last time when I sent I = received a couple of mails with some error messages .. so, not sure

RE: Best Practices for mySQL Backups in Enterprise

2003-06-27 Thread Subhakar Burri
Jeremy/Gerald I just tested it with an insert statement on a MyISAM table and an Innodb table, and I saw the both insert statements in the binary log. So, I can roll forward these changes, right? I still don't see how your answer (MyISAM doesn't have transactions) relate to my initial

RE: Best Practices for mySQL Backups in Enterprise

2003-06-27 Thread Subhakar Burri
If you can identify the log files to apply, you can issue the following command: mysqlbinlog log_file_to_apply | mysql -h server-name hth, SB -Original Message- From: Nils Valentin [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 5:53 PM To: gerald_clark; Subhakar Burri Cc: Keith C