ailed: - MySQL Error: Query was empty
temporary database set up

Failed: - MySQL Error: Query was empty
new character data imported into temporary database

Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
Failed: - MySQL Error: Query was empty
temporary database converted to main database format

starting id cleaning for temp database stage 1 (setting temp database id's to start at 1):

chars done

clans done


items and pets done

temp database id cleaning stage 1 complete

accounts and characters renamed

the following accounts were detected in both databases and the accounts and any characters connected to them will not be imported:


the following characters were detected in both databases and these characters will not be imported:


duplicate accounts and linked characters deleted

starting id cleaning for temp database stage 2 (setting temp database id's to start at maxid from main database + 1):

maxid found

chars done

clans done


items and pets done

temp database id cleaning stage 2 complete

main database table characters field account_name length changed to 45 as a safety check
Failed: insert l2jdb.accounts select * from l2j_temp.accounts; - MySQL Error: Column count doesn't match value count at row 1
Failed: insert l2jdb.character_macroses select * from l2j_temp.character_macroses; - MySQL Error: Table 'l2jdb.character_macroses' doesn't exist
Failed: insert l2jdb.character_quests select * from l2j_temp.character_quests; - MySQL Error: Table 'l2jdb.character_quests' doesn't exist
Failed: insert l2jdb.character_shortcuts select * from l2j_temp.character_shortcuts; - MySQL Error: Column count doesn't match value count at row 1
Failed: insert l2jdb.characters select * from l2j_temp.characters; - MySQL Error: Column count doesn't match value count at row 1
Failed: insert l2jdb.items select * from l2j_temp.items; - MySQL Error: Column count doesn't match value count at row 1
Failed: - MySQL Error: Query was empty

temp database data combined with main database data

starting id cleaning for main database stage 1 (setting main database id's to start at 1):

chars,MySQL Error: Column count doesn't match value count at row 1