How to make it table 'db1.table1' does exist in engine
Posted: 07. November 2021 10:18(1) This morning mysql which is in (G:) xampp210105 was not working.
(2) I tried to make it work, but failed
(3) I installed XAMPP which I dowonloaded Jan, 05. 2021.
(4) it was still not working.
(5) I restore C: of window using a window restore program.
(6) I installed XAMPP which I dowonloaded Jan, 05. 2021.
Now it is at (G:) xampp211107 and it works fine.
(7) If I open phpMyadmin, it has 5 databases.
They are information_schema, mysql, performance_schema, phpmyadmin, and test.
Now I have to add a database named oldDB1.
I used the oldDB1 from Jan, 05, 2021 to yesterday.
It is in (G:) xampp210105/mysql/data/oldDB1
I have to migrate the oldDB1 from (G:) xampp210105/mysql/data/oldDB1 to (G:) xampp211107/mysql/data/oldDB1
Oh, my god!!! I didn't make oldDB1.sql.
Inside the (G:) xampp210105/mysql/data/oldDB1, it has db.opt, myTable1. frm, myTable1.ibd.
(8) I copy oldDB1 from (G:) xampp210105/mysql/data/and past it to (G:) xampp211107/mysql/data/.
Now I have (G:) xampp211107/mysql/data/oldDB1, it has db.opt, myTable1. frm, and myTable1.ibd.
(9) I open phpMyadmin, I can see oldDB1 which is added.
(10) when I click the plus button which is on the left of "oldDB1", it shows myTable1.
I was so happy when I saw it for the first time.
However when I click "myTable1" of oldDB1, It says the following
How can I make it table 'db1.table1' does exist in engine?
How can I make it work fine?
am 8:37:23 [mysql] Error: MySQL shutdown unexpectedly.
am 8:37:23 [mysql] This may be due to a blocked port, missing dependencies,
am 8:37:23 [mysql] improper privileges, a crash, or a shutdown by another method.
am 8:37:23 [mysql] Press the Logs button to view error logs and check
am 8:37:23 [mysql] the Windows Event Viewer for more clues
am 8:37:23 [mysql] If you need more help, copy and post this
am 8:37:23 [mysql] entire log window on the forums
(2) I tried to make it work, but failed
(3) I installed XAMPP which I dowonloaded Jan, 05. 2021.
(4) it was still not working.
(5) I restore C: of window using a window restore program.
(6) I installed XAMPP which I dowonloaded Jan, 05. 2021.
Now it is at (G:) xampp211107 and it works fine.
(7) If I open phpMyadmin, it has 5 databases.
They are information_schema, mysql, performance_schema, phpmyadmin, and test.
Now I have to add a database named oldDB1.
I used the oldDB1 from Jan, 05, 2021 to yesterday.
It is in (G:) xampp210105/mysql/data/oldDB1
I have to migrate the oldDB1 from (G:) xampp210105/mysql/data/oldDB1 to (G:) xampp211107/mysql/data/oldDB1
Oh, my god!!! I didn't make oldDB1.sql.
Inside the (G:) xampp210105/mysql/data/oldDB1, it has db.opt, myTable1. frm, myTable1.ibd.
(8) I copy oldDB1 from (G:) xampp210105/mysql/data/and past it to (G:) xampp211107/mysql/data/.
Now I have (G:) xampp211107/mysql/data/oldDB1, it has db.opt, myTable1. frm, and myTable1.ibd.
(9) I open phpMyadmin, I can see oldDB1 which is added.
(10) when I click the plus button which is on the left of "oldDB1", it shows myTable1.
I was so happy when I saw it for the first time.
However when I click "myTable1" of oldDB1, It says the following
#1932 - Table 'oldDB1.myTable1' doesn't exist in engine
How can I make it table 'db1.table1' does exist in engine?
How can I make it work fine?