Re: Mysql question
| From: | Raditha Dissanayake | Date: | Wed, 19 Nov 2003 01:55:07 +0000 |
| Subject: | Re: Mysql question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-170219@lists.php.net to get a copy of this message | ||
Creating new databases is usually done with the mysql root account. Bad idea to use this account in a php script.
Lists wrote:
I have a db in sql, and I need a php/mysql query/command to copy the entire db (schema and data) to a new db. I know how to do this with a table, but I can not figure out how to do this with a whole db. I also know that I could do it using mysql dump, but I don't want to have to run a shell command. Please help, MIchael-- Raditha Dissanayake. ------------------------------------------------------------------------ http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 150 KB | with progress bar.