-
Importing Tables with Partitions
Hi,
I exported a schema with partitions created for some tables. I try to import the exported dump file
to another user. I wonder will the partitions be automatically created during import or I need to create the partitions manually BEFORE the import.
Thanks in advance...
-
If the tables do not already exist, then they will be created with partitions, yes.
You can see the create table statements before hand by importing the file with the "indexfile=my_file.sql" option, and then open my_file.sql to see the create table and create index statements
-
Thanks for the prompt reply!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|