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:[EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]
> 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/[EMAIL PROTECTED]

-- 
---
Valentin Nils
Internet Technology

 E-Mail: [EMAIL PROTECTED]
 URL: http://www.knowd.co.jp
 Personal URL: http://www.knowd.co.jp/staff/nils


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to