List:General Discussion« Previous MessageNext Message »
From:Nils Valentin Date:July 24 2003 2:38pm
Subject:Re: Re-attaching DB to mysql
View as plain text  
Hope I could be of help.

Best regards

Nils Valentin
Tokyo/Japan

2003年 7月 24日 木曜日 22:51、Henrik Schmiediche さんは書きました:
> Thanks for the help!
>
>     - Henrik
>
>
> -----Original Message-----
> From: Nils Valentin [mailto:nils@stripped]
> Sent: Wednesday, July 23, 2003 10:19 PM
> To: Henrik Schmiediche; 'Andrew Braithwaite'; 'Mysql'
> Subject: Re: Re-attaching DB to mysql
>
> 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