dumping views

[Alex Shannon]

We backup, via mysqldump, our database called "tectonics" and copy to a backup server in another building.
If a developer requires up-to-date data to "play" with (and a way of regularly testing the backups), the backup is loaded back, but the database is given a different name - "tectonics_aps" in my case.
All was well until we started using Views - when they dump, they have 'tectonics' prefixed to the View name. When we load back, it tries to CREATE these views in the original 'tectonics' database, and aborts the import with a "table already exists" type error.

Before I mess around with sed trying to strip the `tectonics`. from the backup file, does anyone know how to either suppress views from being dumped altogether (not very desirable solution) or get mysqldump to remove references to the database (desirable solution).

Thanks
Alex