Thank you for your suggestion. Actually, it is really excellent tool. It can solve my problem. And I have lost one day with it to transfer "clear" data from the current database to new database. The problem is that my forum has over 320.000 threads and 1.4 million posts (the size of my .sql file is 2.5 GB). When I used the import script, it made my server high load and the import process was interrupted several times (some Internal Error messages appeared). When I clicked to Import link again, it resumed the process, but when it finished, there were some failed cases. Importing posts and threads took the most time. I’d not like to wait for one day more with carefully supervision every minute and click Import again whenever the script dies. I have shell access to the server, and I think that PHP script is not a good choice for large database. Is there any way of using shell instead of PHP script?
08-06-2008, 07:14 AM
Threaded Mode