Pick our brains...

All posts tagged Backups

Mysql Database Backup & Import From the Command Line

Let’s say you’ve got root privileges, and you’re working along, and you want to quickly backup a database for USERNAME on the PM servers… cd /home/USERNAME/_back mysqldump  -uroot  DATABASENAME  >  DATABASENAME_YYYYMMDD_shortDescription.sql (Check the size of the backup file, always a good idea) ls  -lah  DATABASENAME_YYYYMMDD_shortDescription.sql (Change the owner and group . . . Read more