Ignore foreign keys for import support

Asked by Josh Boon on 2012-05-21

I recently banged against a wall where I was doing bulk updates of database from a production environment into a dev environment using mysqldump and it's tab delimited function which allowed for import using the threaded mysqlimport which allow for much quicker imports since it's threaded. Some of our tables have foreign key constraints though that break the import if imported this way. I remedied this with the patch over at http://bazaar.launchpad.net/~mysqlatfacebook/mysqlatfacebook/5.1/revision/3459 and it fixes this problem with the addition of a flag to ignore foreign keys. Would it be possible to see this feature incorporated into Percona server so I can stop compiling from source?

Question information

Language:
English Edit question
Status:
Answered
For:
Percona Server Edit question
Assignee:
No assignee Edit question
Last query:
2012-05-21
Last reply:
2012-05-21
Alexey Kopytov (akopytov) said : #1

I have created https://blueprints.launchpad.net/percona-server/+spec/ignore-foreign-keys-for-mysqlimport

It's a reasonable feature request, and we will consider importing it into Percona Server. You can also engage Percona to make it happen within a known timeframe, as customer-reported feature requests always get priority.

Can you help with this problem?

Provide an answer of your own, or ask Josh Boon for more information if necessary.

To post a message you must log in.