Re: Cannot connect to server

2006-03-14 Thread James E Hicks III
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

Re: Which PHP for MySQL 4.1

2004-11-11 Thread James E Hicks III
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

2004-07-22 Thread James E Hicks III
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

Re: Access denied for user: 'root@localhost' (Using password: NO)

2004-07-01 Thread James E Hicks III
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?

Re: Server Down/General Server Questions

2004-06-24 Thread James E Hicks III
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

Re: Form + database / PHP survey + database

2004-06-23 Thread James E Hicks III
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

Re: Dumping mass inserts?

2004-04-09 Thread James E Hicks III
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

Re: Dumping mass inserts?

2004-04-09 Thread James E Hicks III
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

Re: Dumping mass inserts?

2004-04-09 Thread James E Hicks III
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

Re: Prefixing Column Names in Select

2004-02-19 Thread James E Hicks III
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

Re: Prefixing Column Names in Select

2004-02-19 Thread James E Hicks III
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

Prefixing Column Names in Select

2004-02-18 Thread James E Hicks III
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,

Re: MySQL Administration Tools

2004-01-22 Thread James E Hicks III
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

Sporadic myisam table corruption.

2003-12-12 Thread James E Hicks III
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.

Re: How do I know what my MySQL server IP is ??

2003-12-04 Thread James E Hicks III
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

2003-07-10 Thread James E Hicks III
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

Slow batch load after 500MB

2003-07-03 Thread James E Hicks III
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

RE: Your professional opinion Please...

2003-03-25 Thread James E Hicks III
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

mysqlimport: Error: Can't get stat of

2003-03-24 Thread James E Hicks III
=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

RE: mysqlimport: Error: Can't get stat of

2003-03-24 Thread James E Hicks III
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

Is there a better way?

2003-02-08 Thread James E Hicks III
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

Legal query?

2002-12-10 Thread James E Hicks III
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` #

RE: MySQL Checkbox table field

2002-01-25 Thread James E. Hicks III
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