ntioned in my previous email.
-Original Message-
From: Todd Cary [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 06, 2005 8:57 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Using PHP to import a DB
Robert -
I used the backup file on my desktop computer and the browse button.
After
-
From: Todd Cary [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 06, 2005 8:57 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Using PHP to import a DB
Robert -
I used the backup file on my desktop computer and the browse button.
After the upload was over, I got this message:
Your SQL query
#x27;s the case, you
can separate out the sql commands from the file into separate files.
-Original Message-
From: Todd Cary [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 06, 2005 8:43 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Using PHP to import a DB
Robert -
I installed ph
retrieved from http://www.phpmyadmin.net/home_page/
Robbert van Andel
-Original Message-
From: Todd Cary [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 05, 2005 4:02 PM
To: php-db@lists.php.net
Cc: Chris Herron
Subject: [PHP-DB] Using PHP to import a DB
My client switched from a d
phpmyadmin. It's a very good database interface
and can be retrieved from http://www.phpmyadmin.net/home_page/
Robbert van Andel
-Original Message-
From: Todd Cary [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 05, 2005 4:02 PM
To: php-db@lists.php.net
Cc: Chris Herron
Subject
On 2005-11-06, Todd Cary <[EMAIL PROTECTED]> wrote:
>> system("mysql -u user -p db < /tmp/mydb");
> With the "-p" switch, the user is asked for the password. How does that
> happen with the system command?
Don't leave a space between -p and the password
mysql -u user -pyourpassword -h somehost
Don't use it, use --password= instead..
The downside to this is that anyone can see your password in the process list,
but I'm going to hazard a guess that no users are scanning the process list
that often on a shared webserver.
-Micah
On Saturday 05 November 2005 5:21 pm, Todd Cary wrote:
Micah -
With the "-p" switch, the user is asked for the password. How does that
happen with the system command?
Todd
Micah Stevens wrote:
system("mysql -u user -p db < /tmp/mydb");
On Saturday 05 November 2005 4:02 pm, Todd Cary wrote:
My client switched from a dedicated server to a
php.net
Cc: Chris Herron
Subject: [PHP-DB] Using PHP to import a DB
My client switched from a dedicated server to a shared server, so I
cannot use the command line to import a DB that was produced with
mysqldump. Can I duplicate "mysql -u user -p db < /tmp/mydb" with php?
Any
system("mysql -u user -p db < /tmp/mydb");
On Saturday 05 November 2005 4:02 pm, Todd Cary wrote:
> My client switched from a dedicated server to a shared server, so I
> cannot use the command line to import a DB that was produced with
> mysqldump. Can I duplicate "mysql -u user -p db < /tmp
My client switched from a dedicated server to a shared server, so I
cannot use the command line to import a DB that was produced with
mysqldump. Can I duplicate "mysql -u user -p db < /tmp/mydb" with php?
Any suggestions are greatly appreciated
Todd
--
PHP Database Mailing List (http://w
11 matches
Mail list logo