Backing Up MYSQL of Your WordPress – You Opinion?

  • I know in cpanel there is an option called BACKUPS which if you go in there all your mysql backups are in .GZ format for download

    I know also another way is to go into phpadmin and

    1. Select database
    2. click export
    3. select add drop table
    4. select complete inserts
    5. select save as file and no compression

    Question is.. If you download your MSQL database using the first method above where you get a .GZ is that ok or is it advisable to do it the second method and why?

Viewing 2 replies - 1 through 2 (of 2 total)

  • The backup option from my host’s cPanel option is a MYSQL dump so it is pretty close to the same thing that phpMyAdmin generates.

    Of course the cPanel option puts the backup in a GZ gzip file automatically where as in phpMyAdmin, you have to tell it to gzip the file.

    I have better luck with CPanel’s backup than I do with phpmyadmin’s backup when it comes to large databases though.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Backing Up MYSQL of Your WordPress – You Opinion?’ is closed to new replies.