> Please consult the manual before posting to the list.
From my own experience, since I also asked this question recently, I
don't consider the manual to be a useful reference for finding the
answer to that. The problem is, reading the entire manual front to
back (so to speak) is simply not feasible -- I have tons of things
waiting for me to read them, and nowhere near enough time. So it's
left to doing string searches in the index/toc and full text of the
manual, which I did, but still didn't find what I was looking for.
That's partly my fault for not picking "better" words to search for
(but let's face it, we all have different backgrounds that will affect
how we see things, and thus the words we choose when searching for
things), and partly the manual's fault, since I can't control how it
is organized.
This is why a FAQ is so important -- and this question (how to
replicate table structures between databases) is clearly a candidate.
The FAQ gives an alternative point of reference, rather than relying
on the manual. The manual is obviously a worthwhile reference, and
should be the first stop, but a FAQ would give yet another reference
to consult prior to asking questions on this list.
This weekend I will hammer out "version 0.9" of my interactive MySQL
FAQ and publish a pointer to it via this list. (It'll give me a good
excuse to start teaching myself PHP.) Hopefully it can be a
collaborative effort that will help everyone, experts and novices
alike. (Experts might not consult the FAQ, but they'll hopefully
appreciate the reduced appearance of questions in this list!)
-Stuart
whitmore@stripped / http://www.drizzle.com/~whitmore/
(I read this list in digest format, thus my responses may be delayed.)