yavuz
Well-known member
I recently decited to change my hosting provider. Three websites that are running on the server use XenForo which databases are very large avarage 500 MB. I tried cPanel's moving script, backup restore tool, command line (ssh) even third party scripts like bigdump but at a certain point the vps server gets overwhelmed and gives me an internal server error. I've tried increasing the maximum execution time, memory but it doesn't seems to help.
Now I'm using a script called "mysqldumper" in which I'm getting similar errors at one point when it starts to import the search_index table. Is it safe to maybe empty this table and later re-run the search index?
My VPS server specs: 4 GB Ram, 100 GB Space and below:
Total processors: 2
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Core(TM) i7 CPU 930 @ 2.80GHz
Speed
2833.803 MHz
Cache
8192 KB
Processor #2
Vendor
GenuineIntel
Name
Intel(R) Core(TM) i7 CPU 930 @ 2.80GHz
Speed
2833.803 MHz
Cache
8192 KB
Now I'm using a script called "mysqldumper" in which I'm getting similar errors at one point when it starts to import the search_index table. Is it safe to maybe empty this table and later re-run the search index?
My VPS server specs: 4 GB Ram, 100 GB Space and below:
Total processors: 2
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Core(TM) i7 CPU 930 @ 2.80GHz
Speed
2833.803 MHz
Cache
8192 KB
Processor #2
Vendor
GenuineIntel
Name
Intel(R) Core(TM) i7 CPU 930 @ 2.80GHz
Speed
2833.803 MHz
Cache
8192 KB