Linux CP command

[Alex Dean]

Is mysql running when you do this copy?  You'll never get a consistent  
snapshot of your data if it is.

Either use mysqldump, or stop the server prior to doing your copies.   
If you use mysqldump, make sure you use the options to lock the  
database, so you get a consistent dump.  If your application can't  
tolerate the amount of database unavailability which is required  
(either locking or from the server shutdown), set up a database slave  
and take your copies/backups from the slave.

alex

On Aug 12, 2010, at 4:38 PM, Brian Cluff 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 at 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 at lists.plug.phoenix.az.us
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>