✏ EDIT: blueplanet_db_update.sql

-- BluePlanet database update script
-- This SQL script updates references from the old domain (blueswirlz.com) to the new domain (blueplanet.co.in) and installs new SEO metadata.
-- Execute this script against your MySQL database using a tool like phpMyAdmin or the MySQL command line.

-- 1. Update the site URL in a hypothetical site settings table (if it exists).
--    Adjust the table and column names to match your actual schema.
UPDATE site_settings SET value = 'https://blueplanet.co.in' WHERE `key` = 'site_url';

-- 2. Replace occurrences of the old domain within content fields across several tables.  
--    These updates ensure that any embedded links or image paths now point to the new domain.
UPDATE blogs    SET content   = REPLACE(content,   'blueswirlz.com', 'blueplanet.co.in');
UPDATE blogs    SET image_path= REPLACE(image_path,'blueswirlz.com', 'blueplanet.co.in');
UPDATE products SET image_path= REPLACE(image_path,'blueswirlz.com', 'blueplanet.co.in');
UPDATE services SET icon      = REPLACE(icon,     'blueswirlz.com', 'blueplanet.co.in');
UPDATE sliders  SET image_path= REPLACE(image_path,'blueswirlz.com', 'blueplanet.co.in');

-- 3. Insert or update SEO meta tags in a hypothetical meta table.  
--    If your CMS uses a dedicated table for site metadata, adapt the table and column names accordingly.  
--    The REPLACE INTO syntax will insert a new row or update the existing row with the same meta_key.
REPLACE INTO site_meta (meta_key, meta_value) VALUES
 ('meta_description', 'BluePlanet is the official website of Blueswirlz Engineers & Consultants, a premier cold room manufacturer and refrigeration solutions provider based in Hyderabad. We design, manufacture and install energy‑efficient chiller rooms, freezer rooms, blast chillers/freezers, ripening chambers and bespoke refrigeration systems. Our expert team serves businesses and industries across Telangana and Andhra Pradesh with consultation, installation and maintenance services.'),
 ('meta_keywords',    'BluePlanet, Blueswirlz Engineers & Consultants, cold room manufacturer Telangana, cold room manufacturer Andhra Pradesh, refrigeration solutions Hyderabad, chiller rooms, freezer rooms, blast chiller, blast freezer, ripening chambers, cold storage solutions, refrigeration installation Telangana, refrigeration maintenance, Hyderabad cold rooms, energy efficient refrigeration');

[✗] CANCEL