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