How to transfer a big wordpress blog?

by creativemark77 Banned 12 replies
Hello,

I need help on this, I have no problem in transferring small blogs but when it come to big wordpress blog, more than 20 MB, it will time out when you try to import using phpadmin.

Any help will be greatly appreciated.
#main internet marketing discussion forum #big #blog #transfer #wordpress
Avatar of Unregistered
  • Profile picture of the author Tyler Ellison
    That's a tough one. 20 MB is a really big database. Have you contacted your hosting about having them export it for you? That's probably what I would try first.
    {{ DiscussionBoard.errors[500859].message }}
    • Profile picture of the author creativemark77
      Banned
      Originally Posted by VideoEpidemic View Post

      That's a tough one. 20 MB is a really big database. Have you contacted your hosting about having them export it for you? That's probably what I would try first.

      No, what should i say to my host?
      {{ DiscussionBoard.errors[500890].message }}
      • Profile picture of the author KirkMcD
        Originally Posted by creativemark77 View Post

        No, what should i say to my host?
        "Can you move my old site to here?"


        Also 20 megs is nothing.
        I have a couple of mysql databases over 1 gig.
        {{ DiscussionBoard.errors[501119].message }}
  • Profile picture of the author CDawson
    Banned
    the hardest way to do this would be to do it manually.
    {{ DiscussionBoard.errors[500865].message }}
  • Profile picture of the author RobinInTexas
    try wp-admin->tools->export
    and
    wp-admin->tools->import
    Signature

    Robin



    ...Even if you're on the right track, you'll get run over if you just set there.
    {{ DiscussionBoard.errors[500882].message }}
  • I would be happy to move the site and database for you for a small fee. PM me if you are interested. I can provide you customer reviews of the same work completed.

    Cheers
    {{ DiscussionBoard.errors[503489].message }}
  • Profile picture of the author Uncle Dimitry
    check out WSO offer in my sig. My coders will complete the job easy and fast
    {{ DiscussionBoard.errors[503507].message }}
    • Profile picture of the author xga
      For large databases, I usually use mysqldump rather that phpMyAdmin. This is because phpMyAdmin run through the browser and therefore prone to timeout if the execution time is too long.
      {{ DiscussionBoard.errors[503806].message }}
      • Profile picture of the author creativemark77
        Banned
        Originally Posted by xga View Post

        For large databases, I usually use mysqldump rather that phpMyAdmin. This is because phpMyAdmin run through the browser and therefore prone to timeout if the execution time is too long.
        Hi, can you elaborate more on this?

        Thanks a lot.
        {{ DiscussionBoard.errors[506301].message }}
        • Profile picture of the author xga
          Originally Posted by creativemark77 View Post

          Hi, can you elaborate more on this?

          Thanks a lot.
          To use mysqldump, you need to have access to the command line.

          At the command line, type:

          > mysqldump db_name > yourblog.sql

          where db_name is the name of your wordpress database.

          Once done, ftp/copy the yourblog.sql file to the new location and do this:

          > mysql new_db < yourblog.sql

          You might need to create the new database (new_db) first before importing.

          That's it.

          For very large database, the command will take a while to run. But since it is run through the command line and not the browser, there won't be any timeout issues. And if the file is very large, you might want to zip it before ftp.

          For more information on mysqldump, check out: MySQL :: MySQL 5.0 Reference Manual :: 4.5.4 mysqldump ? A Database Backup Program
          {{ DiscussionBoard.errors[521294].message }}
  • Profile picture of the author Virtual Banker
    First you will want to try PHPMYADMIN --> Export as a tar.gz
    you will have to export a few different fields. Doing it as a tar.gz will probably save you from timeouts depending on your hosts setting. Then to import it is same same.

    if that doesnt work you will either have to have SSH root access which you wont have unless you have a dedicated server or get someones script.

    Good luck
    {{ DiscussionBoard.errors[504024].message }}
  • Profile picture of the author ecoverdesign
    Hello,

    just create a .sql dump of your database using phpmyadmin, upload the dump to your new hosting account via FTP and use the following free tool to import it into the new database:
    BigDump: The Staggered MySQL Dump Importer

    If you are moving to a new domain I would also recommend to read this:
    How to Move WordPress Blog to New Domain or Location My Digital Life

    Thomas
    Signature

    Graphics Design, Development and Webmaster Services
    http://www.tbitdesign.com

    {{ DiscussionBoard.errors[506650].message }}
Avatar of Unregistered

Trending Topics

  • 10 {{ upvoteCount | shortNum }}

    How Do Highly Successful People Stay Positive?

    Hi Gang, I just stumbled upon this great article and wanted to share! 6 Ways Highly Successful People Stay Positive So the question begs, how do YOU stay positive? What ... [read more]

  • 6 {{ upvoteCount | shortNum }}

    troubleshooting sales

    sparky63 in Internet Marketing

    hi peeps i have just created my first website about premium plr ebook course where you can rebrand and sell on..now i have had quite abit of traffic over the ... [read more]

  • 11 {{ upvoteCount | shortNum }}

    Free software that can record more that 10 minutes ?

    spartan14 in Internet Marketing

    Hy all i am more a youtube guy and i plan to make a course for my subscribers with some video series and i need to record videos longer that ... [read more]

  • 218 {{ upvoteCount | shortNum }}

    What is the main reason for the 95% failure rate in internet marketing?

    Here is my take on the matter: Look, a lot of people get into the internet marketing business only because of its huge money-making potential without having a love for ... [read more]

  • 2 {{ upvoteCount | shortNum }}

    Giving back a bit PHP redirect

    hometutor in Programming

    I couldn't use header since it had already tranfered I tried a javascript redirect but got an undefined page I used this file_put_contents('logs.txt', "<script>window.location =' .$rsslink.'.php</script>".PHP_EOL , FILE_APPEND | LOCK_EX); ... [read more]