Re: Cannot connect to server
Sara Woglom wrote: Thanks Shawn!! You should be thanking Mladen Adamovic for pointing you to: http://dev.mysql.com/doc/mysql/en/grant.html This page holds your answer. From the error message you got Telnet to port 3306: Host 'my-machine-name' is not allowed to connect to this MySQL server you can be assured that you made a connection to the MySQL server. The problem is the MySQL server doesn't think you should be allowed to connect. I'm sure if you read the page linked above you will be able to persuade your MySQL server into allowing you to connect to it. James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Which PHP for MySQL 4.1
Graham Cossey wrote: Sorry, YMMV? What does that mean? Is there a reference somewhere for all these acronyms? Yes it's called Google. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Error 1045
On Thursday 22 July 2004 09:06 am, Jernej Koprivec wrote: My first contact with MySQL. When I try to login with the following two lines, I get an error code 1045 mysql -h localhost -u jk -p ENTER PASSWORD: password ERROR 1045: Access denied for user: [EMAIL PROTECTED] using password: YES Please help. [EMAIL PROTECTED] Mysql userids/passwords have nothing to do with OS userids/passwords. http://dev.mysql.com/doc/mysql/en/User_Account_Management.html James Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Access denied for user: 'root@localhost' (Using password: NO)
On Thursday 01 July 2004 09:08 am, Nguyen, Long P (Mission Systems) wrote: shouldn't I be able to issue commands at the shell it goes and does it thing and give back output? or does this mean I have a passwd already set and it's secured? http://dev.mysql.com/doc/mysql/en/User_Account_Management.html This might help you out. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Server Down/General Server Questions
On Thursday 24 June 2004 10:20 am, Dirk Bremer \(NISC\) wrote: 1. Is there a way to configure the server to just support MyISAM databases, i.e. disabling the support for InnoDB? My though is that this would prevent the same error from happening again. Put skip-innodb in your my.conf 2. I have more or less a default installation and do not use a .cnf file for settings. I could not locate a .cnf file on the server other than the examples in the mysql root directory, i.e. my-huge, my-large, my-medium, and my-small. Why did the MySQL server complain about the logfile size from a .cnf file? Should I be using a .cnf file and where should it be located? I have but a single, small database with only two tables. Yes I think you need my.cnf, not sure where it goes on windoze though. James Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Form + database / PHP survey + database
On Wednesday 23 June 2004 03:32 pm, tommie ramirez.andujar wrote: Dear colleagues.. I am new to mysql and I am trying to do the following, to create a php file that may contain some kind of form or survey and the data entered may be added to a database. Here's the code of the html form Dearest Colleague, Start writing your project now. No one on this list or the PHP list is going to write this code for you. Either list will be glad to help you with problems you are having with code that you have written. Neither list is going to produce your project for you. I would suggest looking at sourceforge.net for pre-written code. Not Your Code-Monkey, Your Colleagues -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dumping mass inserts?
On Friday 09 April 2004 09:52 am, Mark Susol | Ultimate Creative Media wrote: I'm trying only to update one table from a backup. I have the sql file stripped down to just the INSERT commands. I have emptied the table from phpMyadmin to start. How do I load this sql file so it runs all of the inserts in this file through ssh (70MB)? FTP the sql file to the machine/account that you are ssh'ing into. Then do mysql -u username -p databasename sql_file_to_load James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dumping mass inserts?
On Friday 09 April 2004 11:40 am, Mark Susol | Ultimate Creative Media wrote: On Friday 09 April 2004 11:29 am, you wrote: I'm not getting an error..I'm getting inserts that are NOT in the file I'm directing it to dump. Maybe I don't understand the dump function and how it works with a sql file that is only partially acting on the entire table? Fedora OK, dump usually refers to the act of creating SQL statements from a table into a file. You are trying to process a file that has SQL statements in it. I would call this importing. This is what you are trying to do isn't it? Please give an example of the command you are running. James Ah..I see now. I was still using mysqldump..instead of mysql. Yes I'm trying to import the data from backup, into an empty table since the data was corrupt. Looks like you are on the right track now! :) James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Dumping mass inserts?
On Friday 09 April 2004 12:26 pm, Mark Susol | Ultimate Creative Media wrote: Ok now I want to dump tables with names starting with phpads so I can move them to another db. How is the mysqldump command run then? And when I go to move them to the new db, I do use the mysqldump command since I am dumping to the new db? Mark /var/lib/mysql/ holds all of your DB's. Inside each directory(DB) there are 3 files for each table in that DB (assuming myisam here). You can copy these files to the from one server to the next. It's probably a good idea to stop the servers during this process so that no one can alter the table or try to read from it while you are replacing the old with the new. I don't know that mysqldump takes wildcards so to use that you will probably have to do an individual mysqldump for each table in the DB that you want to dump. Type in man mysqldump to see all the options for mysqldump. James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Prefixing Column Names in Select
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote: You can set it as an alias using AS . Respectfully, Ligaya Turmelle Yes, I was aware of this option, but I was looking for a way to automatically alias all fields with a set prefix or postfix. On a big table it's a lot of typing to alias all fields. I'm lazy! Thanks. James Hicks sql mysql row query table column -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Prefixing Column Names in Select
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote: You can set it as an alias using AS . Respectfully, Ligaya Turmelle Yes, I was aware of this option, but I was looking for a way to automatically alias all fields with a set prefix or postfix. On a big table it's a lot of typing to alias all fields. I'm lazy! Thanks. James Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Prefixing Column Names in Select
Isn't there a way to prefix (or postfix) a tables column names in the results of a select. For example I have a table named from_address. This table has the column names line1,line2,line3,line4,line5. When I do a select query on from_address I want all columns to return as from_line1, from_line2, from_line3, from_line4, from_line5. James mysql, sql, row, select, delete, from, *, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Administration Tools
On Thursday 22 January 2004 02:19 pm, David Blomstrom wrote: I'm using a preconfigured package that includes PHPMyAdmin, which seems to be a pretty good program. However, I just read that similar programs are available, including MySQL Control Center, EMS MySQL Manager, urSAL, PremiumSoft MySQL Studio and MySQLGUI. I just wondered if there might be some advantage to having two or more such programs installed. Would working with MySQL through two different interfaces give you a different perspective, making it a little easier to understand? Or are there particular strengths each program has? All should support what MySQL offers. Whether they do or not is another question. Use what you find most useful. Also, would different MySQL administration tools conflict with each other? No. If you created a new database with phpMyAdmin, would it be recognized by MSQL Control Center? Yes Could you work on MySQL with both programs on at the same time? Yes Thanks. You're welcome. James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Sporadic myisam table corruption.
I'm having sporadic myisam table corruption. This table is constantly being added to, updated, and deleted from. PHPMyAdmin reports that The table is in use when I try to access this table after corruption. After I perform this step in the correct directory everything goes back to normal. myisamchk --recover troubled_table After reading the mysql manual page I changed all the VARCHAR fields to CHAR fields, hoping my problem would dissapear. This change has had no effect on my problem. The only things in the error log are start ups and shutdowns performed nightly. Here's the table definition. CREATE TABLE troubled_table ( office smallint(4) unsigned NOT NULL default '0', ticket_id char(30) NOT NULL default '', item_quantity mediumint(8) unsigned NOT NULL default '0', from_face char(30) NOT NULL default '', from_down decimal(6,1) unsigned NOT NULL default '0.0', from_up decimal(6,1) unsigned NOT NULL default '0.0', from_depth decimal(6,1) unsigned NOT NULL default '0.0', to_face char(30) NOT NULL default '', to_down decimal(6,1) unsigned NOT NULL default '0.0', to_up decimal(6,1) unsigned NOT NULL default '0.0', to_depth decimal(6,1) unsigned NOT NULL default '0.0', associated_document char(30) NOT NULL default '', PRIMARY KEY (office,ticket_id), KEY move_id (ticket_id) ) TYPE=MyISAM COMMENT='Material Move Orders'; mysql --version says: mysql Ver 12.20 Distrib 4.0.13, for pc-linux-gnu (i686) What can I try now? James Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do I know what my MySQL server IP is ??
On Thursday 04 December 2003 03:42 pm, Stéphane Bischoff wrote: Hi, w do I know what my MySQL server IP is ?? thanks How about ifconfig? James Hicks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Slow batch load after 500MB
Thanks, this problem turned out to be a lack of indexing. I figured this out by writing a little PHP script to read and execute the commands one at a time. I then noticed that the delete from table where table_field = 'value' queries were taking the longest. After indexing table_field all queries went very fast! James Hicks -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 7:55 AM To: [EMAIL PROTECTED] Subject: Re: Slow batch load after 500MB James E Hicks III [EMAIL PROTECTED] wrote: I have encountered an interesting problem using mysql. On both 3.23 and another 4.01 server when I try to batch load a file with sql statements (ex. mysql -u user -p mysql_statements.SQL) and the file is greater that 500MB it never seems to finish. I have never had the patiences to see if it ever does. Last night I watched the tables as they were loading and as soon as the DB got to ~ 500 MB the inserts would slow down to a crawl. Before it gets to 500MB the server is loading 100's of records at a time, after 500MB the server may load 2 records/5minutes. When I broke the mysql_statements.SQL into smaller files and consecutively loaded these files, the load only took 5 minutes top. Any ideas what I can do to get these large files to load without breaking them down? Is there a server config value I missed? James E Hicks III Looks quite strange: I have used to load gigabytes of data this way with no problem. Try to upgrade server to the latest binary release (4.0.13?) for your OS.. -- 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 -- 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]
Slow batch load after 500MB
I have encountered an interesting problem using mysql. On both 3.23 and another 4.01 server when I try to batch load a file with sql statements (ex. mysql -u user -p mysql_statements.SQL) and the file is greater that 500MB it never seems to finish. I have never had the patiences to see if it ever does. Last night I watched the tables as they were loading and as soon as the DB got to ~ 500 MB the inserts would slow down to a crawl. Before it gets to 500MB the server is loading 100's of records at a time, after 500MB the server may load 2 records/5minutes. When I broke the mysql_statements.SQL into smaller files and consecutively loaded these files, the load only took 5 minutes top. Any ideas what I can do to get these large files to load without breaking them down? Is there a server config value I missed? James E Hicks III Noland Company 2700 Warwick Blvd Newport News, VA 23607 757-928-9000 ext 435 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Your professional opinion Please...
I'd use MySQL, Apache, and UDMSEARCH. It provides the web interface for the google search engine (Apache and UDMSearch), while connecting to MySQL. If you want, the re-indexing can occur using a cron, and then by making apache serve the documents from the root and doing the fancy indexing. I suppose this is getting off topic, though. [grin] Joe UDMSEARCH is now mnoGoSearch. I pity the fool that is forced to run this on Windows! It seems the linux version is GPL'd and the Windows version is going to cost you. Ha ha... James sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlimport: Error: Can't get stat of
Why am I getting this error? I have looked on google and it said to use the full path when naming the import file. I have done this and still get the error. What else could I be doing wrong? # mysqlimport -d --fields-optionally-enclosed-by=\' --fields-terminated-by=, --use r=userid --password=pword DB_2update /fullpathto/thefile.SQL mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: 13), w hen using table: thefile For the filter. sql, query James E Hicks III Noland Company 2700 Warwick Blvd Newport News, VA 23607 757-928-9000 ext 435 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqlimport: Error: Can't get stat of
Please ignore this this problem as I found the answer. For those inquring minds, I added a -L to the mysqlimport command and we are all happy now. James -Original Message- From: James E Hicks III [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 2:48 PM To: Mysql Subject: mysqlimport: Error: Can't get stat of Why am I getting this error? I have looked on google and it said to use the full path when naming the import file. I have done this and still get the error. What else could I be doing wrong? # mysqlimport -d --fields-optionally-enclosed-by=\' --fields-terminated-by=, --use r=userid --password=pword DB_2update /fullpathto/thefile.SQL mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: 13), w hen using table: thefile For the filter. sql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a better way?
Below is a little PHP code snippet which works great(returns results quickly) for single queries. However when I put this code into a loop incrementing the order_index and line, my application can take as long as 2 minutes to return results. Is there any other way to execute this series of queries more effeciently to come up with $order_line_due? The only steps I have taken so far to decrease query time was to verify that there were indexes set on the order_index and line fields in each table queried. mysql_select_db(orders); $query = select order_quantity ; $query .= from order_lines where (order_index = '$order_index'); $query .= and (line = $line); @extract(mysql_fetch_array(mysql_query($query))); $linequery = select sum(quantity) as already_received ; $linequery .= from receiving_lines ; $linequery .= where ( order_index = '$order_index' ) ; $linequery .= and( line = $line ) ; @extract(mysql_fetch_array(mysql_query($linequery))); $linequery = select sum(quantity) as adjust_receive ; $linequery .= from receiving_line_adjustments ; $linequery .= where ( order_index = '$order_index' ) ; $linequery .= and( line = $line ) ; @extract(mysql_fetch_array(mysql_query($linequery))); $order_line_due = $order_quantity - $already_received + adjust_receive; I hope the PHP code is not to hard for the MySQL gurus to decipher in order to help! James E Hicks III Noland Company 2700 Warwick Blvd Newport News, VA 23607 757-928-9000 ext 435 [EMAIL PROTECTED] For the filter (mysql MySQL SQL table row insert select delete) - 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
Legal query?
Is this query legal? select distinct purchase_orders.header.vendor_number as number, vendor_master.address.sequence_name as name from purchase_orders.header, vendor_master.address where purchase_orders.header.branch = 10 With these DB's # Database : `purchase_orders` # CREATE TABLE header ( branch mediumint(5) unsigned NOT NULL default '0', vendor_number mediumint(7) unsigned NOT NULL default '0' ) TYPE=MyISAM; # # Database : `vendor_master` # CREATE TABLE address ( vendor_number mediumint(6) unsigned NOT NULL default '0', sequence_name varchar(30) NOT NULL default '' ) TYPE=MyISAM; # query query query query query query query sql sql sql sql sql sql sql sql James - 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 Checkbox table field
I've been using enum (Y,N). James -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 10:58 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Checkbox table field Alright then! database,sql,query,table Which field type do I use for a simply checkbox Y,N? 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