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
* -u
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
*
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 non-space
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
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 about
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
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, 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
keep going
-Original Message-
From: Daniel Brown [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
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
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,
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
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 -hhost of Linux Machine -uusername -ppassword
--all-databases --routines --triggers | mysql -hhost of Windows
Machine
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?
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 -hhost of Linux Machine -uusername
15 matches
Mail list logo
