vBulletin import help
Hi, I am trying to import from vBulletin 4.2.2 to BBpress The forum is pretty big with Data of 2.4 GB.
Every time I start the import it gets stuck at 45458th record of topics with when it is executing this statement (I saw the number of records from WP Admin in under Topics section)
SELECT convert(thread.threadid USING “utf8mb4”) AS threadid,convert(thread.forumid USING “utf8mb4”) AS forumid,convert(thread.replycount USING “utf8mb4”) AS replycount,convert(thread.postuserid USING “utf8mb4”) AS postuserid,convert(post.ipaddress USING “utf8mb4”) AS ipaddress,convert(thread.title USING “utf8mb4”) AS title,convert(post.pagetext USING “utf8mb4”) AS pagetext,convert(thread.open USING “utf8mb4”) AS open,convert(thread.sticky USING “utf8mb4”) AS sticky,convert(thread.dateline USING “utf8mb4”) AS dateline,convert(thread.lastpost USING “utf8mb4”) AS lastpost FROM thread AS thread INNER JOIN post AS post USING (threadid) WHERE post.parentid = 0 LIMIT 45300, 100
I followed this but it stops again at every ~50 records.
But When I run this query in the PhpMyAdmin i get proper results of 100 records. I have tried to sanitize all the data that looked suspicious to me. Can someone please guide me to identify this offending data. What should I watch out for ?
I have setup my BBpress on it on my local server which sits on a RAMDisk of 10GB (Makes I/O, hence import process lighting fast). Is this an issue ?
Or are there any logs that I can inspect to see what error occurred ?
- You must be logged in to reply to this topic.