• Home
  • V1 Docs
    • Admin Extras
      • Cost Plus Changer
      • Email Editor
      • Enhanced Editor
      • Enhanced Editor v1.2.15+
      • Multiple Price Changer
      • Option Price Lite
      • Option Price Pro
      • Option Price Link Pro
      • Product As Option
      • Pricing Calculator >
        • Area Calculator
        • Length Calculator
        • Liquids Calculator
        • Pricing Calculator
        • Pricing Calculator Pack
        • Pricing Calculator Area & Length Pack
        • Pricing Calculator Weight & Liquids Pack
        • Volume Calculator
        • Weight Calculator
      • Quick Grid Export
      • Special Shipping Images
      • Telephone Option
      • VAT/Tax ID Option
    • Marketing
      • AddThis
      • Brands Info
      • Build A Gift
      • Calendar
      • Calendar v1.2.15+
      • Constant Contact Integration
      • Constant Contact Integration & Online Newsletter Pack
      • Coupon By Locations
      • Customer Group Auto Assigned
      • Customer Group Category Access
      • EasyAppt Integration
      • Easy Slider
      • Info Banner
      • MailChimp Integration
      • MailChimp Integration Plus
      • MailChimp Integration & Online Newsletter Pack
      • Multiple Discount Manager
      • Online Newsletter
      • Option Price Pro & Product Pricing Plus Pack
      • Product Pricing Plus
      • Quick Checkout
      • Quick View
      • Reorder
    • Partner
      • AbanteCart/AvaTax Integration extension
      • TaxJar Integration
    • Payment
      • Enhanced Authorize.Net (AIM)
      • Interac e-Transfer
    • Product Feeds
      • Total Import
      • Honest Green Import Addon
      • Honest Green Orders Management AddOn
    • Reports
      • Advanced Reports
      • Advanced Reports v1.2.15+
      • Banner Statistic Manager
      • Inventory Report
      • Sales By State Report
    • Shipping
      • Australia Post Integration
      • Canada Post Integration
      • Delivery Scheduler
      • Delivery Scheduler + Quick Grid Export Pack
      • Fedex Integration
      • Enhanced Flat Rate Shipping
      • New Zealand Post Integration
      • Purolator Integration
      • ShipEngine Integration
      • UPS Integration
      • UPS Integration Plus
      • USPS Integration
  • Request Extension Demo
  • Knowledge base
  • Video Library
  • Patch
    • AbanteCart Prior v1.2.10
      • Package Manager
    • AbanteCart v1.2.14
      • AbanteCart v1.2.14 product location files
    • AbanteCart v1.2.16
      • Default Stripe
    • AbanteCart v1.3.0
      • AbanteCart v1.3.0 Default AuthorizeNet Patch Files
      • AbanteCart v1.3.0 Default Core Lib Config Fix
      • AbanteCart v1.3.0 Default Fast Checkout Typo Fix
      • AbanteCart V1.3.0 Patch Files
      • AbanteCart v1.3.0 Product Option Cost patch files
      • AbanteCart v1.3.0 Rounding Fix
      • Default UPS
    • AbanteCart v1.3.1
      • AbanteCart v1.3.1 patch files
      • AbanteCart V1.3.1 Default Core XSS Vulnerability Patch File
      • AbanteCart v1.3.1 Incorrect New Product Length And Weight Class patch file
    • AbanteCart v1.3.2
      • AbanteCart V1.3.2 Base64 Encoded Unnecessarily. Php Mailer Patch File
      • AbanteCart V1.3.2 Default Core XSS Vulnerability Patch File
      • AbanteCart v1.3.2 Default Flat Rate And Default Weight Based Shipping patch file
      • AbanteCart v1.3.2 Incorrect New Product Length And Weight Class patch file
    • AbanteCart v1.3.3
      • AbanteCart v1.3.3 Bootstrap5 patch file
      • AbanteCart v1.3.3 Default Stripe Patch FIle
  • Faq
  • Known Issues
  • Home
  • V1 Docs
    • Admin Extras
      • Cost Plus Changer
      • Email Editor
      • Enhanced Editor
      • Enhanced Editor v1.2.15+
      • Multiple Price Changer
      • Option Price Lite
      • Option Price Pro
      • Option Price Link Pro
      • Product As Option
      • Pricing Calculator >
        • Area Calculator
        • Length Calculator
        • Liquids Calculator
        • Pricing Calculator
        • Pricing Calculator Pack
        • Pricing Calculator Area & Length Pack
        • Pricing Calculator Weight & Liquids Pack
        • Volume Calculator
        • Weight Calculator
      • Quick Grid Export
      • Special Shipping Images
      • Telephone Option
      • VAT/Tax ID Option
    • Marketing
      • AddThis
      • Brands Info
      • Build A Gift
      • Calendar
      • Calendar v1.2.15+
      • Constant Contact Integration
      • Constant Contact Integration & Online Newsletter Pack
      • Coupon By Locations
      • Customer Group Auto Assigned
      • Customer Group Category Access
      • EasyAppt Integration
      • Easy Slider
      • Info Banner
      • MailChimp Integration
      • MailChimp Integration Plus
      • MailChimp Integration & Online Newsletter Pack
      • Multiple Discount Manager
      • Online Newsletter
      • Option Price Pro & Product Pricing Plus Pack
      • Product Pricing Plus
      • Quick Checkout
      • Quick View
      • Reorder
    • Partner
      • AbanteCart/AvaTax Integration extension
      • TaxJar Integration
    • Payment
      • Enhanced Authorize.Net (AIM)
      • Interac e-Transfer
    • Product Feeds
      • Total Import
      • Honest Green Import Addon
      • Honest Green Orders Management AddOn
    • Reports
      • Advanced Reports
      • Advanced Reports v1.2.15+
      • Banner Statistic Manager
      • Inventory Report
      • Sales By State Report
    • Shipping
      • Australia Post Integration
      • Canada Post Integration
      • Delivery Scheduler
      • Delivery Scheduler + Quick Grid Export Pack
      • Fedex Integration
      • Enhanced Flat Rate Shipping
      • New Zealand Post Integration
      • Purolator Integration
      • ShipEngine Integration
      • UPS Integration
      • UPS Integration Plus
      • USPS Integration
  • Request Extension Demo
  • Knowledge base
  • Video Library
  • Patch
    • AbanteCart Prior v1.2.10
      • Package Manager
    • AbanteCart v1.2.14
      • AbanteCart v1.2.14 product location files
    • AbanteCart v1.2.16
      • Default Stripe
    • AbanteCart v1.3.0
      • AbanteCart v1.3.0 Default AuthorizeNet Patch Files
      • AbanteCart v1.3.0 Default Core Lib Config Fix
      • AbanteCart v1.3.0 Default Fast Checkout Typo Fix
      • AbanteCart V1.3.0 Patch Files
      • AbanteCart v1.3.0 Product Option Cost patch files
      • AbanteCart v1.3.0 Rounding Fix
      • Default UPS
    • AbanteCart v1.3.1
      • AbanteCart v1.3.1 patch files
      • AbanteCart V1.3.1 Default Core XSS Vulnerability Patch File
      • AbanteCart v1.3.1 Incorrect New Product Length And Weight Class patch file
    • AbanteCart v1.3.2
      • AbanteCart V1.3.2 Base64 Encoded Unnecessarily. Php Mailer Patch File
      • AbanteCart V1.3.2 Default Core XSS Vulnerability Patch File
      • AbanteCart v1.3.2 Default Flat Rate And Default Weight Based Shipping patch file
      • AbanteCart v1.3.2 Incorrect New Product Length And Weight Class patch file
    • AbanteCart v1.3.3
      • AbanteCart v1.3.3 Bootstrap5 patch file
      • AbanteCart v1.3.3 Default Stripe Patch FIle
  • Faq
  • Known Issues
