2

Bash scripts to backup all databases in a MySQL server with the option to exclu...

 1 week ago
source link: https://gist.github.com/shakhmehedi/d9d966dba399451d1a32b8be1c183980
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

Bash scripts to backup all databases in a MySQL server with the option to exclude some databases. · GitHub

Instantly share code, notes, and snippets.

  • Star 9 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
Clone this repository at <script src="https://gist.github.com/shakhmehedi/d9d966dba399451d1a32b8be1c183980.js"></script>
Save shakhmehedi/d9d966dba399451d1a32b8be1c183980 to your computer and use it in GitHub Desktop.
Bash scripts to backup all databases in a MySQL server with the option to exclude some databases.

Thanks! Great script!

nice work !

Great script, Works nice, except for 2 of my servers request the root password, how can i avoid that?
Another questiion, how can i do to put the date on the filenames in spanish?

@samuelmf The easiest way to do this is to use a client section of the ~/.my.cnf file, and add the credentials inside that file.

[client] 
user=root
password=somepassword

how can i do to put the date on the filenames in spanish?

SET lc_time_names = 'es_ES';

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


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK