export z mysql

LVohralik na csas.cz LVohralik na csas.cz
Středa Srpen 30 13:20:52 CEST 2000


Cely problem tkvi v tom, ze select into outfile dokaze zalozit soubor do
adresare /tmp a tam ja nemam pristup.
Ja mam pridelen adresar /home/muj na ktery se dostanu pomoci FTP s
user/passwd, ale ten select ne.
Jak sem pochopil, problem je v userovi na ten adresar a zaroven userovi, pod
kterym bezi PHP skript.
Protoze znam nastavovani prav jen v WinNT a ackoliv sem se to snazil
pochopit v unixu - nepochopil sem to :-(
tak me nic nenapada. Jenom chmod 777 * ale to jde secure do haje...

> bud si udelejte CSV data, nebo udelat dump - viz dokumentace k mysql
> SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT]
> [SQL_BUFFER_RESULT]
>        [HIGH_PRIORITY]
>        [DISTINCT | DISTINCTROW | ALL]
>     select_expression,...
>     [INTO {OUTFILE | DUMPFILE} 'file_name' export_options]
>     [FROM table_references
>         [WHERE where_definition]
>         [GROUP BY {unsigned_integer | col_name | formula}]
>         [HAVING where_definition]
>         [ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC]
> ,...]
>         [LIMIT [offset,] rows]
>         [PROCEDURE procedure_name] ]
> 
> a ps: zkuste konferu database@

co to znamena database@ ?

> > diky
> > 			Ladislav Vohralik
> 


Další informace o konferenci Linux