BD,
Sorry I can't help you with your corrupted data but here are some related
links for backing up MySQL data the proper way:
There are also some good "canned" shell scripts out there tha do what you
want as well.
It is a good idea to stop the server or lock the tables when copying or
backing up to prevent write conflicts (data in limbo) and ultimate data
corruption.
http://www.mysql.com/doc/m/y/mysqldump.html
http://www.mysql.com/doc/m/y/mysqlhotcopy.html
http://www.mysql.com/doc/B/A/BACKUP_TABLE.html
You could also stop the MySQL server, copy the files and then restart it but
this not a good thing for a 24/7 production server that can't be taken off
line.
http://www.mysql.com/doc/A/u/Automatic_start.html
___________________________________
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
___________________________________
> Correct ownership of the files helps a lot. duh.
>
> I'll do some more checking into the right way to back up this
> database after
> I catch a few hours sleep. I just know that rsync is not the best way....
>
>
> > Running mysql 3.23.24 beta on a RH6.2 box...
> >
> > Is there any way at all to salvage tables that have been backed up using
> > just rsync (straight copy). The original database died, and the guy that
> set
> > up the backups just used rsync to do all the backups and didn't do
> anything
> > special for the database.
> >
> > I know zilch about mysql, but have been trying to recover this
> for an hour
> > now and am getting nowhere... from what I can tell, it's not possible to
> > salvage the data (or at least part of it)? MySQL doesn't think there are
> any
> > fields in any of the "restored" tables..
> >
> > If there's a miracle worker out there, I would appreciate an
> assist..there's
> > a *ton* of work in this database....
> >
> > Thanks...
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
