Export magento database with phpmyadmin

phpMyAdmin is great

phpMyAdmin is a fantastic tool that allows you to interact with databases. It has an amazing set of features and can do pretty much everything that you need it to do. We use phpMyAdmin for nearly all our database manipulations as we find it is one of the easiest to use. Only developers that have approved access to the cpanel account may use phpMyAdmin.

Exporting out a Magento website

Magento is a very powerful system and when a system becomes more powerful, it can lead to more complexity. This makes it even more important to export out a Magento database in the correct format so you can import in again safely. The foreign keys seems to be the biggest issue when exporting out, so ensure this is set correctly.

Exporting a Magento website using phpMyAdmin summary

  1. within phpMyAdmin click on the database you want exported
  2. click on the Export tab
  3. click on the Custom - display all possible options radio button
  4. change Compression to bzipped
  5. click on Disable foreign key checks
  6. click on Add DROP TABLE...
  7. click Go

Exporting a Magento website with phpMyAdmin

  1. within phpMyAdmin click on the database you want exportedphpmyadmin select database
  2. click on the Export tabphpmyadmin choose xport
  3. click on the Custom - display all possible options radio buttonphpmyadmin choose custom
  4. change Compression to bzippedphpmyadmin bzip compression
  5. click on Disable foreign key checksphpmyadmin set ignore foreign key checks
  6. click on Add DROP TABLE...phpmyadmin set drop table
  7. click Gophpmyadmin go