On 8/8/06, Iames Pizzoli <[EMAIL PROTECTED]> wrote:
BUT I know that PostgreSQL has a command to do just this (generate a
CREATE TABLE.../INSERT INTO... text file for the whole database), and I
wonder if such a beast exixts for MySQL too.
Check out the mysqldump program. There are lots of switches to get the
output exactly the way you want it, and you'll need to experiment a
little to get a result script that will import into a different OS
target correctly (note that windows treats database and tables names
with case-insensitivity; all other platforms are case-sensitive.)
--
Ted Roche
Ted Roche & Associates, LLC
http://www.tedroche.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
