Quick Panther/MySQL upgrade question

[brycesutherland]

Hi,

I've installed MySQL on my machine here at home for learning purposes and I'm wondering if I should worry about backing up the databases (or do I need to back-up the whole MySQL installation?) when I upgrade to Panther? If so, I need to go read a book on how to do this...

Thanks,
Glenn

[houchin]

Yes, I would back up the databases. You might not need to, but it's easy enough:

mysqldump --user=root --password --all --databases --complete-insert --add-drop-
table --add-locks space separated list of databases > dump.sql

[ppmax]

I was wondering if you could help me out: I have a similar but different situation.

Like a bozo I didnt dump the databases I had from a previous system (10.2, MySQL 3.xx ) before wiping my drive and installing Panther. However, I did copy the previous mysql../data directory containing all the raw files. I tried copying these to my new MySQL installation but they wont load properly. I use PHPMyAdmin and when I try to access a table in the database I copied I get an error:
"Can't find file: './addressbook/addresses.frm' (errno: 13)"

Do you have any suggestions for migrating my old databases to the new MySQL 4.x install?

thanks much,
ppmax

[zeb]

Originally posted by ppmax
I was wondering if you could help me out: I have a similar but different situation.

Like a bozo I didnt dump the databases I had from a previous system (10.2, MySQL 3.xx ) before wiping my drive and installing Panther. However, I did copy the previous mysql../data directory containing all the raw files. I tried copying these to my new MySQL installation but they wont load properly. I use PHPMyAdmin and when I try to access a table in the database I copied I get an error:
"Can't find file: './addressbook/addresses.frm' (errno: 13)"

Do you have any suggestions for migrating my old databases to the new MySQL 4.x install?

thanks much,
ppmax

I did the same exact thing, except my version of mysql hasn't changed between installs (4.0.13)... does anyone have any ideas on this?

[ulrichm]

If you still remember the names of the tables you created. you could try to create them again and once created, stop mysql and replace the folders it has created with the original folders. I hope it helps and works.