Hi,
I have a db with some tables:
users (main table), orders, auth, ecc. (related tables).
This morning one user, and all related records, has been deleted.
On a test computer I've restored a backup and fortunately the user deleted is present on backup.
May I restore only this user and all the related records from backup?
I can't restore the whole database because of new data entry.
Thanks

Remigio

remigio wrote:
Create a copy of the user data into a empty using INSERT ... SELECT ...
statements, then make a mysqldump of the database which just have the user
related data with --no-create-db, then you can import that mysqldump to your
live database, just before you execute it, just check that you didn't include
drop database option.


--

//Aho