Unlike MyIsam tables, the Innodb ones cannot be symlinked by the file manager.
You can instead use this code:
CREATE SQL SECURITY DEFINER VIEW targetdatabase.tablename AS SELECT
*
FROM
sourcedatabase.tablename
a thoughtful use of digital
Unlike MyIsam tables, the Innodb ones cannot be symlinked by the file manager.
You can instead use this code:
CREATE SQL SECURITY DEFINER VIEW targetdatabase.tablename AS SELECT
*
FROM
sourcedatabase.tablename