how to detach and attach mysql database

We cannot make the database detach and attach in Mysql.

Solution:

1. You can 'dump' a database from one and import it into the other.

2. We cannot make the offline database but Move the database file across the data folder.