MySql commands¶
mysql.backup_db¶
{
"your-own-description": {
"sequence": 1,
"command": "mysql.backup_db",
"params": {
"host": "localhost",
"user": "root",
"password": "root",
"database": "your-database",
"backup_file": "/full/path/to/database/backup/path/file.sql",
"download_tar_to_local_file": "./local/path/db/backup.tar.gz"
}
}
}
Functionality:
- Runs mysqldump and creates a mysql sql that will be compressed to tar.gz.
- The generated sql file will be removed.
- Tries to create the path on remote if it doesn’t exist
- If download_tar_to_local_file is given it will download the tar.gz for local backup
mysql.cleanup_db_backups¶
(Gonna be deprecated, this is something we should implement with the backup_db)
{
"your-own-description": {
"sequence": 1,
"command": "mysql.cleanup_db_dumps",
"params": {
"path": "/full/path/to/database/backup/path",
"max_backup_history": "5"
}
}
}
Functionality:
- Reads path for *.tar.gz files... and removes the oldest files. (by filesystem)
- max_backup_history is optional, defaults to 5
mysql.query¶
{
"your-own-description": {
"sequence": 1,
"command": "mysql.query",
"params": {
"host": "localhost",
"user": "root",
"password": "root",
"query": "CREATE DATABASE IF NOT EXISTS your-db-name"
}
}
}
Functionality:
- Execute a raw query thru the command line
mysql.import_file¶
{
"your-own-description": {
"sequence": 3,
"command": "mysql.import_file",
"params": {
"host": "localhost",
"user": "root",
"password": "root",
"database": "your-database",
"import_file": "/full/path/to/repo/.data/install.sql"
}
}
}
Functionality:
- Executes : ‘mysql -h %(host)s -u %(user)s –password=’%(password)s’ %(database)s < %(import_file)s’
- If import_file does not exist it will show a warning and will continue to the next command
mysql.restore_db¶
{
"your-own-description": {
"sequence": 2,
"command": "mysql.restore_db",
"params": {
"host": "localhost",
"user": "root",
"password": "password",
"database": "your-database",
"backup_path": "/full/path/to/database/backup/path",
"version": "sql-version"
}
}
}
Functionality:
- By default the version is left empty, but you can force this.
- It will list the versions and prompt for a version to restore when params is empty.
- Requires valid backup version