4images Forum & Community

4images Issues / Ausgaben => Installation, Update & Configuration => Topic started by: johnhorniblow on March 14, 2012, 09:50:33 AM

Title: 4images_wordmatch table too much data to migrate
Post by: johnhorniblow 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

Title: Re: 4images_wordmatch table too much data to migrate
Post by: Rembrandt 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

Title: Re: 4images_wordmatch table too much data to migrate
Post by: johnhorniblow on March 14, 2012, 07:57:06 PM

Many thanks Andi for the advice.  :D