Wordpress question - Bulk links insertion - GoFuckYourself.com

alexg · 04-15-2007, 01:47 PM

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?

smutx · 04-15-2007, 02:20 PM

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

alexg · 04-15-2007, 02:22 PM

Quote:

Originally Posted by smutx

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...

GrouchyAdmin · 04-15-2007, 02:24 PM

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?

scouser · 04-15-2007, 02:24 PM

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.

smutx · 04-15-2007, 02:25 PM

Quote:

Originally Posted by alexg

yeah that's an option...

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

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

sarettah · 04-15-2007, 02:27 PM

Quote:

Originally Posted by alexg

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?

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

GrouchyAdmin · 04-15-2007, 02:30 PM

Quote:

Originally Posted by sarettah

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.

alexg · 04-15-2007, 02:35 PM

Quote:

Originally Posted by GrouchyAdmin

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?

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

will try this soon on the new DB...

sarettah · 04-15-2007, 03:17 PM

Quote:

Originally Posted by GrouchyAdmin

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.

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.

Scotty.T · 04-15-2007, 03:29 PM

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.

alexg · 04-15-2007, 04:55 PM

Quote:

Originally Posted by Scotty.T

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

alexg · 04-16-2007, 03:18 AM

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...

Scotty.T · 04-16-2007, 03:25 AM

Quote:

Originally Posted by alexg

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.

HairToStay · 04-16-2007, 04:15 AM

http://www.blogrolling.com

04-15-2007, 01:47 PM	#1
alexg IL4L.com Join Date: Aug 2003 Location: Israel - ICQ: 162136565 Posts: 11,287	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? __________________ Find fuck buddies in your area!

04-15-2007, 02:20 PM	#2
smutx Confirmed User Industry Role: Join Date: Jan 2004 Location: interwebs Posts: 1,190	what i did was i deleted the blogroll and made a php include that had all my links. __________________ icq: 236148465

04-15-2007, 02:24 PM	#4
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	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? __________________ AIM: GrouchyGfy

04-15-2007, 03:29 PM	#11
Scotty.T Confirmed User Join Date: Nov 2004 Location: Scotland Posts: 1,062	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. __________________ .

04-16-2007, 03:18 AM	#13
alexg IL4L.com Join Date: Aug 2003 Location: Israel - ICQ: 162136565 Posts: 11,287	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... __________________ Find fuck buddies in your area!

04-15-2007, 02:24 PM	#5
scouser marketer. Industry Role: Join Date: Aug 2006 Location: bcn Posts: 2,280	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.

04-16-2007, 04:15 AM	#15
HairToStay Confirmed User Join Date: Oct 2002 Location: Southcoast, Mass. Posts: 1,521	http://www.blogrolling.com