MySQL : Backup and Restore Database without phpmyadmin (commandline)

Problem: phpmyadmin interfaces are slow and often attacked by script kids, if you can don’t use it!

Solution: To backup and restore use command line

To Backup a database:

 
$mysqldump -u root -p  wordpressdb > /backups/wordpressdb-dump.sql [Enter root password]

To restore:

$mysql -u root -p wordpressdb < /backups/wordpressdb-dump.sql[Enter root password]

Remark: this is not recogized by the ONLINE SYSTEM if users visits you pages to read! There must be no shutdown of the mysql or apache webserver, its a online HOT-Dump. If you like put it into a script and set cron to backup every night.
Sample Bash MySQL Script for full automatic dumps:

#!/bin/bash
## automatic dump database and add time and date stamp ##
date=`date +%d%m%Y-%H%M`                       # set current date value
mysqldump wordpressdb > /backups/wordpressdb-$date.sql  # save+date
exit  # close script after work

To save all Databases on one MySQL-Server change

mysqldump --all-databases > /backups/server-all-$date.sql

now run

 #crontab -e

set time to run:

@daily   sh /scriptpath/backup-databases.sh > /dev/null 2>&1

This runs daily backup at 00:00AM and post no message to Admin (root) if you need mails remove (>…1)