Database Import

[jballotti]

I'm installing a second instance of Zen Cart for a client to use as a Wholesale store in parallel with her retail store. Can anyone recommend the most effective and efficient method of exporting the original database and importing the data into the new database.

Thanks in advance.

[elastic]

do you need to keep both versions of ZC current, a mirror of one another?

if so, I would recommend using an ESS approach with filemaker pro 9

if not, going to phpmyadmin and exporting the entire database into a SQL fiile, strip customer data out of that file, and installing the revised version into your second store. make sure you dont wipe out any settings when you do the import. you will have a mirror of the products and all the other settings at this point.

you can manually do this every day or week, but an ESS approach would allow almost instant updates

[vend1a]

Hey Elastic or anyone!?!

I would like to know if there is a tutorial on how to update zencart with data from filemaker pro advance 10.

i would like to be able to update the mysql db with data from FMpro.

any help will be much appreciated. have been searching in the forum but no step by step guidance.

thanking you in advance

V