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)



1. Use a backup created using magento backup tool

2. Use the script to create a mysql backup







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


Credits script  is a modified version of     

Thanks to   

Last update:
2015-07-16 10:03
Bytehouse Technical Support
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