Restoring a database backup

Table of ContentsCompression format Running the restoreThere is a number of ways to import a database backup, but we've found the quickest method is to decompress the two files and import using mage-dbump.sh Compression format The backups are stored in bzip2 compressed format (for space efficiency). Decompressing this file type can be done with either … Continue reading

Adding a new database and user

Table of ContentsBest Practice Creating a Database/User via PHPMyAdmin Creating a Database/User via Script Creating a Database/User via MySQL CLICreating a database and user can be completed via a number of means: PHPMyAdmin MySQL CLI MySQL GUI Desktop Client MageStack comes with PHPMyAdmin and MySQL CLI installed as standard, but you can also install a … Continue reading

Purging a database by command line

Table of ContentsPurging a databaseYou can use the mage-dbpurge utility to completely empty a MySQL database. This is useful clear out and existing Magento installation if you intend to restore a backup. It will read your MySQL details from your Magento ./app/etc/local.xml file automatically cd /domains/example.com/http wget sys.sonassi.com/mage-dbpurge.sh ! This utility will erase the whole … Continue reading

Dumping a database by command line

Table of ContentsDumping a database Restoring a database OptionsYou can use the mage-dbump utility to dump your Magento database, without causing downtime on your live store and whilst minimising "junk" database tables (eg. visitor logs, old quotes etc.) It will read your MySQL details from your Magento ./app/etc/local.xml file automatically cd /domains/example.com/http wget sys.sonassi.com/mage-dbdump.sh Dumping … Continue reading