Well, if you could be so kind to 1) tell what kind of RDBMS you want to load the data in, and 2) in wich format the data is in the file (a file extension is not sufficient to tell this), then actually somebody might be able to give you a proper answer as well. If the answer on 1) is MS SQL, and the answer on 2) tabdelimited, then my answer is, assuming the tables are already present in the target RDBMS, use bcp.exe. -----Original Message----- From: Sudeep Zamudra To: php mailinglist Sent: 27-5-2004 8:13 Subject: Transfering database Hi everyone, 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. Sudeep --------------------------------- 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