How to transfer a big wordpress blog?

creativemark77 · 02-09-2009, 12:41 PM

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.

Tyler Ellison · 02-09-2009, 12:42 PM

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.

CDawson · 02-09-2009, 12:43 PM

the hardest way to do this would be to do it manually.

RobinInTexas · 02-09-2009, 12:48 PM

try wp-admin->tools->export
and
wp-admin->tools->import

creativemark77 · 02-09-2009, 12:49 PM

Quote:

Originally Posted by VideoEpidemic

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?

KirkMcD · 02-09-2009, 02:04 PM

Quote:

Originally Posted by creativemark77

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.

Private Label Ebook Shop · 02-10-2009, 07:24 AM

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

Uncle Dimitry · 02-10-2009, 07:30 AM

check out WSO offer in my sig. My coders will complete the job easy and fast

xga · 02-10-2009, 09:17 AM

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.

Virtual Banker · 02-10-2009, 10:32 AM

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

creativemark77 · 02-11-2009, 01:18 AM

Quote:

Originally Posted by 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.

Hi, can you elaborate more on this?

Thanks a lot.

ecoverdesign · 02-11-2009, 04:56 AM

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

xga · 02-15-2009, 10:42 PM

Quote:

Originally Posted by creativemark77

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

02-09-2009, 12:41 PM	#1
creativemark77 Active Warrior Join Date: Jan 2009 Posts: 59 Thanks: 0 Thanked 1 Time in 1 Post	How to transfer a big wordpress blog? 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.

02-09-2009, 12:42 PM	#2
Tyler Ellison SEO Pro War Room Member Join Date: Aug 2007 Location: Brazil/USA Posts: 372 Thanks: 51 Thanked 7 Times in 6 Posts Social Networking Contact Info	Re: How to transfer a big wordpress blog? 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.
	Web Rhyno - Become A "DropShipper" for Web Design and SEO Services!

02-09-2009, 12:43 PM	#3
CDawson old username "IMbeginner" Join Date: Aug 2008 Location: ladson, South Carolina Posts: 289 Thanks: 0 Thanked 16 Times in 15 Posts Social Networking Contact Info	Re: How to transfer a big wordpress blog? the hardest way to do this would be to do it manually.
	If you need articles written, feel free to pm me.

02-09-2009, 12:48 PM	#4
RobinInTexas HyperActive Warrior War Room Member Join Date: Dec 2008 Location: Texas Posts: 103 Thanks: 17 Thanked 8 Times in 8 Posts Social Networking Contact Info	Re: How to transfer a big wordpress blog? try wp-admin->tools->export and wp-admin->tools->import
	Robin My Website A URL pointing to more money on the web WEBHOST with unlimited domains-Bandwidth-Disk Space-MYSQL $25 1st year ...Even if you're on the right track, you'll get run over if you just sit there. .......I'll get a new avatar when I get a Benjamin every day on the web

02-10-2009, 07:24 AM	#7
Private Label Ebook Shop Private Label Rights War Room Member Join Date: Dec 2008 Posts: 42 Thanks: 4 Thanked 2 Times in 1 Post	Re: How to transfer a big wordpress blog? 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
	Private Label Rights Ebook Store

02-10-2009, 07:30 AM	#8
Uncle Dimitry ........................ War Room Member Join Date: Jun 2007 Posts: 263 Thanks: 15 Thanked 75 Times in 13 Posts Social Networking Contact Info	Re: How to transfer a big wordpress blog? check out WSO offer in my sig. My coders will complete the job easy and fast
	--->> Twitter, blog, rss feeds and traffic automation: Blogomator

02-10-2009, 09:17 AM	#9
xga Active Warrior Join Date: Aug 2007 Location: , , . Posts: 50 Thanks: 0 Thanked 10 Times in 3 Posts	Re: How to transfer a big wordpress blog? 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.

02-10-2009, 10:32 AM	#10
Virtual Banker HyperActive Warrior Join Date: Jan 2009 Location: not San Diego Posts: 100 Thanks: 6 Thanked 8 Times in 7 Posts	Re: How to transfer a big wordpress blog? 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

02-11-2009, 04:56 AM	#12
ecoverdesign Pixelpusher War Room Member Join Date: Jun 2003 Posts: 255 Thanks: 1 Thanked 13 Times in 11 Posts Contact Info	Re: How to transfer a big wordpress blog? 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
	Online eCover Generator - Easily Design All Your Marketing Graphics Right In Your Browser http://www.ecover-go.com