4images Forum & Community
Welcome, Guest. Please login or register.
Did you miss your activation email?
September 22, 2014, 02:11:45 PM

Login with username, password and session length
Search:     Advanced search
4images is now on facebook. Click here and become a fan!
Togle to toolbar
Translate this page with =>
Translate this page >
* Home Help Search Login Register
 
+  4images Forum & Community
|-+  4images Issues / Ausgaben
| |-+  Installation, Update & Configuration (Moderators: Acidgod, ivan, Rembrandt)
| | |-+  4images_wordmatch table too much data to migrate
0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Print
Author Topic: 4images_wordmatch table too much data to migrate  (Read 1702 times)
johnhorniblow
Pre-Newbie

Offline Offline

Posts: 4

Thank You
-Given: 1
-Receive: 0


View Profile
« 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
Logged
Rembrandt
Moderator
4images Guru
*****
Offline Offline

Posts: 4056

Thank You
-Given: 105
-Receive: 850

Vienna


View Profile WWW
« 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
Logged

Meine 4Images Modifikationen  Now over 100 Modification Online!    Meine 4images Demo Seite


Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
johnhorniblow
Pre-Newbie

Offline Offline

Posts: 4

Thank You
-Given: 1
-Receive: 0


View Profile
« Reply #2 on: March 14, 2012, 07:57:06 PM »

Many thanks Andi for the advice.  Very Happy
Logged
Pages: [1] Print 
« previous next »
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.124 seconds with 20 queries.