![]() |
| ||||||||
|
|||||||
![]() |
|
|
LinkBack | Thread Tools |
|
|
#1 |
|
Active Warrior
Join Date: Jan 2009
Posts: 59
Thanks: 0
Thanked 1 Time in 1 Post
|
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. |
|
|
|
|
|
#2 |
|
SEO Pro
War Room Member
Join Date: Aug 2007
Location: Brazil/USA
Posts: 372
Thanks: 51
Thanked 7 Times in 6 Posts
|
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.
|
|
|
|
|
|
|
|
|
#3 |
|
old username "IMbeginner"
War Room Member
Join Date: Aug 2008
Location: ladson, South Carolina
Posts: 430
Thanks: 3
Thanked 28 Times in 27 Posts
|
the hardest way to do this would be to do it manually.
|
|
Free E-Book Explains How to get TONS of FREE Traffic:
www.supertrafficsurge.com/optin/ |
|
|
|
|
|
|
#4 |
|
HyperActive Warrior
War Room Member
Join Date: Dec 2008
Location: Texas
Posts: 118
Thanks: 17
Thanked 10 Times in 10 Posts
|
try wp-admin->tools->export
and wp-admin->tools->import |
|
Robin
.......I'll get a new avatar when I get a Benjamin every day on the web |
|
|
|
|
|
|
#5 |
|
Active Warrior
Join Date: Jan 2009
Posts: 59
Thanks: 0
Thanked 1 Time in 1 Post
|
|
|
|
|
|
|
#6 |
|
Senior Warrior Member
War Room Member
Join Date: Apr 2006
Location: , , USA.
Posts: 1,762
Thanks: 17
Thanked 43 Times in 42 Posts
|
|
|
|
|
|
|
|
|
|
#7 |
|
Private Label Rights
War Room Member
Join Date: Dec 2008
Posts: 42
Thanks: 4
Thanked 2 Times in 1 Post
|
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 |
|
|
|
|
|
|
|
|
#8 |
|
........................
War Room Member
Join Date: Jun 2007
Posts: 280
Thanks: 15
Thanked 93 Times in 19 Posts
|
check out WSO offer in my sig. My coders will complete the job easy and fast
|
|
Do you still do ad swaps old way? Time to start with Safe-Swaps.com
|
|
|
|
|
|
|
#9 |
|
Active Warrior
Join Date: Aug 2007
Location: , , .
Posts: 50
Thanks: 0
Thanked 10 Times in 3 Posts
|
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.
|
|
|
|
|
|
#10 |
|
HyperActive Warrior
Join Date: Jan 2009
Location: not San Diego
Posts: 99
Thanks: 6
Thanked 9 Times in 8 Posts
|
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 |
|
|
|
|
|
#11 |
|
Active Warrior
Join Date: Jan 2009
Posts: 59
Thanks: 0
Thanked 1 Time in 1 Post
|
|
|
|
|
|
|
#12 |
|
Pixelpusher
War Room Member
Join Date: Jun 2003
Posts: 283
Thanks: 1
Thanked 22 Times in 12 Posts
|
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 |
|
|
|
|
|
|
#13 |
|
Active Warrior
Join Date: Aug 2007
Location: , , .
Posts: 50
Thanks: 0
Thanked 10 Times in 3 Posts
|
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 |
|
|
|
![]() |
|
| Tags |
| big, blog, transfer, wordpress |
| Thread Tools | |
|
|
![]() |