Import database MySQL File-Per-Table Tablespaces to Same Server

Is necessary copy a database within a single server. Was chosen way to “File-Per-Table Tablespaces to Another Server” as it is the fastest for large databases.

The official documentation states that the database name must be the same on the source server and the destination server.

What if the source server and the destination server – this is one and the same server?

Is there any way in order to be able to copy the database files from one database to another within a server quickly.

Or somehow a way to get “File-Per-Table Tablespaces to Another Server” to ignore the name of the database?

Info server: OS: MS Windows Server 2008
MySQL Server: MySQL 5.5 or MariaDB
Tables Type: InnoDB (if MariaDB - InnoDB plugin)


Source: mysql

Leave a Reply