List:General Discussion« Previous MessageNext Message »
From:Nils Valentin Date:July 24 2003 3:18am
Subject:Re: Re-attaching DB to mysql
View as plain text  
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

Thread
What is a good benchmark?Jake Johnson23 Jul
  • RE: What is a good benchmark?Bryan Koenig23 Jul
    • Re: What is a good benchmark?Yves Goergen23 Jul
    • RES: What is a good benchmark?julio23 Jul
      • RES: What is a good benchmark?julio23 Jul
      • Re: RES: What is a good benchmark?NTLUG23 Jul
  • RE: What is a good benchmark?artem23 Jul
  • RE: What is a good benchmark?Christopher Knight23 Jul
    • Re: What is a good benchmark?Andrew Edwards23 Jul
      • RE: What is a good benchmark?Christopher Knight23 Jul
        • RE: What is a good benchmark?mos23 Jul
          • RE: What is a good benchmark?Jeff Shapiro26 Jul
    • Re: What is a good benchmark?David Griffiths23 Jul
RE: What is a good benchmark?John Griffin23 Jul
RE: What is a good benchmark?Dan Hubbard23 Jul
  • Re: What is a good benchmark?Jim Dickenson23 Jul
    • Re: What is a good benchmark?Chris Knipe23 Jul
    • EXPLAIN - Question..Tom O'Neill \(MySQL User\)23 Jul
RE: What is a good benchmark?John May23 Jul
  • RE: What is a good benchmark?Asif Iqbal29 Jul
    • Re: What is a good benchmark?Jeremy Zawodny29 Jul
      • Re: What is a good benchmark?daniel29 Jul
    • Re: What is a good benchmark?Dan Nelson29 Jul
      • Re: What is a good benchmark?Asif Iqbal29 Jul
        • Re: What is a good benchmark?Dan Nelson29 Jul
          • Re: What is a good benchmark?Asif Iqbal29 Jul
            • Re: What is a good benchmark?Dan Nelson29 Jul
RE: What is a good benchmark?Mark Graves23 Jul
RE: What is a good benchmark?Andrew Braithwaite23 Jul
  • Re-attaching DB to mysqlHenrik Schmiediche23 Jul
    • Re: Re-attaching DB to mysqlEgor Egorov24 Jul
  • Re: What is a good benchmark?Gustavo A. Baratto23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
  • RE: Re-attaching DB to mysqlHenrik Schmiediche23 Jul
    • Re: Re-attaching DB to mysqlNils Valentin24 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
  • RE: Re-attaching DB to mysqlHenrik Schmiediche23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
RE: Re-attaching DB to mysqlAndrew Braithwaite23 Jul
RE: RES: What is a good benchmark?Ow Mun Heng24 Jul
RE: RES: What is a good benchmark?Ow Mun Heng24 Jul
Re: Re-attaching DB to mysqlNils Valentin24 Jul