Backup WordPress or Joomla database with phpMyAdmin

It is a good practice…actually it is a must for all of you that use WordPress, Joomla or any other CMS to make database backups on regular basis.

The time will come when you will be saved only of you have your backups stored on safe place. I will show you how to make WordPress or Joomla Database with phpMyAdmin. More about phpMyAdmin you can find here.

Log in to you phpMyAdmin application.

Slide1_PHPMyAdmin main page

Choose your Database, in my case it is “test3” Database.

Slide2_PHPMyAdmin select database

Click on EXPORT

Slide3_PHPMyAdmin select export

Now you have to select CUSTOM Export method. This will give you possibility to choose compression method.

Slide4_PHPMyAdmin select export method Custom

Slide down until you find COMPRESSION in OUTPUT section . In drop-down menu select GZIPPED or Zipped if that suits you.

Slide4_1_PHPMyAdmin selectCompression gzipped

Slide down to the bottom of the page and press GO button. Save window will pop-up, choose SAVE and press OK.

Slide4_2_PHPMyAdmin save gzipped file

That`s it! Your data is saved on your local hard drive. It is now up to you where you will keep it for later when you will need it.

I hope that this tutorial was informative to you and thank you for visiting this website.

Bojan Markovic

Bojan Markovic

IT professional with almost 20 years of experience, mostly integrator of IT services in TV & Radio broadcasting and web based projects. Expert in broadcasting playout systems, video streaming services and SEO.

Leave a Reply

Your email address will not be published. Required fields are marked *

7 + 6 =