Magento mysql backup fails to restore


Magento mysql backup may fail to restore with following error if mysql backup was taken using simple "mysqldump" command.

 

==========================================

ERROR 1005 (HY000) at line 4367: Can't create table 'db_name.core_session' (errno: 121)

ERROR 1005 (HY000) at line 4367: Can't create table 'db_name.core_store_group' (errno: 121)
==========================================

 

Solutions

1. Use a backup created using magento backup tool

2. Use the script http://files.bytehouse.co.uk/dump_magento_database.sh to create a mysql backup

 

===============================

wget http://files.bytehouse.co.uk/dump_magento_database.sh

bash dump_magento_database.sh

===============================

 

Just run script as "sh dump_magento_database.sh".
Script will ask for mysql user name, password, mysql hostname, database name
Once the details are provided, script will take backup

 

Credits

dump_magento_database.sh script  is a modified version of https://gist.github.com/steve-ross/9958274     


Thanks to https://gist.github.com/steve-ross   

Last update:
2015-07-16 10:03
Author:
Bytehouse Technical Support
Revision:
1.0
Average rating:0 (0 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.

Most popular FAQs RSS

  1. I require an additional IPv4 address. What is Bytehouse's ... (88705 views)
  2. The Most Common Problems When Migrating Websites (69179 views)
  3. How do I create a 301 redirect? (57138 views)
  4. Can I Backup Exchange 2010 with My Online Backup ... (54462 views)
  5. Steps to Add Administrator User for Windows Server (49701 views)

Latest FAQs RSS

  1. Steps to set/customize log rotation from plesk (2016-07-25 07:15)
  2. Generate a self-signed SSL certificate - Nginx,CentOS (2016-07-07 02:31)
  3. Procedure re-register Volume Shadow Copy Service(VSS) in a Windows ... (2016-07-05 04:18)
  4. Steps to Install Mcrypt in Plesk (2016-07-01 17:11)
  5. How to Retrieve a Plesk Password in Linux and ... (2016-07-01 17:09)

Regular new KB articles

Check back from time to time for new articles, or if you have any suggestions please feel free to recommend

top