backup/restore a complete database in MySQL 5.0

[mgpsivan]

Hi,
How can we backup or restore a database with all its tables,procedur es,views,trigge rs etc., when i tried using mysqldump command i'm able to backup the tables and procedures alone.But restoring it is still a ? Can any one help me with this problem. Please let me know the way to backup and restore the complete database.


Thanks
Sivan.G

[ronverdonk]

Just read the standard MySQL documentation on this subject and all will be clear.
mysqldump - a database backup program

Ronald

[mgpsivan]

Hi Ronald,
i've already read that documentation but to include VIEWs to the Backup is not being mentioned. The Backup just contains Tables,Procedur es,Triggers alone.Can u tel how to include Views also along with the Procedures,Trig gers and Tables.

Thanks
Sivan.G