Updating a SIngle Table

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.)


I’m not that familiar with MySQL, but there should be a way to export just one table.

I think there is… here. (Assuming one is using Workbench.)



So exporting and importing is the way to go?

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.



this looks like a good idea:

You can use a “INSERT INTO…” query but, it doesn’t matter how you do it, you’re still exporting and importing

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.