jh> I am trying to restore a mysql database from a
jh> gzipped archive. My most recent archive keeps
jh> telling me that "an error occurred while trying
jh> to open the archive" when I try and open it in
jh> Ark.
I gues Ark is some sort of KDE GUI wrapper for gzip?
jh> Does anyone out there know of any ways around
jh> this, or do I just have to suck it up and start
jh> rebuilding from the previous back up?
Avoid that if you can. If that's an option it means you
are willing to accept loss of data as a solution. How
important is the DB to you? In any case, if something
is actually corrupted, you'll want to know what and
why. gzip files don't just suddenly become corrupt all
by themselves. It's more likely you're doing something
wrong but just don't know it.
Have you tried using gzip from the command line? What
does this tell you?
gunzip mydbarchivename.gz
(Substituting the name of your archive. We hope it says
nothing.)
What command are you using to restore the database?
What error message are you getting when you do it?
Is the mysql archive made with mysqldump or is it an
actual backup of the database data directory? If the
latter you may be seriously hosed.
Need more information to help you.
--
Lynn David Newton
Phoenix, AZ
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)