When developing I create a backup before I start work on a database and then work on this copy.
The developing can go on for several days trying out various ideas and making copies as I go while at the same time the original continues to be worked addind data over the time of the development.
Once I have a working solution I want to import data from the live database so that it can then become the new live database.
Is it possible to import the data from the live database as a job lot from all the tables rather than have to go to each table and perform the import one at a time.
If there is a script out there that would do this I would be interesting in reading it here and for it to be fully documented showing where my tables would go in the script.
Looking forward to your replies.