Create Temporary Table
Hi, PHP Version 4.3.1 Mysql Version 4.0.13 When I try and run the following query CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable; on each database, the first one will run it with no problems at all. The second returns the error: [server] ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'database' I have tried running the same query from MySQL at my site, from via the PHP interface I am working with and also via PHPMyAdmin, each returns the same error. One thing I should note. The CREATE TEMPORARY TABLE syntax does not work, however if I were to use the CREATE TABLE syntax, it works fine. But I'd rather use the TEMPORARY tables. This problem appears to be intermittent, it will work fine for a few days, then fail for an undetermined amount of time. I have checked with my ISP, they are sure that the rights haven't changed, and I have CREATE TEMPORARY TABLE rights. Any ideas why this is intermittent? Thanks for your help! Phil Dowson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: [PHP-DB] Create Temporary Table
Does the ip address of where you are trying to access the mysql database from (client), change?If you have a dynamic ip address your ISP should have a grant something to the effect of: grant all on database.* to [EMAIL PROTECTED] identified by 'password'; This would allow your client to be any address on the 10.1.X.X network. You can just grant access to the database to [EMAIL PROTECTED] if you want that user to be able to access the database from any ip address. This might have some security implications for you, if it's wide open on the Internet. That's the only reason I can think for intermittent problems. Cheers, ~Steve Phil Dowson wrote: Hi, PHP Version 4.3.1 Mysql Version 4.0.13 When I try and run the following query CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable; on each database, the first one will run it with no problems at all. The second returns the error: [server] ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'database' I have tried running the same query from MySQL at my site, from via the PHP interface I am working with and also via PHPMyAdmin, each returns the same error. One thing I should note. The CREATE TEMPORARY TABLE syntax does not work, however if I were to use the CREATE TABLE syntax, it works fine. But I'd rather use the TEMPORARY tables. This problem appears to be intermittent, it will work fine for a few days, then fail for an undetermined amount of time. I have checked with my ISP, they are sure that the rights haven't changed, and I have CREATE TEMPORARY TABLE rights. Any ideas why this is intermittent? Thanks for your help! Phil Dowson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
select help
Hello list, I'm really new to mysql and databases in general. I have a select form that contains a very long list of options, and what I want to do is store the selected item as a number instead of the items name in order to speed up searches. My problem comes when a search is done and I can't figure out how to return the query with the items name not the number. Any suggestions and help is greatly appreciated. Dan Cox -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select help
I'm new, too, so someone correct me if I'm wrong, but... if you make it an ENUM field in a table you can store it using the value in the selection, retrieve it as the same value, and still get all the advantages of numeric storage. Todd On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote: Hello list, I'm really new to mysql and databases in general. I have a select form that contains a very long list of options, and what I want to do is store the selected item as a number instead of the items name in order to speed up searches. My problem comes when a search is done and I can't figure out how to return the query with the items name not the number. Any suggestions and help is greatly appreciated. Dan Cox -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: select help
Another option is to have another table with the item name and number using that as a lookup table. IMHO it all depends on the data if the select is static (or rarely changes) an enum would be best. If is changes a lot then I would use another table to store it in. -Michael I protect you, skin brother. -mriswith On Sun, 6 Jul 2003, Todd O'Bryan wrote: I'm new, too, so someone correct me if I'm wrong, but... if you make it an ENUM field in a table you can store it using the value in the selection, retrieve it as the same value, and still get all the advantages of numeric storage. Todd On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote: Hello list, I'm really new to mysql and databases in general. I have a select form that contains a very long list of options, and what I want to do is store the selected item as a number instead of the items name in order to speed up searches. My problem comes when a search is done and I can't figure out how to return the query with the items name not the number. Any suggestions and help is greatly appreciated. Dan Cox -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
group by query with string manipulation
I'm running this query to get a count of categories I have in a field that contains aircraft categories. SELECT substring(category,10), count(*) FROM `links` where category like 'Aircraft/Sales%' group by category order by category and getting these results: --- Sales/Dealers7 Sales203 I would like to get these results: - Sales210 but am not sure how to manipulate the category field to do this. Thanks in advance.
Determining primary field
Hello, I apologize if this is a very simple question but I have spent the last half hour searching for an answer to it and have thus far been unable to find one. I am pretty new to mysql so please be easy on me if this is painfully obvious :) I am trying to determine the primary field in a table through a query from php to my database. I have several tables that could be potentially queried by a particular function in my web site, but the primary field used to identify the ID for different item types are all named specifically to match the table and item type that it is stored in it. My solution to this was to use the primary key in each table as the identifying factor to compare the item ID with the correct field data. I have not been able to find any information on how to obtain the primary field so as to compare its value for each row to the item ID that I want to match. Thank you in advance for any assistance or direction that you could point me in.
Re: Optimal Disk Configuration
I just assumed your question was for mysql data only.. If you want total I use: OS - raid 1 (2 X 18.2gb - 10kRPM) DATA - raid 0+1 (# X 18.2gb - 15kRPM) usually a dataset is comprised of 6-10 disks.. you could go larger with the drive size.. but more spindles = more thruput Swap isn't much of an issue as memory is very inexpensive.. 2-4GB of ram in a machine configured correctly with mysql shouldn't use swap much.. On Sat, 5 Jul 2003, Jim McAtee wrote: That's it? The entire system - OS, swap space and data in a single array? Nothing more involved? [EMAIL PROTECTED] wrote: My favourite for dedicated db servers (good amount of data, but a ton of access, queries/sec) is raid 0+1 ... fast access, but requires a good number of disks.. Be sure to use a good raid controller, multiple channels for the disks if possible.. On Sat, 5 Jul 2003, Jim McAtee wrote: What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Determining primary field
you mean the primary key (also called primary index), do you? just query 'SHOW INDEX FROM yourtable' and read all rows with Key_name = 'PRIMARY'. you can play around with this in the mysql commandline. you'll get all column names that belong to the primary key in the Column_name field of the returned recordset. at least, that's how it is in mysql 3.23.56-nt... ··· yves at unclassified.de -Ursprüngliche Nachricht- Von: Resolution [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Sonntag, 6. Juli 2003 23:35 Betreff: Determining primary field Hello, I apologize if this is a very simple question but I have spent the last half hour searching for an answer to it and have thus far been unable to find one. I am pretty new to mysql so please be easy on me if this is painfully obvious :) I am trying to determine the primary field in a table through a query from php to my database. I have several tables that could be potentially queried by a particular function in my web site, but the primary field used to identify the ID for different item types are all named specifically to match the table and item type that it is stored in it. My solution to this was to use the primary key in each table as the identifying factor to compare the item ID with the correct field data. I have not been able to find any information on how to obtain the primary field so as to compare its value for each row to the item ID that I want to match. Thank you in advance for any assistance or direction that you could point me in. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
need help
my coulmn (id) is an auto_increment coulmn and lets say that i have 100 entries, so the problem is that when i delete all entries on my table, the column (id) starts from 101 ,shouldn't is starts from 1 again! please i need help with this
Re: [PHP-DB] Create Temporary Table
The IP address CAN change, but doesn't change on such a basis that it would cause a problem. You see the issue also appears whether I am [EMAIL PROTECTED] or [EMAIL PROTECTED] it doesn't matter where I am coming from. Thx - Original Message - From: Stephen March [EMAIL PROTECTED] To: Phil Dowson [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, July 06, 2003 2:29 am Subject: Re: [PHP-DB] Create Temporary Table Does the ip address of where you are trying to access the mysql database from (client), change?If you have a dynamic ip address your ISP should have a grant something to the effect of: grant all on database.* to [EMAIL PROTECTED] identified by 'password'; This would allow your client to be any address on the 10.1.X.X network. You can just grant access to the database to [EMAIL PROTECTED] if you want that user to be able to access the database from any ip address. This might have some security implications for you, if it's wide open on the Internet. That's the only reason I can think for intermittent problems. Cheers, ~Steve Phil Dowson wrote: Hi, PHP Version 4.3.1 Mysql Version 4.0.13 When I try and run the following query CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable; on each database, the first one will run it with no problems at all. The second returns the error: [server] ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'database' I have tried running the same query from MySQL at my site, from via the PHP interface I am working with and also via PHPMyAdmin, each returns the same error. One thing I should note. The CREATE TEMPORARY TABLE syntax does not work, however if I were to use the CREATE TABLE syntax, it works fine. But I'd rather use the TEMPORARY tables. This problem appears to be intermittent, it will work fine for a few days, then fail for an undetermined amount of time. I have checked with my ISP, they are sure that the rights haven't changed, and I have CREATE TEMPORARY TABLE rights. Any ideas why this is intermittent? Thanks for your help! Phil Dowson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Printing to printer
I am new to SQL and was wondering if there was a query that would allow me to print to my printer. I have tried the TO PRINTER, TO FILE, |lpr, and others, but get the syntax error. I am running MySQL on a WIndows XP Home system. My company has asked me to transfer a clients file to forms for printed output. My queries can get the information needed, with the exception of output. Thanks! Vince Bravdica [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help
my coulmn (id) is an auto_increment coulmn and lets say that i have 100 entries, so the problem is that when i delete all entries on my table, the column (id) starts from 101 ,shouldn't is starts from 1 again! please i need help with this Use truncate table, it will reset the auto_incement. -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help
Is there any way to seed a column set to autoincrement? Say I wanted it to begin at 1. - Original Message - From: Greg Donald [EMAIL PROTECTED] To: wael fareed [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, July 06, 2003 4:42 PM Subject: Re: need help my coulmn (id) is an auto_increment coulmn and lets say that i have 100 entries, so the problem is that when i delete all entries on my table, the column (id) starts from 101 ,shouldn't is starts from 1 again! please i need help with this Use truncate table, it will reset the auto_incement. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help
Is there any way to seed a column set to autoincrement? Say I wanted it to begin at 1. alter table table_name auto_increment = 1; -- Greg Donald http://destiney.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Printing to printer
Hi Vince, I assume you want to print to your printer from the mysql client (command line) here is what I do: 0) set up a lp queue (line printer) and make sure it works then proceed to 1) 1a) mysql pager /usr/bin/less mysql \P lp; PAGER set to lp; mysql SHOW INNODB STATUS ; request id is IPSIO8000-2DPS-129 (1 file(s)) 1 row in set (0.01 sec) or you do it like this 1b) mysql command \T ~/outputfilename mysql \t The first command in 1b) starts the output into th file (parallel to the screen) the second (\t) will stop the output. Use the normal print command to print the file. I hope that helps. Best regards Nils Valentin Tokyo/Japan 2003 7 7 07:27Vince : I am new to SQL and was wondering if there was a query that would allow me to print to my printer. I have tried the TO PRINTER, TO FILE, |lpr, and others, but get the syntax error. I am running MySQL on a WIndows XP Home system. My company has asked me to transfer a clients file to forms for printed output. My queries can get the information needed, with the exception of output. Thanks! Vince Bravdica [EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Hi Kevin, try this: 1) stop the mysql server 2) mysqld_safe --skip-grant-tables 3) mysql -u root 4) mysql SHOW GRANTS FOR root; 5) GRANT ALL ON *.* TO 'root'@'%'; 6) restart the server (without --skip-grant-table option) and try to login Best regards Nils Valentin Tokyo/Japan 2003 7 5 00:29Victoria Reznichenko : Kevin H. Phillips [EMAIL PROTECTED] wrote: I am trying to set up mysql 4.0.13 on my RedHat 9 machine. I rebuilt the source rpm. (I had a previous installation which I deleted first). I can log on to the mysql monitor as root but can't creat databases, can't change passwords, can't grant privileges, can't select hosts, can't seem to do anything. I'm getting Errors 1044 2003. Here's some of the output: [EMAIL PROTECTED] root]# mysql -u root mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 4.0.13-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE DATABASE mydatabase; ERROR 1044: Access denied for user: '@localhost' to database 'mydatabase' mysql \q Bye [EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1 ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111) [EMAIL PROTECTED] root]# mysql -u root mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 4.0.13-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql SHOW GRANTS FOR root; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql This may have been covered before. If so, I apologize for the repition. What is the output of SELECT USER()? -- 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
2003 7 7 10:28Nils Valentin : Hi Kevin, try this: 1) stop the mysql server 2) mysqld_safe --skip-grant-tables 3) mysql -u root 4) mysql SHOW GRANTS FOR root; 5) GRANT ALL ON *.* TO 'root'@'%'; GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION; sorry for the mistake. Best regards Nils Valentin Tokyo/Japan 6) restart the server (without --skip-grant-table option) and try to login Best regards Nils Valentin Tokyo/Japan 2003 7 5 00:29Victoria Reznichenko : Kevin H. Phillips [EMAIL PROTECTED] wrote: I am trying to set up mysql 4.0.13 on my RedHat 9 machine. I rebuilt the source rpm. (I had a previous installation which I deleted first). I can log on to the mysql monitor as root but can't creat databases, can't change passwords, can't grant privileges, can't select hosts, can't seem to do anything. I'm getting Errors 1044 2003. Here's some of the output: [EMAIL PROTECTED] root]# mysql -u root mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 4.0.13-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql CREATE DATABASE mydatabase; ERROR 1044: Access denied for user: '@localhost' to database 'mydatabase' mysql \q Bye [EMAIL PROTECTED] root]# mysql -u root -h 127.0.0.1 ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111) [EMAIL PROTECTED] root]# mysql -u root mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 4.0.13-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql SHOW GRANTS FOR root; ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql This may have been covered before. If so, I apologize for the repition. What is the output of SELECT USER()? -- 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 -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Disable InnoDB
Hi, This may be a stupid question but can I still just ask it? Why do you want to disable the use of InnoDB tables? If you don't use it, couldn't the files still be there? It's not like it's a security risk (or is it?) or that it takes up lots of space? (maybe this is true as well?) I'm just starting out and my innoDB files are small. Cheers, Mun Heng, Ow H/M Engineering Western Digital M'sia DID : 03-7870 5168 -Original Message- From: Mike Blezien [mailto:[EMAIL PROTECTED] Sent: Saturday, July 05, 2003 9:03 AM To: [EMAIL PROTECTED] Subject: Re: Disable InnoDB Thanks, that did the trick :) Jeremy Zawodny wrote: On Fri, Jul 04, 2003 at 07:26:54PM -0500, Mike Blezien wrote: Hello, Happy 4th to all :) Anyway, I am attempt to temporarily disable InnoDB tables. We just setup on a new RH/Linux 7.3 server that had the MySQL version 4.0.13 from RPM's, pre-installed... but we currently don't need the InnoDB tables but may in the near future... I've commented out all the relavent setting in the my.cnf file in the data dir(/var/lib/mysql/my.cnf).. then restarted the MySQL server, but it's still creates all the data file related to the InnoDB tables. is it not possible to disable the use of InnoDB tables using the my.cnf file or not with RPM's ?? Put skip-innodb in your my.cnf file. -- MikemickaloBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Web Hosting http://www.justlightening.net Tel: 1(985)902-8484 MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Possible OT: ADONewConnection Error
Post the code Martin - Original Message - From: marvc [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 05, 2003 7:08 PM Subject: RE: Possible OT: ADONewConnection Error I take it no one is familiar with particular error? Didn't get anything on google. -Original Message- From: marvc [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 9:00 PM To: [EMAIL PROTECTED] Subject: Possible OT: ADONewConnection Error Anyone here familiar with the following error: ADONewConnection: Unable to load database driver '' Fatal error: Call to a member function on a non-object in /wwwroot/htdocs/webdev/nubiint/includes/pnAPI.php on line 486 I get this error when trying to configure multisites in my postnuke site. I thought it was an ODBC issue but I've installed both MyODBC iODBC and still get the error. Anyone have any ideas on what else could be causing this? Any responses are appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Hi, Nils I can't get the mysql server to stop! If I try service mysqld stop I get a FAILED error. If I try mysqladmin -u root -p shutdown, I get: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' [EMAIL PROTECTED] root]# If I try shutting down without using a password, I get a message saying that access is denied; I need shutdown privileges for this operation. I have pinged the server and it *says* that it is alive. Perplexing problem, no? Kevin Nils Valentin wrote: 2003 7 7 10:28Nils Valentin : Hi Kevin, try this: 1) stop the mysql server 2) mysqld_safe --skip-grant-tables 3) mysql -u root 4) mysql SHOW GRANTS FOR root; 5) GRANT ALL ON *.* TO 'root'@'%'; GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION; sorry for the mistake. Best regards Nils Valentin Tokyo/Japan 6) restart the server (without --skip-grant-table option) and try to login Best regards Nils Valentin Tokyo/Japan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1044 Error 2003 on 4.0.13 and RH9
Hi Kevin, There is a way to sop the server on OS level. However I am not sure if you want to do it this way. You can use the kill command, but be aware that it might damage a data file if the database is accessing it in just this moment. Having said this warning, here is what you can do: 1) ps ax |grep mysqld to display the process ID. You will get something like 704 ?SW 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid 756 ?S 0:01 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking 923 ?S 0:00 /usr/sbin/mysqld-max --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysql/mysql.pid --skip-locking 2) kill -9 processid) That WILL stop the mysqld demon. In case you see several processes (which is more likely), just start wit the first processid shown. 3) Check again with ps ax |grep mysqld that ALL processes stopped. 4) proceed as described in my previous e-mail. 5) After having setup the rights for the root user. you should make sure that all database files are intact (myisamchk etc) Best regards Nils Valentin Tokyo/Japan 2003 7 7 11:16Kevin H. Phillips : Hi, Nils I can't get the mysql server to stop! If I try service mysqld stop I get a FAILED error. If I try mysqladmin -u root -p shutdown, I get: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)' [EMAIL PROTECTED] root]# If I try shutting down without using a password, I get a message saying that access is denied; I need shutdown privileges for this operation. I have pinged the server and it *says* that it is alive. Perplexing problem, no? Kevin Nils Valentin wrote: 2003 7 7 10:28Nils Valentin : Hi Kevin, try this: 1) stop the mysql server 2) mysqld_safe --skip-grant-tables 3) mysql -u root 4) mysql SHOW GRANTS FOR root; 5) GRANT ALL ON *.* TO 'root'@'%'; GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION; sorry for the mistake. Best regards Nils Valentin Tokyo/Japan 6) restart the server (without --skip-grant-table option) and try to login Best regards Nils Valentin Tokyo/Japan -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal Disk Configuration
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jim, What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? That depends on what your definition of optimal is... ;-P -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/B4xxmk7m2JX6ki4RAoOaAJ9JCEj8XSPY6X9vh14O7UVk/GU1fwCeLE7C 59yx9fQEV1xX8oqXEtw2RDY= =Nuab -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal Disk Configuration
David Lloyd wrote: What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? That depends on what your definition of optimal is... Start with performance and work from there. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Optimal Disk Configuration
Jim McAtee wrote: David Lloyd wrote: What would be the ideal RAID configuration for a dedicated MySQL db server running on FreeBSD? We're also running some MySQL databases on Windows 2000 Servers. What about the best configuration for a dedicated W2k server running MySQL? That depends on what your definition of optimal is... Start with performance and work from there. I should add one assumption: The RAID array where the data resides must offer some degree of fault tolerance. At least to the degree of being able to survive a single disk failure within the array. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Image files
Hi, I want to save image files into BLOB fields?? How do i do it?? And how to retrieve it back from database?? ___ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek Kareena http://www.mpkdh.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]