Wordpress question - Bulk links insertion
 

Let's say I have a blogroll with about 50 links in Blog A, and I want Blog B to have these exact same links (can be useful for blog directory recip links for example). Is there a way I can just transfer all the links with one click, instead of adding them manually one by one?

I tried to edit the mysql tables, but it only allows me to copy a table to another table in the same mysql database. I want to copy to a different database. is that possible?

Or instead, is there a way to add a bulk list of links with wordpress? a plugin for this maybe?

what i did was i deleted the blogroll and made a php include that had all my links.

yeah that's an option...

I should've done it this way from the beginning, and not waste my time on this stupid blogroll... :disgust

Export your table. Import on other database. About 3 clicks, instead of one. Or, pay someone to do this for you in PHP. What's the problem? :error

just export it, so you get something like

insert into ...

and then run that query (paste it in, if you use something like phpmyadmin) into the new db

if that makes sense? sorry im vague. too tired to go into detail.

the best one, messing with tables each time would be a hassle.
one include file would be so much easier

insert into newdatabasename.tablename(fieldlist) select fieldlist from olddatabasename.tablename

Where fieldlist is the lsit of fields you are pulling from one database/table into the other database/table

If he's using different databases, the chances are high that he does not have them on the same system... or just loves to use multiple databases. :)

yeah, i think it might be easier than i thought...

will try this soon on the new DB...

I use multiple databases for many things...lol... So I assumed they are on the same system as he was asking if he could just copy from one to the other.

But you may be right too.

Your links are stored in an OPML file

www.yourdomain.com/wp-links-opml.php

Under the 'Links' or 'Blogroll' link in admin there is then an option to import them again.

Hey, thanks man! I had no idea about this...
this is neat :)

I have to bump this thread again, because I have another question.

Did it happen to you that you make any changes in wordpress, like add or remove links, and the results don't appear instantly, but instead there is a delay of like up to an hour or so?

it happens all the time lately and I have no idea why :(

so many issues with wordpress lately...

I've never had that but I don't make a lot of those kind of changes to be honest.

I have had a couple of 'future' posts that didn't post when they were supposed to though. Haven't found out why though.