Aprium Software

Today I came across the Mysql Workbench GUI tool which for me is one of the most useful web development applications you can install on Linux.

The mysql website used to host a section called GUI Tools which gave you the awful Mysql Administrator and the incredibly buggy Mysql Browser. Both constantly crashed and were a nightmare.

Mysql Workbench seems to be a replacement of these 2 applications and handles SQL development, data modeling and server administration all under one app.

This article covers how to write a Mysql backup script for shell. First of all we need to create the file so open a new text file called backup.sh and set the first line as.

#!/usr/bin/expect

We are using an expect script because it is better suited to dealing with remote requests and responses. The script is going to run like a command and will use the following parameters.