You are not logged in.
I am trying to recover data from a broken MySQL server. I have complete access to the file system, I just cannot actually run the MySQL server to export it or dump it.
If anyone has any insight on how I can recover these old databases I would appreciate it.
Thanks,
Daniel
Last edited by iamdanhenry (2011-12-31 22:52:08)
Personal Blog http://awebnerd.com/
Offline
Hello, and welcome to Arch Linux.
If I understand correctly, you are asking for help on a Windows system. It is our policy to close non-Arch threads.
If I am in error, please contact a moderator and we can re-open this thread.
Nothing is too wonderful to be true, if it be consistent with the laws of nature -- Michael Faraday
Sometimes it is the people no one can imagine anything of who do the things no one can imagine. -- Alan Turing
---
How to Ask Questions the Smart Way
Offline
After communication with the OP, I have re-opened this thread. The intent is how to recover the data from within Arch Linux using SQL magic.
iamdanhenry:
Yes, that was the perfect way to reach me. If you would, go ahead and edit your post to clarify your need.
Again, welcome to Arch Linux.
ewaller
Nothing is too wonderful to be true, if it be consistent with the laws of nature -- Michael Faraday
Sometimes it is the people no one can imagine anything of who do the things no one can imagine. -- Alan Turing
---
How to Ask Questions the Smart Way
Offline
I don't think I can understand your situation very well but I do understand that you're unable to start your MySQL server. Anyhow, IMO if the database/s is/are present inside the '/var/lib/mysql/${dbname}' (or whateva your mysql root dir is) directory, I think you can rsync them to some other mysql server and repair/use them there.
Anyhow, it's worth trying that.
EDIT: Hey Daniel, I have the same name as you man -_- . Welcome to Arch Linux
Last edited by ViruSzZ (2011-12-31 06:50:38)
Their Momma Made Em, Their Momma Gave em & now she can`t even SAVE`em | My WebLog
Offline
I don't think I can understand your situation very well but I do understand that you're unable to start your MySQL server. Anyhow, IMO if the database/s is/are present inside the '/var/lib/mysql/${dbname}' (or whateva your mysql root dir is) directory, I think you can rsync them to some other mysql server and repair/use them there.
Anyhow, it's worth trying that.
EDIT: Hey Daniel, I have the same name as you man -_- . Welcome to Arch Linux
Just came to mark this as solved and saw your post. Did exactly that.
All I did was copy the old files over. I tried this before but forgot to set the permissions of the files so it didn't work
Personal Blog http://awebnerd.com/
Offline
Of course you need to chown your databases to mysql or I'm always using 'rsync -Waq' so it keeps the attributes while transferring over ssh.
Their Momma Made Em, Their Momma Gave em & now she can`t even SAVE`em | My WebLog
Offline