Hi,
Why not just use mysqldump --alldatabases ?
Export all, then import all.
It can make sure all your DB data consistency.
Regards,
On Wed, 8 Sep 2004 16:40:01 -0400 (EDT), Jerry McAllister
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> > On Sep 3, 2004, at 10:46 AM, Jerry McAllister wrot
Hi,
> On Sep 3, 2004, at 10:46 AM, Jerry McAllister wrote:
> >> I have a server that is rapidly filling the var partition with a MySQL
> >> database. I'd like to move it to a subdirectory somewhere under /usr.
>
> > If you don't want to move all the stuff in /var/db, then you will
> > have to be
On Sep 3, 2004, at 10:46 AM, Jerry McAllister wrote:
I have a server that is rapidly filling the var partition with a MySQL
database. I'd like to move it to a subdirectory somewhere under /usr.
If you don't want to move all the stuff in /var/db, then you will
have to be more selective and make th
On Fri, Sep 03, 2004 at 04:40:04PM +0100, Peter Risdon wrote:
> Matthew Seaman wrote:
> > iii) Move the database files to their new location, taking care to
> > preserve ownership, permissions, timestamps etc.
>
>
> Might a cp -p be slightly more cautious/paranoid until step vi has been
> > I'd do it this way:
> >
> > i) Stop mysql
I would actually perform a full mysqldump first and save that off.
SQL dump file is more flexible concerning version changes than is
saving the actual db files.
___
[EMAIL PROTECTED] mailing list
http://
Matthew Seaman wrote:
On Fri, Sep 03, 2004 at 09:42:36AM -0400, Bart Silverstrim wrote:
I have a server that is rapidly filling the var partition with a MySQL
database. I'd like to move it to a subdirectory somewhere under /usr.
Is there a document that would outline a "best practices" approach
>
> I have a server that is rapidly filling the var partition with a MySQL
> database. I'd like to move it to a subdirectory somewhere under /usr.
>
> Is there a document that would outline a "best practices" approach to
> doing this? My first instinct was to stop the mysqld, do a mv on
> /v
> On Fri, Sep 03, 2004 at 09:42:36AM -0400, Bart Silverstrim wrote:
>> I have a server that is rapidly filling the var partition with a
>> MySQL
>> database. I'd like to move it to a subdirectory somewhere under
>> /usr.
>>
>> Is there a document that would outline a "best practices" approach
>> t
On Fri, Sep 03, 2004 at 09:42:36AM -0400, Bart Silverstrim wrote:
> I have a server that is rapidly filling the var partition with a MySQL
> database. I'd like to move it to a subdirectory somewhere under /usr.
>
> Is there a document that would outline a "best practices" approach to
> doing th
I have a server that is rapidly filling the var partition with a MySQL
database. I'd like to move it to a subdirectory somewhere under /usr.
Is there a document that would outline a "best practices" approach to
doing this? My first instinct was to stop the mysqld, do a mv on
/var/db to /var/d
10 matches
Mail list logo