Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2006, 09:54 PM
Arex
Hill Giant
 
Join Date: Jul 2004
Posts: 196
Default what is the fast way of to restore a character?

what is the fast way of to restore a char of character_backup to character_ table? is there any tool that help with it?

Thank You!
Reply With Quote
  #2  
Old 05-22-2006, 02:43 PM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

examine the GMCommands guide for the proper use of the #charbackup command.
__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
Reply With Quote
  #3  
Old 05-22-2006, 07:04 PM
Arex
Hill Giant
 
Join Date: Jul 2004
Posts: 196
Default

Thank You Rangerdown, i only was thinking that it would be hard restore a backup because i didnt have a profile field in character_backup table.
Reply With Quote
  #4  
Old 05-23-2006, 02:21 PM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

that table had a profile field the last time I checked. Did something change with 7.0?
__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
Reply With Quote
  #5  
Old 05-23-2006, 07:14 PM
Arex
Hill Giant
 
Join Date: Jul 2004
Posts: 196
Default

You have 2 profiles on character_ table, ext_profile and profile, and u only have one profile field on character_backup table, then i dont know why one of 2 profiles arent backup on character_backup table...

i have checked the code on character_backup command, i think that with the actual code if a guy have deleted to his char accidentally, he cant restore his character of backup using this command...
Reply With Quote
  #6  
Old 06-16-2006, 12:28 PM
fireclav
Sarnak
 
Join Date: Jun 2006
Location: nowhere
Posts: 56
Default

i just tried the restore command it says char is restored but still doesnt show on my char screen. i had deleted him a bit ago and wanted to get him back is there any other way of doing this. he shows up in the char_backup in mysql but i cant get it to move it to character file
Reply With Quote
  #7  
Old 06-16-2006, 12:30 PM
mattmeck
Guest
 
Posts: n/a
Default

Did you hand delete out of the DB?

Or

Did you use the delete button on the character select?

If you just hit the delete button the character is still in the main character DB, just need to add you account number back into the proper field.
Reply With Quote
  #8  
Old 06-05-2007, 12:58 PM
oghog
Sarnak
 
Join Date: May 2007
Posts: 42
Default

Anyone ever figure out an easy way to restore a deleted character once its gone out of the main table???...It seems as though the #charbackup doesnt work.
Reply With Quote
  #9  
Old 06-05-2007, 01:05 PM
Darkonig
Hill Giant
 
Join Date: Dec 2006
Posts: 102
Default

The only way you could possibly restore a character to a database from which you deleted it would be if you had a backup of the database from before you deleted it. Such a backup does not get created automatically.
Reply With Quote
  #10  
Old 06-06-2007, 03:02 AM
oghog
Sarnak
 
Join Date: May 2007
Posts: 42
Default

Thanks for the reply. Maybe one of you SQL guru's could figure out how to get the #charbackup functions....I lost my oobah chanter hehe.

Seriously though, that would be a great function for the server admins if it worked properly..


Thanks again, Im sure I'll have more questions...
Reply With Quote
  #11  
Old 06-06-2007, 03:21 AM
Darkonig
Hill Giant
 
Join Date: Dec 2006
Posts: 102
Default

If all else fails and you have the GM status, you could always create a new character by the same name and just assign him the level and stats your old character had and summon him the gear.
Reply With Quote
  #12  
Old 06-06-2007, 08:27 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

Are you sure the #charbackup restore [backup#] isn't working? You have to list them first, find the backup you want to restore and use the #. I haven't run this in a while, but I thought i was working before.

Check out commands.cpp in the source to see the flow. "void command_charbackup". SQL appears to be ok.
Reply With Quote
  #13  
Old 06-06-2007, 09:09 AM
oghog
Sarnak
 
Join Date: May 2007
Posts: 42
Default

tested it with my chanter.
my 9 year old deleted him

ran the following commands

#charbackup list 13

it gave me the backup numbers there were 2. One from Sunday night and one from Monday night.

then i ran :

#charbackup restore *** (not sure what the number is as im at work)

Got reply "Character Restored"

No change in the character table, no change on login screen.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:34 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3