[wp-hackers] wordpress import. does it really work?

Mika A Epstein ipstenu at ipstenu.org
Mon Apr 9 11:16:52 UTC 2012


Yes it works, no it doesn't import your links.

http://en.support.wordpress.com/blogroll/import-export-links/

Works the same way on .org installs.

On Apr 8, 2012, at 11:42 PM, Haluk Karamete <halukkaramete at gmail.com> wrote:

> Doesn't wordpress importer ( 0.6 )  import the links?
> 
> I've been trying for the second time, that the exported wordpress does not
> contain any of the original 7 links that comes with the frsh install.
> 
> My test environment is as follows.
> 
> get a fresh install.
> make an xml backup ( export ) of it as backup.xml
> 
> add a few links, posts, tags, taxonomies....
> 
> then run
> 
> TRUNCATE TABLE wp_links
> TRUNCATE TABLE wp_posts
> TRUNCATE TABLE wp_terms
> TRUNCATE TABLE wp_term_taxonomy
> TRUNCATE TABLE wp_term_relationships
> 
> this literally clears the mentioned 5 tables.
> 
> then run the wordpress importer plugin and point to backup.xml
> 
> As a result, I get the hello world, the uncategorized category and that's
> about it,.
> 
> 
> I check out the wp_terms, wp_term_taxonomy, wp_term_relationships tables.
> NADA. 0 records in there.
> 
> I check out the wp_posts and I get 3 records in there, with ID's 1,3 and 4.
> 
> 
> [image: Full Texts]<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&sql_query=SELECT+%2A+FROM+%60wp_posts%60&goto=tbl_structure.php&dontlimitchars=1&token=76e77e3da481bb3f5061bd8ba1a57ab0>
> ID<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60ID%60+ASC>
> post_author<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_author%60+ASC>
> post_date<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_date%60+ASC>
> post_date_gmt<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_date_gmt%60+ASC>
> post_content<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_content%60+ASC>
> post_title<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_title%60+ASC>
> post_excerpt<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_excerpt%60+ASC>
> post_status<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_status%60+ASC>
> comment_status<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60comment_status%60+ASC>
> ping_status<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60ping_status%60+ASC>
> post_password<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_password%60+ASC>
> post_name<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_name%60+ASC>
> to_ping<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60to_ping%60+ASC>
> pinged<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60pinged%60+ASC>
> post_modified<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_modified%60+ASC>
> post_modified_gmt<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_modified_gmt%60+ASC>
> post_content_filtered<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_content_filtered%60+ASC>
> post_parent<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_parent%60+ASC>
> guid<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60guid%60+ASC>
> menu_order<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60menu_order%60+ASC>
> post_type<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_type%60+ASC>
> post_mime_type<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60post_mime_type%60+ASC>
> comment_count<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60+ORDER+BY+%60wp_posts%60.%60comment_count%60+ASC>[image:
> Edit]<https://p3nlmysqladm001.secureserver.net/nld50/95/tbl_change.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&primary_key=+%60wp_posts%60.%60ID%60+%3D+1&sql_query=SELECT+%2A+FROM+%60wp_posts%60&goto=sql.php>[image:
> Delete]<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=DELETE+FROM+%60wp_posts%60+WHERE+%60wp_posts%60.%60ID%60+%3D+1+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddevlib%26table%3Dwp_posts%26token%3D76e77e3da481bb3f5061bd8ba1a57ab0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560wp_posts%2560%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php>
> 112012-04-09 04:33:210000-00-00 00:00:00 Auto Draft auto-draftopenopen
>   2012-04-09
> 04:33:210000-00-00 00:00:00
> 0http://developerlibrary.com/devlib/?p=10post 0[image:
> Edit]<https://p3nlmysqladm001.secureserver.net/nld50/95/tbl_change.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&primary_key=+%60wp_posts%60.%60ID%60+%3D+3&sql_query=SELECT+%2A+FROM+%60wp_posts%60&goto=sql.php>[image:
> Delete]<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=DELETE+FROM+%60wp_posts%60+WHERE+%60wp_posts%60.%60ID%60+%3D+3+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddevlib%26table%3Dwp_posts%26token%3D76e77e3da481bb3f5061bd8ba1a57ab0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560wp_posts%2560%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php>
> 312012-02-26 00:30:132012-02-26 00:30:13Welcome to WordPress. This is your
> first post. Edi...Hello world! publishopenopen hello-world  2012-02-26
> 00:30:132012-02-26 00:30:13 0http://developerlibrary.com/?p=10post 2[image:
> Edit]<https://p3nlmysqladm001.secureserver.net/nld50/95/tbl_change.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&primary_key=+%60wp_posts%60.%60ID%60+%3D+4&sql_query=SELECT+%2A+FROM+%60wp_posts%60&goto=sql.php>[image:
> Delete]<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=DELETE+FROM+%60wp_posts%60+WHERE+%60wp_posts%60.%60ID%60+%3D+4+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddevlib%26table%3Dwp_posts%26token%3D76e77e3da481bb3f5061bd8ba1a57ab0%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560wp_posts%2560%26zero_rows%3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_structure.php>
> 412012-02-26 00:30:132012-02-26 00:30:13This is an example page. It's
> different from a blo...Sample Page publishopenopen sample-page  2012-02-26
> 00:30:132012-02-26 00:30:13 0http://developerlibrary.com/?page_id=20page 0
> [image: With selected:] Check
> All<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60&goto=tbl_structure.php&checkall=1>
> / Uncheck All<https://p3nlmysqladm001.secureserver.net/nld50/95/sql.php?db=devlib&table=wp_posts&token=76e77e3da481bb3f5061bd8ba1a57ab0&sql_query=SELECT+%2A+FROM+%60wp_posts%60&goto=tbl_structure.php>
> *With selected:* [image: Change] [image: Delete] [image: Export]
> 
> It's totally misbehaving. Isn't a wordpress exported xml file with 0
> resourced attached to it be easily imported back with wordpress importer
> identically?
> 
> After truncating the wp_posts table, how come do I end up getting the id 2
> is missing after the import? It beats me.
> _______________________________________________
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
> http://lists.automattic.com/mailman/listinfo/wp-hackers


More information about the wp-hackers mailing list