Export/Import Db in php

[Megahertza]

I have been uploading parts of my site to a free php/mysql webhost. I am having troubles moving a database and table(Using phpmyadmin). Is there a way i can export a db into a txt file using php and the to import it through php.

[matchew]

you dont have phpmyadmin?

[rincewind456]

You can run an SQL query like

SELECT * INTO OUTFILE 'c:/Temp/result.txt'  //path to file
LINES TERMINATED BY '\n'
FROM table_name;

from your normal mysql_query() function for each table, or you can just copy the entire folder within your \mysql\data folder pertaining to the db you want to your server sql folder, if you have access to it.