Hi Hendrik,
not sure if you have already received an answer, so please ignore if you are
already back on track ;-)
I did not find which OS you are using , but under Linux/Unix you would need to
change the ownership back to the user "mysql" and the group "mysql" before
you can use the copied data again.
Go into your data folder (/var/lib/mysql for an rpm install) and do:
chown -R mysql foldername
chgrp -R msql foldername
That should make them accessable again (assuming MySQL uses the owner and
group "mysql".
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 24日 木曜日 04:05、Henrik Schmiediche さんは書きました:
> Copy of the data files :-(
>
> - Henrik
>
>
> -----Original Message-----
> From: Andrew Braithwaite [mailto:Andrew@stripped]
> Sent: Wednesday, July 23, 2003 2:04 PM
> To: 'Henrik Schmiediche'; 'Mysql'
> Subject: RE: Re-attaching DB to mysql
>
> Is the backup a mysqldump or a copy of the data files?
>
> Andrew
>
> -----Original Message-----
> From: Henrik Schmiediche [mailto:henrik@stripped]
> Sent: Wednesday 23 July 2003 19:48
> To: 'Mysql'
> Subject: Re-attaching DB to mysql
>
>
>
>
> Hello,
> I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's
> from that backup and place it into my current production v4.0.14 mysql
> DB.
>
> Can this be done? How?
>
> Sincerely,
>
> - Henrik
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
--
---
Valentin Nils
Internet Technology
E-Mail: nils@stripped
URL: http://www.knowd.co.jp
Personal URL: http://www.knowd.co.jp/staff/nils
