EQEmulator Forums - ITEMS import from database from a couple years ago

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - ITEMS import from database from a couple years ago (https://www.eqemulator.org/forums/showthread.php?t=41433)

ITEMS import from database from a couple years ago

I have a database from a couple years ago that I ONLY want to import some items from that old one into the new database. I've found that there are just a few changes to the ITEMS part since then, mainly it has to do with a sixth augment slot being added. However, this is a LOT of work (280+ fields for each item) to redo.

I'm curious if there's a way to import the old items into the new database without manually entering the items all over again. I thought about creating a test database and just going in and manually creating the new fields, then dumping that into an sql file, then running the sql file on the new database with the new fields added, but is that the easiest way to do that?

OK so I tried just importing the old database into a localhost server, then adding the aug slot fields, and the herosforgemodel field, with the right formats, and added the default entries for them as 0, then dumped the modified database with the items in it to an SQL file, then tried to run the SQL file on the new database and it gives me this error even though I know both databases have the same number of fields:

Code:

1136 - Column count doesn't match value count at row 1

This is the query I ran on the database to try to insert just one record to see if it would work:

Code:

INSERT INTO `items` VALUES ('132476', '0', 'Ancient Journal', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '1', '0', '1', '0', '1', '0', null, '0', '0', '0', '2', '6', '13', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '65535', '4278190080', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '-1', '0', '0', '0', '0', '0', '0', '777', 'IT10645', '1', '11', '2', '0', '0', '0', 'Mmmmm AAs', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '131071', '0', '0', '0', '0', '1', '0', '2', '-1', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '20', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2014-02-23 10:48:12', '', '0', '0', '0', '0', '1', '0', '0', '', '0', '-1', '0', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '0', '0', null, '2012-05-13 04:01:53', null, '13THFLOOR', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '-1', '0', '0', '00000000000000000000', '0', '', '-1', '0', '0', '0', '0', '', '-1', '0', '0', '0', '0', '0', '', '-1', '0', '0', '0', '0', '0', '', '-1', '0', '0', '0', '0', '0', '', '-1', '0', '0', '0', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2004-03-14 15:42:51', '0', '70', '0', '0', '0', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '', '-1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

...And I figured it out. When I renamed the numbers to higher numbers, I misplaced a ' and a , here and there. Fixed.