I have never used it and it is an old tool, but it may still work for you. Try the migrating tool for moving NPCs from one database to another. Here is the thread and the working file download should be listed on GeorgeS site in the last reply.
http://www.eqemulator.net/forums/showthread.php?t=21441
Make SURE you backup your database before trying this tool. If you use navicat, you can right click on your database and select Dump SQL. That will put everything in a file that you can source later if you need to restore it.
Also, you can highlight all of your tables and press CTRL+C and then make a secondary database named "Backup" and highlight the table there and press CTRL+V. That will copy all of your tables, but not your blob files and maybe some others.
Using the copy and paste method may take a few times before it actually does the copy and paste. I don't know why that is. But the nice thing about doing it that way is you can easily delete a table in your running database and copy the backup back to it to restore anything you changed in those tables.
I keep multiple backups of my tables from different times. That way, if I make any mistake or a copy gets messed up, I ALWAYS have an extra backup. And if all else fails, I can just source the dump. Sourcing is the last resort for me, as it takes about 15 hours or so to fully source the whole thing with all character blobs and everything.
If you had been backing up your database like this regularly, you wouldn't be in the current predicament you are in. Hind-sight is 20/20, and hopefully you learned a good lesson from this. It definitely could have been MUCH worse!
Hybrid Mode
