symlink an innodb table to another one in the same server

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

Lascia un commento

Il tuo indirizzo email non sarà pubblicato.