wpkings |
01-29-2008 11:44 AM |
Quote:
Originally Posted by Kard63
(Post 13713508)
You are exactly right. That is what I want.
|
As Jace also suggested, the way to do it would be to create a local database filled with the data you want, then just import it into the live database.
You could do the dump of the local database and import it into the live database, or run the queries manually. For example, to insert a category into the database:
Code:
INSERT INTO `wp_categories` ( `cat_ID` , `cat_name` , `category_nicename` , `category_description` , `category_parent` )
VALUES (
'', 'test cat name', 'test-cat-name', '', '0'
);
To insert a basic link into your blogroll:
Code:
INSERT INTO `wp_links` ( `link_id` , `link_url` , `link_name` , `link_image` , `link_target` , `link_category` , `link_description` , `link_visible` , `link_owner` , `link_rating` , `link_updated` , `link_rel` , `link_notes` , `link_rss` )
VALUES (
'', 'httpwwwtesturlcom', 'Test Blogroll Friend', '', '', '1', '', 'Y', '1', '0', '0000-00-00 00:00:00', '', '', ''
);
* both of these examples assume your table prefix is 'wp_'
Make sure "httpwwwtesturlcom" in the above example is fixed (include colon, slashes, periods) before adding. I'm unable to post links apparently.
Hope this helps.
|