Wordpress question - Bulk links insertion

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • alexg
    IL4L.com
    • Aug 2003
    • 11287
    #1

    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!
    Tags: None
    • smutx
      Confirmed User
      • Jan 2004
      • 1190
      #2
      what i did was i deleted the blogroll and made a php include that had all my links.

      icq: 236148465

        Comment

        • alexg
          IL4L.com
          • Aug 2003
          • 11287
          #3
          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...

          Find fuck buddies in your area!

            Comment

            • GrouchyAdmin
              Now choke yourself!
              • Apr 2006
              • 12085
              #4
              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?

                Comment

                • scouser
                  marketer.
                  • Aug 2006
                  • 2280
                  #5
                  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.

                    Comment

                    • smutx
                      Confirmed User
                      • Jan 2004
                      • 1190
                      #6
                      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

                      icq: 236148465

                        Comment

                        • sarettah
                          see you later, I'm gone
                          • Oct 2002
                          • 14364
                          #7
                          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
                          All cookies cleared!

                            Comment

                            • GrouchyAdmin
                              Now choke yourself!
                              • Apr 2006
                              • 12085
                              #8
                              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.

                                Comment

                                • alexg
                                  IL4L.com
                                  • Aug 2003
                                  • 11287
                                  #9
                                  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...

                                  Find fuck buddies in your area!

                                    Comment

                                    • sarettah
                                      see you later, I'm gone
                                      • Oct 2002
                                      • 14364
                                      #10
                                      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.
                                      All cookies cleared!

                                        Comment

                                        • Scotty.T
                                          Confirmed User
                                          • Nov 2004
                                          • 1062
                                          #11
                                          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.
                                          .

                                            Comment

                                            • alexg
                                              IL4L.com
                                              • Aug 2003
                                              • 11287
                                              #12
                                              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

                                              Find fuck buddies in your area!

                                                Comment

                                                • alexg
                                                  IL4L.com
                                                  • Aug 2003
                                                  • 11287
                                                  #13
                                                  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!

                                                    Comment

                                                    • Scotty.T
                                                      Confirmed User
                                                      • Nov 2004
                                                      • 1062
                                                      #14
                                                      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.
                                                      .

                                                        Comment

                                                        • HairToStay
                                                          Confirmed User
                                                          • Oct 2002
                                                          • 1521
                                                          #15
                                                          http://www.blogrolling.com
                                                          Make bank by giving your surfers free pics every day and it costs you NOTHING! Use POTD Sponsors to find adult sponsors in more than 75 niches who offer a POTD feature!

                                                            Comment

                                                            Previous template Next
                                                            Working...