Questions tagged [backup]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
16
votes
3answers
6k views

Some Magento tables are not InnoDB, is it safe to convert all tables to InnoDB?

I am using AWS RDS Read Replica. It constantly has issues with Magento's Memory engine tables. For backup and read replicas RDS loves InnoDB. Can I safely change all tables to InnoDB? In addition I ...
7
votes
5answers
19k views

Attempted Magento Backup - now throws 500 Internal server error page

I tried taking a backup of Magento by Admin->System->Tools and when I clicked on System Backup, the website showed me - Internal Server Error The server encountered an internal error or ...
7
votes
2answers
3k views

Frontend & Backend Website not launching after performing SYSTEM BACKUP

I decided to perform a SYSTEM Backup via the admin of my website at 4:13am, even though I'm not so techy with Magento. It kept showing 'Please Wait' all the while. I went to bed, woke after 6hours and ...
6
votes
4answers
41k views

How to move magento shop to another server

I was having my site in shared hosting, I took the entire backup, its structure is like addons homedir mysql resellerpackages suspendinfo bandwidth homedir_paths ...
6
votes
2answers
3k views

Change magento backup folder from /var/backup to different/external folder

Is it possible to change the default Magento backup folder (var/backup/) to a different/external folder? We want to keep the Magento folder as small as possible and save those backups in a different ...
5
votes
2answers
3k views

Magento Scheduled Backup is not working

I have a Magento instance and I have enabled Scheduled Backup in System > Configuration > Advanced > System > Scheduled Backup Settings. These are the settings I have: Enable Scheduled Backup: Yes ...
4
votes
2answers
174 views

is there such a thing as a partial backup tool?

I am seriously struggling to get a decent backup to restore to my dev environment. is there such a thing as a script which backs up a part of the database for this purpose? for instance, I know i ...
4
votes
2answers
5k views

Where are my Magento Backups?

I am performing regular backups of my store, however, when I navigate to /var/backups/, I don't see the backup files. I only see the old backups from a month ago (and earlier) in the backups ...
4
votes
1answer
615 views

Creating a database backup of a live shop?

I like to create a backup of the whole database before doing any major changes on a live environment. For smaller projects that is no problem as it usually only takes a few seconds. On larger ...
4
votes
3answers
2k views

Magento backup taking too long

So, I decided to make a database backup from the magento admin panel. But it´s taking too long and there´s no way to know if the backup is actually working or if it got stucked. Is there a way to stop ...
3
votes
2answers
739 views

Magento Backup Tool killed the database

If I click on System > Tools > Backups create a database backup and restore it the shop breaks. Looks like the backup is canceled in the middle. Could this be a PHP timeout problem or is this ...
3
votes
1answer
997 views

Warning: Division by zero in /var/www/magento/vendor/magento/module-backup/Model/Db.php on line 156

When i tried to start a DB backup via: php bin/magento setup:backup --db I got this error: Enabling maintenance mode DB backup is starting... Warning: Division by zero in /var/www/magento/vendor/...
3
votes
1answer
3k views

Importing attributes to a new magento installation

What are the tables I need to dump to be able to import them in a new installation? I need this to avoid reinserting all the custom attributes for every new Magento installation. thanks
3
votes
1answer
2k views

Magento 2 failed database rollback cannot add foreign key constraints

I recently updated from magento v. 2.1.7 to 2.1.9 and then tried to update directly after that to 2.2.1. That failed and when i try to do a rollback (backup created before updating from 2.1.7) that ...
3
votes
2answers
67 views

Magento Backup - required? Little Question

I´m ready with my first magento shop. I´ve just a little question: Is it required to backup the system every wekk / months? How strong is magento? Is it possible that the system no longer works at ...
3
votes
1answer
204 views

delete maintenance.file from cpanel

