dopetalk

Technology => Technical Stuff => Topic started by: andrew on December 23, 2014, 07:04:53 PM

Title: Database Backups (and some phpmyadmin Import/Exports)
Post by: andrew on December 23, 2014, 07:04:53 PM

Batch Method:

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

Title: Re: Database Backups
Post by: andrew on December 23, 2014, 07:05:17 PM

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

Title: Re: Database Backups
Post by: Chip on March 03, 2015, 07:50:12 AM

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.

Title: Re: Database Backups
Post by: Chip on March 09, 2015, 03:57:56 PM

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