![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Can DDLs be retrieved from a dump file? Or is it possible to construct just the schema without the data? Thanks, |
#3
| |||
| |||
|
|
raghu wrote: Can DDLs be retrieved from a dump file? Or is it possible to construct just the schema without the data? Thanks, Actually, is it possible to modify the dump file before importing? There are many ways to retrieve ddl from export files. |
#4
| |||
| |||
|
|
There are many ways to retrieve ddl from export files. You can import with show=y parameter and then format the ddl with any scripting language, you can use indexfile option, you can import without data, then adjust your schema in the database and import data with ignore=y parameter, you can use the tool from http://www.databee.com/dt_home.htm to extract your ddl, probably there are some other possibilities. You should avoid to modify export file. Best regards Maxim |
#5
| |||
| |||
|
|
Maxim Demenko schreef: .... I must say, I've never seen a more polite way of hinting RTFM |
![]() |
| Thread Tools | |
| Display Modes | |
| |