In Dev, I have a table called “products” which has the latest set of data.
In Prod, I have the same table, with the same structure, but old data.
What is the easiest way to get my new data from my laptop into production?
(I know how to use mysqldump to backup my entire database, but I don’t understand how to get the latest data from Dev to Production without disturbing everything else.)
Export/import is probably the most accurate way to go, if nothing else.
However, as you requested, you shouldn’t have to export/import the entire database for just one table. So, if you’re using Workbench, then there should be a table import/export option that would be optimal for what you seek.