Re: WHY do I see this error when restoring my backup db : InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files.

2009-02-14 Thread Moon's Father
This is because you didn't copy innodb ibdata and ib_log files togeter. Or you forgot to stop mysqld when you remove its ib_log files. On Sat, Feb 7, 2009 at 7:21 AM, my sql wrote: > WHY do I see this error when restoring my backup db : > " InnoDB: Your database may be corrupt or you may have co

Re: How to execute prepare statement when the placeholder is a specific table name?

2009-02-14 Thread Moon's Father
Thanks for your fast reply. Do you know MySQL will support this feature in the future? On Sun, Feb 15, 2009 at 12:59 AM, Baron Schwartz wrote: > Hello, > > On Sat, Feb 14, 2009 at 11:15 AM, Moon's Father > wrote: > > Here is my routine. > > DELIMITER $$ > > > > CREATE > >PROCEDURE `t_girl

Simple Search Logic Issue...

2009-02-14 Thread revDAVE
Newbie question... I have a search page with multi lines of search criteria: Name Topic Message Etc... I'm hoping to get results based on what criteria I type - but I'm not getting what I expect. I think it's just getting results where in addition to getting search criteria I type - ALSO none o

Re: mysql full tutorial download or any book

2009-02-14 Thread mos
At 06:16 PM 2/14/2009, Paul DuBois wrote: On Feb 14, 2009, at 5:49 PM, mos wrote: At 05:20 PM 2/14/2009, mos wrote: At 04:07 AM 2/14/2009, Andy Shellam wrote: To be honest, I got started straight from the MySQL manual. There is a tutorial section in the manual as well, and it's also availab

Re: mysql full tutorial download or any book

2009-02-14 Thread Paul DuBois
On Feb 14, 2009, at 5:49 PM, mos wrote: At 05:20 PM 2/14/2009, mos wrote: At 04:07 AM 2/14/2009, Andy Shellam wrote: To be honest, I got started straight from the MySQL manual. There is a tutorial section in the manual as well, and it's also available to download as a PDF. Links: Manua

Re: mysql full tutorial download or any book

2009-02-14 Thread mos
At 05:20 PM 2/14/2009, mos wrote: At 04:07 AM 2/14/2009, Andy Shellam wrote: To be honest, I got started straight from the MySQL manual. There is a tutorial section in the manual as well, and it's also available to download as a PDF. Links: Manual (English): http://dev.mysql.com/doc/refman/

Re: mysql full tutorial download or any book

2009-02-14 Thread mos
At 04:07 AM 2/14/2009, Andy Shellam wrote: To be honest, I got started straight from the MySQL manual. There is a tutorial section in the manual as well, and it's also available to download as a PDF. Links: Manual (English): http://dev.mysql.com/doc/refman/5.1/en/index.html Manual (English P

Re: How to execute prepare statement when the placeholder is a specific table name?

2009-02-14 Thread Baron Schwartz
Hello, On Sat, Feb 14, 2009 at 11:15 AM, Moon's Father wrote: > Here is my routine. > DELIMITER $$ > > CREATE >PROCEDURE `t_girl`.`sp_join2`() >BEGIN >set @a = 'a'; >set @b = 'g'; >set @stmt = concat('select * from ?,? where a.id = g.id'); >prepare s1 from @stmt; >exec

Re: mysql full tutorial download or any book

2009-02-14 Thread Andy Shellam
To be honest, I got started straight from the MySQL manual. There is a tutorial section in the manual as well, and it's also available to download as a PDF. Links: Manual (English): http://dev.mysql.com/doc/refman/5.1/en/index.html Manual (English PDF US Letter): http://downloads.mysql.com/d