Whats the purpose of this export ? for back up ? to create replica of schema ?
I don't see the reason, to export all the tables and certain tables data. Export everything, I mean all the tables of schema with data and control your import with what you wanted tables ddl/tables data.
let me explain what we're trying to do - we want to export one schema from a test box into a test schema on a production box. I don't want to import rows from certain tables (dynamic tables like prod listings) but I do want rows from certain tables (categories). I know there are other methods of setting up a testing environment but we've opted for creating test schemas. Thanks for the help.