Web Projects Outsourcing

Preparing for Fedora 11 – MySQL Database-per-file Dump

Yes, yes, man, I am still NOT on Fedora 11… Because I know how newly-out distributions of Fedora tend to behave on my hardware (which is never really brand-pathetic but effective in the terms of gigahertzes¬† and terabytes). I have to wait a month or two before I really make a decision to slowly migrate the oldest of my laptops to 11 as soon as I see that Livna and other repos are really ripe ready for that…

The below is a pretty short solution for backup up your MySQL databases in case you really need it.

Moreover, it’s a pretty good stimulus to clean everything up and kinda start from the scratch. Itchy jobless freelancers would probably know what I mean during the world economical crisis as it was said on the TV…

So, create a ~/bin dir is it still does not exist and a script file to be used for MySQL dumping.

It will open a window with an empty file to edit. Copy and paste the below.

[sourcecode lang=”plain”]
#!/bin/bash

backup each mysql db into a different file, rather than one big file

as with –all-databases – will make restores easier

USER="MYSQL_USER_NAME"
PASSWORD="MYSQL_PASSWORD"
OUTPUTDIR="./"
MYSQLDUMP="mysqldump"
MYSQL="mysql"
databases=$MYSQL --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database
for db in $databases; do
echo $db
$MYSQLDUMP –force –opt –routines –user=$USER –password=$PASSWORD –databases $db > "$OUTPUTDIR/$db.dump.sql"
done
[/sourcecode]

Make needed replacements, save and run in the terminal in just any directory – this will create a pack of *.dump.sql files with the desired dumps.

For the security purposes, I would delete the script file thereafter or simply clear the MySQL user and password data. And bookmark this site for future reference, of course.

3 thoughts on “Preparing for Fedora 11 – MySQL Database-per-file Dump

  1. Anders Ingemann

    Just use -B or –batch.
    Column names and pipes wont be outputtet then.
    You still need to filter out the mysql and information_schema database

  2. Alec Post author

    To fix the “information_schema” stuff, I use the following now:

Leave a Reply

Your email address will not be published. Required fields are marked *

four × two =