I have one database file content. I need to import this file into the new database. I moved the old database in /var/lib/mysql folder. But showing only database name. please, anyone, help me
Asked
Active
Viewed 224 times
0
-
Possible duplicate of [How to recover MySQL database from .myd, .myi, .frm files](https://stackoverflow.com/questions/879176/how-to-recover-mysql-database-from-myd-myi-frm-files) – ChristophS Jun 19 '18 at 11:37
-
I tried But I can't export the database. While exporting the database it showing No tables found in the database. – favasaman Jun 19 '18 at 12:56
-
I guess you use mysql because of folder name. Do you still have access to the original database? If yes, use `mysqldump databasename > db.sql` to export from old database, and `mysql databasename < db.sql` to import to new one. Search the internet to find a couple of examples. – ChristophS Jun 19 '18 at 13:05