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.
mkdir -p ~/bin
chmod +x ~/bin/mysqlfiledump.sh
It will open a window with an empty file to edit. Copy and paste the below.
backup each mysql db into a different file, rather than one big file
as with –all-databases – will make restores easier
$MYSQL --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database
for db in $databases; do
$MYSQLDUMP –force –opt –routines –user=$USER –password=$PASSWORD –databases $db > "$OUTPUTDIR/$db.dump.sql"
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.