yeah i forgot the -r
On Fri, Aug 13, 2010 at 7:32 AM, Shawn Badger <
badger.shawn@gmail.com> wrote:
> Mysql stores the databases in an individual folder for each database. You
> need to use -r (recursive) option with the cp to make it work properly.
>
> Eric had the right syntext in his posting, but the trailing /. isnt' needed.
>
> sudo cp -r DB1 DB2
>
>
>
> On Thu, Aug 12, 2010 at 4:38 PM, Brian Cluff <brian@snaptek.com> wrote:
>>
>> sudo cp DB1/* DB2/ should have worked. The fact that it's giving you a
>> file not found is a little confusing. My guess is that you have either have
>> a typo in the source database folder name, or more likely you haven't taken
>> into account that Linux file systems are case sensitive.
>>
>> Brian Cluff
>>
>> On 08/12/2010 04:17 PM, keith smith wrote:
>>>
>>> Hi,
>>>
>>> For some reason I just don't get the cp command. Maybe it is the deep
>>> rooted MS DOS from the 80's and 90's. I spent about a decade using MS
>>> DOS.
>>>
>>> Here is what is going on. I am in a CentOS box and do not ever become
>>> root. I use sudo.
>>>
>>> I want to copy one MySql DB to another so I can use the data for testing.
>>>
>>> 1) I cd to /var/lib/mysql
>>> 2) I can see both DB's
>>> 3) I issue any number of commands that do not work.
>>>
>>> Lets say DB1 is the source directory & DB2 is the destination directory
>>>
>>> mysql]$ sudo cp DB1/*.* DB2/ Results: cp: cannot stat `DB1/*.*': No such
>>> file or directory
>>>
>>> mysql]$ sudo cp DB1/* DB2/ Results: cp: cannot stat `DB1/*': No such
>>> file or directory
>>>
>>> mysql]$ sudo cp DB1/ DB2/ Results: creates the directory DB1 under DB2
>>> and copies all the files into DB2/DB1
>>>
>>> mysql]$ sudo cp DB1 DB2/ Results: does not seem to do anything.
>>>
>>> http://www.computerhope.com/unix/ucp.htm shows this example: cp -r
>>> /home/hope/files/* /home/hope/backup
>>>
>>> mysql]$ sudo cp -r /var/lib/mysql/DB1/* /var/lib/mysql/DB2 - cp: cannot
>>> stat `/var/lib/mysql/baseline/*': No such file or directory
>>>
>>> This is driving me crazy. Any help much appreciated!
>>>
>>> ------------------------
>>> Keith Smith
>>>
>>>
>>>
>>>
>>> ---------------------------------------------------
>>> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>>> To subscribe, unsubscribe, or to change your mail settings:
>>> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>>
>> ---------------------------------------------------
>> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
>> To subscribe, unsubscribe, or to change your mail settings:
>> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
--
A mouse trap, placed on top of your alarm clock, will prevent you from
rolling over and going back to sleep after you hit the snooze button.
Stephen
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)