Mysql – How to restore thesql database

backupdatabasemysqlrestore

I have taken the backup of mysql database but when I am trying to restore it my stored procedures are not getting restored. Is there any way like for backup we use –routines in mysqldump command.
Can we do any such thing in mysql.

If I am using mysqldump then it is just dumping mysql tables but if I am using mysql command to restore then it is giving me an error –
ERROR 1064 (42000) at line 3062: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 6.

Thanks in advance

Best Solution

you are restoring 5.1 backup to 5.0 instance. you will have to remove 'USING BTREE' from your table definitions, if you want to load this dump into 5.0.