my sql problem - intergrating databases - Databases forum at WebmasterWorld

Forum Moderators: open

Message Too Old, No Replies

my sql problem - intergrating databases

silkvixen

6:34 am on Feb 14, 2010 (gmt 0)

Ive just changed over my shopping cart from osc to zencart.
my host only supports one database atm and my issue is how cna i transfer over mainly my customers.
i backed up my osc shop and have all the info there which i can see and access in notepad++ but i have no idea how to intergrate the customers into the new database

i hope i have posted this in the right section :)

thanks

Tracy

Demaestro

6:23 pm on Feb 25, 2010 (gmt 0)

If you have the data in a text file then you can write a simple import routine in PHP or some other back-end language that takes in the file and loops through it creating insert statements and executing them.