Customer Info

I just installed 1.3.5-sp4. Tried to upgrade however I did not have much luck. I was using 1.3.4-sp3. Is there anyway I can move all of my customer info over to the new website? I sure hope so…Everything else went very well however this is my last task to do. Any Ideas?



Thanks for the help!:smiley: :confused:

The only way I know how to do this is through phpmyadmin…export/import your “users” information:



Look for:

cscart_users

cscart_user_data

cscart_user_profiles



So if you’re familiar with using phpmyadmin on MySQL it’s pretty easy.



Back up your database first!



Then open phpmyadmin to your store database and select the table you want to “export”…Select the “Export” link.



Under “Export” left side:

Make sure SQL is selected



Right Side leave as is and make sure these are selected also:

Add DROP TABLE

Add IF NOT EXISTS



At the bottom select “Save As File”

Hit Go…



Name the file the same as the “table” name you are exporting.

Remember where you save it.



Now the only thing you need to be aware of is if your database names are different.

If they are you will need to open the exported file in a ‘text’ editor and change the name of the database to the name of the database you will be importing the file to.



If the database names are the same, you’re good to go.



Then go to your new site database with phpmyadmin and click on Import:

Browse to the file you just exported.

Uncheck “Partial Import”

“SQL compatibility mode” NONE

Hit Go



It sounds a lot more complicated then it really is but once you’ve done it a couple times it’s a great time saver for moving data.



WebGuy