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 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/ wget ! 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