RE: [PHP-WIN] Transfering database

Sudeep, This is a php list, you are asking a MySQL question with no relevance to php. Check the MySQL manual for Load Infile commands. I have to admit I can never get them to work on my versions of MySQL and have tended to use other methods to load tables. As I said before, with MySQLFront, you can paste the content of your .sql file into the SQL query panel and run it. Your table will be built. I do this all the time, regardless of local or remote MySQL server. Just create your database first, open it then do the query. George in Oxford > -----Original Message----- > From: Sudeep Zamudra [mailto:sudeep_zamudra@yahoo.com] > Sent: 27 May 2004 7:14 am > To: php mailinglist > Subject: [PHP-WIN] 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