[SOLVED] How to get MySQL Backup with Views?

[amithad]

Hi,

I want to get MySQL backup with views. MySQL server is hosted on Fedora 13 Server. Currently I use ;

mysqldump -u root -pPW dbname > db.dump

command in a shell script to get backups daily. But when I restore the DB in developer (WinXP) pc the views are not restoring

what should I do to get views in the backup?


Thanks

[matonb]

Have you checked to see if the views are in the backup, but not being created on restore?
Exporting (dumping) VIEWs Using mysqldump — mysqlhacker This link is old (200, but discusses issues with views and permissions / host restrictions.

[amithad]

Have you checked to see if the views are in the backup, but not being created on restore?
Exporting (dumping) VIEWs Using mysqldump — mysqlhacker This link is old (200, but discusses issues with views and permissions / host restrictions.

Dear Matonb,

Thanks for your reply ! I tried resoring the MySQL dump using commandline( Instead of MySQL Administrator) then got an error like

MySQL : "The user specified as a definer ('root'@'%') does not exist"

Searched the similar error and apply the command

grant all on *.* to 'root'@'%' identified by 'password' ;

It worked fine all the views are there now

Thanks

[matonb]

You're most welcome ,
can you tag this thread as solved?