Debian DokuWiki

You can use any of the following command to determine table type.

SHOW TABLE STATUS WHERE Name = 'table_name';
OR
SHOW CREATE TABLE 'table_name';
OR
SHOW TABLE STATUS;

cat slaves | while read i ; do echo $i; mysql -h$i -e "SHOW SLAVE STATUS \G" | grep "Relay_Master_Log_File"; done

This issue is appeared due to the default character set.
As Both version of database diff. character set. To get rid of that character try to following steps.

  1. insert following line to your my.cnf
     set-variable=character-set-server=UTF8
  2. re-import database should fix the issue.

By default mysqldump only store triggers not procedures/functions.

In order to include to your mysqldump there is switch
-R, –routines Dump stored routines (functions and procedures).

In order to include triggers to your mysqldump there is switch
–triggers Dump triggers for each dumped table

mysqldump -R -u <username> -p<password> <database>

Use following line in your my.cnf will resolve the issue. as latin1 is default character set in 4.0 and 4.1 has utf8

| my.cnf

 set-variable=character-set-server=latin1