After MySQL dump and import into new instance, all views now tables.
Posted on 2010-08-12
MySQL newbie here just wondering if this is expected behavior or not.
Essentially needed to create a mirrored instance of an existing MySQL database. Ran a full mysqldump, moved the dump file to the new server and imported everything just via mysql < dumpfile.
Now, according to those working with the data, all views have become regular tables. Is this standard? Is there a way to create the dump file (or a way to import it) to ensure that this doesn't happen?
Thanks in advance, SQL wizards!