Author Topic: 4images_wordmatch table too much data to migrate  (Read 4516 times)

0 Members and 1 Guest are viewing this topic.

Offline johnhorniblow

  • Pre-Newbie
  • Posts: 4
    • View Profile
4images_wordmatch table too much data to migrate
« on: March 14, 2012, 09:50:33 AM »
Hi , I have just had to migrate my 4images website to a new hosting environment . The site has been very active now for six years so it has a lot of data in the database. One table 4images_wordmatch has a lot of data in it 120,000 lines. I am having trouble importing a dump of the table into the new db for the site  because its just too large and I get a timeout.

I have three questions.
How important is the existing word match data? If I start the newly migrated site without the data will it create a problem?
Can I import it in small pieces if export it as a text file then break it into small file sizes?

Thanks
John

Rembrandt

  • Guest
Re: 4images_wordmatch table too much data to migrate
« Reply #1 on: March 14, 2012, 02:04:33 PM »
Hi!

It is not necessary, the two tables "word_match" und "word_list"  to import.
You can the two tables refiled with the ACP / plugins / rebuild_searchindex.php.

mfg Andi

Offline johnhorniblow

  • Pre-Newbie
  • Posts: 4
    • View Profile
Re: 4images_wordmatch table too much data to migrate
« Reply #2 on: March 14, 2012, 07:57:06 PM »
Many thanks Andi for the advice.  :D