Hello,
When i want to transfer data base from local to server it gives me this error
ERROR 1071 (42000) at line 1236: Specified key was too long; max key length is 767 bytes
Thanks
A quick Google search for that error renders quite a few hits, but ... Localhost copy is what moodle version and what is version of MySQL? Same questions for server end.
How are you attempting transfer ... with the 'experimental tool' in Moodle? or are you taking a mysqldump of the local DB and importing that dump into a DB on the server?
Is the DB server to which you are transferring set for InnoDB ... in particular this setting:
default-storage-engine=InnoDB
Caution there are other InnoDB settings that should be in DB server config so adding just the one line might produce other errors.
'spirit of sharing', Ken