cancel
Showing results for 
Search instead for 
Did you mean: 

Please Help me Restore and config news VPS

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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 >>