Page 1 of 1

schedule export from mysql to txt-file or csv

Posted: Tue Sep 06, 2005 2:52 am
by ballamann
I need to schedule a job i windows, where i select from a table in mySQL and save the data in a txt or csv file.

; must seperate

I've created a job via php cli, that imports from a txt file, but how do i export it?

Posted: Tue Sep 06, 2005 2:58 am
by feyd
what's the intention of this export? If it's for backup only, use mysqldump (command line utility)

at any rate, you can use icron or windows' scheduled tasks.

Posted: Tue Sep 06, 2005 3:27 am
by ballamann
when i try to use the --tab=dump.txt i get:

can't create/write to file 'test1.txt\table1.sql' <Errcode:2 >

In the help it says something about mysqld deamon has to be installed on the same machine.

Can this be the problem and how do i check if this daemon is installed?

Posted: Tue Sep 06, 2005 3:34 am
by ballamann
Oh never mind, i got it to wórk