View Single Post
  #395  
Old 11-10-2021, 10:50 AM
 
PhilJ PhilJ is offline
 

X-Guru
  
Join Date: Nov 2002
Posts: 4,094
 

Default Re: X-Cart reBOOT (reDUX) Template

Quote:
What is the best way to transfer all the modified reboot database config/languages settings over to my live store?

@Vulcan, not been asked that before, but it's certainly possible.

For template settings (x-cart config entries), you could use PHPMyAdmin to search for the reboot settings with the following SQL...
Code:
SELECT * FROM `xcart_config` WHERE `name` LIKE '%reboot_%' LIMIT 9999;

Then export the results/entries found which will give you an SQL file... note that you'll only need the SQL code between...
Code:
-- -- Dumping data for table `xcart_config` --

And..
Code:
-- -- Indexes for dumped tables --
In that SQL code, replace...
Code:
INSERT INTO `xcart_config` (`name`, `comment`, `value`, `category`, `orderby`, `type`, `defvalue`, `variants`, `validation`, `signature`) VALUES

With...
Code:
REPLACE INTO `xcart_config` (`name`, `comment`, `value`, `category`, `orderby`, `type`, `defvalue`, `variants`, `validation`, `signature`) VALUES

I would recommend making a DB backup of your destination site before applying the SQL to it.

Languages are trickier, as not all language entry names contain the word "reboot", but you could export all language entries from your source site to CSV, and import them back into the destination site.
__________________
xcartmods.co.uk
Reply With Quote