WickedFire - Affiliate Marketing Forum - Internet Marketing Webmaster SEO Forum - View Single Post

BrooklynBlue · 02-03-2008, 03:25 PM

This would work:

Code:

/usr/bin/mysqldump --all-databases -hlocalhost -uroot -pMYSQLROOTPW | /bin/gzip -9 > /home/USERNAME/backups/XXX_alldb.`/bin/date "+&#37;Y%m%d"`.sql.gz

If you're tables are all MyISAM and you have a shit-ton of data, checkout using mysqlhotcopy.

02-03-2008, 03:25 PM	#20 (permalink)
BrooklynBlue Senior Member Join Date: Dec 2007 Posts: 320 iTrader: 5 / 100%	This would work: Code: /usr/bin/mysqldump --all-databases -hlocalhost -uroot -pMYSQLROOTPW \| /bin/gzip -9 > /home/USERNAME/backups/XXX_alldb.`/bin/date "+%Y%m%d"`.sql.gz If you're tables are all MyISAM and you have a shit-ton of data, checkout using mysqlhotcopy.