cancel
Showing results for 
Search instead for 
Did you mean: 

Please Help me Restore and config news VPS

Please Help me Restore and config news VPS

I have a database with MySQL 5.6 (Apache), i have used mysqldump and backup it, but when i restore to VPS (used MariaDB 5.5), it show error: ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes.

 

If i have install new Magento, it working with new Database

Please help me

1 REPLY 1

Re: Please Help me Restore and config news VPS

Hello Sir,

 

Kindly change your type in to VARCHAR (250) or TEXT (1000) in ENGINE=MyISAM to [mysqld] default-storage-engine=InnoDB 

 

Thanks

prevaj

 

<< Signature to be setup in profile >>