[webp]

I installed iMacros FireFox addon and did a simple loop to click stop and start every 5 minutes. I could have use Python to do this job but simple 3 line Macro is easiest. Now it’s been running over 12 hours with over 30K users imported.

[webp]

Adding the wait_timeout above doubled the run time to maybe 6 minutes, but still hangs after ~ 6 minutes.

Per stackoverflow.com/questions/18253934/set-maximum-execution-time-in-mysql-php , adding the following to to the beginning of converter.php did not help:

ini_set('max_execution_time', 0);

Ah…

[webp]

Found the solution.
In /etc/mysql/my.cnf (/root/my2.cnf for me since it’s my second temp mysql instance for me), I changed wait_timeout from 600 to:

wait_timeout = 600000000000000

I found I read somewhere else in this forum that says the same, but I couldn’t find it again.
Please refer to: MySQL wait_timeout and WordPress

• wait_timeout is the time mysql will hold a non-interactive connection open for before closing it basically.
• It’s the number of seconds of inactivity on a single connection mysql will wait for before terminating a connection. For instance you may make a connection 1 second into script execution then go away and do 40 seconds of work in php and when you go back to use your connection again, mysql has killed it.

[webp]

After removing almost half of the Drupal 6 spam and blocked uses, I still have over 250K users to import to WP/bbPress.

I run a prior test import for the topics, and it seemed to run fine. But importing users one at a time hangs after every ~one hundred users. I have to manually click stop and start at the Converter Admin page every few minutes. If I can’t find other solutions, I might want to install a Browser addon to click stop and start for me every 3 minutes when I’m away. Otherwise, I’m at 2500 users now and I still have 247K users to go! It won’t finish for weeks.

Suggestions? Thanks.

[webp]

FYI: In contrary to above, bbPress can import from remote database. But must use Hostname:Port in the converter admin, instead of hostname and port in separate input form fields.

I’m able to use a remote MySql server as import source.
Details please see a minor bug or enhancement that I just created:
BBpress import from remote database hostname:port config

[webp]

FYI: In contrary to above, bbPress can import from remote database. But must use Hostname:Port in the converter admin, instead of hostname and port in separate input form fields.

I’m able to use a remote MySql server as import source.
Details please see a minor bug or enhancement that I just created:
BBpress import from remote database hostname:port config