Thanx Qatqat, I moved the files into /the/directory and then did mysql > restore table my_table from '/the/directory'; and that worked.
I think the problem was I had not unpacked the .frm .MYD and .MYI files properly from the tarball.
Solved.
I RTFM the MySQL Manual and tried this:
mysql> restore table my_table from '/path/to/backup/directory';
and i got this:
+------------------+---------+----------+--------------------------+
| Table | Op | Msg_type | Msg_text |...
I would like to rebuild a MySQL table from binary files.
I have the binary files for my_table in the files my_table.frm, my_table.MYD and my_table.MYI.
I would like to generate an SQL statement to export the data.
I created my_db on my local machine and then created the table my_table. This...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.