Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2008-01-10 22:33:34

alannie
Member
From: Minnesota, USA
Registered: 2005-09-15
Posts: 150

phpMyAdmin import issues

I know this isn’t a phpmyadmin forum but I’m hoping some of you might have run into this issue. I’m trying to import a SQL database export from one TXP installation into another. When I click “import” in phpMyAdmin (and I’ve done this successfully countless times before), it chugs away a few minutes before eventually giving me a blank page where phpMyAdmin’s main content usually is. The phpMyAdmin sidebar and header are still there. I’ve tried re-exporting the data as both zip and plain SQL, to no avail.

Here is my setup info:

phpMyAdmin 2.11.3
PHP version: 5.2.4
GD Image Library: version bundled (2.0.34 compatible), supported formats: GIF, JPG, PNG
MySQL: 5.0.45-log
Locale: en_US.UTF-8
Server: Apache/2.2.4
Apache version: Apache/2.2.4
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: FreeBSD 6.2-RELEASE-p1

Any ideas??

Offline

#2 2008-01-10 22:48:39

alannie
Member
From: Minnesota, USA
Registered: 2005-09-15
Posts: 150

Re: phpMyAdmin import issues

I figured it out … the txp_log table was so bloated that phpMyAdmin was choking on it. When I re-exported everything without that table, it imported without a hitch.

Offline

Board footer

Powered by FluxBB