of 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 PM 1/7
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/2003 +0100, you wrote
]
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 much
Jon Bertsch
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 archive