Import DB to new Magento installation

Question

I'm running into a big problem with my Magento stores, 4 months ago I installed the latest version of Magento (1.9) into my server, I created 2 different stores, I created categories, I added over 300 products, made a lot of customization, I had about 60 sales or so, I had some customer sign ups, created sitemaps, created widgets, integrated PayPal, USPS shipping methods, coupons, etc. While editing ftp accounts on cpanel one of them was accidentally deleted, this caused the complete Magento installation files to be deleted, I had a recent backup that I was relying on, it turns out that this backup .tgz file never finished and was incomplete and corrupted, however it seems that the media file did finish, I then turned to my hosting company to see if they had backups, they told me they removed my account of their daily backups 4 months ago due to excessive inods abuse, all I have now is my Magento DB and a backup of my products in a csv file, here is the big question, how can I restore my DB into a new installation, this data is what's most important for me, I don't mind doing the customization again, all I want is the Customers, Sales, Products, etc into the new installation.

Answer 1

• Create a file named local.xml under app/etc/ folder and put below content into that file:

<?xml version="1.0"?> <!-- /** * Magento * * NOTICE OF LICENSE * * This source file is subject to the Academic Free License (AFL 3.0) * that is bundled with this package in the file LICENSE_AFL.txt. * It is also available through the world-wide-web at this URL: * http://opensource.org/licenses/afl-3.0.php * If you did not receive a copy of the license and are unable to * obtain it through the world-wide-web, please send an email * to [email protected] so we can send you a copy immediately. * * DISCLAIMER * * Do not edit or add to this file if you wish to upgrade Magento to newer * versions in the future. If you wish to customize Magento for your * needs please refer to http://www.magento.com for more information. * * @category Mage * @package Mage_Core * @copyright Copyright (c) 2006-2016 X.commerce, Inc. and affiliates (http://www.magento.com) * @license http://opensource.org/licenses/afl-3.0.php Academic Free License (AFL 3.0) */ --> <config> <global> <install> <date><![CDATA[Wed, 15 Jun 2016 14:08:02 +0000]]></date> </install> <crypt> <key><![CDATA[da1f934273a6047d404b7ead7b34d831]]></key> </crypt> <disable_local_modules>false</disable_local_modules> <resources> <db> <table_prefix><![CDATA[]]></table_prefix> </db> <default_setup> <connection> <host><![CDATA[localhost]]></host> <username><![CDATA[mage1]]></username> <password><![CDATA[stpl123#]]></password> <dbname><![CDATA[mage1]]></dbname> <initStatements><![CDATA[SET NAMES utf8]]></initStatements> <model><![CDATA[mysql4]]></model> <type><![CDATA[pdo_mysql]]></type> <pdoType><![CDATA[]]></pdoType> <active>1</active> </connection> </default_setup> </resources> <session_save><![CDATA[files]]></session_save> </global> <admin> <routers> <adminhtml> <args> <frontName><![CDATA[admin]]></frontName> </args> </adminhtml> </routers> </admin> </config>

Change values of host, username, password and dbname tags.

• Login to phpmyadmin or management panel and select appropriate DB name, then click on import button, browse database backup file and click save button.

After import is complete, database will be fully functional for new instance of magento.

Note: If required, change values of unsecure_base_url and secure_base_url in core_config_data table.

Please let me know if you find any problem.