#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2009
    Posts
    4
    Rep Power
    0

    Exporting tables from one DB to another DB


    Hello Everyone,

    Could someone please help me with the SQL query to export a table from one database into another database?

    I want to export from this database:

    Code:
    wingsofw_aasite
    Into this database:

    Code:
    wingsofw_import
    The table I'd like to export/import is:

    Code:
    mage_catalog_product_entity
    Both database are on the same server and if this makes a difference, the database are for the ecommerce software Magento.

    Thank you for your time and any help you can give me.

    Keith
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2009
    Posts
    4
    Rep Power
    0
    No help on this one?
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Oct 2009
    Location
    Nebraska, USA
    Posts
    876
    Rep Power
    276
    are you using commandline or do you have phpmyadmin to work with?
  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0
    Via Command line and assuming both databases exist already.
    # mysqldump -u <someusername> -p --opt wingsofw_aasite mage_catalog_product_entity > wingsofw_aasite.sql
    # mysql -u <someusername> -p wingsofw_import < wingsofw_aasite.sql

    Originally Posted by HMS Hajj
    Hello Everyone,

    Could someone please help me with the SQL query to export a table from one database into another database?

    I want to export from this database:

    Code:
    wingsofw_aasite
    Into this database:

    Code:
    wingsofw_import
    The table I'd like to export/import is:

    Code:
    mage_catalog_product_entity
    Both database are on the same server and if this makes a difference, the database are for the ecommerce software Magento.

    Thank you for your time and any help you can give me.

    Keith

IMN logo majestic logo threadwatch logo seochat tools logo