Re: Counting distinct elements
Depends. If this is a correlation table and the combined columns are a primary key, SELECT ObjId, COUNT(ElemId) FROMElems GROUP BY ElemId; if the combination is not unique, then: SELECT ObjId, COUNT(DISTINCT ElemId) FROMElems GROUP BY ElemId; - Original Message - From: Csaba Gabor [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 07, 2002 10:20 AM Subject: Counting distinct elements Seems like this should be an easy question, but I just don't get it: If I have CREATE TABLE Elems (ObjId INT, ElemId INT); Is there a nice query to find the Number of Distinct ElemId's for each ObjId? Motivation: Later I will want to add a WHERE ObjId IN (...) and join the Obj describing table to the results of this query. Thanks, Csaba Gabor from New York __ 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 - 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: Is it possible to have MySQL perform an action at a specifictime?
Have you looked at cron on LINUX? - Original Message - From: Jamie Buck [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 11:37 AM Subject: Is it possible to have MySQL perform an action at a specifictime? I have a file containing commands to add and drop tables as a means of synchronizing two databases. What i want to happen is for MySQL to open this file and read it at a specific time without the user having to explicitly connect to MySQL and type in the commands in order to get it to read the file, such as mysql dbname text_file_name. Is there a way to schedule a process either using a function of MySQL or of the operating system to get it to do this? The operating system would be Linux to my knowledge. I am hosting the db on an ISP and am not sure what they will let me do in regards to interacting with MySQL but it is possible to get a telnet connection if need be to perhaps setup a script. if it has to be a shell script, i doubt they will let me do this, but you never know. Also, as another option, is it possible to create a web interface for this instead where a button hit by the user would initiate the reading of the file somehow? This might be easier but I was not sure how to exactly send command line directions from a webpage. Thank you, Jamie Buck - 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: stupid error, please kick me (and send me a solution)
If the snippet is copied directly out of your code, are you missing a single quote before: $link_glob $result = mysql_db_query('$db_glob', '$query', $link_glob'); - Original Message - From: Jule Slootbeek [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 03, 2002 5:09 PM Subject: Re: stupid error, please kick me (and send me a solution) [EMAIL PROTECTED] wrote: Hi Jule !!! This can be a socket error. Sometimes when installing PHP/Mysql as binary dist PHP does not know where mysql socket is. The default is (AFAIK) /tmp/mysql.sock Make a test: Try to connect with mysql console with exactly the same info as You use in Your PHP script. shell# mysql -hlocalhost -u theUser -p db_name If you connect succesfully then run command: mysql status Mysql shows some info about the connection and You should see where the mysql socket is located. PHP test: create a file phptest.php ?php phpinfo(); ? this file shows detailed information about mysql. Find mysql info and mysql.sock If PHP is NOT using the same file tehn You propably find the error !! You can then open php.ini, edit path to mysql.sock to match with the one shown by mysql console, then restart apache and try again... Good Luck =d0Mi= Hey guys, i'm getting this error with the following sql script using php: --error-- Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/phpquiz/register_user.php on line 12 --error-- --script-- $link_glob = mysql_connect('$host_glob', '$un_glob', '$pw_glob'); $query = INSERT INTO user values('0', '$fname', '$lname', '$email', '$username', PASSWORD('$password'); $result = mysql_db_query('$db_glob', '$query', $link_glob'); if (!$result) { echo font size=+1Your Information could not be entered into the - 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 The strange thing i also noticed about this error, is that mysel_error() doesn't give any output.. Jule -- Jule Slootbeek [EMAIL PROTECTED] http://blindtheory.cjb.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 - 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
MyODBC Question
I have a question about MyODBC and the results of SQLGetTypeInfo from a table with a column of type TEXT. The results show that the column is of type VARCHAR with a length of 255. Is there a way to show the true datatype? The MySQL that I'm running is 3.23.36. SQL question.. - 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: MyODBC Question
So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? - Original Message - From: Venu [EMAIL PROTECTED] To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 2:17 PM Subject: RE: MyODBC Question Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:35 PM To: [EMAIL PROTECTED] Subject: MyODBC Question I have a question about MyODBC and the results of SQLGetTypeInfo from a table with a column of type TEXT. The results show that the column is of type VARCHAR with a length of 255. Is there a way to show the true datatype? The MySQL that I'm running is 3.23.36. That is supposed to be for the fix for invalid mapping of SET and enum types from other vendors while migrating (MSSQL, ACCESS, DTS and all conversion tools), else the behaviour is not expected. One magic here is that, if you set this to CHAR(..) then the Access 97 works, and if it is VARCHAR(..) then All other ACCESS (98, 2000, XP) works, but 97 fails. We are trying to fix this issue in next versions to have a common procedure by allowing TEXT type to accept field size. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ 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: MyODBC Question
I don't mean to beat a dead horse here, but when the backend checks the length of the datatype for the columns to prepare the statment, the TEXT column comes back as length of 255 so my 1,500 char string gets cut off. Is there a datatype that the MyODBC driver will return as character data greater than 255? - Original Message - From: Venu [EMAIL PROTECTED] To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 2:45 PM Subject: RE: MyODBC Question Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? You can always make use of TEXT, MEDIUM TEXT, LONG VARCHAR, .. and similarly for BLOBs. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ 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: Queries help (part II)
If you only want it ascending, take out the DESC as in: $query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT 3; - Original Message - From: David Rice [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 12:19 PM Subject: Queries help (part II) Hey thanks i got it to work sort of $query = SELECT * FROM gigs WHERE date '$today' ORDER BY date DESC LIMIT 3; that works but i want it to show them ascending and when i change it to $query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC; DESC LIMIT 3; it doesn't work any thoughts? _ 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
Re: Can you Change Nulls in the MySQLDump from \N?
Well I was able to fix the problem by doing a Select into Outfile and specifying in my select list and using IF... thanks - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: David M. Peak [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Thursday, March 21, 2002 4:24 PM Subject: Re: Can you Change Nulls in the MySQLDump from \N? At 12:11 -0800 3/21/02, David M. Peak wrote: Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? Nope. You'll have to postprocess the files somehow. I'm working on a MySQL to SQL Server migration and having problems with the output files. I'm doing this all in batch fellas so I'm not finding a good search and replace utility. (perl, c++, and other langs are not an option..) Thanks David - 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
Can you Change Nulls in the MySQLDump from \N?
Is there a way to tell MySQL to put a blank space instead of \N in the tab-delimited files when it does a dump? I'm working on a MySQL to SQL Server migration and having problems with the output files. I'm doing this all in batch fellas so I'm not finding a good search and replace utility. (perl, c++, and other langs are not an option..) Thanks David - 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: Changing Default for Not Null to NOTHING
ok, more specific: here is a table: CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1) If I do an insert into the FOO table with the following: INSERT INTO FOO (foo1,foo2) VALUES (1,1) Everything works as planned. If I do an insert into the FOO table with the following: INSERT INTO FOO (foo1) VALUES (1) Everything works as planned If I do an insert into the FOO table with the following: INSERT INTO FOO (foo2) VALUES (1) I want an error. But what happens is that the db engine explicitly defines a default of 0 to the foo1 column even though I defined it as int NOT NULL and did not give it a default. After I change the configuration with the following: CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure and re-create my table in a new database, I do get an error on INSERT INTO FOO (foo2) VALUES (1) because I didn't give a value for foo1, but I also get an error on this: INSERT INTO FOO (foo1) VALUES (1) even though I have explicitly defined a default for foo2. So. What I want: No default unless I define one Error on NOT NULL if I don't define a default Default inserted if NOT NULL and I define a default and I don't specify a value in an insert statement Does this make more sense? Thanks, David - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 6:54 AM Subject: Re: Changing Default for Not Null to NOTHING David, Friday, March 08, 2002, 11:03:30 PM, you wrote: DMP I just tried something and would a second opinion: DMP I re-configured my MySQL server on my RH Linux machine using the following : DMP CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure DMP and ran the following SQL: DMP CREATE TABLE FOO (foo int NOT NULL DEFAULT 5, foo1 INT NULL); DMP INSERT INTO FOO (foo1) VALUES (1); DMP MySQL-Error: DMP == DMP 1048 - Column 'foo' cannot be null. DMP So is it true that you either have an installation of MySQL that will have DMP defaults for NOT NULL defined columns (explicity or implied) or you can have DMP an installation that does not allow default values for NOT NULL defined DMP columns? Yes, if you specify CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure you will have errors in INSERT statements for NOT NULL columns inserting NULL values. DMP What I want is to be able to create a table that has columns defined as NOT DMP NULL and if I don't assign a default to that column, I want an error if I DMP don't give it a value on insert. What I DON'T want is to define a column as DMP NOT NULL with NO EXPLICIT DEFAULT to get a value if it is left out of an DMP insert statements list of column/value set. DMP Does this make sense?? Looks like it does but try to be more clear. -- For technical support contracts, goto https://order.mysql.com/ 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 - 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: Changing Default for Not Null to NOTHING
Beings as I haven't gotten an answer to this, is there a better place to find information on this? - Original Message - From: David M. Peak [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Friday, March 08, 2002 1:03 PM Subject: Re: Changing Default for Not Null to NOTHING I just tried something and would a second opinion: I re-configured my MySQL server on my RH Linux machine using the following : CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure and ran the following SQL: CREATE TABLE FOO (foo int NOT NULL DEFAULT 5, foo1 INT NULL); INSERT INTO FOO (foo1) VALUES (1); MySQL-Error: == 1048 - Column 'foo' cannot be null. So is it true that you either have an installation of MySQL that will have defaults for NOT NULL defined columns (explicity or implied) or you can have an installation that does not allow default values for NOT NULL defined columns? What I want is to be able to create a table that has columns defined as NOT NULL and if I don't assign a default to that column, I want an error if I don't give it a value on insert. What I DON'T want is to define a column as NOT NULL with NO EXPLICIT DEFAULT to get a value if it is left out of an insert statements list of column/value set. Does this make sense?? - Original Message - From: David M. Peak [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 9:22 AM Subject: Changing Default for Not Null to NOTHING Is there a way for me to NOT have a default value for a column in a table that I define as NOT NULL? EXAMPLE SQL: mysql CREATE TABLE FOO (foo1 int NOT NULL); Query OK, 0 rows affected (0.05 sec) mysql DESCRIBE FOO; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | foo1 | int(11) | | | 0 | | +---+-+--+-+-+---+ 1 row in set (0.00 sec) mysql I don't want the default to be 0 (zero) Any ideas? - 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: Changing Default for Not Null to NOTHING
I just tried something and would a second opinion: I re-configured my MySQL server on my RH Linux machine using the following : CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure and ran the following SQL: CREATE TABLE FOO (foo int NOT NULL DEFAULT 5, foo1 INT NULL); INSERT INTO FOO (foo1) VALUES (1); MySQL-Error: == 1048 - Column 'foo' cannot be null. So is it true that you either have an installation of MySQL that will have defaults for NOT NULL defined columns (explicity or implied) or you can have an installation that does not allow default values for NOT NULL defined columns? What I want is to be able to create a table that has columns defined as NOT NULL and if I don't assign a default to that column, I want an error if I don't give it a value on insert. What I DON'T want is to define a column as NOT NULL with NO EXPLICIT DEFAULT to get a value if it is left out of an insert statements list of column/value set. Does this make sense?? - Original Message - From: David M. Peak [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 9:22 AM Subject: Changing Default for Not Null to NOTHING Is there a way for me to NOT have a default value for a column in a table that I define as NOT NULL? EXAMPLE SQL: mysql CREATE TABLE FOO (foo1 int NOT NULL); Query OK, 0 rows affected (0.05 sec) mysql DESCRIBE FOO; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | foo1 | int(11) | | | 0 | | +---+-+--+-+-+---+ 1 row in set (0.00 sec) mysql I don't want the default to be 0 (zero) Any ideas? - 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
Changing Default for Not Null to NOTHING
Is there a way for me to NOT have a default value for a column in a table that I define as NOT NULL? EXAMPLE SQL: mysql CREATE TABLE FOO (foo1 int NOT NULL); Query OK, 0 rows affected (0.05 sec) mysql DESCRIBE FOO; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | foo1 | int(11) | | | 0 | | +---+-+--+-+-+---+ 1 row in set (0.00 sec) mysql I don't want the default to be 0 (zero) Any ideas? - 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
Max Row Length
is there a max row length for MyISAM tables? I'm having a hard time finding it. - 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: Changing the locations of the tables
Don't forget to ensure that the account that the mysqld is running under has the proper permissions to the new directory. I ran into that one before.. - Original Message - From: Matthew Smith [EMAIL PROTECTED] To: 'MySQL' [EMAIL PROTECTED] Sent: Tuesday, December 18, 2001 10:24 AM Subject: RE: Changing the locations of the tables I think the key was _without_ reinstalling. I emailed this privately first, but should work with minimum downtime and preserve data: mysqladmin -u . shutdown su cd /var/lib tar -cf - mysql | (cd /usr/lib ; tar xvBpf -) rm -rf mysql vi /etc/my.cnf :%s/\/var\/lib\/mysql/\/usr\/lib\/mysql/g :x ...restart mysqld. -Original Message- From: Bill Blowitz [mailto:[EMAIL PROTECTED]] Sent: 18 December 2001 17:54 To: 'Stephen Johnson'; 'MySQL' Subject: RE: Changing the locations of the tables Here you go:-) [root@server src]# rpm -i MySQL-3.XX.XX-1.src.rpm [root@server src]# tar -xvzf ../../src/redhat/SOURCES/mysql-3.XX.XX.tar.gz [root@server src]# cd mysql-3.XX.XX [root@server mysql-3.XX.XX]# ./configure \ --prefix=/usr/lib/mysql [root@server mysql-3.XX.XX]# make [root@server mysql-3.XX.XX]# make install [root@server mysql-3.XX.XX]# scripts/mysql_install_db XX.XX is your mysql version Good Luck! -Original Message- From: Stephen Johnson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 9:19 AM To: MySQL Subject: Changing the locations of the tables Is there a way without reinstalling MySQL to change the locations of the database tables? For example right now they are in /var/lib/mysql I want them /usr/lib/mysql Thanks in advance -- Stephen Johnson [EMAIL PROTECTED] http://www.pets4u.com Owner / Founder -- your next best friend is waiting for you -- - 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 password
try: mysqladmin -u root password new_password_here - Original Message - From: Jeremiah Jester [EMAIL PROTECTED] To: 'MySQL' [EMAIL PROTECTED] Sent: Tuesday, December 18, 2001 10:50 AM Subject: mysql password Im attempting to install mysql. The service started and everything seems to be going ok except for that I can't set the root password for the mysql server. To reset password i type: /usr/bin/mysqladmin -u root -p mypassword Then I get the following error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Anyone, anyone? Bueller? Fry? JJ - 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