|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
07-12-2017, 03:19 PM
|
Hill Giant
|
|
Join Date: Feb 2008
Posts: 188
|
|
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?
|
07-12-2017, 04:47 PM
|
Hill Giant
|
|
Join Date: Feb 2008
Posts: 188
|
|
Edited database
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
|
|
|
|
07-12-2017, 04:54 PM
|
Hill Giant
|
|
Join Date: Feb 2008
Posts: 188
|
|
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');
|
|
|
|
07-12-2017, 06:41 PM
|
Hill Giant
|
|
Join Date: Feb 2008
Posts: 188
|
|
...And I figured it out. When I renamed the numbers to higher numbers, I misplaced a ' and a , here and there. Fixed.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 09:10 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|