Transfer MySQL from one computer to another after a crash

Question

My local server has just blown up and gone bust. It’s refusing to boot and just hangs with a black screen. But I can access the data when making the HDD external

I have installed my new HDD into my server and installed everything i need now i need to know how to copy MySQL data from from one crashed system to the new one?

In using Ubuntu and copied the files from:

/var/lib/mysql/TableName

To the new location but I’m getting a error from phpMyAdmin saying cannot find file "products.frm" (errno: 13) but when I look in:

/var/lib/mysql/TableName

It’s there and I can see it?

What am I missing? I have no other backup.

No answering this, but will say this: Your problem is not phpMyAdmin. Your problem is MySQL. phpMyadmin is simply a web-based interface for phpMyAdmin. And copying database files like that can be iffy. Much better to rely on `mysqldump` exports. Always safer. And after this incident I recommend you use `mysqldump`—on a script perhaps—to backup a database. — Giacomo1968, Jun 25 '14 at 22:56

score 2 · Accepted Answer · edited May 23 '17 at 12:06

2

Are you talking about copying phpmyadmin or your mysql data?

If it's phpmyadmin, I'd just reinstall it.

If it's your mysql data, it's going to take a bit more work. Start here: Restoring MySQL database from physical files.

edited May 23 '17 at 12:06

Community

1
1

answered Jun 25 '14 at 22:52

Kryten

15,230
6
45
68

1

+1. Not sure who downvoted you, your answer is pretty clear. – Aeveus Jun 25 '14 at 22:55
@nietonfir The answer given by Jackie Xu actually help and solved my problem – nats0128 Jun 25 '14 at 23:06

bitWorking · Answer 2 · 2014-06-25T23:01:28.003

0

Run the command:

SHOW VARIABLES LIKE 'datadir';

This will show you the right location of the database folders and the containing frm files.

edited Jun 25 '14 at 23:01

answered Jun 25 '14 at 22:54

bitWorking

12,485
1
32
38

Transfer MySQL from one computer to another after a crash

2 Answers2