roscius/DB Dump

Last active August 29, 2015 14:01

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/roscius/5b54621467ec6bc64e68.js"></script>
Save roscius/5b54621467ec6bc64e68 to your computer and use it in GitHub Desktop.

Download ZIP

Dump DB to DB stripping DEFINER MYSQL

Raw

DB Dump

mysqldump -u**** -p**** --order-by-primary db | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' | mysql db --host=mydb.com -u**** -p****

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment