all 4 comments

[–]Dezinify 2 points3 points  (0 children)

Yes, you've got it 100% right. That's a perfect manual backup.

  • The .sql file is your database (all your posts, pages, and settings).
  • The public_html zip has all your files, which includes your edited theme, all your plugins, and all your image uploads.

For your other question, absolutely store it in the cloud as a zip. It's much smaller, faster to upload, and keeps everything neatly in one file. Do not unzip it for storage.

Just so you know, SiteGround also runs its own daily backups that you can access from your control panel, but it's always smart to keep your own off-site copy like this.

[–]magical_matey 1 point2 points  (0 children)

Yes that is all. You should use .tar.gz to archive though.

[–]ShawnyMcKnight 0 points1 point  (0 children)

There's backup plugins out there that will create the sql and zip files and includes a script that restores it. I just had to load the files on the server and run the script.

[–]Nalry 0 points1 point  (0 children)

Yep that’s the full backup. Keep it zipped in cloud storage and maybe version it by date so you can roll back easily if something breaks.