I want to get MySQL backup with views. MySQL server is hosted on Fedora 13 Server. Currently I use ;
command in a shell script to get backups daily. But when I restore the DB in developer (WinXP) pc the views are not restoring :(Quote:
mysqldump -u root -pPW dbname > db.dump
what should I do to get views in the backup?