Look Sudeep, I do some research for you, all the funtions php do is on the manual, exactly on "Function Reference" Chapter LXI (Mysql). Hope this helps, but I'm agree with the guys that you need to do some research (first of all, always check the manual) before you post here. Don't take it bad, but for me, it's the way it is. Best regards, Alex ----- Original Message ----- From: "Angelo Zanetti" <binc2@xxxxxxxxxxx> To: "Sudeep Zamudra" <sudeep_zamudra@xxxxxxxxx>; "Svensson, B.A.T. (HKG)" <B.A.T.Svensson@xxxxxxx> Cc: "php mailinglist" <php-windows@xxxxxxxxxxxxx> Sent: Thursday, May 27, 2004 6:19 AM Subject: RE: Transfering database > why dont you do some research before you just expect other people to your > work for you. YOu seem to make no attempt to find out anything about what > you've asked. Svensson gave you the the commands for what you just asked. > > it's getting ridiculous, anyone second that? > > Angelo > > -----Original Message----- > From: Sudeep Zamudra [mailto:sudeep_zamudra@xxxxxxxxx] > Sent: Thursday, May 27, 2004 10:04 AM > To: Svensson, B.A.T. (HKG) > Cc: php mailinglist > 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 > > -------------------------------------------------------------------- > Disclaimer > This e-mail transmission contains confidential information, > which is the property of the sender. > The information in this e-mail or attachments thereto is > intended for the attention and use only of the addressee. > Should you have received this e-mail in error, please delete > and destroy it and any attachments thereto immediately. > Under no circumstances will the Cape Technikon or the sender > of this e-mail be liable to any party for any direct, indirect, > special or other consequential damages for any use of this e-mail. > For the detailed e-mail disclaimer please refer to > http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php