Re: Backups mechanism

2003-01-08 Thread Jon Bertsch
the script output. mysqlhotcopy db_name [/path/to/new_directory] You can find out more in the manual at: http://www.mysql.com/doc/en/mysqlhotcopy.html and here's a general intro: http://www.mysql.com/doc/en/Backup.html Sorry, there is some reading involved :-) Jon Bertsch At 04:07 P

Re: LOAD DATA LOCAL

2003-01-03 Thread Jon Bertsch
rt of the clause and give the path to the file while running the command line or SQL. Of course this approach recreates the security hole but my scripts are all behind login pages anyway. Not much help I know, but you are not the only person having this problem. Jon Bertsch At 09:38 PM 1/3/2

Load Data Local Infile

2002-12-14 Thread Jon Bertsch
=1 [mysql] local-infile=1 [mysqld] local-infile=1 to the my.cnf file but that still hasn't done it. Could it be that recompiling with --enable-local-infile is the only way to get this to work? Does anyone have any other suggestions? Thanks very mu

Load Data Infile command

2002-12-12 Thread Jon Bertsch
load data and it is part of several utility applications I use. Thanks in advance Jon Bertsch - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar