MySQL
Restoring a database backup
Table of ContentsCompression format Running the restore Magento 1There 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 … Continue reading
Adding a new database and user
Table of ContentsBest Practice Creating a Database/User via PHPMyAdmin Creating a Database/User via Sonassi control panel Creating a Database/User via MySQL CLICreating a database and user can be completed via a number of means: PHPMyAdmin Sonassi control panel MySQL CLI MySQL GUI Desktop Client MageStack comes with PHPMyAdmin and MySQL CLI installed as standard, but … 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