Database cleaner

astonerii · #1 01-12-2004, 02:24 PM

I was wondering if there were any tools/programs that I could use to remove duplicate entries from a .sql file?

I ask because there seems to be alot of different databases, and I would like to be able to put them all into one file, and then have another program clean them, by removing duplicated entries.

Shawn319 · #2 01-12-2004, 02:59 PM

notepad.exe

[/joke]

i wish.

astonerii · #3 01-12-2004, 03:22 PM

I have tried to use MS EXCEL but it has a 65536 limit... and many of the parts have well over 100000.

farce · #4 01-12-2004, 05:04 PM

personally i'd use perl or sed or some such tool, and change all of the INSERT INTO's into REPLACE INTO's..

that way it wont complain about duplicate keys... it'll just replace what's using that key with the last one..

cat foo.sql | sed -e 's/INSERT INTO/REPLACE INTO/' > out.sql

would do it nicely.

Lurker_005 · #5 01-12-2004, 07:50 PM

There isn't an easy way that does not involve lots of manual labor.

About the closest I have seen anyone come with a automated way was http://www.eqemulator.net/forums/vie...c&start=34 But that is a very basic way, and you have to already have the sql data merged without overwriting each other.