Bogus

[classiceq]

After finishing with Administative Punishment....I built him something on a seperate machine to learn on.

Unfortunately from the sounds of it I am a day to late. I used a gui program to back up the data.

Oddly enough it is the only thing I use it for. Not sure why actually. Everything else is done via command line.

I checked all my backups doing a few test restores along the way and none of them have any data in the blob.

Lesson learned.

Thanks for the info guys. I appreciate you taking the time to help out.

- Razzle

[cavedude]

Well, it's not a total loss you still have your inventories intact. Items are the real pain to restore, imho. What I'd do in your case is mark down the current IDs of all your toons and then wipe the character_ table. Then, re-create the toons in-game. Go back to the db, and change the toon's IDs so they match their old values. The next time you log in, all of your items will be there as you left them. From there, you just need to use GM commands to get your level, AAs, skills, and spell scrolls back. If you have a small private server, that won't be too bad. After you're done, immediately make a backup with mysqldump and check to make sure that the BLOBs are intact in it.

[classiceq]

Thanks CD. That is exactly what I started doing. It is tedious but will serve its purpose.

From the looks of it I have about 60 toons to create maybe less. I will only create those that have logged in for the past 30 days.

Should make for a interesting weekend. Can't ride because of the rain so I might as well make it an EQEMU weekend.

- Razzle

[AndMetal]

I'm not sure if this will actually work, but you might want to try inserting data without any values into the blobs (all binary 0's). I would imagine the easiest way to do this would be the following:

UPDATE character_ SET profile = RPAD('',19568,CHAR(0)) WHERE LENGTH(profile) != 19568

To clarify, that's 2 apostrophies inside the RPAD. This should create a blob 19568 characters long with all zeroed information wherever the blob isn't the appropriate length. However, I'm not sure if the server will be able to do anything with it, other than maybe inserting the character name, because it is stored in the name field also.

[classiceq]

One problem I did find is the race information is stored in the blob. With out that info I can't do a mass creation of toons.

I will try to insert the data into the blob and see what happens.

- Razzle

[classiceq]

I used the sql command to modify the blob and it completes without error but doesn't make any changes that I can see. The blob is still empty.

- Razzle

[AndMetal]

Even though it doesn't show anything, there should still be information there (the ASCII character 0 is NULL). This is the easiest way to make sure:

SELECT LENGTH(profile) FROM character

If you want to, you can also add a WHERE or LIMIT clause to limit the results to specific records (good for a larger database), but it should return a length of 19568. If not, it might require adding some info to the first few bytes of data (the checksum field):

UPDATE character_ SET profile = RPAD('ABCD',19568,CHAR(0)) WHERE LENGTH(profile) != 19568

To be honest though, I think the better way to do it would be either to do what cavedude recommended & recreate the characters, etc. However, you could also just inject the known info (race, diety, etc) using other SQL commands.

Either way, good luck with the project

[nosfentora]

I just used Navicat 8 to dump the character_ table to an .sql file.
upon importing with mysql, and with navicat i am getting the same error:

'ERROR 1054 (42S22): Unknown column '0x0A04E78E4E6F7366656E746F72000000000000000000000000000000000000' in 'field list'

Any thoughts?

Also - what is the purpose of the character_backup table? i was able to import that table back into the db without a problem.
is there a way to re-load the character info to the character_ table from character_backup?