Home › MYSQL database dumps through ssh ›

Reply to comment

MYSQL database dumps through ssh

in


#!/bin/sh

PASS=$1

for i in `/usr/bin/mysql --user=root --password=$PASS --batch --skip-column-names -e "show databases" | sed 's/ /%/g'`;do
nice -n 19 /usr/bin/mysqldump -u root -p$PASS "$i" & /home/backupsql/"$i".sql
gzip /home/backupsql/"$i".sql
done

This will dump all databases into separate files, then gzip them. Perfect script for using in a backuppc DumpPreUserCmd option.

Reply

  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <br> <p> <pre> <b> <del>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.
  • You may post PHP code. You should include <?php ?> tags.
  • You may link to Gallery2 items on this site using a special syntax.
  • Image links with 'rel="lightbox"' in the <a> tag will appear in a Lightbox when clicked on.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.