DDL not in .sql file using -T option
Posted by:
R Das
Date: May 24, 2006 10:06AM
I'm using "mysqldump Ver 10.10 Distrib 5.0.16, for Win32 (ia32)" with these options:
-v --single-transaction -T E:\data\csd_glb_db\backup csd_glb
and I get the DDL for my views, but not my tables. I've tried all sorts of permutations (--create-options / --opt / --tab) and nothing seems to work.
This did work under version "mysqldump Ver 10.9 Distrib 4.1.11, for Win32 (ia32)". Also, I am able to get a single file with all the DDL and data.
Can anyone suggest a combination of options to use to get each table in a separate file and the DDL too?
Thanks
Subject
Views
Written By
Posted
DDL not in .sql file using -T option
3434
May 24, 2006 10:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.