list of unresolved tables

[mvd1987]

i got this mgs when rebuiling the server via dspserver updater.

when i look what it is it says

sql/char_inventory.sql contains userdata, requires manual back up.

and 3 more of this/

how do i do this manually?? dont wanna lose the data cause my friends datas are in it to for testing my server for it goes online

maybe a dom thing to ask but just dont wanna lose the data and this is the first time this happend to me

already thanx michael

[diatanato]

create dump and try this

Code: Select all

ALTER TABLE `char_inventory` ADD `locked` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `quantity`;
ALTER TABLE `char_inventory` ADD `col` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER `locked`;
ALTER TABLE `char_inventory` ADD `row` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER `col`;
ALTER TABLE `char_inventory` ADD `level` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER `row`;
ALTER TABLE `char_inventory` ADD `rotation` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER `level`;
ALTER TABLE `char_inventory` CHANGE `location` `location` tinyint(1) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `char_inventory` CHANGE `slot` `slot` tinyint(2) unsigned NOT NULL DEFAULT '0';
ALTER TABLE `char_inventory` CHANGE `itemId` `itemId` smallint(5) unsigned NOT NULL DEFAULT '65535';

UPDATE `char_inventory`, `char_furnishings` SET
`char_inventory`.`locked` = `char_furnishings`.`locked`,
`char_inventory`.`col` = `char_furnishings`.`col`,
`char_inventory`.`row` = `char_furnishings`.`row`,
`char_inventory`.`level` = `char_furnishings`.`level`,
`char_inventory`.`rotation` = `char_furnishings`.`rotation`
WHERE `char_inventory`.`charid` = `char_furnishings`.`charid` AND `char_inventory`.`location` = 1 AND `char_inventory`.`slot` = `char_furnishings`.`slot`;

DROP TABLE IF EXISTS `char_furnishings`;

DROP TABLE IF EXISTS `char_profile`;
CREATE TABLE IF NOT EXISTS `char_profile` (
`charid` int(10) unsigned NOT NULL,
`rank_points` int(10) unsigned NOT NULL DEFAULT '0',
`rank_sandoria` tinyint(2) unsigned NOT NULL DEFAULT '1',
`rank_bastok` tinyint(2) unsigned NOT NULL DEFAULT '1',
`rank_windurst` tinyint(2) unsigned NOT NULL DEFAULT '1',
`fame_sandoria` smallint(5) unsigned NOT NULL DEFAULT '0',
`fame_bastok` smallint(5) unsigned NOT NULL DEFAULT '0',
`fame_windurst` smallint(5) unsigned NOT NULL DEFAULT '0',
`fame_norg` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`charid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `char_profile`
(`charid`,`rank_points`,`rank_sandoria`,`rank_bastok`,`rank_windurst`,`fame_sandoria`,`fame_bastok`,`fame_windurst`,`fame_norg`) 
SELECT 
`chars`.`charid`,
`chars`.`rankPoints`,
`chars`.`rankSandoria`,
`chars`.`rankBastok`,
`chars`.`rankWindurst`,
`chars`.`fameSandoria`,
`chars`.`fameBastok`,
`chars`.`fameWindurst`,
`chars`.`fameNorg` 
FROM
`chars`;

ALTER TABLE `chars` DROP `rankPoints`;
ALTER TABLE `chars` DROP `rankSandoria`;
ALTER TABLE `chars` DROP `rankBastok`;
ALTER TABLE `chars` DROP `rankWindurst`;
ALTER TABLE `chars` DROP `fameSandoria`;
ALTER TABLE `chars` DROP `fameBastok`;
ALTER TABLE `chars` DROP `fameWindurst`;
ALTER TABLE `chars` DROP `fameNorg`;

DROP TABLE IF EXISTS `char_storage`;
CREATE TABLE IF NOT EXISTS `char_storage` (
`charid` int(10) unsigned NOT NULL,
`inventory` tinyint(2) unsigned NOT NULL DEFAULT '30',
`safe` tinyint(2) unsigned NOT NULL DEFAULT '50',
`locker` tinyint(2) unsigned NOT NULL DEFAULT '0',
`satchel` tinyint(2) unsigned NOT NULL DEFAULT '30',
`sack` tinyint(2) unsigned NOT NULL DEFAULT '30',
PRIMARY KEY (`charid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `char_storage`
(`charid`,`inventory`,`safe`,`locker`,`satchel`,`sack`) 
SELECT 
`chars`.`charid`,
`chars`.`inventory`,
`chars`.`safe`,
`chars`.`locker`,
`chars`.`satchel`,
`chars`.`sack`
FROM
`chars`;

ALTER TABLE `chars` DROP `inventory`;
ALTER TABLE `chars` DROP `safe`;
ALTER TABLE `chars` DROP `locker`;
ALTER TABLE `chars` DROP `satchel`;
ALTER TABLE `chars` DROP `sack`;

ALTER TABLE `chars` ADD `playtime` int(10) unsigned NOT NULL DEFAULT '0' AFTER `zones`;

ALTER TABLE `char_stats` CHANGE `hp` `hp` smallint(4) unsigned NOT NULL DEFAULT '50';
ALTER TABLE `char_stats` CHANGE `mp` `mp` smallint(4) unsigned NOT NULL DEFAULT '50';

[mvd1987]

can some one tell me how to do this exacly step by step cause i dont wanna lose all the data of the characters on my server cause its almost ready and some friends are already in the data.

do i do this on navicat? and just select dump on all the tables? or only the char tables?

and how do i do them back when i updated the server??

hope some one can help me.

greetings michael



and the nex rev gives the same thing unresolved tables sql/chars.sql contains userdata requires manual back up.


what do i do when i get this when i update?? its always the tables with the info of the accounts and char??

or isnt this a problem??
cause i couldnt get on it the last time this happend.

the main thing is how do i update without losing all my account and character data??

thanx already

[mvd1987]

i already had to delete all the tables in navicat and i am now setting the server back up empty

can some one please tell me how to keep all the account and character data and how to put it back after a update.
and do i need to delete all the tables after a update on dspserver updater says that it cant change some files cause there is user data.
do i then need to back up the data and put it back after updating??

hope some one can tell me how to do it step by step

thanx already

[whasf]

create dump and try this

Code: Select all

<snip>

Thank you, you saved me from having to write that!

[mvd1987]

can some one please help with problem i have on how to save all account and character data of all the members on my server.
i already lost everything now but dont want to lose everything again(cause i wanna go public and then this will be a disaster)
so how do i save al the data and where do i put it and how and when do i put it back??

its not in the guide on how to save all the account and character date and then update and then put all the account data and character data back in the table.

can some one please tell me step by step on how to do this cause i already lost the data on the server and dont want this to happen again.


already thanx michael

[Metalfiiish]

You would need to dump all sql files from the database that pertain to characters (in navicat, highlight all the tables right click and hit dump). Then you would need to pretty much have a strong understanding of SQL commands to have it convert your old tables into the new format. Or you can hope that when someone breaks it that they release the commands to convert it for you like Dia did in this post.

I personally just wipe completely after a sql table format breaks.

[whasf]

That script worked for getting me up to rev1964