On Wed, Mar 12, 2008 at 3:26 PM, Tim McDaniel <[EMAIL PROTECTED]> wrote:
> On Wed, 12 Mar 2008, Michael Dykman <[EMAIL PROTECTED]> wrote:
>
> > It's quite simple; -p, --password takes an optional argument which
> > it will only look for if
> >a) the short form is immediately followed by a no
On Wed, 12 Mar 2008, Michael Dykman <[EMAIL PROTECTED]> wrote:
You misunderstand. I realize that putting the password on the command
line is insecure in the presence of "ps auxwww" and Process Explorer
and such. I'm kvetching about how mysql and mysqldump parse their
arguments, that
*
> You misunderstand. I realize that putting the password on the command
> line is insecure in the presence of "ps auxwww" and Process Explorer
> and such. I'm kvetching about how mysql and mysqldump parse their
> arguments, that
> * -uUSERNAME and -pPASSWORD are parsed similarly
> * -
On Tue, 11 Mar 2008, Richard Heyes <[EMAIL PROTECTED]> wrote:
How very inconsistent and obnoxious.
But yet far more secure.
You misunderstand. I realize that putting the password on the command
line is insecure in the presence of "ps auxwww" and Process Explorer
and such. I'm kvetching abou
How very inconsistent and obnoxious.
But yet far more secure. FWIW, if you're transferring between machines
you can gzip the output of mysqldump to compress it, resulting in far
less transfer time.
Eg.
mysqldump -u username -p database_name | gzip -c > dump.sql.gz
IIRC
--
Richard Heyes
Em
On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
On Mon, Mar 10, 2008 at 4:05 PM, Terry Babbey <[EMAIL PROTECTED]> wrote:
If I use the method below, will that transfer the mysql admin database
too with the user information?
nohup mysqldump -h -u -p
--all-databases --routin
On Mon, Mar 10, 2008 at 4:05 PM, Terry Babbey <[EMAIL PROTECTED]> wrote:
> Thanks to all for the quick replies.
>
> Yes, the mysqldump worked perfectly. Boy do I feel like a newbie now!
>
> If I use the method below, will that transfer the mysql admin database
> too with the user information?
>
PROTECTED]
Sent: March 10, 2008 2:52 PM
To: Daniel Brown; Terry Babbey
Cc: mysql@lists.mysql.com
Subject: RE: Migrate HUGE Database
You can take this a step further
nohup mysqldump -h -u -p
--all-databases --routines --triggers | mysql -h -A
This will pipe all the data directly to Windows machine
mysqldump from the commandline. You are most likely running into php
execution time limits using phpmyadmin
OR you could probably just copying the underlying files, .frm,MYI and MYD
I've successfully done that with myisam databases going from version 4 - 5
on tables exceeding 50M rows. Not sure a
Tim McDaniel wrote:
I was a bit puzzled seeing "-p database_name",
...
How very inconsistent and obnoxious.
It's best to think of -p as never taking an argument, always asking
interactively. Many operating systems will let a processes access the
command line parameters of another process
On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
mysqldump -u username -p database_name > database_name.sql
To explain:
-u usernameReplace 'username' with the database username.
-p This signifies that you'll use a password
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 2:40 PM
To: Terry Babbey
Cc: mysql@lists.mysql.com
Subject: Re: Migrate HUGE Database
On Mon, Mar 10, 2008 at 2:29 PM, Terry Babbey <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a huge database that I would like to migrat
On Mon, 10 Mar 2008 at 14:29 -0400, [EMAIL PROTECTED] confabulated:
Hello,
I have a huge database that I would like to migrate from a server
running 4.0.16 to a server running the Windows version 5.0.45. The
database is approximately 3,500,000 records. I get timeout errors using
PHPMyAdmin to e
On Mon, Mar 10, 2008 at 11:29 AM, Terry Babbey <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a huge database that I would like to migrate from a server
> running 4.0.16 to a server running the Windows version 5.0.45. The
> database is approximately 3,500,000 records. I get timeout errors using
On Mon, Mar 10, 2008 at 2:29 PM, Terry Babbey <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a huge database that I would like to migrate from a server
> running 4.0.16 to a server running the Windows version 5.0.45. The
> database is approximately 3,500,000 records. I get timeout errors using
>
15 matches
Mail list logo