I tried to do a backup system using tools from the mangento cpanel online ( I don't have any local version on my computer). the website is unreachable as well as the cpanel I have "Error 503: ...
3
votes
1answer
40 views

Which element added in magento admin backup?

I want to know the exact use of below backup setting. System backup -> is system configuration settings are stored and where stored? Database and Media backup -> is media files are including on this ...
3
votes
1answer
67 views

How to handle a timeframe in which checkouts are not possible?

Our Magento is attached to a second database which is responsible for commodities management. Now this second database is quite strange as it developed over years and one of the strange things is that ...
2
votes
3answers
1k views

Error on backup utility in Magento2 admin

When I try to do a back up in admin using the utility it gives me the following error Failed to save backup with error: Utility gzip not found I have confirmed the gzip is loaded on the server (And ...
2
votes
3answers
8k views

Migrate products and categories

What would be the easiest way to copy all products (including images) and categories from one installation of Magento to another one (completely empty and vanilla) on the same server? I don't need to ...
2
votes
1answer
623 views

Copy sales_flat_quote_item table with foreign keys

I need to alter sales_flat_quote_item having large amount of data and do not want to hammer add to cart functionality. Then i have decided to alter table by copying data and structure of table. ...
2
votes
1answer
7k views

What is included in the System Backup

What exactly is included in the System backup found under System>Tools>Backups?
2
votes
2answers
332 views

Magento Backup Help

When I try and do the 'database and media backup' on Magento it isn't show in my list in the backend. I did my own research and some users suggested looking in the 'error_log', which I did, and it ...
2
votes
1answer
101 views

Magento Database item Export wamp mysql

Here's the deal, I lost some products from my site, they were erased by mistake somehow. I have a backup of a site (just content files) from before moving to a new server and losing the products I ...
2
votes
2answers
3k views

Export database through mysqldump, or Magento admin?

I was looking at this doc: http://www.magentocommerce.com/wiki/1_-_installation_and_configuration/restoring_a_backup_of_a_magento_database which says to add a few lines to your dump file or the ...
2
votes
1answer
50 views

magento site temporally unavailable

I put my magento site on maiatenance mode whislt I did a back up. after the back i deleted all the file in the server because i wanted to start afresh because of a database issue. but to my surprise ...
2
votes
1answer
1k views

Fatal error: Class 'Varien_Data_Collection_Filesystem' when taking backup

We kept the scheduled backup in night. but when we checked this , we are getting an error under System > Tools > Backup Fatal error: Class 'Varien_Data_Collection_Filesystem' not found in /...
2
votes
1answer
34 views

How to backup old magento onto new Magento on a different subdomain

I'm trying to design a new theme on my Magento so I created a test.***.com.au sub-domain to try it out on. I want the old data/pics onto the new one to see how it all looks, but after trying to ...
2
votes
1answer
4k views

Magento's admin scheduled backups makes multiple backups on the server

I have setup of Database daily backup every night at 12:30am, through Admin's System>Configuration>Advanced>System>Scheduled Backup Settings. Magento backs up the data base. But it creates 4 of the ...
2
votes
2answers
620 views

How can I make a fresh install of 1.9 keeping my data?

I've been using Magento for a while, but somehow I screwed something. Some functions aren't working well (for example, the "Flush CSS/Javascript" buttons are gone, the shipping cost isn't shown on the ...
2
votes
1answer
151 views

Magento backup functionality is deprecated as of 2.1.16, 2.2.7, and 2.3.0?

I was happily reading the documeent below enjoying the fact that these backup commands for media, db and code existed https://devdocs.magento.com/guides/v2.3/install-gde/install/cli/install-cli-...
2
votes
0answers
1k views

Error Code: 1022. Can't write; duplicate key in table x - While Restoring Database Backup

I am trying to restore a database backup to my local project, however I'm getting this error. I searched and found out that it is because I am trying to set an existing constraint name when I run the ...
2
votes
0answers
832 views

#1062 - Duplicate entry '3-285-42-0' for key 'UNQ_CAT_CTGR_ENTT_INT_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID' [closed]

I am picking up a site from a predecessor and I am creating a dev version of a live site. After exporting the site via sequel pro or phpmyadmin (seperate attempts), the import process always bulks at ...
1
vote
3answers
2k views

Backup with only ssh

I have install an extension, it totally kill my magento, which stay on 503 error. I have try to clean cache, delete maintenance.flag and use ssh to uninstall the extension, but it's still in 503, so I ...
1
vote
2answers
1k views

How do I schedule hourly backups of the Magento database?

I see that the built in backup scheduler can do daily and longer, but how about hourly? If there's not a way to set it in the GUI, can I make a call (from cron) to a Magento utility that will do the ...
1
vote
2answers
679 views

Backup using FTP

I got a question about backing up my website. How do I make sure I have downloaded all, copying the files locally using FTP? I left the terminal to work and a copy of Magento folder was created on my ...
1
vote
2answers
1k views

Backup large database and avoid website slowness and downtime (and keeping data integrity)

My goal is to be able to backup a large database on a fairly popular Magento site without causing performance problems to the live site. Data integrity is also important to me. Hoping that somebody ...
1
vote
2answers
1k views

Best way to BACKUP?

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 ...
1
vote
2answers
2k views

What are the BEST practices for backing up a LOCAL Magento CE development site using MAMP?

I apologize in advance at the low level of this question, but I'm very new to Magento and just beginning my career as a developer. I have successfully built a local development site on Magento CE 1....
1
vote
2answers
2k views

How to restore customer data from old data

I have delete all customer from my system Now i have old a database , i want to restore the customers from this old database Thus Customer id and data are not changed Can i try this SET ...
1
vote
3answers
2k views

Magento will not make database backup anymore!

I have a problem with the backup feature in Magento 1.8.1.0 I can't create backups anymore, using "System - tools - backup". It has been working fine before, but the last month, I will not work ...
1
vote
2answers
84 views

Magento Compiler and Backup issues

In admin there is no tab for compiler. And also with backup it just does nothing. I am at a loss to what the issue could be. I have reinstalled magento to another folder and compiler is there and ...
1
vote
1answer
29 views

How can I exclude a folder from a command line backup

I'm doing a command line backup of the file system with bin/magento setup:backup --code, but I have one directory which contains a lot of large image files that I would like to exclude. Is there ...
1
vote
2answers
147 views

Magento 2 - Syntax error on bin/magento support:backup:db

I am trying to get backup of DB using following command php -dmemory_limit=1G bin/magento support:backup:db It is giving me syntax error: sh: 2: Syntax error: word unexpected (expecting ")") Error: ...
1
vote
1answer
73 views

How to change the day of scheduled backup?

Is there a way to modify the way when a schedule backup is going to run? let's say every week, can we set it to run during Saturdays instead of Mondays?
1
vote
2answers
89 views

How to recover magento, when database is alive but ALL the files are removed?

So I have a Magento website where ALL the files are removed by accident and there is no back up for it. But, the database is still alive and working. Is there anyway for me to recover at least ...
1
vote
1answer
42 views

Fix admin backup with observer and max_execution_time?

max_execution_time blocks the backup function in admin from working. So I thought I can use an observer and ini_set to increase the max_execution_time for this purpose only. Questions is which ...
1
vote
1answer
172 views

Magento webpage won't display and want to delete all public_html and re-install

I wanted to know whether is it fine if I delete the ENTIRE CONTENTS of /home/user/public_html directory of a user then re-install with a zip file? I have a backup that I want to use because my ...
1
vote
1answer
2k views

Magento 1.9.0.1 Backup and Captcha

I'm using Magento 1.9.0.1 with New Installation and have 2 issues. 1.) After proceeded Backing up and whether checked the "Put store on the maintenance mode while backup creation" or not, Frontend ...
1
vote
1answer
416 views

Magento create duplicate site script in php

I am looking for a PHP script that can create a backup mirror of my store for development purposes. I have been looking around, but not found. Reading this: http://www.magentocommerce.com/wiki/...