Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: man oh man. migrating to local site headaches.
Els wrote:
I’ve had this once before when trying to import a Slimstat database, one table in there was huge… the txp_log table can be rather large as well.
In the import screen in my phpMyAdmin I see something likeMaximum size: 2.048KB. Could it be that your sql file is too large?
the site that was easy to import was 1.5 megs. my problem site is 4-5 megs depending on which sql i use. one came from the RSS DB plugin
Offline
#17 2008-07-02 19:48:34
- els
- Moderator
- From: The Netherlands
- Registered: 2004-06-06
- Posts: 7,458
Re: man oh man. migrating to local site headaches.
Hmm… the 2,048KB I mentioned is my local install. Most hosts indicate 50 or 60MB, so 4-5 could hardly be a problem I’d think.
Have you tried exporting and importing the tables one by one (so each table is a separate file)?
Offline
Re: man oh man. migrating to local site headaches.
Els wrote:
Hmm… the 2,048KB I mentioned is my local install. Most hosts indicate 50 or 60MB, so 4-5 could hardly be a problem I’d think.
Have you tried exporting and importing the tables one by one (so each table is a separate file)?
my localhost phpmyadmin says: Max: 16,384 KiB
so i tried Gzipping which brought the 5meg database down to like 700kb
tried the import and got one of my usual style errors:
Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\libraries\import\sql.php on line 129
i guess it’s time to try the one-by-one advice you gave which sounds similar to when i got my wisdom teeth pulled. ;)
Last edited by mrtunes (2008-07-02 21:02:46)
Offline
Re: man oh man. migrating to local site headaches.
it turns out that the Log table was the culprit. i didn’t realize how large the log can get, and i’m sure it slows down site performance a lot. so i deleted all 8 pages of logs(100/page), turned logging off. exported my sql file and it imported into localhost fine now :)
i spent a lot of time on this so i’m glad it’s resolved now. but what i’m confused about is my other site that i transferred the sql successfully before, had 300 less logs
Offline