I installed the newest Magento version (1.9.1) on a linux server. I have the cPanel available to me in my cloud hosting package.
I remember some time back when I had a VPS hosting plan that something went wrong with my Magento shopping cart and I needed to have everything restored from a backup. I asked the hosting company to use the last backup (I had a 'once a day' backup plan back then) but they had a very difficult time restoring from the regular backup (something with the tables, the database or something or other). So - here is the million dollar question - I am now getting ready to install an extension via Magento Connect - How should I backup my entire Magento store? (files and database). Shall I download all my files via FTP or can I backup everything from the cPanel? What about the database?
Thank you very much for any suggestions. I know there are a lot of smart people out there who know this stuff (unlike me :-) )
Allysin
mysqldump -u yourname -p dbname > filename.sql
Just replace yourname and dbname with the actual names. Filename should be something descriptive such as BackupBeforeNewEmailExtension_Aug-5-2015.sql. – tzvi Aug 5 '15 at 20:54