problem with backup :-(

[Aizatullov]

Hello, All.
I use SUSE 10.0 and plesk 8.2
One of my sites has been corrupted. And i use backup system from the Plesk interface. After deployment backup, i has seen message:

Failed deployment of database client (domain domain)

Unable to execute the following command:
Unpack MIME part.
The probable reason is: Runtime error during 'db': (1, '', 'ERROR 1071 (42000) at line 1042: Specified key was too long; max key length is 1000 bytes\n')

And now site does not work (((((
Is there any solution?????

 

[ACID25]

Hi

i think this comes from different mysql versions.....but i have not really a solution for that....check google about max key length

reagards
ACID25

 

[Aizatullov]

can i in anyway open backup file, and manual edit some rows to fix this trouble ???

 

[ACID25]

you can do it on the old server....export database on your computer and edit the db.sql file f.e. with an editor of your choice...
go to new server and import the fixed db...

 

[Aizatullov]

But i have only one server ! I do not migrate? i am attempt restore backup, after crash site ! And i have not dump of db? i have only backup on plesk format ....

 

[Aizatullov]

The problem is solved.
I am, unzip file and cut by sed from totalbackup sql dump and restore him.