#3684 Tables and Views disappear

[Anonymous]

Originally created by: jonat...@fenj.nl

What exact steps will reproduce the problem?
1. Export database with tables and views
2. Import that database to another server with an other user which only has rights to one database
3. As you will see, after import the database tables and views are gone. When you connect to this database with for example SQLYog, you still see this tables.

Suggested fix
I guess this has something to do with the definer during export, since it will be exported as another user.
When retrieving database information on the new database, I see this:

SHOW TABLE STATUS FROM `new_db`;
/* SQL Fout (1143): SELECT command denied to user ''@'localhost' for column 'id' in table 'example_table' */
SHOW FUNCTION STATUS WHERE `Db`='new_db';

Version used?
HeidiSQL revision: 9.1.0.4903
MySQL Server version: MySQL 5.5.36 (CentOS)
Operating system: Windows 7 x64