In all friendly manner:
Take my advice - according to your request, you only want to load this data,
so don't do this with php, do it from a command line. It is /not/ needed to
walk over the river to get to the water.
But if you don't know how to handle a command shell in unix stay away from
it! Especially if you run as root!!! Please do contact your local admin and
he will help you out - or at least somebody with some knowledge of unix
shells.
Secondly, I don't see this as my mission to be an educator about these basic
things, I suggest you get some help from professional support or something
similar instead of playing around with a system that you may damage beyond
all repair.
And by the way, I actually gave you three php examples below.
-----Original Message-----
From: Sudeep Zamudra
To: Svensson, B.A.T. (HKG)
Cc: php mailinglist
Sent: 27-5-2004 10:03
Subject: RE: Transfering database
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@xxxxxxx> 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@xxxxxxxxxxxxx
Sent: 27-5-2004 9:13
Subject: Re: 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
<http://messenger.yahoo.com/>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
