From: Alex Dean
> On Aug 13, 2010, at 7:32 AM, Shawn Badger wrote:
>> Mysql stores the databases in an individual folder for each database.
> mysql MYISAM does that. Innodb & other storage engines uses other
> mechanisms.
innodb_file_per_table = 1
...will make InnoDB store one table in one fi
On Aug 13, 2010, at 7:32 AM, Shawn Badger wrote:
Mysql stores the databases in an individual folder for each database.
mysql MYISAM does that. Innodb & other storage engines uses other
mechanisms.
---
PLUG-discuss mailing list - PLUG-discuss
- my formative years :)
Keith Smith
--- On *Fri, 8/13/10, Lisa Kachold /mailto:lisakach...@obnosis.com>>/* wrote:
From: Lisa Kachold mailto:lisakach...@obnosis.com>>
Subject: Re: Linux CP command
To: "Main PLUG discu
mative years :)
>>
>>
>> Keith Smith
>>
>> --- On *Fri, 8/13/10, Lisa Kachold /> <mailto:lisakach...@obnosis.com>>/* wrote:
>>
>>
>> From: Lisa Kachold > <mailto:lisakach...@obnosis.com>>
ine - my formative years :)
Keith Smith
--- On *Fri, 8/13/10, Lisa Kachold /mailto:lisakach...@obnosis.com>>/* wrote:
From: Lisa Kachold mailto:lisakach...@obnosis.com>>
Subject: Re: Linux CP command
To: "Main PLUG discussion list"
h cp some more. It does not work the way I expect.
> Probably those 10 years I spent on the DOS command line - my formative years
> :)
>
>
> Keith Smith
>
> --- On *Fri, 8/13/10, Lisa Kachold * wrote:
>
>
> From: Lisa Kachold
> Subject: Re: Li
Kachold wrote:
From: Lisa Kachold
Subject: Re: Linux CP command
To: "Main PLUG discussion list"
Date: Friday, August 13, 2010, 11:26 AM
Glad you got it.
sudo cp -r for directory is required; and paths can be difficult.
Sheesh, you asked us clearly, but it took 10 volleys to get you an
oing a dump and an import.
>
> Thank you all for your help and insight!
>
>
> Keith Smith
>
> --- On *Fri, 8/13/10, Shawn Badger * wrote:
>
>
> From: Shawn Badger
> Subject: Re: Linux CP command
> To: "Main PLUG discussion list"
yeah i forgot the -r
On Fri, Aug 13, 2010 at 7:32 AM, Shawn Badger 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'
the problem you are running into is with file structure,
"*cp /home/public_html/mylog.txt /home/public_html/backup/mylog.bak*"
in that example from your page you see that it starts at / and works down.
so you would need to do something similar
cp /var/lib/mysql/DB1/*.* to /var/lib/mysql/DB2/
I think I tried that also. I ended up doing a dump and an import.
Thank you all for your help and insight!
Keith Smith
--- On Fri, 8/13/10, Shawn Badger wrote:
From: Shawn Badger
Subject: Re: Linux CP command
To: "Main PLUG discussion list"
Date: Frid
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 wrote:
I personally use 'tar' in place of 'cp' all the time:
tar cf - * | ( cd /target; tar xfp -)
On Thu, Aug 12, 2010 at 4: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 usin
gh, I'd do a
mysqldump instead.
--- On Thu, 8/12/10, keith smith wrote:
From: keith smith
Subject: Linux CP command
To: "Main PLUG discussion list"
Date: Thursday, August 12, 2010, 6:17 PM
Hi,
For some reason I just don't get the cp command. Maybe it is the deep rooted
Thanks!
Keith Smith
--- On Thu, 8/12/10, Alex Dean wrote:
From: Alex Dean
Subject: Re: Linux CP command
To: "Main PLUG discussion list"
Date: Thursday, August 12, 2010, 4:52 PM
Is mysql running when you do this copy? You'll never get a consiste
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 appli
I used the tab complete and still not working.
Keith Smith
--- On Thu, 8/12/10, Brian Cluff wrote:
From: Brian Cluff
Subject: Re: Linux CP command
To: "Main PLUG discussion list"
Date: Thursday, August 12, 2010, 4:38 PM
sudo cp DB1/* DB2/ should h
I don't get how the /var/lib/mysql/baseline got involved with the cp. Its
not in the path specified.
Try this:
cp -r /var/lib/mysql/DB1/* /var/lib/mysql/DB2/.
the following /. may help...
Eric
On Thu, Aug 12, 2010 at 4:17 PM, keith smith wrote:
>
> Hi,
>
> For some reason I just don't get the
s all the files from DB1
I thought this would be a quick and dirty was to setup a testing DB.
I guess I'll have to do it the mysqldump way!
Keith Smith
--- On Thu, 8/12/10, Lisa Kachold wrote:
From: Lisa Kachold
Subject: Re: Linux CP command
To: "Main PLUG
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
Hi Kevin:
On Thu, Aug 12, 2010 at 4: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 becom
Use mysqldump
Ask me about free travel
-Original Message-
From: keith smith
Sender: plug-discuss-boun...@lists.plug.phoenix.az.us
Date: Thu, 12 Aug 2010 16:17:11
To: Main PLUG discussion list
Reply-To: Main PLUG discussion list
Subject: Linux CP command
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
23 matches
Mail list logo