On Jan 30, 2008, at 10:44 AM, Jerry Schwartz wrote:
mysqldump -A > file.dump
tar -jcf file.dump
rsync
[JS] You could also just pipe the output of mysqldump through gzip.
tar buys
you nothing, since it is a single file.
-j is the bzip2 compression option. :)
[JS] Yes, but tar is just extra b
> >> mysqldump -A > file.dump
> >> tar -jcf file.dump
> >> rsync
> >
> > [JS] You could also just pipe the output of mysqldump through gzip.
> > tar buys
> > you nothing, since it is a single file.
>
> -j is the bzip2 compression option. :)
[JS] Yes, but tar is just extra baggage.
Regards,
Jerry
Is there a reason this wouldn't work with InnoDB? (I understand
there's usually a single ibdata file, but so?)
On Jan 24, 2008, at 8:08 AM, Matthias Witte wrote:
On Thu, Jan 24, 2008 at 01:42:38PM +0200, Ivan Levchenko wrote:
Hi All,
What would be the best way to transfer a 20 gig db from
On Jan 29, 2008, at 10:02 AM, Jerry Schwartz wrote:
mysqldump -A > file.dump
tar -jcf file.dump
rsync
[JS] You could also just pipe the output of mysqldump through gzip.
tar buys
you nothing, since it is a single file.
-j is the bzip2 compression option. :)
--
MySQL General Mailing List
All,
InnoDB and MyISAM tables are platform independent, is there a reason
why transferring the actual binary files from one system (or mount
point) is not advised? From like OS to like OS, this seems like it
should be okay and you'll only get into trouble with Float/Double.
MySQL Document
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 29, 2008 2:02 AM
> To: Ivan Levchenko
> Cc: mysql@lists.mysql.com
> Subject: Re: transfer huge mysql db
>
> Ivan Levchenko wrote:
> > Hi All,
> >
> > What wou
I have a similar question.
I've run out of disk space on one of my partitions. What would be the best
way to move one table over to another partition? I see you can specify DATA
DIRECTORY and INDEX DIRECTORY, but when I try and ALTER or CREATE LIKE with
these parameters, the table stays where i
Ivan Levchenko wrote:
Hi All,
What would be the best way to transfer a 20 gig db from one host to another?
mysqldump -A > file.dump
tar -jcf file.dump
rsync
or use replication to do it (might take a bit longer this way though).
--
MySQL General Mailing List
For list archives: http://lists.my
Thanks Everybody for your help!
I'll think over what would be the best in my situation...
/me hoping to add a success story to this thread later
On Jan 24, 2008 3:08 PM, Matthias Witte <[EMAIL PROTECTED]> wrote:
> On Thu, Jan 24, 2008 at 01:42:38PM +0200, Ivan Levchenko wrote:
> > Hi All,
> >
>
On Thu, Jan 24, 2008 at 01:42:38PM +0200, Ivan Levchenko wrote:
> Hi All,
>
> What would be the best way to transfer a 20 gig db from one host to another?
If it consists of MyISAM tables you can do a pre rsync with everything
up and running.
Then you would lock all tables and do the real sync[1]
2008, at 12:20, Saravanan wrote:
do binary copy. sql dump will be slow.
Saravanan
--- On Thu, 1/24/08, Ivan Levchenko <[EMAIL PROTECTED]> wrote:
From: Ivan Levchenko <[EMAIL PROTECTED]>
Subject: transfer huge mysql db
To: mysql@lists.mysql.com
Date: Thursday, January 24, 2008, 6:1
do binary copy. sql dump will be slow.
Saravanan
--- On Thu, 1/24/08, Ivan Levchenko <[EMAIL PROTECTED]> wrote:
> From: Ivan Levchenko <[EMAIL PROTECTED]>
> Subject: transfer huge mysql db
> To: mysql@lists.mysql.com
> Date: Thursday, January 24, 2008, 6:12 PM
> Hi
heh.. a little problem with this is that i'm going to do all of this remotely.
I was thinking on doing a mysqldump with the compress flag.
Anything to say about mysql migration tools? can it be used to do the
job more efficiently?
Its just that the db is in high use and i don't want to lock the
Hi All,
What would be the best way to transfer a 20 gig db from one host to another?
Thanks in advance for your answers!
--
Best Regards,
Ivan Levchenko
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
14 matches
Mail list logo