home/KNOWLEDGE BASE/Tips And Tricks/How to change table prefix in sql file

How to change table prefix in sql file

17 views 0 September 30, 2021 Updated on October 1, 2021 why2central

You will need to know your existing cart table prefix. To find it Open cPanel and you should see:

1.Click the File Manager.

After clicking the File Manager, you should see:



2. Click public_html.
3. Click the installation subfolder name if you are installing AbanteCart in the subfolder instead of the root folder.
4. Click system.
5. Click config.php.
6. Right click config.php and click the View. It will open up a new page showing your cart database info.

7. This is your database prefix.

8. Open the sql file that you have downloaded to your computer.

9. Change these prefixes to the prefix that your cart installation use in number 7 above.

10. Finally save the changes.

Was this helpful?

Yes  No
Related Articles
  • Create Route Planner For WHY2 Delivery Scheduler Extension Using Google MyMaps
  • Multi store using subdomain(s)
  • Multi store using subfolder(s)
  • Create subdomain
  • Multi store using sub/subfolder(s)
  • Product Options Configuration

Didn't find your answer? Contact Us

  Edit Maintenance Page Become Under Construction Page

How to update AbanteCart or extensions using a staging site  

AbanteCart Extensions clients

Support : here

Buy extension:

Buy in the MarketPlace: here

Buy or Rent extensions from AbantecartExtensions.com: here

AbanteCart Plus clients:

Support: here

Tired of updating hassles? – check out our Managed Client services:
here

Frequent Visit Links
  • Licenses
  • Terms
  • Refunds
  • Privacy Policy
  • © We Hear You 2, Inc (WHY2) 2002-2023 - All rights reserved