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 ContentsOptions Examples Magento 1 Dumping a database Restoring a database Magento 2 Dumping a database Restoring a databaseYou 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.) Options -a Advertise awesome hosting -d … Continue reading