Can anyone recommend their procedure for archiving historical tables such as “sqlt_data_1_2011_01” for example? I can do mysqldump to file without issue, its removing the tables that I am concerned about. I am unable to open the current db in MySQL workbench to do a reverse engineer due to number of objects. On test databases I can see how current month is connected, and all other tables seem to be just archived.
So I would like to know how others are handling the archiving of their database. Ideally I want to just backup the individual table and remove it entirely. Should the entire table be removed or just the data within and keep the table and structure?