Magento - Export all products & categories tables

Magento - Export all products & categories tables

October 3, 2026 · Illustrated author avatarBy Stefan Bogdanescu
Magento - Export all products & categories tables

Migrating Magento: A Comprehensive Guide to Exporting Products & Categories

As a seasoned Magento developer, I understand the frustration that arises when your e-commerce platform starts malfunctioning. In this comprehensive guide, we’ll walk you through the process of exporting all necessary tables from an existing Magento installation to create a fresh new instance.

The Challenge: A Failing Installation

You’ve found yourself in a predicament - your entire Magento site has become unresponsive over time, displaying 404 errors on key pages like the admin export tool. Despite trying numerous solutions found online, no fix seems to work.

Your Approach: A Clean Slate with Data Migration

To resolve this issue efficiently, you’ve decided to:

  1. Create a new Magento installation directory.
  2. Import all 600+ products and associated data into the fresh instance.
  3. Include linked entities such as categories and any additional extensions like Advanced Product Options.
  4. Download and upload the media/catalog folder for seamless product image migration.

The Critical Question: Which Tables Are Required?

Identifying the necessary tables is the key to a successful data migration process. Here’s a comprehensive list of tables you’ll need to export:

  1. Catalog-related tables:

    • catalog_product_entity: Contains general product information.
    • catalog_product_entity_media_gallery: Stores product image paths.
    • catalog_category_entity: Holds category details.
    • catalog_category_entity_int: Includes category attributes.
  2. Advanced Product Options extension:

    • ap_options: Stores option data.
    • ap_options_values: Contains option values.
    • ap_product_options: Links options to products.
  3. Indexing and search-related tables (optional, for improved performance):

    • catalog_index_entity_idx: Enhances product search functionality.
    • catalog_index_entity_flat: Provides a flat structure of entity data.

Exporting the Tables: A Step-by-Step Guide

Given your hosting environment lacks SSH or shell access, I recommend using phpMyAdmin to export the required tables efficiently. Here’s how:

  1. Log in to your hosting control panel and navigate to phpMyAdmin.

  2. Select your Magento database from the left sidebar.

  3. Click on the “Export” tab at the top of the page.

  4. Choose the format as “Quick - display only the output”. This generates a SQL file that can be easily imported into a new database.

  5. Under “Structure for export”, ensure all tables are selected by clicking on the checkbox next to each table name or using the “Add All” button at the top.

  6. Click the “Go” button to begin the export process.

  7. Save the generated SQL file to your local machine.

Conclusion: A Successful Data Migration

Exporting Magento data can seem daunting, but by following this comprehensive guide, you’ll successfully migrate all necessary product and category information into a clean, fresh installation.

Remember to create the new instance first, import the media/catalog folder, then use phpMyAdmin to import the exported SQL file into your new database. This ensures a seamless transition with minimal downtime for your e-commerce business.

For more in-depth insights into Magento development best practices and advanced techniques, I invite you to explore our extensive collection of articles at Laravel Company. We strive to provide the most accurate and practical advice to help you excel in the world of e-commerce development.

Catalog Database Extensions Themes

Our network