Moving to lower database version

[Get-Gaming]

I've moved to a new host but its only support mysql 5.5 and i used to be on 5.6. So i cannot import my database as it gives errors about full text not being supported.

[Get-Gaming]

Unable to import the vtc dump:
ERROR 1214 (HY000) at line 3138: The used table type doesn't support FULLTEXT indexes
Traceback (most recent call last):
File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module>
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 100, in main
restore(options, password)
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 89, in restore
raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode)
Exception: program 'mysql' finished with non-zero exit code: 1

 

[RevengeFNF]

You are using innodb, and only 5.6 and up support fulltext for it. 

You are in a shared host or vps/server? 

[Get-Gaming]

Moved to a new vps. But plesk installs only mysql 5.5 and not 5.6 

Tried doing it manually already but that became a disaster and i had to set back a backup which also made our teamspeak server go down to much unhappiness of the community.

oh its centos 7

[RevengeFNF]

If you use Plesk, not too much i can do to help you. I install everything manually.

If you want to format your server and install everything, you can send me a pm and i can give you guidance's and help.

[HCICT]

Don't know of this helps.

But; install navicat(maybe you can do it with the trail version), add the two databases, Transfer data/structure.

For me this always works. 

[Get-Gaming]

navicat runs into problems as well. 

[Nathan Explosion]

8 hours ago, Fabby said:

But plesk installs only mysql 5.5 and not 5.6

If you have server access, steps to upgrade (followed them a few weeks back):

https://kb.plesk.com/en/127962

[RevengeFNF]

If you still have your old server, convert the innodb tables to myisam and you will then be able to restore into mysql 5.5

[Get-Gaming]

I managed to get 5.6 to work finnaly but now i'm getting this.

 

Fatal error: Uncaught ErrorException: mysqli::real_escape_string(): Couldn't fetch IPS\Db in /home/tourom1q/public_html/system/Db/Db.php:1964 Stack trace: #0 [internal function]: IPS\IPS::errorHandler(2, 'mysqli::real_es...', '/home/tourom1q/...', 1964, Array) #1 /home/tourom1q/public_html/system/Db/Db.php(1964): mysqli->real_escape_string('cacheKeys') #2 /home/tourom1q/public_html/system/Data/Store/Database.php(89): IPS\_Db->in('store_key', Array) #3 /home/tourom1q/public_html/system/Data/Store/Database.php(105): IPS\Data\Store\_Database->loadIntoMemory(Array) #4 /home/tourom1q/public_html/system/Data/Store/Database.php(152): IPS\Data\Store\_Database->get('settings') #5 /home/tourom1q/public_html/system/Data/AbstractData.php(121): IPS\Data\Store\_Database->exists('settings') #6 /home/tourom1q/public_html/system/Data/Store.php(188): IPS\Data\_AbstractData->__isset('settings') #7 /home/tourom1q/public_html/system/Settings/Settings.php(133): IPS\Data\_Store->__isset('settings') #8 /home/tourom1q/public_html/system/Settings/ in /home/tourom1q/public_html/system/Db/Db.php on line 1964