• 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/Using phpMyAdmin to import sql file

Using phpMyAdmin to import sql file

48 views 1 July 20, 2021 why2central

You will need the database base name.  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 name. Do not close the page, you will need the database name as your reference upon import the SQL file.

8. Click the cP icon to go back to cPanel main page.

9. Click phpMyAdmin.

10. Click the database name. Refer to number 7 above to know the correct database name that your cart is using.
11. Click the Import.

12. Click Choose File. Make sure the uploaded SQL file is the correct one.
13. Click Go to start the import process.

14. You will see the messages if the import process was successful.

Was this helpful?

1 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)
  • How to change table prefix in sql file

Didn't find your answer? Contact Us

  Using cPanel to upload patch files

Using Product Images And Product Options Image  

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