Hello, I have an old wordpress database, before I had a chance to do a data dump, I lost it due to an operation error, but I still have the old structure of the database backed up. The old woedpress database is called wp_db, so I dug it out from this directory. /usr/local/mysql-5.7.24-macos10.14-x86_64/data, (I use a Mac.) In this data folder, it contains all databases include wp_db, it has ib_logfile0, ib_logfile1 and ibdata1, if I understand it correctly, the ibdata1 contains most of the old data, is it possible to reconstruct the wp_db base on these items? If so, how? Thanks.
Lookup how to recover Innodb tables from ibdata1. I'll just say, in general it's difficult and the process is different in every instance. You can try percona's tool: https://launchpad.net/percona-data-recovery-tool-for-innodb Sometimes all it takes is putting the server in a forced recovery mode and starting it.
You can also try to install the same MySQL server version on your machine and replace the default `data` directory with the one from your backup. Then you can back up the database using the standard mysqldump tool.