RE: [PHP-WIN] Transfering database
| From: | Sudeep Zamudra | Date: | Thu, 27 May 2004 08:03:45 +0000 |
| Subject: | RE: [PHP-WIN] Transfering database | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-23861@lists.php.net to get a copy of this message | ||
hi,
Please make it clear. My server is unix. I have no knowledge of shell commands. This is what i want.
Ex:- My username is root and database name is xyz and the .sql file is in my server www/html/test/.
What should i do
"Svensson, B.A.T. (HKG)" <B.A.T.Svensson@lumc.nl> wrote:
RTFM:
popen("mysql -u username -p database < C:\path\to\your\dump\file.sql");
shell_exec("mysql -u username -p database < C:\path\to\your\dump\file.sql");
system("mysql -u username -p database < C:\path\to\your\dump\file.sql");
etc, etc, etc...
-----Original Message-----
From: Sudeep Zamudra
To: Jeroen Serpieters
Cc: php-windows@lists.php.net
Sent: 27-5-2004 9:13
Subject: Re: [PHP-WIN] Transfering database
Thanx for your suggestions. But i am looking for a php script by which i
can do this not from the mysql shell command line. If any has it .
Please suggest it to me.
Thanx
Jeroen Serpieters wrote:
On Wed, 26 May 2004, Sudeep Zamudra wrote:
>
> I have dumped my entire database into files with extension '.sql'
(separate file for each table). Now please tell me any function or
statements if any to tranfer the contents of the file(i.e table
structure and table contents) into a new database which is on another
database server. I guess there is a statement for this. Help please.
>
--
Jeroen
There are only two kinds of programming languages: those people always
bitch about and those nobody uses.
-- Bjarne Stroustrup
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---------------------------------
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger