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

Mon Apr 9 04:42:04 UTC 2012

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.