Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
[SOLVED] tranfer a large textpattern table
I am migrating to TXD. All went fine except in the neme.org site. The first issue I am trying to resolve is how to transfer a large textpattern table at 21.3Mbs. When I gzip it the table stops at 7.8Mbs and leaves some of the content out. On bziping it makes the file 2.9Mbs but I get the following error in phpMyadmin: “You attempted to load file with unsupported compression (application/bzip2). Either support for it is not implemented or disabled by your configuration.”
Any suggestion that an idiot like me could implement would be appreciated.
Last edited by colak (2012-12-03 15:53:05)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [SOLVED] tranfer a large textpattern table
Hi Yiannis
Is the phpmyadmin destination support zip? if yes try to zip your table!
have you a shell access to your new domaine?
Offline
Re: [SOLVED] tranfer a large textpattern table
I have no idea re shell access. Zip creates a file which stops at 7.8Mbs:(
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#4 2012-12-03 15:22:30
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,315
Re: [SOLVED] tranfer a large textpattern table
Yiannis, in phpmyadmin you can export chunks of the textpattern table when you select it the table in the left hand frame first. After clicking the Export tab, then there’s the following line in the main frame:
Dump [_n_] row(s) starting at record # [_n_]
Hope that helps.
Last edited by uli (2012-12-03 15:48:47)
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
Re: [SOLVED] tranfer a large textpattern table
That might/should do the trick. Thanks uli
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [SOLVED] tranfer a large textpattern table
solved… thanks uli
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#7 2012-12-03 22:07:09
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,315
Re: [SOLVED] tranfer a large textpattern table
Great! You’re welcome! I never had to use that but it seemed like a simple, viable, solution. And the timeframe you finished it in would witness that. Mentally bookmarked ;)
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline