Hi everyone
I need to delete some data from a database, but it's only selected data.
We need to re-enter a selection of orders into our order system because they were done incorrectly.
I have the query which returns the data, and I was planning to just delete all those rows within phpMyAdmin.
I've backed up the data to an Excel file, and taken numerous dumps of the whole table.
But I was wondering if anyone knows of a script or program that can give me an SQL dump of only the result set, not the entire table?
Then if something goes wrong, I can just paste the SQL dump into the SQL window of phpMyAdmin to restore those rows of data.
I use phpMyAdmin and the MySQL Query Browser and neither have the option to export a result set as SQL... only CSV, Excel, PDF report, PLIST etc.
Does anyone know of a PHP script or utility that will let me do this?
I don't have the time to write a PHP script myself.
Thanks
Ben
Export a result set as an SQL dump
Moderator: General Moderators