Recovering data from old MySQL Database into a new one Mac OSX

Question

I have a full data folder which includes all of my previous databases from my old instance of MySQL. I upgraded OSX 10.6 to 10.7, I started having problems almost instantly so reinstalled mysql and phpMyAdmin (PMA).

I have tried simply moving the data/ folder to usr/local/mysql/data/ but then MySQL will not start at all.

So I tried moving just the database folder into data/ - This works, I see my database in PMA, however when i click it, theres no tables.

If I move all the files inside the database folder into a new one created - I see all the tables but get this error : Error

So can anyone tell me, where or what i am doing wrong?

See if this link helps http://stackoverflow.com/questions/6443428/cant-find-file-ci-users-frm-errno-13 — vcs, Sep 12 '13 at 16:07

score 0 · Answer 1 · edited May 23 '17 at 12:01

0

This was a permissions problem.

Downloading an app such as BatChmod helped me.

Or follow this link : Can't find file: './ci/users.frm' (errno: 13)

MySQL needs its permissions.

edited May 23 '17 at 12:01

Community

1
1

answered Sep 12 '13 at 16:27

Ricki

933
2
15
33

Recovering data from old MySQL Database into a new one Mac OSX

1 Answers1