[1.6] Importing from Serendipity hangs

[seraphyn]

Used the CVS and I've one showstopper in the import-function import from serendipity admin interface.

fromhttp://board.s9y.org/viewtopic.php?f=6& ... p=10425207
Put the DB-data after installation from the other s9y-Installation in and pressed import.
This runs over an hour with 100% on the dbms.
Have had a restart of the dbms to stop the use of 100% cpu.
Refreshed the import-gui and stand next to the login-page again.
Looks like an timeout for me.
But all entries are well imported.
Comments are not all well, template shows 3 comments, but only 2 are shown.

1.6 clean install in another subdomain.
Apache2 Version: 2.2.16-6+squeeze1
PHP5 Version: 5.3.3-7+squeeze1
DBMS: mysql Version: 5.1.49-3
btw Version 1.5.5 import to 1.6

Hi!

How large is your install, i.e. the sql dump? Can you open a new thread for this so we can work it out.

Regards,
Garvin

Files: 95MB (96780)
SQL:
42 tables
Entries at all 1,111,144
size of over all 169,3 MiB
Machine is a 2.4GHZ p4 with 1GB RAM.
Footprint debian without running services 17MB RAM.
With all services 278MB RAM used. (nfs, ushare, cups, apache2, mysql, tinytinyrss with cron update every 4 hours, backup only in the early morning)
MySQL got 128MB RAM in key_buffer. <--- the only change
Is php.ini needed too?

Looks like a timeout for my session or something else.
It is possible for me to delete the db in the dbms reinstall it the same way...

Greetings Chris

[garvinhicking]

Hi!

Hm, 163MB of data to copy inside a single PHP script might take some time. Are you running PHP as CGI or mod_php? You might need to change php.ini to allow max_execution_time for i.e. 10 Minutes, and then retry the import.

I'm also quite sure this is a server timeout issue; on the s9y side it's hard to do something about it...

Regards,
Garvin

[seraphyn]

Running as mod.
I think I need to change the max_input_time too?
Was just a minute.
So I'll raise up the max_input_time and the max_execution_time to ae 30 minutes and restest again.
I'll send feedback later this day.

Chris

EDIT:
Possibility to run this with php-cli to have a verbose output. that I could control in this case?

[garvinhicking]

Hi!

You can't easily run it in php-cli due to authentication requiring a cookie etc.

You could edit the importer file and use echo/logging/fwrite for every performed SQL query and some breakpoints...

HTH,
Garvin

[seraphyn]

Try my best.
DBMS aren't normally my world, but still ready to learn
Chris