Code Monkey home page Code Monkey logo

mysql_backup_restore's Introduction

mysql_backup_restore

Interactive "windowed" script to backup and restore mysql databases

Bash script for easy backup and restore mysql dataases;

"Windows" made with whiptail:

https://en.wikibooks.org/wiki/Bash_Shell_Scripting/Whiptail

Backup/restore itselfs made with mydumper/myloader:

https://launchpad.net/mydumper

I will add soon option to use mysqldump (but take a look at mydumper - it's better ;p)

The only thing to do if You want to use my script is to edit .sh file and fill mysql_user and mysql_pass variables. I propose to use dedicated "backup user" to not hardcode root password. And even better use mysql --login-path function (but then You have to change script [replace "-u $mysql_user -p $mysql_pass" with "--login-path=backup"]. More info about login-path:

https://dev.mysql.com/doc/mysql-utilities/1.5/en/mysql-utils-intro-connspec-mylogin.cnf.html

Best regards, Navid

mysql_backup_restore's People

Contributors

davidzisky avatar

Watchers

James Cloos avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.