Jump to content

Simple backup/restoration module/solution for PS.


Recommended Posts

Can someone suggest me some module or tool for Prestashop backup that will include both files and DB. Tool should have simple restoration procedure as well so I can easily restore my backup.

 

Ty in advance.

Dean

Link to comment
Share on other sites

No suggestions?

 

I do know how to make a DB dump from the phpMyAdmin and how to download all the files using FTP. This is basically all I need, bout I was searching for much user friendly solution, like Akeeba Backup for Joomla CMS for example.

 

Thanks.

Link to comment
Share on other sites

I know TomerG has a backup/restore module:

http://www.presto-changeo.com/en/prestashop-modules/37-automatic-prestashop-backup.html

 

Never tried it myself, but reviews are positive. More info on it here:

http://www.prestashop.com/forums/topic/55766-module-automatic-prestashop-backup-backup-your-entire-shop-on-the-server-by-email-on-amazon-s3/

 

Not fully fully automatic, I believe. However, I read there was a (good) reason why restore of files needed some more steps. had to do with permissions. Just read through the Post and replies above and see if it's useful.

 

My 2 cents,

pascal

Link to comment
Share on other sites

Hi Vekia,

 

Yes, I can make a full cPanel backup that will include all files and DBs

But problem is that in the cPanel I have emails, some other scripts beside Prestashop etc.

 

Thats why full cPanel backup is not elegant solution.

 

On the other hand, FTP backup of the Prestashop files is a painful long process and I need to exclude files from the public_html folder that are not prestashop related and that takes some time as well

 

So thats why I wonder if there is easy solution like Akeeba is for Joomla CMS.

 

Thanks

Link to comment
Share on other sites

Dolke: We do not have a free trial, however, we have a few hundred customers using the module, as well as ourselves, and every client we built a website for.

 

You can select which tables to backup for the DB (or "All"), and which folders to backup (or "All")

Link to comment
Share on other sites

Instead of full backup use cron job for files and db separate.

For daily backup at midnight...

5 0 * * * tar cvfz - public_html/prestafolder/ > backupfolder/prestafolder_backup_`date +\%Y\%m\%d`.tar.gz

10 0 * * * mysqldump -u username -h hostname -ppassword prestadbname > backupfolder/prestadbname_db_backup_`date +\%Y\%m\%d`.sql

 

When you need to restore,

for files : just use extract from cpanel file manager for files.

For db : quick cron job with the following command will do.

*/5 * * * * mysql -u username -h hostname -ppassword prestadbname < backupfolder/prestadbname_db_backup_dateinfo...sql

(*** must delete this cronjob as soon as restore done, otherwise it will keep restoring until u delete this cronjob)

  • Like 2
  • Thanks 1
Link to comment
Share on other sites

  • 3 months later...

Hi xmilo,

 

your solution sounds great.

my question is : how do you know where to send backups ?

 

in your example you send them to "backupfolder" ?

what is the path to this folder ?

something like "www.mydomain.com/backupfolder" or else ?

Link to comment
Share on other sites

Hi Fred, it looks like it's a folder in your "home" folder, where also the public_html is put in.

 

"Home"

- public_html (in here, your shop files are located)

- backupfolder (here backups are stored)

 

Anyone, please correct me if I'm wrong...

 

pascal

Link to comment
Share on other sites

yes, create a folder inside your "home" folder or "root" folder(above /public_html) and use it.

one note though,

check after the cron job is completed, this "backupfolder" (you make your own name) might be created at your root folder location. (above /public_html)

If you have access to the root area, I prefer to store my backups to there instead of /public_html/ folder where anyone can access if the file path is known.

 

good luck.

Link to comment
Share on other sites

To be honest... i'm a bit lost  :)

 

My site is running on a dedicated server. It has Linux (Debian based ditribution has far as i know) + ISP Config panel.

This site is stored in a "web" folder (same as "www" or "public_html" i guess).

 

The "rootest" folder i can access is the folder above "www".

In it i have several folders : etc, home, tmp, var and web of course.

In home folder i have a "web1" folder (i don't understand its purpose).

 

If i try to create a folder in the "rootest" folder, i have an error (permission denied).

I can connect with sftp or ssh as well, but i'm not good with Linux administration so i prefer not to for the moment.

 

OK i guess it's a little bit confused  :)

Fell free to ask me if you need more explanations

Link to comment
Share on other sites

It will then probably be something like:

 

5 0 * * * tar cvfz - www/yourprestafolder/ > tmp/backupfolder/prestafolder_backup_`date +\%Y\%m\%d`.tar.gz
10 0 * * * mysqldump -u username -h hostname -ppassword prestadbname > tmp/backupfolder/prestadbname_db_backup_`date +\%Y\%m\%d`.sql

 

 

username, hostname, password and presta DB name you can find in /config/settings.inc.php:

define('_DB_SERVER_', 'host name of you');

define('_DB_NAME_', 'Presta DB name of you');
define('_DB_USER_', 'user name of you');
define('_DB_PASSWD_', 'password of user');
 
 
pascal
  • Like 1
Link to comment
Share on other sites

×
×
  • Create New...