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
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
You could run a system command from the web browser to import the text file.
If you have access to PHPmyAdmin, you could use it to then import the file.
Or finally, you should be able to read the contents of the file into a
variable (if it's small enough) and then run the query using mysql_query.
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
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
