Claudia M Posted April 15, 2022 Share Posted April 15, 2022 Hi, I'm starting a new web site and am using the All In One Shipping for both. I have it setup for the older site and was wondering if there is some way I can just copy the rates (database) to the new site from the other database. I need to keep it in the older site too. It's just that they are the same and it would be a lot of work. Thanks in advance, Claudia Link to comment Share on other sites More sharing options...
bsmither Posted April 15, 2022 Share Posted April 15, 2022 You will want to copy CubeCart_shipping_rates and CubeCart_shipping_zones. You will also want to copy the one single record in CubeCart_config where 'name' is "All_In_One_Shipping". Link to comment Share on other sites More sharing options...
Claudia M Posted April 15, 2022 Author Share Posted April 15, 2022 How do I do that? Link to comment Share on other sites More sharing options...
bsmither Posted April 16, 2022 Share Posted April 16, 2022 Using phpMyAdmin (or whichever external database management utility you have access to as provided by your hosting provider), examine the database of your existing store. Somewhere in phpMyAdmin, you will be shown a way to back up (might be called 'Export') individual tables. Choose the two mentioned above. When executed, there will be a SQL file that can be downloaded. Then, view the CubeCart_config table. Find the row for AIOS. Copy the contents of the 'array' column and paste it to a waiting instance of a text editor. The column's contents will look like a random sequence of characters. That is what you want. Now examine the database of your new store. Somewhere in phpMyAdmin, you will be given a means to restore from a backup -- probably "Load or Run from SQL file". Upload the SQL backup file. Then, view the CubeCart_config table. If there is already a row for AIOS, simply replace the contents of the 'array' column. If not, add a new row where 'name' is "All_In_One_Shipping" and 'array' is the contents from the text editor. (I don't use phpMyAdmin, so I can't give explicit instructions.) Link to comment Share on other sites More sharing options...
Claudia M Posted April 16, 2022 Author Share Posted April 16, 2022 Sounds like good instructions to me. I'll give it a go! Thanks! Link to comment Share on other sites More sharing options...
havenswift-hosting Posted April 17, 2022 Share Posted April 17, 2022 On 4/16/2022 at 1:22 AM, Claudia M said: Sounds like good instructions to me. I'll give it a go! Thanks! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.