How to import Mysql Tables

Discussion in 'MySQL' started by Jalpari, Oct 18, 2009.

0
  1. #1
    how to import only specific category posts from phpmyadmin i am using wordpress 2.8.4 :rolleyes:
     
    Jalpari, Oct 18, 2009 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Do you have sql dump?
     
    mwasif, Oct 18, 2009 IP
  3. blackcarat

    blackcarat Peon

    Messages:
    13
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Sorry not familiar with wordpress but you could construct a mysql query to take specific data from one table to populate another.

    An simple example found on tinternet.

    INSERT INTO database2.table1 (field1,field3,field9)
    SELECT table2.field3,table2.field1,table2.field4
    FROM table2;

    If you add a where clause you can then be specific on match rules.. eg FROM table2 WHERE table2.field1 like '%for sale%';

    Andy
     
    blackcarat, Oct 18, 2009 IP
  4. Jalpari

    Jalpari Notable Member

    Messages:
    5,640
    Likes Received:
    137
    Best Answers:
    0
    Trophy Points:
    260
    #4
    i am not familiar with this command :confused:
     
    Jalpari, Oct 19, 2009 IP
  5. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #5
    can you help us with data example and table structures?

    that will give us fair idea of what you wish to achieve.
     
    mastermunj, Oct 21, 2009 IP
  6. heavydev

    heavydev Peon

    Messages:
    33
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    This will probably be the best solution, but you may also have to manually rebuild relational data tied to the posts. Wordpress in my experience also keeps an index of posts and what categories they are tied to so ultimately you will have a few steps in addition to this.
     
    heavydev, Oct 23, 2009 IP