Zen Cart Logo
Forums / General Questions / Making a new database, then reimporting everything

Making a new database, then reimporting everything

Locked

Views: 718

Results 1 to 2 of 2
This thread is locked. New replies are disabled.
21 May 2008, 3:28 AM
#1
canemasters avatar

canemasters

Zen Follower

Join Date:
Mar 2007
Posts:
444
Plugin Contributions:
0

Making a new database, then reimporting everything

If I were to make a new database, then take my old database and import the customers, products with attributes and pretty much everything else, would I use phpmyadmin?

Maybe there is already a guide on how to do this...

21 May 2008, 4:27 AM
#2
elastic avatar

elastic

New Zenner

Join Date:
Dec 2007
Location:
New Jersey
Posts:
76
Plugin Contributions:
0

Re: Making a new database, then reimporting everything

yeah, you need phpmyadmin. basic approach here would be to save your old db through phpmyadmin as a SQL file which you save to your local machine. Make sure this export contains drop if exists!

Once you install your new version of zen cart and you have all the new config information, you would:

  1. open that SQL file in a text editor and delete the portions of it that contain admin and config information, save as edited copy

  2. open the new db in phpmyadmin, and import the edited copy of your file.

two things - your configure and admin settings from the recent import are still pure, and you have the old information on products, customers, etc accessible in the new database