Re: Using PHP to import a DB
| From: | Micah Stevens | Date: | Sun, 06 Nov 2005 01:24:40 +0000 |
| Subject: | Re: Using PHP to import a DB | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40602@lists.php.net to get a copy of this message | ||
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 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