Huge bug in DA!!!

G

Goosemoose

Verified User
Joined
Nov 17, 2005
Messages
8
I moved to a brand new server 2 weeks ago, and while still in the process of getting everything setup the brand new hard drive failed.

Ok, "it's ok", I tell myself as I have DirectAdmin backing up every night to an external hard drive. Of course I haven't tested a restore since I'm still setting everything up, but in the meantime 2 weeks and thousands of posts have been made on my forum. I've gone through over 100 hours of configuring the server.

First I try to get DA to do the restore, but there is no restore under Site Backup! Ok, I see that notated on this forum. I think this definately needs to be notated in DA, as for someone like me, a new DA user, this is a no brainer. If theres a backup, there is a restore.

So I go to restore manually, and discover that the full-mysql.tar.gz DOES NOT BACK UP InnoDB tables!!!!!!!!

How is this possible? Of course having a huge forum with over 400,000 posts I have to use InnoDB tables. Am I totally missing something? PLEASE tell me I am and the tables are hiding somewhere!

I am very very dissapointed in my first experience with DA, I had heard such great things.
 
Any innodb tables just weren't backed up or they were saved as myisam?

Have you emailed DirectAdmin support about this issue?
 
I haven't messaged them yet. Sorry, I thought this was it, I'm a new DA user.


There are frm files for the InnoDB tables but mysql is giving errors like this:

051203 22:48:43 InnoDB error:
Cannot find table admin_goosemoose/rfc_settings from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the corresponding .frm files of InnoDB tables, or you
have moved .frm files to another database?
Look from section 15.1 of http://www.innodb.com/ibman.html
how you can resolve the problem.
051203 22:48:43 [ERROR] /usr/sbin/mysqld: Can't open file: 'rfc_settings.ibd' (errno: 1)
 
Goosemoose said:
I haven't messaged them yet. Sorry, I thought this was it, I'm a new DA user.
Click to expand...

Unofficially, but from time to time some slip through since DA staff doesn't monitor all threads. (Having said this of course, naturally I'm sure they'll catch it).

But you should probably send an email to [email protected]
 
I might have figured it out. I'll update you as soon as I finish testing this out.
 
Figured it out!

I finally figured it out. I couldn't figure out how I had lost data since my backup was still close to the same size as before.

It turns out that the entire database isn't in the database folder /var/lib/mysql/username_databasename when using InnoDB files, but there is a file callee ibdata1 that houses the InnoDB tables. They were backed up but needed to be moved to /var/lib/mysql as the restore wasn't doing that.

Anyways, its take 3 days, but I have everything back up!
 
Did DA support help, or did you find it on your own?

Where were they backed up? In what folder path?

Does DA still have to make a change to a restore routine?

Jeff
 
I figured it out myself. I would see how it could be quite a problem as you'd have to restore all users databases if any of them have InnoDB tables. This would mean if just one user went corrupt you'd still have to restore everyone's to the backup date.
 
Will you let us know where it was backed up?

I want to make sure the sysbk has it backed up.

Thanks.

Jeff
 
You must log in or register to reply here.
Back
Top