4766 Restrictions on Views •Dump files created with  mysqldump  cannot be loaded into servers that enforce the column-length restriction. A workaround for either problem is to modify each problematic view definition to use aliases that provide shorter column names. Then the view replicates properly, and can be dumped and reloaded without causing an error. To modify the definition, drop and create the view again with  DROP VIEW  and  CREATE VIEW , or replace the definition with  CREATE OR REPLACE VIEW . For problems that occur when reloading view definitions in dump files, another workaround is to edit the dump file to modify its  CREATE VIEW  statements. However, this does not change the original view definitions, which may cause problems for subsequent dump operations.