Magento

eCommerce Software for Online Growth

Magento Forum

From setting up your store to managing your products, pages and promotions to generating detailed reports, the Magento User Guide empowers the user to utilize the platform for all of its vast capacity.
Available in eBook and Print formats – Download Now!!!
   
how to change database name in magento after installation
 
biplobbasu2007
Jr. Member
 
Total Posts:  1
Joined:  2009-08-07
 

Hi..
I have install magento...but I want to change my database name. What should I do?
Please help me. I can not solve the problem.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ksolaro
Guru
 
Avatar
Total Posts:  422
Joined:  2008-11-19
 

You can probably do this through your host’s Cpanel. And then update the db name in your app/etc/local.xml file.

 Signature 

CloudQuarry LLC
Custom Magento Development
Check out our latest store: Poetrie.com: Online Boutique for Independent Designers

 
Magento Community Magento Community
Magento Community
Magento Community
 
Mammon
Jr. Member
 
Avatar
Total Posts:  19
Joined:  2009-08-24
 

http://www.magentocommerce.com/wiki/groups/227/moving_magento_to_another_server

 
Magento Community Magento Community
Magento Community
Magento Community
 
Brent W Peterson
Moderator
 
Avatar
Total Posts:  1361
Joined:  2009-02-26
Minneapolis MN
 

1) Make a backup of your database
2) Create database with new name
3) restore old database to new database like this:

mysqldump --username=YOURUSER --password=YOURPASS DB_NAME > /path/to/dump/file.sql

mysql 
--user=YOURNEWUSERNAME --password=YOURNEWPASSWORD NEW_DB_NAME < /path/to/dump/file.sql

4) change your database name, username and password in your local.xm file,

 Signature 

Brent W. Peterson S.C.J.E.
What cool thing did I do lately?:
Quick Order
What am I working on now?: Auto add to cart now with discount
Bored? Read my non-techie blog

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
 
© Copyright 2010 Magento Inc.
Privacy Policy|Terms of Service
Magento Community Count
279113 users|1242 users currently online|348114 forum posts