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 <jeroen@xxxxxxxxxxxxx> 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