XML/JSON vs. SQL backups

Discussion in 'Web Design and Development' started by patent10021, Jun 9, 2014.

  1. patent10021 macrumors 68030

    patent10021

    Joined:
    Apr 23, 2004
    #1
    So I was told to use SQL db backups via phpadmin but i don't see the point since we now have XML/JSON via Cherry Options etc.

    I was thinking to do a complete backup i just export XML/JSON files from within the Dashboard Cherry Options then use FTP to grab the entire public_html folder.

    In the future I just upload the public_html folder via FTP and then import the XML/JSON files for the data.

    What do you think?
     
  2. ppc_michael Guest

    ppc_michael

    Joined:
    Apr 26, 2005
    Location:
    Los Angeles, CA
    #2
    For backups, I think it's unwise to store in anything other than its native format. Your data's integrity is at risk if it's being converted to some other format for storage, then converted once again if it's ever actually used as a backup.

    Plus, I can't imagine that XML would weigh less than a raw SQL backup.
     
  3. Cromulent macrumors 603

    Cromulent

    Joined:
    Oct 2, 2006
    Location:
    The Land of Hope and Glory
    #3
    Do an SQL database backup. It will be faster, easier to maintain (you can do it via a shell script incredibly easily) and will ensure that both the data and the structure of your database is backed up. Plus it will be quicker to restore the backup in the case of loss of data.

    XML and JSON have their place but this isn't one of them.
     

Share This Page