Vanishing characters after windows format?

[Bigolenoobert]

Started a new thread for an entirely different question. so i just redid/reformatted my operating system. and the level 2 tutorial character i made vanished. now there arent any made characters on the character list. How do i prevent them from vanishing when ever i have to reinstall windows again?>

[Shendare]

Characters are stored in your mysql/mariadb database, with various aspects of them spread across several tables. If characters disappear when you reinstall Windows, then you most likely didn't fully back up your eqemu database and restore it after the reinstallation.

[Bigolenoobert]

hello thanks for the prompt reply! can you walk me through backing it all up real quick?

[Shendare]

Huh. It looks like Akka's repack comes with a pre-made backup script for that. Nice, Akka.

Look for "t_backup_server_database" under:

C:\EQ - AKKA'S PEQ REPACK\EQEMU SERVER\

Running that (I assume you can run it with a simple double-click from Explorer) looks like it should make a backup of your database in the Backups folder inside there.

[Kingly_Krab]

In Navicat you can do this: http://prntscr.com/8gskx3

In HeidiSQL you can do this: http://prntscr.com/8gsl7g

Edit: Shendare posted as I did, but Akkadius also has an auto-backup, but this is a manual way of doing the exact same thing.

[Shendare]

Ooh, now we know Kingly_Krab's database schemas. HACK ATTACK!

[Bigolenoobert]

when i try to open the t_backup_server_database as in the akka repack. it quickly says error occurred...exiting. then vanishes. it wont stay open long enough to read any of it except that. what do i do to fix that?

[Shendare]

Well, easiest way is to do it the HeidiSQL way, since Akka's Repack installs that as well. Find the HeidiSQL icon in your start menu / screen (it's green and yellow) and open it. Log in with the credentials in the <database> section of your eqemu_config.xml. Right-click the database containing your eqemu tables, and choose "Export database as SQL" as shown in Kingly_Krab's screenshot.

It should default to Create Database, Create Tables, Export All Tables, Structure + Data, and Single .sql file.

Tell it where you want the backup .sql file to go (it might even have a default set for that) and start it up. Takes a minute or two. You can .zip the resulting .sql file to save disk space if you need, since it's just a huge text file.

Don't try to open it in Notepad. Hahaha.

[Bigolenoobert]

Okay i will try that and let you know how it goes. thanks alot guys. good to have people to help out big ole nooberts like me.

[Bigolenoobert]

