[SOLVED]Broken MySQL server, Recover old data.

iamdanhenry · 2011-12-31 01:33:13

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)

ewaller · 2011-12-31 02:36:15

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.

ewaller · 2011-12-31 04:22:11

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

ViruSzZ · 2011-12-31 06:49:38

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)

iamdanhenry · 2011-12-31 07:40:28

ViruSzZ wrote:

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

ViruSzZ · 2011-12-31 07:58:30

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.

Arch Linux

#1 2011-12-31 01:33:13

[SOLVED]Broken MySQL server, Recover old data.

#2 2011-12-31 02:36:15

Re: [SOLVED]Broken MySQL server, Recover old data.

#3 2011-12-31 04:22:11

Re: [SOLVED]Broken MySQL server, Recover old data.

#4 2011-12-31 06:49:38

Re: [SOLVED]Broken MySQL server, Recover old data.

#5 2011-12-31 07:40:28

Re: [SOLVED]Broken MySQL server, Recover old data.

#6 2011-12-31 07:58:30

Re: [SOLVED]Broken MySQL server, Recover old data.

Board footer