how do i overwrite the megento database

[Vanagandr]

I'm trying to install a new store and i already have a database that is fully loaded with the store products. how do i use my loaded database to overwrite the one that was set up when i installed magento. i'm working with magento ce 1.9.0.1

[xeont · Accepted solution]

Hi,

If I understand correctly, You have a previous Magento Database with all your products in it.

You can simply create a new database and install Magento to it.

After the installation is complete, you can change the database details to previous one in /etc/local.xml,

I have done this to many 1.x upgrades.

Make sure you clear cache manually before accessing the website with previous database.

Thank you

[Vanagandr]

Thank you for explaining where to change the information. But where or how do I upload the database I already have with my products in it. The database is a .SQL file and I'm using a ftp program to upload files to the server. I just don't know where I'm to upload/install my existing database.