Missing DB Update 9073 '2015_01_31_character_item_recast.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_31_character_item_recast.sql)
o Saved: (db_update/2015_01_31_character_item_recast.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9072 '2015_01_30_merc_attack_delay.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_30_merc_attack_delay.sql)
o Saved: (db_update/2015_01_30_merc_attack_delay.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9071 '2015_01_29_merc_stats_table_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_29_merc_stats_table_update.sql)
o Saved: (db_update/2015_01_29_merc_stats_table_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9070 '2015_01_28_quest_debug_log_category.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_28_quest_debug_log_category.sql)
o Saved: (db_update/2015_01_28_quest_debug_log_category.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9069 '2015_01_25_logsys_Mercenaries_category.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_25_logsys_Mercenaries_category.sql)
o Saved: (db_update/2015_01_25_logsys_Mercenaries_category.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9068 '2015_01_15_logsys_categories_table.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_15_logsys_categories_table.sql)
o Saved: (db_update/2015_01_15_logsys_categories_table.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9067 '2015_01_21_npc_types_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2015_01_21_npc_types_update.sql)
o Saved: (db_update/2015_01_21_npc_types_update.sql)
The filename, directory name, or volume label syntax is incorrect.
DB up to date with: 9066 - '2014_12_31_npc_types_default_values_update.sql'
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9065 '2014_12_26_merc_weaponinfo_table_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_12_26_merc_weaponinfo_table_update.sql)
o Saved: (db_update/2014_12_26_merc_weaponinfo_table_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9064 '2014_12_24_npc_types_table_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_12_24_npc_types_table_update.sql)
o Saved: (db_update/2014_12_24_npc_types_table_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9063 '2014_12_24_npc_types_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_12_24_npc_types_update.sql)
o Saved: (db_update/2014_12_24_npc_types_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9062 '2014_12_15_multiple_table_updates.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_12_15_multiple_table_updates.sql)
o Saved: (db_update/2014_12_15_multiple_table_updates.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9061 '2014_12_13_inventory_table_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_12_13_inventory_table_update.sql)
o Saved: (db_update/2014_12_13_inventory_table_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9060 '2014_12_09_items_table_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_12_09_items_table_update.sql)
o Saved: (db_update/2014_12_09_items_table_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9059 '2014_12_01_mercs_table_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_12_01_mercs_table_update.sql)
o Saved: (db_update/2014_12_01_mercs_table_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9058 '2014_11_26_InventoryTableUpdate.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_11_26_InventoryTableUpdate.sql)
o Saved: (db_update/2014_11_26_InventoryTableUpdate.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9057 '2014_11_13_spells_new_updates.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_11_13_spells_new_updates.sql)
o Saved: (db_update/2014_11_13_spells_new_updates.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9056 '2014_11_08_RaidMembers.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_11_08_RaidMembers.sql)
o Saved: (db_update/2014_11_08_RaidMembers.sql)
The filename, directory name, or volume label syntax is incorrect.
DB up to date with: 9055 - '2014_10_30_special_abilities_null.sql'
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9054 '2014_10_19_raid_group_mentor.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_10_19_raid_group_mentor.sql)
o Saved: (db_update/2014_10_19_raid_group_mentor.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9053 '2014_10_18_group_mentor.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_10_18_group_mentor.sql)
o Saved: (db_update/2014_10_18_group_mentor.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9052 '2014_10_13_RaidLeadership.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_10_13_RaidLeadership.sql)
o Saved: (db_update/2014_10_13_RaidLeadership.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9051 '2014_10_11_RaidMOTD.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_10_11_RaidMOTD.sql)
o Saved: (db_update/2014_10_11_RaidMOTD.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9050 '2014_09_20_ban_messages.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_09_20_ban_messages.sql)
o Saved: (db_update/2014_09_20_ban_messages.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9048 '2014_09_09_attack_delay.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_09_09_attack_delay.sql)
o Saved: (db_update/2014_09_09_attack_delay.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9046 '2014_08_23_player_events_and_player_aa_rate_hourl y.sql'

o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_08_23_player_events_and_player_aa_rate_hourly .sql)
o Saved: (db_update/2014_08_23_player_events_and_player_aa_rate_hourly .sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9045 '2014_08_23_Complete_QueryServ_Table_Structures.sq l'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_08_23_Complete_QueryServ_Table_Structures.sql )
o Saved: (db_update/2014_08_23_Complete_QueryServ_Table_Structures.sql )
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9044 '2014_08_20_merchantlist_probability.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_08_20_merchantlist_probability.sql)
o Saved: (db_update/2014_08_20_merchantlist_probability.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9043 '2014_08_18_spells_new_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_08_18_spells_new_update.sql)
o Saved: (db_update/2014_08_18_spells_new_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9042 '2014_08_12_NPC_raid_targets.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_08_12_NPC_raid_targets.sql)
o Saved: (db_update/2014_08_12_NPC_raid_targets.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9041 '2014_08_02_spells_new.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_08_02_spells_new.sql)
o Saved: (db_update/2014_08_02_spells_new.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9040 '2014_07_10_npc_spells.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_07_10_npc_spells.sql)
o Saved: (db_update/2014_07_10_npc_spells.sql)
The filename, directory name, or volume label syntax is incorrect.
DB up to date with: 9036 - '2014_05_04_SlowMitigationFix.sql'
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9035 '2014_04_27_AISpellEffects.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_04_27_AISpellEffects.sql)
o Saved: (db_update/2014_04_27_AISpellEffects.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9034 '2014_04_25_spawn_events.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_04_25_spawn_events.sql)
o Saved: (db_update/2014_04_25_spawn_events.sql)
The filename, directory name, or volume label syntax is incorrect.
DB up to date with: 9032 - '2014_04_12_SlowMitigation.sql'
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9031 '2014_04_10_No_Target_With_Hotkey.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_04_10_No_Target_With_Hotkey.sql)
o Saved: (db_update/2014_04_10_No_Target_With_Hotkey.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9030 '2014_04_04_PhysicalResist.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_04_04_PhysicalResist.sql)
o Saved: (db_update/2014_04_04_PhysicalResist.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9028 '2014_02_26_roambox_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_02_26_roambox_update.sql)
o Saved: (db_update/2014_02_26_roambox_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9027 '2014_02_20_buff_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_02_20_buff_update.sql)
o Saved: (db_update/2014_02_20_buff_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9026 '2014_02_13_spells_new_update.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_02_13_spells_new_update.sql)
o Saved: (db_update/2014_02_13_spells_new_update.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9025 '2014_02_13_Rename_instance_lockout_tables.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_02_13_Rename_instance_lockout_tables.sql)
o Saved: (db_update/2014_02_13_Rename_instance_lockout_tables.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9022 '2014_01_20_Weather.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_01_20_Weather.sql)
o Saved: (db_update/2014_01_20_Weather.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9020 '2014_01_20_Not_Extendable.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_01_20_Not_Extendable.sql)
o Saved: (db_update/2014_01_20_Not_Extendable.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9018 '2014_01_09_PreservePetSize.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_01_09_PreservePetSize.sql)
o Saved: (db_update/2014_01_09_PreservePetSize.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9017 '2014_01_08_SpellsNewAdditions.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2014_01_08_SpellsNewAdditions.sql)
o Saved: (db_update/2014_01_08_SpellsNewAdditions.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9015 '2013_12_26_MerchantList_Class_Required.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_12_26_MerchantList_Class_Required.sql)
o Saved: (db_update/2013_12_26_MerchantList_Class_Required.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9014 '2013_11_18_AssistRadius.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_11_18_AssistRadius.sql)
o Saved: (db_update/2013_11_18_AssistRadius.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9012 '2013_11_07_BaseData.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_11_07_BaseData.sql)
o Saved: (db_update/2013_11_07_BaseData.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9011 '2013_10_31_Recipe_disabling.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_10_31_Recipe_disabling.sql)
o Saved: (db_update/2013_10_31_Recipe_disabling.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9009 '2013_10_12_Merc_Special_Abilities.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_10_12_Merc_Special_Abilities.sql)
o Saved: (db_update/2013_10_12_Merc_Special_Abilities.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9008 '2013_07_11_NPC_Special_Abilities.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_07_11_NPC_Special_Abilities.sql)
o Saved: (db_update/2013_07_11_NPC_Special_Abilities.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9007 '2013_05_05_Item_Tick.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_05_05_Item_Tick.sql)
o Saved: (db_update/2013_05_05_Item_Tick.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9006 '2013_05_05_Account_Flags.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_05_05_Account_Flags.sql)
o Saved: (db_update/2013_05_05_Account_Flags.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9005 '2013_04_08_Salvage.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_04_08_Salvage.sql)
o Saved: (db_update/2013_04_08_Salvage.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9002 '2013_03_1_Merc_Rules_and_Equipment.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_03_1_Merc_Rules_and_Equipment.sql)
o Saved: (db_update/2013_03_1_Merc_Rules_and_Equipment.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9001 '2013_02_25_Impr_HT_LT.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_02_25_Impr_HT_LT.sql)
o Saved: (db_update/2013_02_25_Impr_HT_LT.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 9000 '2013_02_18_Merc_Rules_and_Tables.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/git/req
uired/2013_02_18_Merc_Rules_and_Tables.sql)
o Saved: (db_update/2013_02_18_Merc_Rules_and_Tables.sql)
The filename, directory name, or volume label syntax is incorrect.
Missing DB Update 8000 'mercs.sql'
o URL: (https://raw.githubusercontent.com/EQ...ls/sql/svn/mer
cs.sql)
o Saved: (db_update/mercs.sql)

EQEmu Update Utility Menu:
1) Backup Database - (Saves to Backups folder)
2) Backup Database Compressed - (Saves to Backups folder)
3) Run pending REQUIRED updates... (65)
4) AAs - Download Latest AA's from PEQ (This overwrites existing data)
5) OPCodes - Download latest opcodes
6) Maps - Download latest map and water files
7) Plugins - Download latest Perl plugins
8) Quests - Download latest PEQ quests and stage updates
9) LUA Modules - Download latest LUA Modules (Required for Lua)
20) Force update this script (Redownload)
0) Exit

Enter numbered option and press enter...

>Trying to download latest updates. by pressing 3. all of the errors above show. The filename, directory name, or volume label syntax is incorrect. im confused what can i do about this?

[Uleat]

The on-screen dialog is self-explanatory - but, selecting #3, then #3 again, will give you a straight-through update.

That quote is from the setup guide..which you may have missed using the repack.

3) Run pending REQUIRED updates... (65)

The menu is telling you that you need to press '3' again to apply the updates.

[Bigolenoobert]

i dont think its giving me a straight through update though. it never says applying updates.

The filename, directory name, or volume label syntax is incorrect.
On every update it tries to do. i do the 3. and then 3 again as said. something is very wrong i think .. : ( maybe something got corrupt or something?

[Bigolenoobert]

reason i was trying to update is because. when i go into the game. start the tutorial at mines of gloomingdeep. every character i make. ends up in a spot on the map they're not suppose to right when i zone in. and get stuck. and its all glitchy. if the updates are okay. then how do i fix zoning in to a stuck character everytime?

[Uleat]

Keep an ear out..I haven't run across this particular situation before.


EDIT: On the Mines issue..I think there is a post about that.


As far as the update menu, if your db is up-to-date, you shouldn't be getting the menu..only a quick blip in the console window
saying that updates are being checked.

If you're getting the menu and it's saying you need to update..then it doesn't let you..that is odd...


EDIT2: What client did you say you are using?

[Uleat]

Try the last solution in this thread and report the results back, si vous plais

http://www.eqemulator.org/forums/sho...s+gloomingdeep