I always keep a backup of my database running in another database name, so I can just use Navicat to copy lines from the backup and paste them into the database that the server uses. Navicat Lite doesn't have a copy/paste setting, but you can use CTRL+C and CTRL+V to copy and paste just fine. Normally, when pasting a whole line from another table, I will just go to the end of the current table I am wanting to paste into and hit the down arrow 1 time so that it starts a new line and then CTRL+V to paste it. That way, you don't have to worry about accidentally over-writing other lines there. Make sure you select the first column on the left before pasting so the paste lines up properly though.
Since you probably don't have a backup database running yet, you can just create a new one and name it something like "peq_backup" and then source the PEQ files into that one just like you did with your current database. Then, you can copy any of those fields that you want.
|