Sample Header Ad - 728x90

MySQL: Reconnect to Existing Database that I lost access to

0 votes
0 answers
91 views
Note I am not a programmer by trade. I have the most annoying problem ever while using MySQL 8.0, and all online resources I've seen provide zero solutions. I have one of those MySQL data directories that contains folder names such as "#innodb_redo", "#innodb_temp", "mysql", "performance_schema", and "sys". It also has a database in it, call it "database1". This data directory is already in existence, and I had been using it for years. Something had happened to to my ability to access database1---the root password would not be accepted anymore, even when I tried to reset it, and I had to re-install all MySQL programs. **Now, I am attempting to reconnect MySQL to my extant database**. I have tried to re-install MySQL/initialize a new server, but that requires an empty data directory and does not help me. I have tried to manually copy/paste my database1 data into the new data directory; I have tried removing replacing all the folders in the new data directory (e.g., all the new "#innodb_temp", "mysql", "performance_schema", and "sys" folders) with my old data directory. I have tried changing the directory altogether. Nothing works. If I replace all the files in the new data directory with my old data directory, the root password no longer works and I have to re-install MySQL again, because the instructions to reset the password do not work. If I just try to copy/paste *only* the database1 folder directly into the new directory, it is not recognized as a database when I log into the server (it doesn't appear when I load Workbench, nor when I call 'show databases'). I can't use mysqldump on my old data because I had lost access to the server already. I can't restore the InnoDB files because I don't know the table structure to all of my tables, and 8.0 doesn't use .frm file types. **Please help me.** I can literally see the files for each table for my database1 (only in .ibd, .myi, and .myd because I'm in MySQL 8.0) as well as all other "old" server information (i.e., "#innodb_temp", "mysql", "performance_schema", and "sys") but I CANNOT ACCESS IT. IT IS SO FRUSTRATING. I have no idea why it is so difficult to access data files that I know exist and I know I have the programs that theoretically can load it. They just refuse to.
Asked by ZZ Top (1 rep)
Feb 2, 2024, 11:34 PM
Last activity: Feb 3, 2024, 10:22 AM