Database Backups (and some phpmyadmin Import/Exports)

[andrew]

Batch Method:

mysqldump -u root -pXXXX --all-databases > /SQL/database_`date '+%m-%d-%Y'`.sql

[andrew]

re. http://www.noupe.com/development/10-ways-to-automatically-manually-backup-mysql-database.html

[Chip]

best way is phpmyadmin database export / import.

tip: CLICK on "save file" or something that creates the actual file.

move file from above to download(/upload) and then upload to the intranet's test system.

effectivley cloning all of SMF !

get used to mysql as you need to drop and create database smf209 at the appropriate times.

[Chip]

cron runs "dbback" (mysqldump) hourly, on the 1st. minute and writes into "/SQL"