Re: Perl/DBI & load data local
At 10:23 -0800 6/21/02, nellA hciR wrote: >iH > >running mySQL 3.23.51, i have a my.cnf file with local-infile=1 and >am able to use the "load data local file" command when running run >the interactive mysql app (command line). > >my problem is that i can not use the "load data local" command from >a Perl script. i am connecting as the same user and i do with the >command line. other command such as connect, disconnect, insert, >select do work > >what am i missing to allow the same access via Perl as with the command line Add: ;mysql_read_default_group=client to the end of your DSN string. > >thanks >- hcir >[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem under Solaris
Yes, it looks like the permissions are skewed. YOu might just want to do a chown -R mysql:mysql /usr/local/mysql The out-of-the-package permissions should be correct, ownership could be the issue. Regards, Bhavin. - Original Message - From: "Emiliano Marmonti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 7:36 AM Subject: Fw: Problem under Solaris > Dear people > > I have a problem installing under Solaris. I've downloaded a compiled > mysql, installed under /usr/local, create mysql group and mysql user, the > owner of mysql/data is the group mysql and everything looks well. But when I > try: > > bin/safe_mysqld --user=mysql > > The mysql starts and inmediatly ends. Looking the log file I can see > that it says: > > 020621 20:49:05 mysqld started > 020621 20:49:05 /usr/local/mysql/bin/mysqld: Can't create/write to file > '/usr/l > ocal/mysql/data/bdu.pid' (Errcode: 13) > 020621 20:49:05 /usr/local/mysql/bin/mysqld: Can't find file: > './mysql/host.frm > ' (errno: 13) > 020621 20:49:05 /usr/local/mysql/bin/mysqld: Error on delete of > '/usr/local/mys > ql/data/bdu.pid' (Errcode: 13) > 020621 20:49:05 mysqld ended > > it looks like has no rights to write the file, isn´t it. I tried to use > scripts/mysql_install_db but It says that could not find mysqld and I 've > seen that my.cnf does not exists. Is there a way to put it working or must I > download source code and compile it from scratch? > > Thanks a lot in advance > > Emiliano H.Marmonti > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Build errors with 3.23.51
Running Debian, 2.4.19pre1 kernel, gcc 3.0.4, glib-2.2.2 with linuxthreads and the
mysql-supplied linuxthreads patch.
I'm using the following configure line:
CFLAGS="-O3 -march=pentiumpro" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti" ./configure --with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static --enable-thread-safe-client
--with-other-libc=/usr/local/mysql-glibc-2.2.2
I have not successfully built against this glibc yet, however I did not receive any
unusual warnings, and no errors occured during any part of the build.
Following is the output of the configure:
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking target system type... i686-pc-linux-gnu
checking for a BSD compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... yes
checking for working aclocal... missing
checking for working autoconf... missing
checking for working automake... missing
checking for working autoheader... missing
checking for working makeinfo... found
checking whether to enable maintainer-specific portions of Makefiles... no
checking whether build environment is sane... yes
checking whether make sets ${MAKE}... (cached) yes
checking for mawk... mawk
checking for gcc... gcc
checking for C compiler default output... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for executable suffix...
checking for object suffix... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking whether we are using the GNU C++ compiler... no
checking whether gcc accepts -g... no
checking how to run the C preprocessor... gcc -E
checking "C Compiler version"... "gcc 3.0.4"
checking "C++ compiler version"... "gcc 3.0.4"
checking for ranlib... ranlib
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
loading cache /dev/null within ltconfig
checking for object suffix... o
checking for executable suffix... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.lo... yes
checking if gcc supports -fno-rtti -fno-exceptions ... yes
checking if gcc static flag -static works... -static
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the linker (/usr/bin/ld) supports shared libraries... yes
checking command to parse /usr/bin/nm -B output... ok
checking how to hardcode library paths into programs... immediate
checking for /usr/bin/ld option to reload object files... -r
checking dynamic linker characteristics... Linux ld.so
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for objdir... .libs
creating libtool
updating cache /dev/null
checking for a BSD compatible install... /usr/bin/install -c
checking for bison... bison -y
checking for pdftex... manual.pdf
checking "return type of sprintf"... "int"
checking for uname... /bin/uname
checking operating system... Linux
checking "if we should use 'skip-locking' as default for linux-gnu"... "yes"
checking for ln... /bin/ln
checking for ln... /bin/ln
checking for mv... /bin/mv
checking for rm... /bin/rm
checking for cp... /bin/cp
checking for sed... /bin/sed
checking for cmp... /usr/bin/cmp
checking for chmod... /bin/chmod
checking for hostname... /bin/hostname
checking for gnutar... no
checking for gtar... no
checking for tar... tar
checking for perl... /usr/bin/perl
checking for ps... /bin/ps
checking "how to check if pid exists"... "/bin/ps p $$PID | grep mysqld > /dev/null"
checking for kill... /bin/kill
checking "for kill switches"... "/bin/kill -0 $$PID > /dev/null 2> /dev/null"
checking for gcc option to accept ANSI C...
checking if we should use assembler functions... no
checking if we should use RAID... no
checking if we should should enable LOAD DATA LOCAL by default... no
checking for getconf... getconf
checking for CFLAGS value to request large file support... -D_FILE_OFFSET_BITS=64
checking for LDFLAGS value to request large file support...
checking for LIBS value to request large file support...
checking for _FILE_OFFSET_BITS... 64
checking for _LARGEFILE_SOURCE... no
checking for _LARGE_FILES... no
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for size_t... yes
checking for dirent.h that defines DIR... yes
checking for opendir in -ldir... no
checking for ANSI C header files...
Fw: Problem under Solaris
Dear people I have a problem installing under Solaris. I've downloaded a compiled mysql, installed under /usr/local, create mysql group and mysql user, the owner of mysql/data is the group mysql and everything looks well. But when I try: bin/safe_mysqld --user=mysql The mysql starts and inmediatly ends. Looking the log file I can see that it says: 020621 20:49:05 mysqld started 020621 20:49:05 /usr/local/mysql/bin/mysqld: Can't create/write to file '/usr/l ocal/mysql/data/bdu.pid' (Errcode: 13) 020621 20:49:05 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm ' (errno: 13) 020621 20:49:05 /usr/local/mysql/bin/mysqld: Error on delete of '/usr/local/mys ql/data/bdu.pid' (Errcode: 13) 020621 20:49:05 mysqld ended it looks like has no rights to write the file, isn´t it. I tried to use scripts/mysql_install_db but It says that could not find mysqld and I 've seen that my.cnf does not exists. Is there a way to put it working or must I download source code and compile it from scratch? Thanks a lot in advance Emiliano H.Marmonti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Nasty LIMIT/multi-table DELETE bug?
Hi, AFAIK, this problem has already been fixed by sinisa. (it was due to an uninitialized pointer) ([EMAIL PROTECTED], 2002-05-29 21:20:28+03:00, [EMAIL PROTECTED] A very nasty bug in multi-table deletes & updates sql/sql_parse.cc 1.228 02/05/29 21:20:27 [EMAIL PROTECTED] +2 -1 A very nasty bug in multi-table deletes & updates) Regards, Jocelyn - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, June 22, 2002 12:16 AM Subject: Re: Nasty LIMIT/multi-table DELETE bug? > Jon, > > - Original Message - > From: ""Jon Frisby"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Saturday, June 22, 2002 12:51 AM > Subject: Nasty LIMIT/multi-table DELETE bug? > > > > I just discovered a very scary behavior. We're using MySQL 4.0.1 on > Linux, > > both tables are InnoDB, AUTO_COMMIT is on (default) and these queries are > > being issues from the MySQL interactive console. > > > > If I do a query of the form: > > > > SELECT > > transaction_report.*, > > confirmed > > FROM > > transaction_report, > > user > > WHERE > > user_id = user.id AND > > DATE_FORMAT(when_reported, '%Y-%m-%d') = '2002-06-21' AND > > transaction_report.partner_id = 1 AND > > confirmed != 1 > > LIMIT > > 50; > > > > And then a query of the form: > > > > DELETE transaction_report FROM transaction_report, user WHERE user_id = > > user.id AND confirmed != 1; > > > > Only 50 rows will be deleted. If I reissue the DELETE, it will delete 50 > > more rows. If I reissue the SELECT with a LIMIT 20, then the DELETE > > statements will remove 20 rows. > > there were several bugs in multi-table delete in 4.0.1. I am not sure if > this is one of the bugs which have already been fixed to 4.0.2. I am Cc:ing > Sinisa who knows the answer. > > > This seems to be limited to a single connection handle (issuing the SELECT > > in one MySQL console doesn't cause problems with the DELETE in a second > > console...). > > > > -JF > > Regards, > > Heikki > Innobase Oy > > (sql database) > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: here we go again
At 16:52 -0700 6/21/02, Cindy wrote: >Bhavin Vyas writes: > >Does the error file (hostname.err) have any messages? > >OK, I didn't think to look at this: >020213 14:23:52 mysqld started >/usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: ready for >connections >020430 17:09:08 >/usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: Norma >l shutdown > >020430 17:09:09 >/usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: Shutd >own Complete > >020430 17:09:09 mysqld ended > > >So it looks like it shut down shortly after my last round with it. I can >cope with that. > >OK, so in theory I should just be able to restart this, right? >And when I restart, I have to reset the root password? So given that No, just restart it. The password doesn't have to be reset. Re: a previous question about the socket file vamoosing - yes, the server removes it when it shuts down, and recreates it when it starts up next time. >the mysql user is mysql_st, I'd do the following: > >cd /usr/local/mysql >bin/safe_mysqld --user=mysql_st >bin/mysqladmin -u root password "kool" > >and then after that, this >bin/mysql -u root -p >would work? > >"kool", being of course just used illustratively :-) > >I dunno, it seems like I just wind up reinstalling. So if any of you >see something I'm missing here, please feel free to pipe up... > >Thanks, >--Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: here we go again
Bhavin Vyas writes: >Does the error file (hostname.err) have any messages? OK, I didn't think to look at this: 020213 14:23:52 mysqld started /usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: ready for connections 020430 17:09:08 /usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: Norma l shutdown 020430 17:09:09 /usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: Shutd own Complete 020430 17:09:09 mysqld ended So it looks like it shut down shortly after my last round with it. I can cope with that. OK, so in theory I should just be able to restart this, right? And when I restart, I have to reset the root password? So given that the mysql user is mysql_st, I'd do the following: cd /usr/local/mysql bin/safe_mysqld --user=mysql_st bin/mysqladmin -u root password "kool" and then after that, this bin/mysql -u root -p would work? "kool", being of course just used illustratively :-) I dunno, it seems like I just wind up reinstalling. So if any of you see something I'm missing here, please feel free to pipe up... Thanks, --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: here we go again
Does the error file (hostname.err) have any messages? Regards, Bhavin. - Original Message - From: "Cindy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 4:34 PM Subject: here we go again > > mysql_st> /usr/local/mysql/bin/mysql -u root -p Text > Enter password: > ERROR 2002: Can't connect to local MySQL server through socket > '/tmp/mysql.sock' (2) > > > OK. The background is that mysql was started at the end of April > and then not touched since. (not used to access anything, etc). > The hostmachine was not restarted, either. > > The sticky bit in /tmp is set. I don't set up some other socket file > in my.cnf. > > A careful perusal of ps -elf shows nothing named mysql or subset > thereof seems to be running. > > This is sun solaris ultra 450. > > What I'm thinking is that mysqld shut down for some random reason and > with it the socket vamooses as well? > > I'm trying to figure out what is going *on* here. I update some stuff > about once a quarter with mysql but every single time I come back to > it, despite having carefully set it up to work last time, I get this > crap, try to restart mysqld, have a hell of a time doing so, and end > up reinstalling the whole damn thing, only to start over again next > time. Well this time, I'm yapping for help before touching a single > thing, because I don't want to do this *again*. > > What is happening? > > --Cindy > -- > [EMAIL PROTECTED] > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
here we go again
mysql_st> /usr/local/mysql/bin/mysql -u root -p Text Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) OK. The background is that mysql was started at the end of April and then not touched since. (not used to access anything, etc). The hostmachine was not restarted, either. The sticky bit in /tmp is set. I don't set up some other socket file in my.cnf. A careful perusal of ps -elf shows nothing named mysql or subset thereof seems to be running. This is sun solaris ultra 450. What I'm thinking is that mysqld shut down for some random reason and with it the socket vamooses as well? I'm trying to figure out what is going *on* here. I update some stuff about once a quarter with mysql but every single time I come back to it, despite having carefully set it up to work last time, I get this crap, try to restart mysqld, have a hell of a time doing so, and end up reinstalling the whole damn thing, only to start over again next time. Well this time, I'm yapping for help before touching a single thing, because I don't want to do this *again*. What is happening? --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
DBug Test Signal/Illegal Op received with Show table status comand
hello, i'm using mysql 3.23.51-max on windows 98. It worked fine up until the point where I started using a PHP app that used the command SHOW TABLE STATUS FROM tablename. Everytime this is executed Mysql gives me a dialog window that says Test Signal with an OK button, then I get an illegal op. I can do a regular SHOW STATUS w/o problems as well as other SHOW statements. I have no idea why this particular one is causing problems. I really need to figure this out as the PHP app I use depends on this command it seems. It seems that trying to use the other binaries included in the mysql package (mysqld-max, mysqld-nt, etc.) all but freeze up when I attempt a SHOW TABLE STATUS command; other commands work fine though. With the other binaries I'm not given the small dialog window that says Test Signal. I'm just given the illegal op window. Can anyone help? Thanks brandon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Nasty LIMIT/multi-table DELETE bug?
Jon, - Original Message - From: ""Jon Frisby"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, June 22, 2002 12:51 AM Subject: Nasty LIMIT/multi-table DELETE bug? > I just discovered a very scary behavior. We're using MySQL 4.0.1 on Linux, > both tables are InnoDB, AUTO_COMMIT is on (default) and these queries are > being issues from the MySQL interactive console. > > If I do a query of the form: > > SELECT > transaction_report.*, > confirmed > FROM > transaction_report, > user > WHERE > user_id = user.id AND > DATE_FORMAT(when_reported, '%Y-%m-%d') = '2002-06-21' AND > transaction_report.partner_id = 1 AND > confirmed != 1 > LIMIT > 50; > > And then a query of the form: > > DELETE transaction_report FROM transaction_report, user WHERE user_id = > user.id AND confirmed != 1; > > Only 50 rows will be deleted. If I reissue the DELETE, it will delete 50 > more rows. If I reissue the SELECT with a LIMIT 20, then the DELETE > statements will remove 20 rows. there were several bugs in multi-table delete in 4.0.1. I am not sure if this is one of the bugs which have already been fixed to 4.0.2. I am Cc:ing Sinisa who knows the answer. > This seems to be limited to a single connection handle (issuing the SELECT > in one MySQL console doesn't cause problems with the DELETE in a second > console...). > > -JF Regards, Heikki Innobase Oy (sql database) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Nasty LIMIT/multi-table DELETE bug?
I just discovered a very scary behavior. We're using MySQL 4.0.1 on Linux, both tables are InnoDB, AUTO_COMMIT is on (default) and these queries are being issues from the MySQL interactive console. If I do a query of the form: SELECT transaction_report.*, confirmed FROM transaction_report, user WHERE user_id = user.id AND DATE_FORMAT(when_reported, '%Y-%m-%d') = '2002-06-21' AND transaction_report.partner_id = 1 AND confirmed != 1 LIMIT 50; And then a query of the form: DELETE transaction_report FROM transaction_report, user WHERE user_id = user.id AND confirmed != 1; Only 50 rows will be deleted. If I reissue the DELETE, it will delete 50 more rows. If I reissue the SELECT with a LIMIT 20, then the DELETE statements will remove 20 rows. This seems to be limited to a single connection handle (issuing the SELECT in one MySQL console doesn't cause problems with the DELETE in a second console...). -JF - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error on insert statement...
Can someone tell me what this means? I mean, I guess I *know* what it means, but why? The insert statement into a mysql database is... 'insert into works values(?, ?, ?, ?, ? ,?)' The invocation of the dynamic sql is... status = cur_mysql.execute(sql, (wrk_inst, ZERO, trs_inst, aas_inst, title, NADA)) (ZERO = 0L and NADA = 'N/A') I do a print of the wrk_inst, trs_inst, aas_inst (and zero and nada) followed by a print of title before the error... 80956 177802 0 0 N/A WANTED ... A BROTHER ...here is the error... Exception in Tkinter callback Traceback (most recent call last): File "C:\Python22\lib\lib-tk\Tkinter.py", line 1292, in __call__ return apply(self.func, args) File "C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo g\catalog_gui.py", line 82, in engage catalog.extract_works() File "C:\Documents and Settings\mjessop\My Documents\Python Development\Catalo g\catalog_model.py", line 249, in extract_works (wrk_inst, ZERO, trs_inst, aas_inst, title, NADA)) File "C:\Python22\Lib\site-packages\MySQLdb\cursors.py", line 70, in execute raise ProgrammingError, m.args[0] ProgrammingError: not all arguments converted == here is a description of the database table... mysql> describe works -> ; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | wrk_inst | int(11) | | MUL | 0 | | | sinker | int(11) | | MUL | 0 | | | trs_inst | int(11) | YES | | 0 | | | aas_inst | int(11) | YES | | 0 | | | title| varchar(255) | YES | | NULL| | | pub_name | varchar(80) | YES | | NULL| | +--+--+--+-+-+---+ 6 rows in set (0.03 sec) Any thoughts? Thank you, in advance... +++-+++--+++ + Michael S. Jessop+ | Senior Web Developer | + Copyright Clearance Center, Inc. + +++-+++--+++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: please modify init.d script
On Fri, 2002-06-21 at 12:09, Gerald Clark wrote: > Or better yet, > add a sleep 2 to the beginning of the init.d program you are starting > that expects to connect to mysql. > > Why slow down the booting for everybody when some other daemon that > expects to connect to mysql > can not handle a failed connect properly? Because you have to do that for every service that uses MySQL (that means modifying lots of things) when, in fact, the problem is in MySQL's script (and it could be fixed modifying that one script). I don't quite understand why one would care so much about a couple of seconds of boot time? It's not like you reboot the production servers every day. And, BTW, we're talking about Unix, right? Not Windows RebootME. ;-) I would be much more concerned about the reliability of the boot-up process, than with some unrealistic "mine boots up one milisecond faster that yours". Reliability is _much_ more important than one second added to boot-up time. My customers wouldn't care too much if my servers came back one second later, but they would care very much if the servers came back without running some critical services. This is about playing by the rules too: when the init.d script returns, and it reports "OK" or success, or whatever, then it should tell the truth. Right now, mysql's init.d script is lying; it reports success, while MySQL didn't in fact finished the boot-up process. It is conceivable that it might actually fail later, because it still has a few things to do after the script already returned control (and happily reported success). This rule is observed by the init.d scripts of most of the other daemons. For example, Squid's script does not return control when shutting down the daemon until the daemon really closed all filedescriptors; on a very busy caching proxy, that might take one minute to complete (and i've seen even longer times occasionally)! But hey, one has to clean up its own mess, right? If you don't do that (wait for the proxy to properly terminate connections/flushing buffers), the init hierarchy would end up SIGKILLing squid at the end, with the risk of terminating active filedescriptors, etc. You only have to SIGKILL it if indeed it takes an exagerated time to shut down, and that means there's a problem hidden somewhere, and now you are aware of it and you can fix it. -- Florin Andrei "You can get excited about just any subject if you study it enough. It's the deep knowledge that makes a topic interesting." - Larry McVoy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Foreign Key Worries
Hello. On Fri 2002-06-21 at 10:47:28 -0400, [EMAIL PROTECTED] wrote: > On Thursday 20 June 2002 21:15, Benjamin Pflugmann wrote: > > > IMHO, the interesting question is: how could the tables get out of > > sync, in a way that foreign keys would be able to prevent? I am not > > able to see a way in everyday work (explicitly filling in nonsense > > does not count). > > > > The only thing I can see that could happen in normal use is that you > > get an entry for orders but none in orderItems, because a program is > > interrupted. That could happen with foreign keys as well. > > > Well, there are a couple of considerations. When you simply consider > something simple like you have a webapp and it manipulates a database, then > its probably not too much of a concern that things can get out of sync. The > world is rarely that simple though. Over time its quite possible other bits > of code will be written for various reasons which access the same data, for > purposes of archiving, reporting, order fulfillment, etc. Some of that code > is bound to monkey with the database, and all it takes is one bad piece of > code to botch things up. > > Aside from using key constraints, the other strategy is to use transactions. Yes, I absolutely agree, transaction would help. But we were talking about foreign keys. [...] > While, as the previous poster suggested, you can use some sort of flag, this > has several implications and doesn't entirely solve the problem. 1st of all > it doesn't prevent an order from never being flagged as complete when it > should be. Neither do foreign keys. > 2nd the code is less certain to behave properly in the case where an > insert of one item in an order fails but others don't. How would foreign keys help? All items refer to the order, which already has been inserted. So the foreign keys constraint is fulfilled even if some of the item inserts fail. > A slight error in the code could lead to half an order in this case > once again. Same with foreign keys. The only thing foreign keys can prevent, is that someone writes a sloppy program where a items refers to a non-existing order. But then, there are so many ways how the program can mix up, that I would not rely on them (e.g. use always "1" as orderid and foreign keys will be happy - as there is quite probably an order "1"). > Given that you don't have transactions or foreign keys available at > this time you might want to do as suggested, but I'd upgrade to a > version of MySQL that does support them as soon as possible. If you meant to say, using transaction would have been the Right proposal, instead of a "state" column, I agree. But, then, you just answered yourself why I did not. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: locking on row level ...
Michael, - Original Message - From: "Michael Bacarella" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> > > SELECT * FROM mytable WHERE mycol = xxx LOCK IN SHARE MODE; > > > > or > > > > SELECT * FROM mytable WHERE mycol = xxx FOR UPDATE; > > > > > > The upper query sets a shared lock (= read lock), and the lower one an > > exclusive lock (= write lock) on the row. > > While we're on the subject (Heikki, I know I need to get back to you on something > else, will do that soon ), I'm having a problem that involves locks. > > Deadlocks. We maintain tables to store user session information. These > tables are updated constantly, and can grow quite large over time. A maintenance > script runs every day which deletes records older than 24 hours. > > In the olden days with MyISAM, ''DELETE FROM blah WHERE TS < timestamp'' would just set > a table lock and stop the site for a few seconds. With InnoDB, it of course keeps on chugging you can set a table lock also on an InnoDB table with LOCK TABLES yourtable WRITE; before you do the big delete. This will not prevent all deadlocks or lock wait timeouts because some smaller transactions may have already acquired row locks on the table when the big transaction gets the table lock. In that case you can try wrapping also some of your smaller transactions inside LOCK TABLES to serialize them. > I can think of plenty of better workarounds, but I wanted to solicit input before > implementing something that I may not have to. > > Suggestions? ;) > > -- > Michael Bacarella | Netgraft Corporation >| 545 Eighth Ave #401 > Systems Analysis | New York, NY 10018 > Technical Support | 212 946-1038 | 917 670-6982 > Managed Services | [EMAIL PROTECTED] Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: please modify init.d script
Or better yet, add a sleep 2 to the beginning of the init.d program you are starting that expects to connect to mysql. Why slow down the booting for everybody when some other daemon that expects to connect to mysql can not handle a failed connect properly? Florin Andrei wrote: >The init.d script provided with the MySQL RPMs has a problem: if an >application depends on MySQL (say, it's a daemon logging some data in >MySQL), and this application starts right after MySQL, it usually fails. > >The reason is, when the init.d/mysql script returs, usually MySQL is not >fully running, but it's still initializing some stuff. If the other >application has its init.d script right after, it fails to connect to >the database, because the database does not run yet. Depending on the >application, then the application itself might fail to start altogether. > >Please add a delay (like "sleep 2" or something like that) to the start >function in the init.d script. Or modify the start function to not >return until MySQL has booted up properly. Like: > >while [it didn't started yet]; do > sleep 1 >done > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
please modify init.d script
The init.d script provided with the MySQL RPMs has a problem: if an application depends on MySQL (say, it's a daemon logging some data in MySQL), and this application starts right after MySQL, it usually fails. The reason is, when the init.d/mysql script returs, usually MySQL is not fully running, but it's still initializing some stuff. If the other application has its init.d script right after, it fails to connect to the database, because the database does not run yet. Depending on the application, then the application itself might fail to start altogether. Please add a delay (like "sleep 2" or something like that) to the start function in the init.d script. Or modify the start function to not return until MySQL has booted up properly. Like: while [it didn't started yet]; do sleep 1 done -- Florin Andrei "You can get excited about just any subject if you study it enough. It's the deep knowledge that makes a topic interesting." - Larry McVoy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl/DBI & load data local
iH running mySQL 3.23.51, i have a my.cnf file with local-infile=1 and am able to use the "load data local file" command when running run the interactive mysql app (command line). my problem is that i can not use the "load data local" command from a Perl script. i am connecting as the same user and i do with the command line. other command such as connect, disconnect, insert, select do work what am i missing to allow the same access via Perl as with the command line thanks - hcir [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MSAccess to MySQL
GlacierWhen trying to transfer a database from MS Access 2000 to MySQL, I encounter this error message, "ODBC--call failed. 37000: [Microsoft][ODBC microsoft Access Driver] Syntax error in CREATE TABLE statement. I am using MyAccess to do the transfer. I am new at this in the MySQL area and, am running out of ideas. Can anyone please, help me. Thank you for your time! jeff --- [This E-mail scanned for viruses by The Park Net] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL dump/recovery - no bug at all
Thank you very much for your quick and accurate responses.
I tried to dump with the -Q (--quote-names) and it perfectly works.
I'm not completely sure I understood what Tod Harter meant in his mail,
because I set up an 'automated' backup process, and if I would ever need
to recovery our main DB, I would not like to manually edit the SQL
script generated by mysqldump, so I can't remove indexes creation before
uploading data.
My only doubt remains if there could ever be any concern about quoting
names while dumping; I mean, if not, why don't setting it as the
default?
Anyway thank you very much again, the problem is solved.
Regards,
Stefano
> -Original Message-
> From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
> Sent: 21 June 2002 16:31
> To: [EMAIL PROTECTED]
> Subject: Re: MySQL dump/recovery probable bug
>
>
> Stefano,
> Friday, June 21, 2002, 4:43:29 PM, you wrote:
>
> SI> I found the following problem, which I consider a bug,
> but maybe I'm missing something to make it work correctly.
>
> SI> I'm using 'mysqldump' to backup our MySQL DB, and when I
> try to recover it on a blank DB it gives syntax errors while
> creating some table.
> SI> This is the Table structure which cause the error :
>
> [skip]
>
> SI> When I try to run this command on the mysql console, I
> receive the following error :
> SI> mysql> CREATE TABLE Test (
> SI> -> ID int(10) unsigned NOT NULL auto_increment,
> SI> -> IL varchar(12) NOT NULL default '',
> SI> -> Item_ID int(10) unsigned NOT NULL default '0',
> SI> -> BLDate datetime NOT NULL default '-00-00 00:00:00',
> SI> -> RelToTest datetime default NULL,
> SI> -> RelToRegr datetime default NULL,
> SI> -> RelToNPI datetime default NULL,
> SI> -> RelToCCO datetime default NULL,
> SI> -> SanityResult enum('None','Green','Red') NOT NULL
> default 'None',
> SI> -> PRIMARY KEY (ID),
> SI> -> UNIQUE KEY Load (IL,Item_ID)
> SI> -> ) TYPE=MyISAM COMMENT='SCM Internal Loads table';
> SI> ERROR 1064: You have an error in your SQL syntax near
> 'Load (IL,Item_ID)
> SI> ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
>
> [skip]
>
> SI> Is really urgent for us to solve this problem, because
> our DB is growing fast and we would like to have a consistent Backup.
> SI> If I'm doing something wrong, please tell me.
>
> LOAD is a reserved word:
> http://www.mysql.com/doc/R/e/Reserved_words.html
>
> It's not recommended to use reserved words in table/column/key etc
> names...
> You can fix you problem just quoting LOAD with a ``' characters. Use
> -Q or --quote-names option of mysqldump.
>
> SI> Best Regards,
> SI> Stefano
>
>
>
>
> --
> For technical support contracts, goto
> https://order.mysql.com/?ref=ensita
> This email is sponsored
> by Ensita.net http://www.ensita.net/
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Victoria Reznichenko
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
><___/ www.mysql.com
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Migration of a database from mSQL 2.x to MySQL 3.23.51
Hi, Mark Hennessy wrote: > I have decided to use MAX(tablename_index)+1 in advance of inserting the > record, as I want to use as little dbms-specific magic as possible and > this matches as close as I can figure the behavior of _seq in mSQL. > > I would be doing the following in the same thread in this order: > $id=SELECT MAX(tablename_index)+1; > INSERT into tablename VALUES($id,...); > > Would it be prudent to wrap a rw lock around this? Yes. Unless you are 100% sure that you will never have 2 threads doing it at the same time ;) > > -- > Mark P. Hennessy [EMAIL PROTECTED] > Regards -- Joseph Bueno - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: locking on row level ...
On Fri, Jun 21, 2002 at 12:38:06AM +0300, Heikki Tuuri wrote: > InnoDB type tables in MySQL have row level locking. Call SET AUTOCOMMIT=0 or > wrap your transaction in BEGIN ... COMMIT. > > Make sure you have an index on column 'mycol' so that InnoDB finds the row > without a table scan. Then you can lock a row: > > SELECT * FROM mytable WHERE mycol = xxx LOCK IN SHARE MODE; > > or > > SELECT * FROM mytable WHERE mycol = xxx FOR UPDATE; > > > The upper query sets a shared lock (= read lock), and the lower one an > exclusive lock (= write lock) on the row. While we're on the subject (Heikki, I know I need to get back to you on something else, will do that soon ), I'm having a problem that involves locks. Deadlocks. We maintain tables to store user session information. These tables are updated constantly, and can grow quite large over time. A maintenance script runs every day which deletes records older than 24 hours. In the olden days with MyISAM, ''DELETE FROM blah WHERE TS < timestamp'' would just set a table lock and stop the site for a few seconds. With InnoDB, it of course keeps on chugging along--in theory. Most of the time this transaction fails on us with an error message about a deadlock being detected. My current workaround is to now let this accumulate for a week and stop the web servers while I clean the tables out--very undesired. The site is multilingual and is busy almost 24 hours a day, so there's no real slow period where the maintenance scripts run with less contention issues. I can think of plenty of better workarounds, but I wanted to solicit input before implementing something that I may not have to. Suggestions? ;) -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
64 Bit mysqld on Solaris
Does anyone out there have any experience running a 64 bit mysql server on solaris? Here's my issue: I have compiled mysql 3.23.51, with Sun's C compiler from Sun ONE Studio 7 (C compiler version 5.4, one up from Forte 6.2). The compile options were thus: setenv CC cc setenv CXX CC setenv CFLAGS "-fast -xarch=v9a" setenv CXXFLAGS "-fast -xarch=v9a" ./configure --prefix=/usr/local/mysql --without-bench --with-mysqld-user=mysql --without-docs --with-pthread --enable-thread-safe-client --with-comment Everything compiled and installed fine. The problem is when I try to start the server (from the error log): 020621 10:11:59 mysqld started 020621 10:11:59 /usr/local/mysql/libexec/mysqld: Out of memory (Needed 3248151704 bytes) 020621 10:11:59 /usr/local/mysql/libexec/mysqld: 'host.ISD' is locked against change 020621 10:11:59 /usr/local/mysql/libexec/mysqld: Normal shutdown 020621 10:11:59 mysqld ended It's asking for just a hair over 3 GB of ram. Looking through the manual, I can only find references to the out of memory error when dealing with a client query. Has anyone else come across this? I know mysql has to be in other 64bit environments (alpha, etc). Thanks for all your help. Matt Patterson [EMAIL PROTECTED] Programmer, Solinus, Inc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Referring Page in PHP/SQL
This question is more appropriate for the PHP list.
Here is an example:
// if row exists - login/pass is correct
if (mysql_num_rows($result) == 1)
{
// initiate a session
session_start();
// register the user's ID and permission level
list($uid, $uperms) = mysql_fetch_row($result);
$_SESSION{UID} = '$uid';
$_SESSION{UPERMS} = '$uperms';
// redirect to main menu page
header("Location:menu.php");
mysql_free_result ($result);
// close connection
mysql_close($connection);
}
else
// login/pass check failed
{
mysql_free_result ($result);
mysql_close($connection);
// redirect to error page
header("Location: error.php?e=0");
exit;
}
-Steve
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: auto_increment and clustering sequence
In the last episode (Jun 21), Bill Ferrett said:
> I would like to have a MySql table where each row has a unique id
> (using auto-increment) but is clustered, i.e. physically stored, in a
> different sequence, e.g. name. This is so that an sql query to order
> by namew will be quicker.
>
> I don't want the auto-increment id to be duplicated - I believe this
> happens when the auto_increment column is not the first column - so a
> multi-column index of name,id seems to be out.
Your choice of primary key has no bearing at all on where mysql decides
to store a row in MyISAM tables. It has a slight bearing on BDB and
InnoDB tables, since they are really index-organized tables. You'll
get clustering but not sequential order through the entire table.
You can guarantee uniqueness of the auto_increment column by creating
another unique index (not primary, just unique) on the id column.
So basically, do this:
CREATE TABLE mytable (
id INTEGER AUTO_INCREMENT,
name VARCHAR(20),
{other fields}
PRIMARY KEY (name, id),
UNIQUE INDEX (id)
) TYPE={InnoDB/BDB};
and you're set.
--
Dan Nelson
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Migration of a database from mSQL 2.x to MySQL 3.23.51
I have decided to use MAX(tablename_index)+1 in advance of inserting the
record, as I want to use as little dbms-specific magic as possible and
this matches as close as I can figure the behavior of _seq in mSQL.
I would be doing the following in the same thread in this order:
$id=SELECT MAX(tablename_index)+1;
INSERT into tablename VALUES($id,...);
Would it be prudent to wrap a rw lock around this?
--
Mark P. Hennessy [EMAIL PROTECTED]
On Wed, 19 Jun 2002, Mark Hennessy wrote:
> Date: Wed, 19 Jun 2002 14:44:49 -0400 (EDT)
> From: Mark Hennessy <[EMAIL PROTECTED]>
> To: Gerald Clark <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Migration of a database from mSQL 2.x to MySQL 3.23.51
>
> I don't see how AUTO_INCREMENT preserves its value in the output of a
> mysqldump.
>
> --
> Mark P. Hennessy [EMAIL PROTECTED]
>
> On Wed, 19 Jun 2002, Gerald Clark wrote:
>
> > Date: Wed, 19 Jun 2002 13:33:00 -0500
> > From: Gerald Clark <[EMAIL PROTECTED]>
> > To: Mark Hennessy <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: Migration of a database from mSQL 2.x to MySQL 3.23.51
> >
> > Use AUTO_INCREMENT.
> > Why should there be a problem restoring?
> >
> > Mark Hennessy wrote:
> >
> > >I'm using DBI/DBD with Perl 5.6.1 to send queries to this database.
> > >
> > >I'm a relative newbie to DB design, I have done some basic administration
> > >for clients. I ask:
> > >
> > >1) In the database I plan on migrating, I have a few simple tables which
> > >use "select _seq" to increment the index value for each table as insert
> > >queries are done. I looked at AUTO_INCREMENT in MySQL and couldn't see
> > >how one would restore from backup (backups made by mysqldump) the last
> > >AUTO_INCREMENT value for a table. I am thinking of using:
> > >
> > >select MAX('tablename_index')+1 from tablename
> > >
> > >instead of mucking around with AUTO_INCREMENT. I plan on making an
> > >insert query with the resulting value in the same session in DBI. Is it
> > >likely that I need to worry about locking the table for this process?
> > >
> > >I don't want to even think about backfilling, so MAX+1 seems fine for what
> > >I'm doing.
> > >
> > >If I understand correctly, as the field is designated as an index, MAX for
> > >it is a stored value and thus is selected very quickly.
> > >
> > >2) Are there any known problems in 3.23.51 stable that would muck with
> > >something as simple as described above?
> > >
> > >Any suggestions?
> > >
> > >--
> > > Mark P. Hennessy[EMAIL PROTECTED]
> > >
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: locking on row level ...
On Thursday 20 June 2002 17:50, Cal Evans wrote: What you want to do is wrap the update in a transaction with transaction isolation level set to SERALIZABLE. This should insure that whichever client is first to initiate the transaction will have effectively exclusive access to the record in question. Thus something like. SET AUTOCOMMIT=0 SET TRANSACTION ISOLATION LEVEL SERIALIZABLE BEGIN SELECT UPDATE COMMIT If both clients do this, then I believe you should insure that whichever client gets to the database first will be able to read the record and update it before the other client even gets to see the data. Note however that effectively what is happening is that a lock is being set on ALL the rows in the SELECT clause, so every other access to the table will block until the transaction completes. It can, needless to say, have a negative effect on database performance... > Short answer: > You don't. That's not the way SQL databases work. When you hear of 'row > level locking' it means something different than you are used to if you are > coming from Access/Foxpro. > > If you are using InnoDB tables then you can: > BEGIN TRANS > statement > statement > statement > COMMIT or ROLLBACK > > > Long answer: > If you are coming from a FoxPro background (as I am) then you are used to > being able to issue a RLOCK() and the database will place a lock on that > record not allowing anyone else to touch it into you are done with it. (If > your background is not FoxPro then I'm sure the desktop DB you are using > has something similar). > > You don't do that in SQL. > > However, in times past, when I've felt the overwhelming urge to regress, I > have built systems that have a LOCK field. (i.e. userLock varChar(10)) > Then when someone wanted to 'lock' the record, I would write their userID > in the lock field with an update statement. > > Then before granting someone else a lock on the record, I would check to > make sure that someone else didn't already have it locked. The downside to > this methodology is that you are increasing your hits on the database > server. If your application is not busy then it's not a major deal. If, > however, you have a busy server, this will cause it to be busier. > > Once the user with the lock issues their UPDATE statement then I issue a > second UPDATE to clear the lock (or if you want to get fancy, clear it in > the first UPDATE with a userLock='') > > Anyhow, if you study how databases are built in SQL you won't find a lot of > this type of programming. I now rely much more on transactions to keep > things straight. Yes, this means that two users could issue updates almost > at the same time. Last one to the database wins. > > HTH, > =C= > > -Original Message- > From: Silmara Cristina Basso [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 19, 2002 1:10 PM > To: [EMAIL PROTECTED] > Subject: locking on row level ... > > > I'm newbie MySQL and I'm using MySQL-max 4.0.1(Innodb), with one > application developed in Delphi and connect through MyODBC. The question is > ... How can i do to lock one row so that it is editing in the application? > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: MySQL does not always recognize \n as a field terminator while loading data from txt file
> Esp on windows machines this is a good idea, newlines > there tend to end up being who-knows-what... It is known exactly what they end up being. Any software that is written with any sort of vague attempt to be portable and/or actually useful to its users in a mixed environment, rather than being written to make some sort of political or religious point, will cope, on either platform, with either form of line ending if at all possible (which for text file input it almost always is). Anybody whose anti-Microsoft religious mania forces them to deliberately write code that doesn't cope with both sorts of line endings really should consider a career change. Tim Ward Brett Ward Limited - www.brettward.co.uk sql,query --- This e-mail and the information it contains are confidential and may be privileged. If you have received this e-mail in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person. All emails to and from ip.access may be monitored and stored for audit and other legal reasons. --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Referring Page in PHP/SQL
Hi All, Can anyone help me on how to call up an HTML page in PHP after a succesful entry, example I don't want to have to type the HTML code again in between the php code because the page I need is already at another URL. If anyone knows what I am talking about please help. Toks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: "INSERT INTO" vs. "REPLACE INTO"
You'll have much less overhead checking with a select first and then insert if not exists olinux --- Sebastian Bergmann <[EMAIL PROTECTED]> wrote: > [resent; original posting didn't make it (through > the spam protection)] > > With phpOpenTracker I have for instance the > following table > > CREATE TABLE pot_foo ( > data_id int(11) NOT NULL, > string varchar(255) NOT NULL > > PRIMARY KEY (data_id) > ) DELAY_KEY_WRITE=1; > > For each visitor, I need to make sure that I have > a row for the > current (data_id, string) pair in the table. > > For performance reasons it makes no sense to use a > SELECT query to > determine whether or not the row in question > already exists in the > table. > > So, what is the better / faster way to do this > with MySQL: > > 1) Use "REPLACE INTO" at the cost of deleting > the old row (which >is identical!) every time. > > 2) Use "INSERT INTO" and ignore the failure of > the query if the >row (ie. the PRIMARY KEY) already exists. > > -- > Sebastian Bergmann > http://sebastian-bergmann.de/ > http://phpOpenTracker.de/ > > Did I help you? Consider a gift: > http://wishlist.sebastian-bergmann.de/ > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Foreign Key Worries
On Thursday 20 June 2002 21:15, Benjamin Pflugmann wrote: > IMHO, the interesting question is: how could the tables get out of > sync, in a way that foreign keys would be able to prevent? I am not > able to see a way in everyday work (explicitly filling in nonsense > does not count). > > The only thing I can see that could happen in normal use is that you > get an entry for orders but none in orderItems, because a program is > interrupted. That could happen with foreign keys as well. > Well, there are a couple of considerations. When you simply consider something simple like you have a webapp and it manipulates a database, then its probably not too much of a concern that things can get out of sync. The world is rarely that simple though. Over time its quite possible other bits of code will be written for various reasons which access the same data, for purposes of archiving, reporting, order fulfillment, etc. Some of that code is bound to monkey with the database, and all it takes is one bad piece of code to botch things up. Aside from using key constraints, the other strategy is to use transactions. That does protect you against the problem of an aborted update. The two should be used together really, that way you not only can't create an order for a non-existent item, you also can't end up with HALF an order in the system, which is just as important. While, as the previous poster suggested, you can use some sort of flag, this has several implications and doesn't entirely solve the problem. 1st of all it doesn't prevent an order from never being flagged as complete when it should be. 2nd the code is less certain to behave properly in the case where an insert of one item in an order fails but others don't. A slight error in the code could lead to half an order in this case once again. Given that you don't have transactions or foreign keys available at this time you might want to do as suggested, but I'd upgrade to a version of MySQL that does support them as soon as possible. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
auto_increment and clustering sequence
I would like to have a MySql table where each row has a unique id (using auto-increment) but is clustered, i.e. physically stored, in a different sequence, e.g. name. This is so that an sql query to order by namew will be quicker. I don't want the auto-increment id to be duplicated - I believe this happens when the auto_increment column is not the first column - so a multi-column index of name,id seems to be out. Can I do this and if so how? Many thanks -- Bill Ferrett Accroserve Systems Ltd. Office: 01702 342148 Mobile: 07855 868565 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: restart/flush needed when using symlinks?
Hello Is a restart/reload or a "flush tables" necessary when creating or removing databases? bye, -christian- cookie-for-the-robot: sql,query -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Authorized Reseller - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: @@IDENTITY
On Friday 21 June 2002 06:55, Arul wrote:
No, but last_insert_id() is only valid until you do another query on the same
database handle. The only explanation I can think of is that somehow you're
code is interjecting some other query between the insert and the call to
last_insert_id(). Maybe a commit? I'd make sure that the very next thing you
do after insert is to get that id.
> Even the last_insert_id() returns 0
> is it coz the table type is INNODB
>
>
> - Original Message -
> From: "Jan Peuker" <[EMAIL PROTECTED]>
> To: "Arul" <[EMAIL PROTECTED]>
> Sent: Friday, June 21, 2002 4:16 PM
> Subject: Re: @@IDENTITY
>
> > You are using M$-Syntax, in MySQL you should use:
> > SELECT last_insert_id()
> > http://www.mysql.com/doc/e/x/example-AUTO_INCREMENT.html
> >
> > regards,
> >
> > jan
> >
> >
> > - Original Message -
> > From: Arul
> > To: MySQL
> > Sent: Friday, June 21, 2002 12:17 PM
> > Subject: @@IDENTITY
> >
> >
> >Hi
> >
> > I m using mysql 3.23.51 on win 2k
> >
> > Well..I have a user table where i have the userid column as primary key
>
> and
>
> > auto_increment column and name as varchar(25).
> >
> > I insert values in the table such as
> >
> > Insert into user (name) values ('AA');
> >
> > Then When i do select @@Identity in the next time , it tells me as 0
> >
> > Why is this happenning..
> >
> > I need to get the last inserted value of the primary key ..right
> >
> > -Arul
> >
> >
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php (the manual)
> >http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL does not always recognize \n as a field terminator while loading data from txt file
On Friday 21 June 2002 08:31, Roger Baklund wrote: > * Podhorski, Adam use the perl "chomp()" function... It strips off any sort of "newlinish" trash at the end of the line, then explicitly tack a '\n' onto the end before you feed it to MySQL. Esp on windows machines this is a good idea, newlines there tend to end up being who-knows-what... > > > If I don't put the tab before the the end of the line in the txt file > > that contains the data, mySQL does not properly put the data into table > > using LOAD DATA INFILE. > > [...] > > > But if there is only a \n at the end of the line (e.g. > > 1\tTC446696\tTC27867\n), the data gets corrupted and even the display > > does not proerly work (note the wrong vertical column bars for display) > > > > mysql> SELECT * FROM tigr_mgi_tcs; > > ++--++ > > > > | ID | TC | TC_Synonym | > > > > ++--++ > > > >| | TC446696 | TC27867 > >| | TC446696 | TC37198 > >| | TC446696 | TC39544 > >| | TC446696 | TC70404 > > > > ++--++ > > It seems as your file have \r\n line endings, not only \n. This can happen > if the file is produced on a windows machine, or if it has been edited in a > text editor and saved on a windows machine. > > Try using LINES TERMINATED BY '\r\n' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL dump/recovery probable bug
On Friday 21 June 2002 09:54, Keith C. Ivey wrote: > On 21 Jun 2002, at 15:43, Stefano Incontri wrote: > > ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID) > > ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12 > > "LOAD" is a reserved word in MySQL, so you need backticks around it. > Have you tried using the --quote-names option in mysqldump? > > http://www.mysql.com/doc/m/y/mysqldump.html On top of what Keith says, it is a lot more efficient to create the index AFTER you load the data anyway. Given that the data is a restore of known-good values which shouldn't ever violate the unique key constraint there is no advantage in creating the index before loading. With large amounts of data the difference in performance could be considerable. I'm only working from memory here, but I think there are also some parameters related to transactions and InnoDB tables you want to look at as well when you load up large amounts of data. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: remote mysql access ?????
toby, Friday, June 21, 2002, 12:05:26 PM, you wrote: t> ok guyz somebody was talkin about accessing mysql from a remote machine t> how the devil do i do that ? You can connect using mysql command-line client or any GUI for MySQL, f.e. MyCC: http://www.mysql.com/downloads/gui-mycc.html t> the problem is : t> 1.i have mysql on my work machine ... not at my home t> & i dont wanna have to go thru all the trouble of download and config and t> all Use remote connect. t> 2. i couldnt locate my.ini or my.cnf t> what should i do ? If you need it, you can create it by yourself. (you can find examples: my-large.cnf, my-huge.cnf etc.) t> but mysql seems to be working fine even without it Sure, MySQL uses default options. t> i ve win2k, apache 1.3.24 , mysql 3.23.51 t> thnx a million t> toby . -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL dump/recovery probable bug
Stefano,
Friday, June 21, 2002, 4:43:29 PM, you wrote:
SI> I found the following problem, which I consider a bug, but maybe I'm missing
something to make it work correctly.
SI> I'm using 'mysqldump' to backup our MySQL DB, and when I try to recover it on a
blank DB it gives syntax errors while creating some table.
SI> This is the Table structure which cause the error :
[skip]
SI> When I try to run this command on the mysql console, I receive the following error
:
SI> mysql> CREATE TABLE Test (
SI> -> ID int(10) unsigned NOT NULL auto_increment,
SI> -> IL varchar(12) NOT NULL default '',
SI> -> Item_ID int(10) unsigned NOT NULL default '0',
SI> -> BLDate datetime NOT NULL default '-00-00 00:00:00',
SI> -> RelToTest datetime default NULL,
SI> -> RelToRegr datetime default NULL,
SI> -> RelToNPI datetime default NULL,
SI> -> RelToCCO datetime default NULL,
SI> -> SanityResult enum('None','Green','Red') NOT NULL default 'None',
SI> -> PRIMARY KEY (ID),
SI> -> UNIQUE KEY Load (IL,Item_ID)
SI> -> ) TYPE=MyISAM COMMENT='SCM Internal Loads table';
SI> ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
SI> ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
[skip]
SI> Is really urgent for us to solve this problem, because our DB is growing fast and
we would like to have a consistent Backup.
SI> If I'm doing something wrong, please tell me.
LOAD is a reserved word:
http://www.mysql.com/doc/R/e/Reserved_words.html
It's not recommended to use reserved words in table/column/key etc
names...
You can fix you problem just quoting LOAD with a ``' characters. Use
-Q or --quote-names option of mysqldump.
SI> Best Regards,
SI> Stefano
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing Multiple Versions of MySql on the Same Computer
Michael, Friday, June 21, 2002, 6:17:44 AM, you wrote: MI> I am currently running MySQL-3.23.51 on RedHat Linux MI> 7.2 and would like to gradually switch to MI> MySQL-Max-3.23.51. My question is, would I be able to MI> install them both if I only run one at a time? Sure. You can't use MySQL-Max if you doesn't have original MySQL server. MI> I am really looking forward to trying out transations MI> and foreign keys using InnoDB and am interested in BDB MI> as well. MI> I'd appreciate hearing about any problems or things to MI> avoid when setting up InnoDB. don't forget to specify innodb_data_file_path start up option. MI> --Michael -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql's ignoring query.. error
Franco, Friday, June 21, 2002, 6:03:16 AM, you wrote: FMG> I'm using mysql-3.23.41 and initially able to use it without any problem. However, after I issued this command, "grant all privileges on *.* to root@localhost identified by 'mypassword' with FMG> grant option; ", mysql will simply display the message "Ignoring query to other database" after issuing any command such as "show databases;". FMG> I am able to access mysql using : "mysql -root -p", and entering the my password. FMG> Would appreciate any assistance. Did you run mysql client program with --one-database option? (check also my.cnf/my.ini file if there is "one-database" entry) FMG> Best regards, FMG> Franco -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: turkish character set
Hello I converted charset from latin1(default) to latin5 and I read INSTALL_SOURCE If you change character sets after having created any tables, you will have to run `myisamchk -r -q' on every table Therefore I run `myisamchk -r -q' on every table but it still couldn't sorting data correctly is there any command on mysqlserver to correct tables according to new charset ? What shall I do ? - Original Message - From: "Gurhan Ozen" <[EMAIL PROTECTED]> To: "Malik Bülent" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 20, 2002 3:50 PM Subject: Re: turkish character set > You have to change the default charset to latin5. You can either do it by > giving command line option while starting your mysqld or you can just edit > my.cnf option file.. > See: > http://www.mysql.com/doc/C/o/Command-line_options.html > http://www.mysql.com/doc/O/p/Option_files.html > > > - Original Message - > From: "Malik Bülent" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, June 20, 2002 7:48 AM > Subject: turkish character set > > > > Hello > > I installed mysql3.23.server on FreeBSD4.4. and it works. I made some > tables > > but > > By default, MySQL uses the ISO-8859-1 (Latin1) character set. > > I use turkish character set therefore How can I convert character set from > > Latin1 to turkish for Mysql. > > if I convert to turkish character set, What will I have to any settings ? > > > > what shall I do ? > > > > Thanks > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Innodb and transactions
Thanks alot Cal.
-Steve.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 9:38 AM
To: Steve Bradwell; [EMAIL PROTECTED]
Subject: RE: Innodb and transactions
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('Insert something'))){
mysql_query('COMMIT');
} else {
mysql_query('ROLLBACK');
}
I'm working from memory here. I use the ADODB wrapper and it works a little
different. (Look into it, it's a great piece of code)
HTH,
=C=
-Original Message-
From: Steve Bradwell [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 7:58 AM
To: [EMAIL PROTECTED]
Subject: Innodb and transactions
Hey everybody,
Thank god its friday. =]
Can someone point me to an example of how to do begin rollback commit with
php and mysql Innodb tables?
Thanks for any and all help,
Steve.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication
hi, i am running mysql-max-log 32.23.50 on Solaris as slave and mysql-max-log 32.23.51 on linux as a master i often happend that slave stop because of a grant query it can't execute. a flush privileges in the slave is enough to make it restart. does anyone have this problem ?? thanks Pierre -- sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL dump/recovery probable bug
On 21 Jun 2002, at 15:43, Stefano Incontri wrote: > ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID) > ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12 "LOAD" is a reserved word in MySQL, so you need backticks around it. Have you tried using the --quote-names option in mysqldump? http://www.mysql.com/doc/m/y/mysqldump.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL dump/recovery probable bug
Dear All,
I found the following problem, which I consider a bug, but maybe I'm missing something
to make it work correctly.
I'm using 'mysqldump' to backup our MySQL DB, and when I try to recover it on a blank
DB it gives syntax errors while creating some table.
This is the Table structure which cause the error :
DROP TABLE IF EXISTS InternalLoads;
CREATE TABLE InternalLoads (
ID int(10) unsigned NOT NULL auto_increment,
IL varchar(12) NOT NULL default '',
Item_ID int(10) unsigned NOT NULL default '0',
BLDate datetime NOT NULL default '-00-00 00:00:00',
RelToTest datetime default NULL,
RelToRegr datetime default NULL,
RelToNPI datetime default NULL,
RelToCCO datetime default NULL,
SanityResult enum('None','Green','Red') NOT NULL default 'None',
PRIMARY KEY (ID),
UNIQUE KEY Load (IL,Item_ID)
) TYPE=MyISAM COMMENT='SCM Internal Loads table';
When I try to run this command on the mysql console, I receive the following error :
mysql> CREATE TABLE Test (
-> ID int(10) unsigned NOT NULL auto_increment,
-> IL varchar(12) NOT NULL default '',
-> Item_ID int(10) unsigned NOT NULL default '0',
-> BLDate datetime NOT NULL default '-00-00 00:00:00',
-> RelToTest datetime default NULL,
-> RelToRegr datetime default NULL,
-> RelToNPI datetime default NULL,
-> RelToCCO datetime default NULL,
-> SanityResult enum('None','Green','Red') NOT NULL default 'None',
-> PRIMARY KEY (ID),
-> UNIQUE KEY Load (IL,Item_ID)
-> ) TYPE=MyISAM COMMENT='SCM Internal Loads table';
ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
mysql>
To make it work correctly it is enough to remove the name 'Load' assigned in the
'UNIQUE KEY' row :
UNIQUE KEY Load (IL,Item_ID)-> UNIQUE KEY (IL,Item_ID)
I think this could be a bug, because as a matter of fact I wouldn't be able to rebuild
our DB in case of crash without editing the SQL Backup file generated by mysqldump,
which is really dangerous.
Is really urgent for us to solve this problem, because our DB is growing fast and we
would like to have a consistent Backup.
If I'm doing something wrong, please tell me.
Best Regards,
Stefano
Stefano Incontri
OWT WebMaster
Cisco Photonics Italy S.r.l.
Via Philips, 12
20052 Monza (MI)
e-mail: [EMAIL PROTECTED]
Tel. +39 039 209 1266
Cell. +39 0335 7454458
Fax. +39 039 209 1099
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Innodb and transactions
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('Insert something'))){
mysql_query('COMMIT');
} else {
mysql_query('ROLLBACK');
}
I'm working from memory here. I use the ADODB wrapper and it works a little
different. (Look into it, it's a great piece of code)
HTH,
=C=
-Original Message-
From: Steve Bradwell [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 7:58 AM
To: [EMAIL PROTECTED]
Subject: Innodb and transactions
Hey everybody,
Thank god its friday. =]
Can someone point me to an example of how to do begin rollback commit with
php and mysql Innodb tables?
Thanks for any and all help,
Steve.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: file permissions
The manual says: chown -R mysql.mysql /usr/local/mysql You did not do that. Do the same for MySQL's data directory. Michael Sellers wrote: >I'm very new to mysql. Just learning. I'm trying to correctly set up the >permissions for the files under the mysql/ directory. I've included a >list. I would appreciate it if some one could look over it and recommend >changes. Thank you. > >Michael Sellers > > >/usr/local/mysql > >total 4752 >drwxr-xr-x2 root root 4096 Jun 19 00:05 bin >-rw-r--r--1 root mysqlgrp 122213 Jun 3 05:39 ChangeLog >-rwxr-xr-x1 root mysqlgrp 773 Jun 9 08:13 configure >-rw-r--r--1 root mysqlgrp19106 Jun 8 09:57 COPYING >-rw-r--r--1 root mysqlgrp47577 Jun 8 09:57 COPYING.LIB >drwxr-x---4 root mysqlgrp 4096 Jun 19 23:02 data >drwxr-xr-x2 root mysqlgrp 4096 Jun 9 08:13 include >-rw-r--r--1 root mysqlgrp 147458 Jun 8 09:57 INSTALL-BINARY >drwxr-xr-x2 root mysqlgrp 4096 Jun 9 08:13 lib >drwxr-xr-x2 root mysqlgrp 4096 Jun 9 08:13 man >-rw-r--r--1 root mysqlgrp 2336774 Jun 8 09:56 manual.html >-rw-r--r--1 root mysqlgrp85892 Jun 8 09:56 manual_toc.html >-rw-r--r--1 root mysqlgrp 2021070 Jun 8 09:56 manual.txt >drwxr-xr-x6 root mysqlgrp 4096 Jun 9 08:13 mysql-test >-rw-r--r--1 root mysqlgrp 1976 Jun 3 05:39 README >drwxr-xr-x2 root mysqlgrp 4096 Jun 9 08:13 scripts >drwxr-xr-x3 root mysqlgrp 4096 Jun 9 08:13 share >drwxr-xr-x7 root mysqlgrp 4096 Jun 9 08:13 sql-bench >drwxr-xr-x2 root mysqlgrp 4096 Jun 9 08:13 support-files >drwxr-xr-x2 root mysqlgrp 4096 Jun 9 08:13 tests > > >/usr/local/mysql/bin > >total 15696 >-rwxr-xr-x1 root root 619808 Jun 9 08:13 comp_err >-rwxr-xr-x1 root root 749524 Jun 9 08:13 isamchk >-rwxr-xr-x1 root root 1474 Jun 9 08:13 msql2mysql >-rwxr-xr-x1 root root 828488 Jun 9 08:13 myisamchk >-rwxr-xr-x1 root root 747244 Jun 9 08:13 myisampack >-rwxr-xr-x1 root root 630504 Jun 9 08:13 >my_print_defaults >-rwxr-xr-x1 root root 759028 Jun 9 08:13 mysql >-rwxr-xr-x1 root root 111547 Jun 9 08:13 mysqlaccess >-rwxr-xr-x1 root root 1702 Jun 3 05:39 mysqlaccess.conf >-rwxr-xr-x1 root root 601236 Jun 9 08:13 mysqladmin >-rwxr-xr-x1 root root 615144 Jun 9 08:13 mysqlbinlog >-rwxr-xr-x1 root root 9731 Jun 9 08:13 mysqlbug >-rwxr-xr-x1 root root 595304 Jun 9 08:13 mysqlcheck >-rwxr-xr-x1 root root 3144 Jun 9 08:13 mysql_config >-rwxr-xr-x1 root root 2976 Jun 9 08:13 >mysql_convert_table_format >-rwxr-xr-x1 root root 3835316 Jun 9 08:13 mysqld >-rwxr-xr-x1 root root18415 Jun 9 08:13 mysqld_multi >-rwxr-xr-x1 root root96797 Jun 9 08:13 mysqld.sym.gz >-rwxr-xr-x1 root root 609244 Jun 9 08:13 mysqldump >-rwxr-xr-x1 root root 4986 Jun 9 08:13 mysqldumpslow >-rwxr-xr-x1 root root 2654 Jun 9 08:13 mysql_find_rows >-rwxr-xr-x1 root root 4437 Jun 9 08:13 >mysql_fix_privilege_tables >-rwxr-xr-x1 root root27610 Jun 9 08:13 mysqlhotcopy >-rwxr-xr-x1 root root 591904 Jun 9 08:13 mysqlimport >-rwxr-xr-x1 root root15255 Jun 9 08:13 >mysql_setpermission >-rwxr-xr-x1 root root 592800 Jun 9 08:13 mysqlshow >-rwxr-xr-x1 root root 614688 Jun 9 08:13 mysqltest >-rwxr-xr-x1 root root 3104 Jun 9 08:13 mysql_zap >-rwxr-xr-x1 root root 707928 Jun 9 08:13 pack_isam >-rwxr-xr-x1 root root 625528 Jun 9 08:13 perror >-rwxr-xr-x1 root root 633800 Jun 9 08:13 replace >-rwxr-xr-x1 root root 625204 Jun 9 08:13 resolveip >-rwxr-xr-x1 root root 624232 Jun 9 08:13 >resolve_stack_dump >-rwxr-xr-x1 root root 8463 Jun 19 00:03 safe_mysqld > > >/usr/local/mysql/data > >total 44 >-rw-r--r--1 mysqladm mysqlgrp 3527 Jun 20 19:22 laptop.err >-rw-rw1 root mysqlgrp29777 Jun 20 19:22 log.01 >drwxr-x---2 root mysqlgrp 4096 Jun 17 11:51 mysql >drwxr-x---2 root mysqlgrp 4096 Jun 17 14:08 test > > >/usr/local/mysql/include > >total 400 >-rw-r--r--1 root mysqlgrp21021 Jun 9 08:07 config.h >-rw-r--r--1 root mysqlgrp 9394 Jun 3 05:39 config-win.h >-rw-r--r--1 root mysqlgrp 3445 Jun 3 05:39 dbug.h >-rw-r--r--1 root mysqlgrp 2082 Jun 3 05:39 errmsg.h >-rw-r--r--1 root mysqlgrp 1819 Jun 3 05:39 ft_global.h >-rw
RE: problem with configure
Hi, I am new user of mysql and I can't post questions to this mailing list. Even though I subscribed and started getting mailing list emails in my mailbox. I use outlook with send message type "Plain text", can you please help me Whenever I try to send message, I get a bounced email from mailer daemon saying Sorry. Your message could not be delivered to: w3d3demo (Mailbox or Conference is full.) Thanks Roma -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 9:13 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: problem with configure Make sure yours Docs dir hase a Makefile.in. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 7:16 AM To: [EMAIL PROTECTED] Subject: problem with configure Hi All, I am trying to configure the Nusphere mysql (mysql-3.23.49.tar.gz) from its source. I am using Redhat 7.2, the configure options are ./configure --prefix=/var/home/mysql --localstatedir=/var/home/mysql/data -- enable-large-files --with-gemini=/var/src/mysql-3.23.49/gemini At the time of ./configure I am getting error message Can't read ./Docs/Makefile.in No such file or directory Because of that Make is giving errors...Any help... Thanks in advance... regds, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie question
Why are you getting this message, "Access denied for user '@localhost' for
database test2"?
If you are logged on as 'emil' and you attempt to connect, if you are
denied access you should receive a message like this; "Access denied for
user 'emil@localhost' for database test2"
It would appear that you are not passing a user name to MySQL when you are
trying to connect.
If I were you, I would delete all users with either a null/blank user name
or null/blank password from my "user" table.
Then, I would flush priveleges.
Then, I would try to connect as the user 'emil' (-u emil).
These documents (links shown below) provide an OUTSTANDING explanation of
users and privileges for MySQL.
http://www.mysql.com/doc/C/o/Connection_access.html
http://www.mysql.com/doc/R/e/Request_access.html
http://www.mysql.com/doc/A/c/Access_denied.html
I also highly recommend the book "MySQL" by Paul DuBois. It has been
indispensable for me.
Respectfully,
Charles Q.
At 05:44 AM 6/21/2002, you wrote:
>if i could add to this question a bit:
>
>what are the steps in adding a user that will have access to only one
>database?
>
>i've tried using both:
>
>GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON uview.* TO user@%
>IDENTIFIED BY "password"; (then did a FLUSH PRIVILEGES)
>
>and i've tried adding directly yo the users database:
>
>NSERT INTO user
>VALUES('localhost','USERNAME',PASSWORD('some_pass'),'SELECT','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>
>but i can't seem to get things to work. i've looked over the manual and a
>small tutorial.
>
>
>are there some steps i'm missing?
>
>
>thanks.
>
>
>jason upton
>
>
>
>
>
>6/20/2002 4:30:47 PM, "Emma Grant" <[EMAIL PROTECTED]> wrote:
>
> >Hi, I am just starting out with mysql.
> >
> >MySQL allows anon access so I don't have to log on to the sql just the
> >linu server.
> >
> >I am trying to create a test database 'test2'. I am logged on as my user
> >'emil' (not root) on a test linux server. When I go to create the
> >database:
> >
> >mySQL> CREATE DATABASE test2;
> >
> >It gives me the following error.
> >
> >Error: 1044: Access denied for user '@localhost' for database test2
> >
> >I then log in as root and change my privelages:
> >
> >mySQL> GRANT ALL ON test2.* for emil;
> >
> >But still I get the same error when I try to create it.
> >
> >In fact, I can't get on to a database even if the root creates it and
> >then I GRANT the user 'emil' ALL to the newly created database.
> >
> >Can someone direct me in the right place?
> >
> >Thanks,
> >
> >Emma
> >
> >
> >
> >-
> >Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> >To request this thread, e-mail <[EMAIL PROTECTED]>
> >To unsubscribe, e-mail <[EMAIL PROTECTED]>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> >
>
>
>
>
>
>
>
>
>
>
>
>-
>Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem with configure
Make sure yours Docs dir hase a Makefile.in. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 7:16 AM To: [EMAIL PROTECTED] Subject: problem with configure Hi All, I am trying to configure the Nusphere mysql (mysql-3.23.49.tar.gz) from its source. I am using Redhat 7.2, the configure options are ./configure --prefix=/var/home/mysql --localstatedir=/var/home/mysql/data -- enable-large-files --with-gemini=/var/src/mysql-3.23.49/gemini At the time of ./configure I am getting error message Can't read ./Docs/Makefile.in No such file or directory Because of that Make is giving errors...Any help... Thanks in advance... regds, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Innodb and transactions
Hey everybody, Thank god its friday. =] Can someone point me to an example of how to do begin rollback commit with php and mysql Innodb tables? Thanks for any and all help, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem importing data from SQL server 2000 to mysql
Hi guys, I want to migrate data from SQL Server 2000 to Mysql. My problem is to migrate big fields which had type varchar(7900) or so I tried using Text datatype of mysql, then I cant migrate data in that field I used command LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABLE mailmessagetext_table; For the field messagetext - varchar(7900), it only migrated few characters, not the complete length Please help Thanks Roma - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with MySQL ODBC Driver?
Well, not really a problem, I guess... but when I run a python program that makes use of it I get the following "message" per row I process... Freeing pointer out of range at line 663, 'C:\49\libmysql\libmysql.c' Should I worry? Can I stop this from happening? Mike +++-+++--+++ + Michael S. Jessop+ | Senior Web Developer | + Copyright Clearance Center, Inc. + +++-+++--+++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie question
if i could add to this question a bit:
what are the steps in adding a user that will have access to only one database?
i've tried using both:
GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON uview.* TO user@% IDENTIFIED BY
"password"; (then did a FLUSH PRIVILEGES)
and i've tried adding directly yo the users database:
NSERT INTO user
VALUES('localhost','USERNAME',PASSWORD('some_pass'),'SELECT','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
but i can't seem to get things to work. i've looked over the manual and a small
tutorial.
are there some steps i'm missing?
thanks.
jason upton
6/20/2002 4:30:47 PM, "Emma Grant" <[EMAIL PROTECTED]> wrote:
>Hi, I am just starting out with mysql.
>
>MySQL allows anon access so I don't have to log on to the sql just the
>linu server.
>
>I am trying to create a test database 'test2'. I am logged on as my user
>'emil' (not root) on a test linux server. When I go to create the
>database:
>
>mySQL> CREATE DATABASE test2;
>
>It gives me the following error.
>
>Error: 1044: Access denied for user '@localhost' for database test2
>
>I then log in as root and change my privelages:
>
>mySQL> GRANT ALL ON test2.* for emil;
>
>But still I get the same error when I try to create it.
>
>In fact, I can't get on to a database even if the root creates it and
>then I GRANT the user 'emil' ALL to the newly created database.
>
>Can someone direct me in the right place?
>
>Thanks,
>
>Emma
>
>
>
>-
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with MySQL ODBC Driver?
Well, not really a problem, I guess... but when I run a python program that makes use of it I get the following "message" per row I process... Freeing pointer out of range at line 663, 'C:\49\libmysql\libmysql.c' Should I worry? Can I stop this from happening? Mike +++-+++--+++ + Michael S. Jessop+ | Senior Web Developer | + Copyright Clearance Center, Inc. + +++-+++--+++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL does not always recognize \n as a field terminator while loading data from txt file
* Podhorski, Adam > If I don't put the tab before the the end of the line in the txt file that > contains the data, mySQL does not properly put the data into table using > LOAD DATA INFILE. [...] > But if there is only a \n at the end of the line (e.g. > 1\tTC446696\tTC27867\n), the data gets corrupted and even the display does > not proerly work (note the wrong vertical column bars for display) > > mysql> SELECT * FROM tigr_mgi_tcs; > ++--++ > | ID | TC | TC_Synonym | > ++--++ >| | TC446696 | TC27867 >| | TC446696 | TC37198 >| | TC446696 | TC39544 >| | TC446696 | TC70404 > ++--++ It seems as your file have \r\n line endings, not only \n. This can happen if the file is produced on a windows machine, or if it has been edited in a text editor and saved on a windows machine. Try using LINES TERMINATED BY '\r\n' -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with configure
Hi All, I am trying to configure the Nusphere mysql (mysql-3.23.49.tar.gz) from its source. I am using Redhat 7.2, the configure options are ./configure --prefix=/var/home/mysql --localstatedir=/var/home/mysql/data -- enable-large-files --with-gemini=/var/src/mysql-3.23.49/gemini At the time of ./configure I am getting error message Can't read ./Docs/Makefile.in No such file or directory Because of that Make is giving errors...Any help... Thanks in advance... regds, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug: MySQL does not always recognize \n as a field terminator while loading data from txt file
Hi! If I don't put the tab before the the end of the line in the txt file that contains the data, mySQL does not properly put the data into table using LOAD DATA INFILE. The courious thing is that this only happens with this one file. I was using the same commands for all my other files and this situation has never happened. All the data and file names are true. I use: version 4.0.1-alpha-nt Microsoft Windows 2000 [Version 5.00.2195] I have the file: d:\Users\APodhorski\DataNash\DB\Tigr\MGI\cmd.sql that contains: USE datanash; DROP TABLE IF EXISTS Tigr_MGI_TCs; CREATE TABLE Tigr_MGI_TCs ( IDint NOT NULL AUTO_INCREMENT, TCvarchar( 8 )NULL, TC_Synonymvarchar( 20 ) NULL, PRIMARY KEY ( ID ) ); LOAD DATA INFILE 'd:/Users/APodhorski/DataNash/DB/Tigr/MGI/PreScan-MGI.TCs.tmp' INTO TABLE Tigr_MGI_TCs; Than I execute it using: type cmd.sql | "d:/Users/APodhorski/mysql/bin/mysql.exe" The truth is that I have a perl script that does all this, but I was able to reproduce the problem using Windows command line directly. If there are tabs before the end of the line (e.g. 1\tTC446696\tTC27867\t\n) I got everything OK mysql> SELECT * FROM tigr_mgi_tcs; ++--++ | ID | TC | TC_Synonym | ++--++ | 1 | TC446696 | TC27867| | 2 | TC446696 | TC37198| | 3 | TC446696 | TC39544| | 4 | TC446696 | TC70404| ++--++ But if there is only a \n at the end of the line (e.g. 1\tTC446696\tTC27867\n), the data gets corrupted and even the display does not proerly work (note the wrong vertical column bars for display) mysql> SELECT * FROM tigr_mgi_tcs; ++--++ | ID | TC | TC_Synonym | ++--++ | | TC446696 | TC27867 | | TC446696 | TC37198 | | TC446696 | TC39544 | | TC446696 | TC70404 ++--++ Below is what the txt data file contains. If you remove the tabs than the trouble occurs. 1 TC446696TC446696 2 TC446696TC27867 3 TC446696TC37198 4 TC446696TC39544 Regards Adam -- Dr Adam Podhorski CEIT, Centro de Estudios e Investigaciones Técnicas de Gipuzkoa Paseo de Manuel Lardizábal, 15 20018 San Sebastian Spain Tel.: (34) 943 212 800 Fax.: (34) 943 213 076 email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using web forms and webpages to access/view mysql data
On Thu, 20 Jun 2002, Emma Grant wrote: > I successfully created and added data to my database! > > Does anyone know any good websites where I can learn to insert, update > data using a web form and CGI? http://selfaktuell.teamone.de/artikel/cgiperl/index.htm Text is in German, but you may use the code examples. Thomas -- sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unions
Take a look at "http://www.mysql.com/doc/";. If you search the keyword union you can get an answer. Arul wrote: >Hi > > Can i use Unions in MySQL. > If not could anyone comeout with some alternates.. > > Regards, > -Arul > >sql, > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Unions
* Arul > Can i use Unions in MySQL. >From version 4 you can: http://www.mysql.com/doc/U/N/UNION.html > > If not could anyone comeout with some alternates.. The normal workaround is to use temporary tables: create temporary table t1 select ...; insert into t1 select ...; select * from t1; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sorry for this "basic" question
* [EMAIL PROTECTED] > I like to know the sintax to do a similar select in mysql (this come from > db2): > > select * from tabella where rrn(tablename) > 50 limit 10 > > the mean is to select ten records from 50 to 60, > > any equivalent with mysql ? mysql does not have the rrn() function, but if you have a primary key called 'id', this should work: select * from tabella order by id limit 50,10; -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: @@IDENTITY
Even the last_insert_id() returns 0
is it coz the table type is INNODB
- Original Message -
From: "Jan Peuker" <[EMAIL PROTECTED]>
To: "Arul" <[EMAIL PROTECTED]>
Sent: Friday, June 21, 2002 4:16 PM
Subject: Re: @@IDENTITY
> You are using M$-Syntax, in MySQL you should use:
> SELECT last_insert_id()
> http://www.mysql.com/doc/e/x/example-AUTO_INCREMENT.html
>
> regards,
>
> jan
>
>
> - Original Message -
> From: Arul
> To: MySQL
> Sent: Friday, June 21, 2002 12:17 PM
> Subject: @@IDENTITY
>
>
>Hi
>
> I m using mysql 3.23.51 on win 2k
>
> Well..I have a user table where i have the userid column as primary key
and
> auto_increment column and name as varchar(25).
>
> I insert values in the table such as
>
> Insert into user (name) values ('AA');
>
> Then When i do select @@Identity in the next time , it tells me as 0
>
> Why is this happenning..
>
> I need to get the last inserted value of the primary key ..right
>
> -Arul
>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unions
Hi Can i use Unions in MySQL. If not could anyone comeout with some alternates.. Regards, -Arul sql, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sorry for this "basic" question
Hello, I like to know the sintax to do a similar select in mysql (this come from db2): select * from tabella where rrn(tablename) > 50 limit 10 the mean is to select ten records from 50 to 60, any equivalent with mysql ? TNX ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
@@IDENTITY
Hi
I m using mysql 3.23.51 on win 2k
Well..I have a user table where i have the userid column as primary key and
auto_increment column and name as varchar(25).
I insert values in the table such as
Insert into user (name) values ('AA');
Then When i do select @@Identity in the next time , it tells me as 0
Why is this happenning..
I need to get the last inserted value of the primary key ..right
-Arul
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: remote mysql access ?????
Remote access for mysql database can be done with this tool: http://www.anse.de/mysqlfront/ Its free, reasonably reliable and pretty easy to use (also for making dumps) my.ini is found under /WINNT directory my.cnf is found under the root dir (prolly C:\ for you) => this file is not obligated to have, mysql will work without it and you can create it yourself if you need to add parameters to it Hope it helps, CB. -Original Message- From: toby - [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 10:05 To: [EMAIL PROTECTED] Subject: remote mysql access ? ok guyz somebody was talkin about accessing mysql from a remote machine how the devil do i do that ? the problem is : 1.i have mysql on my work machine ... not at my home & i dont wanna have to go thru all the trouble of download and config and all 2. i couldnt locate my.ini or my.cnf what should i do ? but mysql seems to be working fine even without it i ve win2k, apache 1.3.24 , mysql 3.23.51 thnx a million toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
remote mysql access ?????
ok guyz somebody was talkin about accessing mysql from a remote machine how the devil do i do that ? the problem is : 1.i have mysql on my work machine ... not at my home & i dont wanna have to go thru all the trouble of download and config and all 2. i couldnt locate my.ini or my.cnf what should i do ? but mysql seems to be working fine even without it i ve win2k, apache 1.3.24 , mysql 3.23.51 thnx a million toby . _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: RE: update syntax
Hello Terry, Thursday, June 20, 2002, 5:14:40 PM, you wrote: DT> Egor, DT> I hope I understand you work for MySQL in some fashion, is there any plan to DT> allow sub-selects in future releases ? Yes, multi-table updates and sub-selects is on development and they will come in version 4.1 DT> RSVP, DT> Terry -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Multi-threaded MySQL?
The Makefile of mysql server says about linuxthreads:
@${ECHO} " WITH_LINUXTHREADS=yes Use the linuxthreads pthread
library."
@${ECHO} " This is _NOT_ recommended
for production"
@${ECHO} " servers. Expect problems
when enabled."
Iago.
In the last episode (Jun 19), Chris Johnson said:
> I'm using 3.23.47 on a FreeBSD 4.5 server with two CPUs. I believe I've
got
> MySQL configured appropriately to take advantage of this configuration,
but
> it appears that it only ever uses one CPU. The other is always idle, or
> running the few remaining Unix processes when they want to do something.
>
> I've got these lines in my /etc/my.cnf file, for example:
>
> set-variable= thread_cache=8
> # Try number of CPU's*2 for thread_concurrency
> set-variable= thread_concurrency=4
>
> Is MySQL unable to use extra CPUs beyond one, am I just confused, or is
> something misconfigured?
FreeBSD's threads library implements threads as a single process, so it
will never use more than one CPU. If you built using the ports tree,
try rebuilding with WITH_LINUXTHREADS=yes, which will use the Linux
threads model (one process per thread).
--
Dan Nelson
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Hi David,
On Fri, Jun 21, 2002 at 03:59:33AM -0400, david wrote:
> Well i seem to have gotten MySql working but i can't seem to use mysqladmin:
> to do anything. When i start MySql with the following:
>
> [root@RR davidwri]# safe_mysqld -u root
> Starting mysqld daemon with databases from /var/lib/mysql
>
>
> it will sit indefinitely as above, is this correct?
Yes. You probably want to add an & to the end so it runs in the
background. This is all standard shell functionality. Or even run
it in its own subshell:
[root@RR davidwri]# (safe_mysqld -u root &)
> If i try to add:
> mysql -u root -p mysql
>
> It still just sits,...
>
That's right. You didn't get your prompt back as you wrote earlier.
> [root@RR davidwri]# mysqladmin version
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
>
You tell the mysql client to not use a password and root needs a
password. So the MySQL daemon won't allow you to log in like this.
> I did Set the password, based on the following syntax example (with my value,
> obviously):
> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password');
>
> So if i cntrl-z:
>
> [1]+ Stopped safe_mysqld -u root
>
> then try:
> [root@RR davidwri]# mysql -u root
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
>
Like before.
> [root@RR davidwri]# mysql -u root -p mysql
> Enter password:
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 2 to server version: 3.23.32
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
> mysql>
>
Correct. You told the mysql client to ask you for a password.
> I have never set up and administered MySql myself, so i don't know exactly
> what to expect but this is definitely not right. thanks for all your help
>
Nothing unexpected so far.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: corrupt index in BDB table
On Fri, 21 Jun 2002 09:51:35 +0200 Giuseppe Careri <[EMAIL PROTECTED]> wrote: > Hi, > > i have a problem with an index of a BerkeleyDB table because this is corrupted > and crashes Mysql (v. 3.23.49). > > The size of table file is correct 8Mb for 15.000 records but from a select > I view only the first 957 > > If I launch "mysqldump" or a "select" or "alter table drop index.." the result > is the same. Mysql crashes > > How can I fix index in BDB table, I did not find any tools in mysql package... just do from mysql prompt : mysql> repair table [tablename] -- I'd crawl over an acre of 'Visual This++' and 'Integrated Development That' to get to gcc, Emacs, and gdb. Thank you. -- Vance Petree, Virginia Power - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error: 'Access denied for user: 'root@localhost' (Using password: NO)'
On Fri, 21 Jun 2002 03:59:33 -0400 david <[EMAIL PROTECTED]> wrote: > [root@RR davidwri]# mysqladmin version > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > [root@RR davidwri]# mysql -u root -p mysql > Enter password: > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A Everytime you do : mysql or mysqladmin you have to add these parameters : -u root -p e.g. : mysqladmin -u root -p version mysql -u root -p [databasename] -- Let's call it an accidental feature. -- Larry Wall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table can't Add new record
On Fri, 21 Jun 2002 14:36:28 +0700 "ihwan" <[EMAIL PROTECTED]> wrote: > Dear All, > > I have a trouble with my database using mysql. > The problem is one of the table can not increase new record. > and I can not add new data to that table. > The last row is no. 226428 > I don't use number field type for identity or auto_increment > . > Does anyone know why this trouble can occurs? Please provide us more informations. What query did you run ? And what was the error message displayed ... and maybe also with the table description -- > I'm an idiot.. At least this [bug] took about 5 minutes to find.. Disquieting ... -- Gonzalo Tornaria in response to Linus Torvalds's - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Well i seem to have gotten MySql working but i can't seem to use mysqladmin:
to do anything. When i start MySql with the following:
[root@RR davidwri]# safe_mysqld -u root
Starting mysqld daemon with databases from /var/lib/mysql
it will sit indefinitely as above, is this correct?
If i try to add:
mysql -u root -p mysql
It still just sits,...
[root@RR davidwri]# mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
I did Set the password, based on the following syntax example (with my value,
obviously):
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('secret_password');
So if i cntrl-z:
[1]+ Stopped safe_mysqld -u root
then try:
[root@RR davidwri]# mysql -u root
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
[root@RR davidwri]# mysql -u root -p mysql
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.32
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql>
I have never set up and administered MySql myself, so i don't know exactly
what to expect but this is definitely not right. thanks for all your help
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
corrupt index in BDB table
Hi, i have a problem with an index of a BerkeleyDB table because this is corrupted and crashes Mysql (v. 3.23.49). The size of table file is correct 8Mb for 15.000 records but from a select I view only the first 957 If I launch "mysqldump" or a "select" or "alter table drop index.." the result is the same. Mysql crashes How can I fix index in BDB table, I did not find any tools in mysql package... Thanks... Giuseppe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table can't Add new record
Dear All, I have a trouble with my database using mysql. The problem is one of the table can not increase new record. and I can not add new data to that table. The last row is no. 226428 I don't use number field type for identity or auto_increment . Does anyone know why this trouble can occurs? Ihwan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
