Hi,
Try MRTG, there are a couple of very good scripts available for monitoring
mysql, it can monitor locally for you without requiring TCP access to the
DB. This allows you to monitor (not on a real time basis though) multiple
databases and provide some nice pictures to spot errors quickly. There
Why not keep the date of birth as a standard date field and extract the
fields you need using the DATE_FORMAT function?
eg. DATE_FORMAT(date_of_birth, '%Y')
mysql \u test
Database changed
mysql create table test_dates (a int, mydate date);
Query OK, 0 rows affected (0.29 sec)
mysql describe
Have you checked out
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html, you should
be able to en/decrypt your data via these functions thereby rendering any
data on the disk totally useless unless the process comes through your mysql
server. You will have to configure mysql with
Hi Ed,
You may like to look at this, especially the last statement. If you are
not using these options however, I would suspect a bug.
Regards
--replicate-do-db=db_name
Tell the slave to restrict replication to statements where the default
database (that is, the one selected by USE) is
Hi Bruce,
Do you have any messages in the MySQL log?
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
PROTECTED]
Sent: Thursday, 30 November 2006 9:52 AM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: DROP DATABASE weirdness
I get this error:
/usr/sbin/mysqld-max: relocation error: /usr/sbin/mysqld-max: undefined
symbol: zlibCompileFlags
Logan, David (SST - Adelaide
PROTECTED]
Sent: Thursday, 30 November 2006 11:17 AM
To: mysql@lists.mysql.com
Cc: Logan, David (SST - Adelaide)
Subject: Re: DROP DATABASE weirdness
Nope, That didn't fix it. I'd uses MySQl provided rpms but they don't
seem to have them got glib23 anymore.
Suggestions?
Bruce Ferrell wrote:
I
Try http://www.php.net/manual/en/install.windows.php
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
Hi Renish,
Perhaps these might be a more appropriate forum and also get you the
result you need. This being a database list (I'm sure there are php
experts on here) is probably not quite the right place to be asking. One
of the php lists may produce a more relevant response.
Hi Patrick,
The error says a permissions problem. Did you change the ownership/group
to mysql:mysql, to the mentioned files, after you restored them?
Regards
---
** _/ ** David Logan
*** _/ ***
Hi Tanner,
These are the binary logs. Look in your my.cnf file or check your system
variable ( do this )
mysql show variables like '%log%';
and see if you have log-bin enabled. These are generally used for
recovery from the last full backup (similar to logical/redo logs in
other technologies)
Hi Folks,
Does anybody have any idea when 5.1 may come to General Release? I am
particularly interested in MySQL Cluster as I have several databases
(around 50) totalling 26Gb and would like to consider moving to this
version because of the Cluster Disk Data Storage and the fact the
current
Hi Folks,
Does anybody know if it is possible to restrict access to these commands
on an individual basis? I have a need to exclude users, who would
otherwise have most privileges, and was wondering if there was a
particular privilege that I could revoke.
If not, does anybody have a technique
Hi Anil,
Why not pipe the mysqldump direct into gzip?
eg: mysqldump etc ... | gzip -c
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/
Sounds like you will have to change the structure of your table. I would
add an auto-increment column at the beginning of the row and use that as
the primary key. You can still select on the horse, course etc. like so
SELECT * FROM horse_and_courses WHERE selection criteria ORDER BY
http://www.php.net there are many code examples here. That is a probably
more appropriate place for such a question
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
Hi Warren,
I would generally keep the binary log until you have done a full backup.
Once that is done, all the transactions that are contained in those logs
are now committed and saved in your database backup.
All binary logs may be deleted that were created before that backup took
place. The
Hi Brian,
Try having a good read here :
http://dev.mysql.com/doc/refman/5.0/en/replication.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/
Hi Daevid,
There are the binary logs. Yes they are used for replication or you can use
them much the same as a logical log exists in some other technologies.
You can find a good description of them at the mysql manual website at :
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
Hi,
Try here
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/*
The trouble with myisamchk is that it requires the server to be offline.
This may not be suitable. Do you have a bad area on the disk? The
easiest way would be to stop the server briefly, rename the index thus
keeping it occupying the potentially bad part of the disk and recreate
the index.
This
Hi Ali,
Your problem is as it states
/usr/lib/gcc/i586-suse-linux/4.0.2/../../../../i586-suse-linux/bin/ld: cannot
find -lmysqlclient
collect2: ld returned 1 exit status
The linker, ld, does not know where to find the library libmysqlclient.so. You
need to tell the linker using either
Hi Ali,
I'll repeat what I've already said, it is the ld command that is having the
problem. If you don't know what the ld command is or does, you need to look
elsewhere for the answer as this is beyond the scope of this list. As I have
previously mentioned, try
$ man ldconfig
Your problem
Hi Brett,
Can you please do the following :
SHOW MASTER STATUS; (on the master)
and
SHOW SLAVE STATUS; (on the slave)
Thanks
P.S I will be going to bed soon so don't worry if you don't hear
anything, I'll look at it first thing in the morning.
Hi Brett,
Just about to go when your email rocked up 8-) Like you, I can't see any
reason why it is not replicating according to the logs.
Have you tried to create a database on the master and see if it appears
on the slave? What commands are being replicated at this time? You can
use the
Hi Brett,
I am a little bit lost as to why this is happening. The only suggestion
I have at this point is to go through the replication troubleshooting in
this chapter and see if something there is causing the problem. Looking
at what you have done and the docs, I don't think this will help. This
Hi Brett,
I am absolutely baffled as to how the binlog/relaylog can be updated but
the dbs/tables etc. are not being touched. The only other thing is to
check the datadir on your server. Is it actually pointing to where you
think it is?
You can do a
SHOW VARIABLES LIKE 'datadir';
and check it
Another suggestion, look for other files on the system ending in .MYD or
put a query through that you know has updated a particular
table/database and do a find looking for a file that has been updated in
the last 5 minutes. See which ones have.
Regards
Hi Brett,
Did you reset the master and/or slave? Looking at the logs, it appears
as though the slave is trying to read from a different position in the
log than the master has reached.
Regards
---
** _/ ** David
Aah, sorry, I didn't explain myself very well 8-( At the mysql prompt
RESET SLAVE;
This tells the slave to reset itself back, and forget the current
settings (eg. the log position etc., not the master or such details) to
where the master started and begin replication from there. There is also
a
Hi Dominic,
Why not just use an OPTIMIZE TABLE ? This will map to an ALTER table
command for an InnoDB table which will free the now unused space. From
the manual at http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
For InnoDB tables, OPTIMIZE TABLE is mapped to ALTER TABLE, which
Try http://us2.php.net/manual/en/ref.mysql.php
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/
Hi,
There are a couple of errors in the way it is defined, firstly
1) There should be a ; after the DROP PROCEDURE statement
2) use a delimiter //, this stops the mysql client trying to interpret
the other ; as the end of the command. It then takes everything until
the next // as belonging to
Hi Scott,
mysqladmin can issue a kill from the command line. You will have to
issue a mysqladmin -u etc. etc. processlist to get the process id from
mysql and then you can issue a mysqladmin -u etc. etc. kill mysql
process id
Regards
Hi Chris,
I've noticed that a Ctrl-C will also leave the query running (5.0.22 -
Linux) and I've had to use the kill from mysqladmin or mysql client to
get rid of it.
Regards
---
** _/ ** David Logan
*** _/
Hi Michael,
I believe you can purchase a commercial license taking away the GPL
provisions from your software if you do not wish to GPL your own
software. You can enquire on the MySQL website.
Regards
---
** _/ **
Hi Chris,
I would agree, I have found it useful as well. It does have a few
limitations (well the versions I've used) but once it is up and running,
it works fine. eg. It doesn't help with replication, amongst a few
others.
I use it internally within an intranet so there isn't much of a security
Hi Michael,
Have you tried the link at the bottom of every email? If not then have you
looked here? http://lists.mysql.com/faq.php
Shouting at everybody who chooses to subscribe (which you have at some stage)
doesn't help
Regards
Hi Daniel,
Sounds like there are a few records missing out of the mysql tables. Did
you run mysql_install_db?
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Regards
---
** _/ ** David Logan
. ps auxw | grep myslqd show it
there
running.
Thanks again!
On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Daniel,
Sounds like there are a few records missing out of the mysql tables.
Did
you run mysql_install_db?
http://dev.mysql.com/doc/refman/4.1/en/unix-post
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 May 2006 10:39 AM
To: Logan, David (SST - Adelaide)
Cc: David Griffiths; mysql@lists.mysql.com
Subject: Re: i'm at a complete loss?
Nah, that's not the case my friend. I made sure that when I installed
mysql that the old one was completely removed. But, I
Hi Jørn,
I myself haven't had too many spams, I get a few anyway from various places my
email address is placed. I would suggest try unsubscribing using this alias and
just re-subscribe with your new (known only to you) alias.
Regards
Hi Ben,
Try doing
SHOW ENGINES;
and see what it says. It should say InnoDB is supported, if not then it
hasn't compiled in.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist
ent
---
-Original Message-
From: Ben Clewett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 May 2006 5:50 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re
There is no reason why you can't use single quotes around the HTML. You
don't appear to have any single quotes with the HTML so this should work
fine. Everything, including the double quotes, should be then stored in
your database.
Regards
Hi Connie,
Looks like you have hit http://bugs.mysql.com/bug.php?id=18091 (which
hasn't been fixed yet) potential solutions are documented there.
Regards
---
** _/ ** David Logan
*** _/ *** ITO
Hi Greg,
Maybe similar features to that of bacula (my current backup software of
choice for my wifes business servers). This is a very comprehensive open
source solution that has many of the features requested below. eg.
multiple servers, pooling, aging etc. It is a good example of what my
own
Hi Luke,
Like most backup systems, there is no window unless you are locking the
table/database. If the record has been read and passed out to mysqldump,
any further updates will not be included until the next backup.
The only way to ensure you get complete referential integrity is to stop
any
Hi Payne,
This should have all the info you need, there is also another command
myisamchk which requires the server to be down while it repairs.
mysqlcheck does not.
http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
Regards
---
Hi Yves,
You could also have changed the directory in the global /etc/my.cnf file
by setting
datadir=/path/to/mysql/data
This is pretty simple and works a lot easier than hacking the init
scripts.
Regards
---
** _/
Apologies, I didn't read your initial posting properly. Perhaps a glance
at this http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html would
provide you the facilities that you require for using multiple servers.
This work well and enables you to manage the multiple global
configuration files
You could further explain the lats and longs being slightly off by the
use of a different datum. There are many many datums utilised by
different geographical/geological authorities. This difference could
become quite large dependent upon the datum used.
As gmail user as noted, negative = West
Hi Pedro,
What version of MySQL are you running? From the manual
COALESCE(value,...)
Returns the first non-NULL value in the list, or NULL if there are no non-NULL
values.
mysql SELECT COALESCE(NULL,1);
- 1
mysql SELECT COALESCE(NULL,NULL,NULL);
- NULL
COALESCE() was added in
It is rather a shame if the method of reply is all that it takes to turn
you off the list. Personally the content of the list is far more
important to me.
There are forums if you want a web interface.
Having been through this argument on another list recently, I can say
there is no pleasing all
Hi Chris,
Looks like you may have to either upgrade your current server to the
version the Arch Linux was running or install a second temp server of
that version, export the databases and then import them into the ver 3.2
server.
Personally, I'd look closely at upgrading if at all possible.
in advance,
Abdul.
On Sat, 2006-04-15 at 23:35 +1000, Logan, David (SST - Adelaide) wrote:
Hi,
Also a read of
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html and
http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html would
probably
be quite helpful. The second gives you a good
Hi,
Also a read of
http://dev.mysql.com/doc/refman/5.0/en/multiple-servers.html and
http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html would probably
be quite helpful. The second gives you a good idea on how to setup the
my.cnf file for multiple servers. The concepts are the same for
Hi Tom,
Are you using the --quick option?
--quick, -q
This option is useful for dumping large tables. It forces mysqldump to
retrieve rows for a table from the server a row at a time rather than
retrieving the entire row set and buffering it in memory before writing
it out.
From the manual at
Do you have any cron jobs that clear the /tmp directory during the day?
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/*
Perhaps reading the manual would be a good start at
http://us3.php.net/manual/en/function.mysql-num-rows.php
It clearly states
Retrieves the number of rows from a result set. This command is only
valid for SELECT statements. To retrieve the number of rows affected by
a INSERT, UPDATE, or DELETE
Hi,
This is more a question of how to use php, so perhaps this page may be
of more use http://us2.php.net/manual/en/function.mysql-query.php
It gives a good explanation there of how the SELECT statement will
return the resource number on success, if you wish to access the data
returned, you
If you still have issues after that, then read
http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist -
Hi,
Looks like you don't have the DBI installed, doesn't appear to be
anything to do with the installation of MySQL. The first line of the
message states it cannot find DBI.pm in the include path.
Try installing that from CPAN and retry the installation. You may have
to set your perl paths (man
Hi Mark,
You will need to setup a processing script on your mailer that will do
that for you. Your ISP maybe able to set this up for you. Most mailers
use the aliases file for that. A quick google found this as an example,
yes it is talking to Oracle but the principles are exactly the same.
-
From: Rithish Saralaya [mailto:[EMAIL PROTECTED]
Sent: Thursday, 23 February 2006 5:02 PM
To: Logan, David (SST - Adelaide); MySQL general mailing list
Subject: RE: error 1016 : cant open ibd file even though it exists
Hello David. Thanks for the prompt response.
The permissions were the first
Hi Rithish,
Please check your ownership/permissions
hambone ~ $ perror 1
OS error code 1: Not owner
hambone ~ $
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist -
Hi Michael,
Have you considered a Master-Master (or more if required) replication
setup for achieving what you mentioned below? That would certainly
provide the I'll show you mine if you show me yours scenario.
I can recommend the High Performance MySQL book by Jeremy Zawodny as
it has an
Hi Ariel,
It works fine for me
localhost.testshow create table mytest\G
*** 1. row ***
Table: mytest
Create Table: CREATE TABLE `mytest` (
`id` int(11) NOT NULL auto_increment,
`test_col` varchar(10) default NULL,
PRIMARY KEY (`id`)
)
It looks more like you haven't run the mysql_install_db script.
From the manual :
http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html
If necessary, run the mysql_install_db program to set up the initial
MySQL grant tables containing the privileges that determine how users
are
Hi Andre,
I don't believe 4.1 is able to do this. Version 5.0.18 (latest) has the
ability to use triggers to do exactly what you describe. You may have to
consider an upgrade to achieve this functionality or do something in
php.
Regards
; Heikki Tuuri; mysql@lists.mysql.com; Logan, David (SST
- Adelaide)
Subject: Re: Surviving MySQL crash
15 * * * * /usr/local/mysql/bin/mysql -u root -pxx -e 'FLUSH
TABLES'
This would run a FLUSH TABLES once every hour at 15 minutes past. If
you
are using Windows, sorry I'm not sure how to do
---
-Original Message-
From: suomi [mailto:[EMAIL PROTECTED]
Sent: Thursday, 9 February 2006 6:47 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: Failed to upgrade from 4.1.16 to 5.0.18
Hi Dave
i did so, but probably in the wrong moment. i got Access denied when i
PROTECTED]
Sent: Thursday, 9 February 2006 10:16 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: Failed to upgrade from 4.1.16 to 5.0.18
Hi again,
it just does not work.
follows the entire dialog:
[EMAIL PROTECTED] /home/myuser/software rpm -U --nodeps
MySQL-server
Hi,
If they are MyISAM tables, you can run a FLUSH TABLES statement at a
periodic interval. A good reference is here
http://dev.mysql.com/doc/refman/5.0/en/flush.html
Regards
---
** _/ ** David Logan
*** _/
Hi,
Did you run the bin/mysql_fix_privilege_tables script? This is
documented in the upgrade procedures on the website under the
installation chapter.
Regards
---
** _/ ** David Logan
*** _/ ***
Hi Sol,
I think you can change the startup properties from the services screen.
If you right click on the MySQL service, you can set startup parameters
at the bottom of the first screen. You could set the --skip-grant-tables
there.
Regards
Hi Luiz,
If however you do not wish to create the indexes while inserting data,
you can use the following option for the mysqldump
--disable-keys, -K
For each table, surround the INSERT statements with /*!4 ALTER TABLE
tbl_name DISABLE KEYS */; and /*!4 ALTER TABLE tbl_name ENABLE KEYS
Hi Doug,
It is probably failing because you changed the ip address. The security
system in MySQL is based around where a user is coming from. There is
good documentation that is available here
http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html
I've referred to the current manual for
PROTECTED]
Sent: Tuesday, 17 January 2006 2:55 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: RE: error connecting to db.
Thanks for the link I am glad the site has added manuals for multiple
versions.
I think I have access and db privileges set properly. I can (in effect
Hi Vishwas
These and many other answers can be found here :
http://dev.mysql.com/doc/refman/5.0/en/what-is.html
There is no practical limitation on the row size apart from the number
of fields x the size of these fields. eg. 1000 fields of varchar(255) or
larger will take up that space. I don't
Hi Jason,
Most other peoples responses are excellent as usual, however might I suggest
getting a copy of High Performance MySQL by Jeremy Zawodny (O'Reilly
publishers). This covers the exact scenario you are talking about.
Regards
Hi Anthony,
If you are accessing the db from perl, just execute a show databases
from there using the DBI interface. There is quite an amount of doco
about this and other features at cpan.org. You could also look at the
source for phpMyadmin as this has to get the database names to display
them.
AM
To: Logan, David (SST - Adelaide)
Cc: Mikhail Berman; mysql@lists.mysql.com
Subject: Re: remotely show databases
On 1/9/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Anthony,
If you are accessing the db from perl, just execute a show databases
from there using the DBI
---
-Original Message-
From: Jon Miller [mailto:[EMAIL PROTECTED]
Sent: Saturday, 7 January 2006 7:58 PM
To: Logan, David (SST - Adelaide)
Subject: RE: missing mysqld.sock
Tried everything on that page and nothing help
Hi Jon,
This reference will give you all the info you need.
http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery
Hi,
Are you running mysqldump through into a pipe eg: into tar or similar? I
mention this because :
test1=perror 32
System error: 32 = Broken pipe
Regards
---
** _/ ** David Logan
*** _/ ***
Hi,
The error message (errno: 13) indicates a permissions problem. Check the
permissions of the user that is running the backups or, alternatively,
check the permissions that are set for this file.
Regards
---
** _/
Morning Jon,
You will not be too successful in using MySQL logging to trace this. You
need to be able to connect to the server at the very least before this
would help.
I don't know much about MailScanner but I would be checking a couple of
things, 1) do you have a firewall in place? is the port
Hi Hal,
You might like to try setting the umask for the mysql user. I would
think the server would abide by the OS rules for permission settings.
You may be able to set the UMASK_DIR environment variable (as described
here http://dev.mysql.com/doc/refman/5.0/en/environment-variables.html).
.
Logan, David (SST - Adelaide) wrote:
Hi James,
There are a couple of options (from the Linux side of things) :
1) set the datadir either in the start options of safe_mysqld (or
mysqld_safe I can never remember) or set it in the options file
(my.cnf
or a .my.cnf in your home directory) see
Hi James,
There are a couple of options (from the Linux side of things) :
1) set the datadir either in the start options of safe_mysqld (or
mysqld_safe I can never remember) or set it in the options file (my.cnf
or a .my.cnf in your home directory) see
Hi James,
Not AFAIK, one can create tables without specifying a PK and there is no
objection. Data is stored quite happily and you should be able to use
your FK's to access other data. It must be voluntary because the ALTER
TABLE DML statement has
DROP PRIMARY KEY drops the primary index. Note:
Hi Mark,
Have you checked to see if you any aliases set? It might be using that
instead of the mysql command. May well be worth checking your path to
ensure you aren't picking up a script called mysql or something similar.
Regards
David Logan
Database Administrator
HP Managed Services
148
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:21 PM
To: mysql@lists.mysql.com
Cc: Logan, David (SST - Adelaide)
Subject: Re: Need Help Connecting
David,
How do I do that?
Thanks
+61 417 268 665 - Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: Mark Phillips [mailto:[EMAIL PROTECTED]
Sent: Thursday, 22 December 2005 5:36 PM
To: Logan, David (SST - Adelaide)
Cc: mysql@lists.mysql.com
Subject: Re: Need Help Connecting
David,
This is what I got:
[EMAIL
Hi Marcus,
Do you have the output of the EXPLAIN? I've found the number of rows
processed to be very instructional. If you could get this number down,
it may be well worth putting an index on the account column and
re-running the EXPLAIN to see how many rows are being processed.
I recently put
Why not then use user variables? eg.
select @a:=((col1+col2+col3)/col4), @b:=((col5+col6+col7)/col8),
pow(@a,2), pow(@b,2) ... table1
Regards
David Logan
Database Administrator
HP Managed Services
148 Frome Street,
Adelaide 5000
Australia
+61 8 8408 4273 - Work
+61 417 268 665 - Mobile
+61 8
- Mobile
+61 8 8408 4259 - Fax
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 December 2005 9:34 AM
To: Logan, David (SST - Adelaide); Elmar von Muralt
Cc: mysql@lists.mysql.com
Subject: RE: How to Square a number?
At 03:30 PM 12/19/2005, Logan, David (SST
Hi Stephen,
Unfortunately this is not a moderated list. Basically anybody can join,
send an email and then vanish. Nothing much to be done about it. I would
however note, this is only about the third time in a couple of years
listening that I've seen anything.
Regards
David Logan
Database
Hi Elliot,
It is in the docs, just a little bit further down the page 8-)
LOCAL works only if your server and your client both have been enabled
to allow it. For example, if mysqld was started with --local-infile=0,
then LOCAL does not work. See Section 5.6.4, Security Issues with LOAD
DATA
1 - 100 of 200 matches
Mail list logo