New shop

[Solan]

Hi all, im thinking of starting a whole new shop cus my shop now have a lot of bugs and wrongs, with many unneeded contribs. and i really dont know how to get them all right.

 

My wonders are if i can take a whole new shop and start all over with the contribs i want and them move som e of the database without loosing all i need from the old one like customers, adress and so forth.

 

What do i have to move from the old database to start "all" over with a fresh shop?

 

 

Hope that someone can explain an easy way.. :)

[FIMBLE]

Hi

You can do this via phpmyadmin, workout the tables (plus related tables) you want to export.

with products you will need to not only export products table, but products descriptions, attributes, etc..

Im not able to get a full list of tables from where i am curently, but they are pretty much self explainetory.

Select the tables you want to export, then export them.

 

I would suggest you take some time to go over the backup and removed reference to previous intstalled contributions. This is not a show stopper if you do not, however it may confuse if you later try to install a contribution with a SQL update you used previous only to find that the SQL is there already.

 

Im sorry im making this sound so much harder than it really is!

It depends on your level of understanding the workings of the DB

 

Nic

 

 

[Solan]

Thank you so very much :rolleyes:

 

But i need to ask about this:

 

I would suggest you take some time to go over the backup and removed reference to previous intstalled contributions.

 

Is therre a manual or thread that explains how i do that?

 

And no, im not very familiar with how databases works.. lol :lol:

[FIMBLE]

Hi

No manual that i am aware of im sorry.

If you take a standard oscommerce database from the install folder you can us it to compare what is default osc and what is not.

It all depends on the contributions you have installed, as some do not require database entries.

Nic

[000---000]

May I suggest you try setting up a whole new shop, using the same OSC version, with a complete clean install. Create a new directory for the new site, and a new database (won't be used). Once the basic install is done, change the configuration (configure.php) of the new site to use the old database. If it works you don't have to play around with the database, you will simply have a fresh OSC site to work with.

 

Of course, if you want to remove some of the database details that may require more work. Also, you may have contributions that won't work with a clean install, but it is always worth a go.

 

Matt

[FIMBLE]

IMHO you may as well just add the older databse to a new store as in effect this is what you are suggesting.

Nic

[Solan]

Thanks Guys... i´ll give it a try.. :)