Failed: - 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
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.new_accounts select * from l2j_temp.accounts; - MySQL Error: Table 'l2jdb.new_accounts' doesn't exist
Failed: insert l2jdb.new_character_macroses select * from l2j_temp.character_macroses; - MySQL Error: Table 'l2jdb.new_character_macroses' doesn't exist
Failed: insert l2jdb.new_character_quests select * from l2j_temp.character_quests; - MySQL Error: Table 'l2jdb.new_character_quests' doesn't exist
Failed: insert l2jdb.new_character_recipebook select * from l2j_temp.character_recipebook; - MySQL Error: Table 'l2jdb.new_character_recipebook' doesn't exist
Failed: insert l2jdb.new_character_shortcuts select * from l2j_temp.character_shortcuts; - MySQL Error: Table 'l2jdb.new_character_shortcuts' doesn't exist
Failed: insert l2jdb.new_character_skills select * from l2j_temp.character_skills; - MySQL Error: Table 'l2jdb.new_character_skills' doesn't exist
Failed: insert l2jdb.new_characters select * from l2j_temp.characters; - MySQL Error: Table 'l2jdb.new_characters' doesn't exist
Failed: insert l2jdb.new_clan_data select * from l2j_temp.clan_data; - MySQL Error: Table 'l2jdb.new_clan_data' doesn't exist
Failed: insert l2jdb.new_items select * from l2j_temp.items; - MySQL Error: Table 'l2jdb.new_items' doesn't exist
Failed: insert l2jdb.new_pets select * from l2j_temp.pets; - MySQL Error: Table 'l2jdb.new_pets' doesn't exist
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