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