How to make it table 'db1.table1' does exist in engine

Und alles was mit phpMyAdmin seine Verwandtschaft findet hat hier seinen Platz.

How to make it table 'db1.table1' does exist in engine

Postby dotKer » 07. November 2021 10:18

(1) This morning mysql which is in (G:) xampp210105 was not working.
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?
dotKer
 
Posts: 40
Joined: 09. November 2020 13:28
XAMPP version: 7.4.11
Operating System: windows

Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 28 guests