So I have a 100gb mysql database dump. I need to extract a few tables from it so I can import them into an alternate database. At the moment, I have tried importing it into a temporary mysql instance but it fails when trying to import a particular table, saying it doesn't exist. I am not aware of any issues with the database, so the major discrepancy I can think of is the mysql version I am importing to is different to the mysql version running on the primary database (that the dump was taken from). Has anyone heard of a discrepancy like this presenting such symptoms? Could it also be a sign of some database corruption?
I still need the tables so I was considering making some manual changes to the file but vim really struggles when editing a 100gb text file. I was then thinking of just grepping for "CREATE TABLE 'X'", but if the table creation and import process occurs over more than one line, the output of my grep is not going to have all the data.
I suppose I will need to try finding a copy of the exact same mysql version to install and install it from source (i guess it would be possible), to rule out the issue, but then again it's only a stab in the dark. I am still quite perplexed as to how a working database can be dumped and whilst trying to be imported, notes a table doesn't exist. Any advice appreciated.