SLEEP command in mysql

Hi all, Is there a 'sleep' command in mysql? I'm trying to take a backup of MySQL instance from a ksh script, and I want to lock all the tables before I take a back of all datafiles. So, once I issue the lock tables command and exit the session to take backup of the OS files, the session (and t

RE: backup / superuser only

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 / s

RE: creating table type innodb

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 To

RE: AUTOEXTEND

e fixed some time 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 PROTE

RE: AUTOEXTEND

TEND Subhakar, - 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 coup

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 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: Newbie questions (3) - listeners / BLOB / PHP

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

AUTOEXTEND

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 th

RE: Best Practices for mySQL Backups in Enterprise

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

RE: Best Practices for mySQL Backups in Enterprise

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 question

RE: Best Practices for mySQL Backups in Enterprise

Can I roll forward if I do backups using Mysqldump? Say, I did backups using Mysqldump @ 8:00 AM and my instance crashed @ 2:00 PM. I can restore the tables (both Innodb and MyISAM tables) from my 8:00AM backup, but can I roll forward the data that changed after 8:00 AM or do I lose the data aft