export database to a text file

[rskuse]

I have created a php form that inserts data into a MySQL database but I would like to be able to export the data directly to a text file or even an access database. Is there any way of doing this?

I have tried....
load data outfile "c:/mysql/bin/myfile.txt" from table_name but it only allowed me to do this once. Ideally I would like to just add data to the text file each time a user submits.....any ideas????

Thankyou in advance,

Rach

 

[jimoblak]

If you use Windows, go get MySQLFront from mysqlfront.de

It is a free GUI for what you want to do. You can manage records in a spreadsheet view, export and import text files, and create/modify tables.

You can also get (free) MyODBC driver from MySQL.com so that you can link your MySQL tables in a MS Access database as a 'machine source'. Editing records in the customizeable GUI of Access will automatically modify records on in your linked MySQL database.

 

[jimoblak]

After realizing "Ideally I would like to just add data to the text file each time a user submits", you may just want to create a text file on the server that gets written to at the same time a record is added or modified in the MySQL database. If you are trying to be alerted whenever someone submits something (and there may be no more than a handful of submissions in a day) you may have the server email you the user submission with a basic 'mail' command.

 

[rskuse]

I am using windows so I will try MySQLfront. Thankyou for your advice and be warned I may be back for more!!! ;o)