Fresh Install Then Importing Old Database

Hey guys,



I'm currently running CS-Cart that has been updated many times. The products originally came from 2.X, then upgraded to 4.1 then to 4.2.x.



My question is, If I backup my current database, then import it to a fresh install of 4.2.4, will everything work?



I'm assuming it should, but just wanted to double check.

if you want to backup and import the whole database, then you should use the normale upgrade.



If you want to insert only the nessecary tables and inserts than you can do this:

  • What i should do is upgrading first to 4.2.4 and backup the sql data, and ftp backup with the images.
  • Clean install
  • And just import the sql tables with insert from categories, products, options, filters, features, clients, images, and what you want to keep…



    Repair and optimize the sql database in phpmyadmin

    Clear cache in the admin and building & design up from scratch without the old ftp files.



    You should only do this if you know what you are doing.



    second option,

    Upgrading to the last version.

    Make backup first from ftp files.

    Removing in ftp all the files, except the var and images folder and design template (if you wanne keep this), config_global.php and htacces file.

    Place the new files from 4.2.4 in ftp and set chmod to the correct files.

    Login to admin, and clear cache.



    Hope this help you further.

    But like i said only do this of you know what you are doing.



    Kindley regards

[quote name='nathand' timestamp='1417891195' post='198950']

Hey guys,



I'm currently running CS-Cart that has been updated many times. The products originally came from 2.X, then upgraded to 4.1 then to 4.2.x.



My question is, If I backup my current database, then import it to a fresh install of 4.2.4, will everything work?



I'm assuming it should, but just wanted to double check.

[/quote]



Yes it should work fine as all the database differences were changed throughout the previous upgrades. No doubt the database is carrying a bit of weight that isnt needed from the older versions,but it will work fine on a fresh install of the same version, 4.1, 4.2

but as ever, to be sure do it on a dev site first

John