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@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
