Bogus

[Theeper]

It looks like the profile blobs in your character_ table are empty.

[AndMetal]

Originally Posted by Theeper

It looks like the profile blobs in your character_ table are empty.

I concur. The profile blob contains exactly 19568 characters according to the source code, which matches what the error is throwing. In addition, it says the length is 0, so it seems like there's just absolutely nothing there.

How did you backup the DB? To a .sql file?

[classiceq]

I have verified they are in fact empty. Due to the nature of the blob is there a way to fix it or am I out of luck? I tried a couple different utilities to access the blob. Namely Kayotro's sql editor. If I opened the account it would show the characters associated with the account followed by errors as you would expect.

The database was backed up to a .sql file.

Thanks.

- Razzle

[cavedude]

I'm sorry that their learning process resulted in the destruction of your database. If they're stilling willing to learn (and you're still willing to let them, hehe) I'd recommend creating a new username for them under Windows, and restricting their db access to their own work, keeping yours safe.

On to the matter at hand. How exactly did you backup your database? mysqldump or one of those gui programs? mysqldump is the most secure way to go, and will dump all data, including the nasty BLOB stuff. A full dump is easily done at a traditional command prompt using:

mysqldump -u username -p --extended-insert dbname > dbname.sql

That'll dump the whole database to your current dir. The username/password is optional and may not be required, but i do recommend the extended-insert, as it makes the sourcing process much faster.

As for getting your data back. Are the blobs in character_backup intact? If so, you're in luck. If not, then I'm afraid your toons are lost for good, unless you have another backup lying around.

[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.