Re: How to restore 1 database from mysqldump of all databases

2007-07-11 Thread waldo_tumanut
Thanks to all who have replied. Since this thread has evolved into discussing the dump, I would like to ask the group what are their practices for backup and recovery on Windows platform. Waldo Tumanut Database Analyst

How to restore 1 database from mysqldump of all databases

2007-07-10 Thread waldo_tumanut
Question: How do I restore 1 database from amysqldump of all databases? Obviously a newbie. I've searched the list but couldn't find the answer. Can someone help? Waldo Tumanut Database Analyst CONFIDENTIALITY NOTICE: This

Re: How to restore 1 database from mysqldump of all databases

2007-07-10 Thread waldo_tumanut
Thanks for your response, Rolando. I know all the DML to create the database is in the mysqldump. I was looking for a command or command options, if there are any, to extract the DML for the database, like what you can do with mysqlbinlog. - Message from Rolando Edwards [EMAIL PROTECTED] on

selecting second last row

2007-05-30 Thread waldo_tumanut
If there are only two rows that satisfy SELECT * FROM news WHERE display='yes' ORDER BY id desc then SELECT * FROM news WHERE display='yes' ORDER BY id asc limit 1 gives the second row. Am I missing something? Waldo Tumanut Database Analyst

Question on InnoDB support

2007-05-07 Thread waldo_tumanut
I'm making an assessment of MySQL possible official adoption in my company. A question I have is: with InnoDB codebase being owned by Oracle, is there any impact to its reliability and support? Any other issues? Waldo Tumanut Database Analyst