2015/03/12

MySQLDump

how to properly dump a complete catalog (this post is a work in progress)



    mysqldump --login-path=XX database_here --add-drop-database --add-drop-table --add-drop-trigger --add-locks --comments --disable-keys --dump-date --lock-all-tables --log-error=/tmp/mysqldump.log --routines >/data/$RUTA/$SQLLOG

saving SPs only:

    mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt database_here > outputfile.sql