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
