How screwed am I?

[Pope Viper]

Then I swear, by Crom, I'm getting away from MS. This is bolsh.

 

[Edrondol]

Does your host have backups? You may have only lost the last X hours if you can have them pull a restore.

 

[Pope Viper]

Unfortunately, the host (me), has corrupted backups, which is why I'm frantic.

 

[Edrondol]

So everyone you host is currently boned? Ouch, double ouch, triple ouch.

 

[Mike Edge]

Still killing me.

Would it be possible for one of you guys to take my various databases, and do SQL dumps of them?

Sure hit me up via PM and I'll set you up an account to upload them

 

[Pope Viper]

Mike - if you can save me, I'd be forever in your debt.

@Ed - Fortunately, everything I'm hosting is for myself.

 

[digitalpoint]

Still killing me.

Would it be possible for one of you guys to take my various databases, and do SQL dumps of them?

If it was a Linux machine, I could... but I know nothing about Windows servers (is that helpful? hah)

 

[CTXMedia]

I feel your pain Pope - hope you get it all back <crosses fingers> ...

 

[Mike Edge]

If it was a Linux machine, I could... but I know nothing about Windows servers (is that helpful? hah)

Oh is this not doable @digitalpoint ? I figured I could just create a database in phpmyadmin and move the .MYI files to it?

 

[digitalpoint]

Well, first of all XenForo uses InnoDB by default, which doesn't HAVE .MYI (or .MYD) files.

 

[Mike Edge]

Well, first of all XenForo uses InnoDB by default, which doesn't HAVE .MYI (or .MYD) files.

Well there is..

xf_search_index.frm
xf_search_index.MYD
xf_search_index.MYI

but yeah, I was just giving an example of extension on what i thought I could try to do for him.

 

[digitalpoint]

Search index is MyISAM because InnoDB doesn't support fulltext search... by default all the "important" tables are InnoDB.

 

[Mike Edge]

Search index is MyISAM because InnoDB doesn't support fulltext search... by default all the "important" tables are InnoDB.

I know.. I'm just busting your chops

 

[Lee]

Mike - if you can save me, I'd be forever in your debt.

@Ed - Fortunately, everything I'm hosting is for myself.

Did you get sorted?

 

[Pope Viper]

Not as yet, I've uploaded my DBs to Mike's FTP server, and since my connection was the way it is, it took a while.

 

[Mike Edge]

@Mike Any suggestions? After taking his data directory and moving the files into a created database it is only showing MyISAM tables.

Trying to dump the database also errors of tables not found.

mysqldump -R -q jaysql_xf1 | gzip -q -9 - > xf1.sql.gz

Error: Couldn't read status information for table archived_import_log ()
mysqldump: Couldn't execute 'show create table `archived_import_log`': Table 'jaysql_forum.archived_import_log' doesn't exist (1146)
root@nitro #

 

[estranged]

Innodb databases are not stored in data directories unless innodb_file_per_table is enabled in my.cnf

All innodb databases are stored in one file called "ibdata1" in /var/lib/mysql /

Path and filename may change depending on the panel. I'm not sure. This is for cpanel.

 

[Pope Viper]

I'm screwed.

 

[Lee]

Is it a big forum?

 

[Pope Viper]

Not at all, The two things I'm most concerned about are the forum and Jukebox36 databases.