database structure script

Is there an easy way to create SQL script from existing database and use it to create a new database? Tks Pax - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

newbie: Upgrading MySQL

Hi I am newbie to mySQL and Linux in general. I installed Suse 7.3 with mySQL and I would like to update it to the latest version. My questions are: - should I uninstall the previous version? And if so, how? - are there any instruction of compiling it from source? Thanks Pax