Started 2 weeks, 3 days ago (2009-10-26 08:48:00)
by Edward Murphy
Looks like I may have disk errors. I ran CHKDSK and see 4 file record segments as unreadable. So, for the next guy, I post an update.
Further update -- my disk is toast, I am saving what I can and moving to a new server.
Edited 1 time(s). Last edit at 10/27/2009 07:57AM by
Edward Murphy.
Started 1 month, 1 week ago (2009-10-04 22:58:00)
by Matt Pellegrino
Hello,
Unfortunately you will need at least the .frm file as well to preform and sort of restore of your database. Even with InnoDB recovery tools:
http://code.google.com/p/innodb-tools/wiki/InnodbR ecoverySteps
You would need the
transaction log files (ib* files) as well as the .frm in order for it to generate the header file and grab the table schema.
Matt Pellegrino
...
Started 1 month ago (2009-10-06 12:52:00)
by Jay Alverson
If you have Windows try one of the File Undelete/Recovery programs
if you can afford it.
Otherwise...the manual has suggestions for Chapter 6.
Backup and Recovery
>
Thanks, Jay
Started 1 month, 1 week ago (2009-10-04 23:08:00)
by Matt Pellegrino
Hello,
If you basically have two installations of MySQL already on the server (4.1.12 and 5.1),
why not try to temporarily run both on different ports or one at a time on the same port. You could then connect to the old instance still and run a mysqldump which you would then import into the 5.1 instance. It might take some modification to the init script or possibly starting of the MySQL ...
Started 1 month, 1 week ago (2009-10-04 23:01:00)
by Matt Pellegrino
Hello,
Can you tell us which type of storage engine you were using for your database (i.e. InnoDB, MyISAM, etc). Also, is there anything appearing in the mysql.log file during start up that points to errors/corruption with the MySQL database in question?
Matt
Pellegrino
Support Engineer
mpellegrino @ hosting.com
www.Hosting.com
Started 1 month, 1 week ago (2009-10-01 12:48:00)
by Jay Alverson
I think you can use the INSERT...SELECT statement to simply append the data
from other tables into a single one; even if they're in different schemas.
Chapter 12.
2.5.1. INSERT ... SELECT Syntax in the manual.
You can test of course with three tables (or more). Then once the data
is consolidated simply drop (delete) the tables you no longer need.
Table1
Table2
Table3
...