loading files onto MySQL

2007-01-11 Thread Scott Yamahata
Newbie question here. Using Mac OSX Server 10.4.4. Do most MySQL tasks in terminal window. Recently purchased software that tells me to go to Control Panel (which I don't think I have--though I have MySQL tools) and load their file onto the MySQL database. I'm not sure what this means. If I

SQL syntax

2006-12-28 Thread Scott Yamahata
Hi, I'm getting the following error message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' enabled = '1'' at line 3INSERT INTO clf_cities SET cityname = 'Santa Barbara', countryid = , enabled = '1' and

Complete newbie (OSX Server - MySQL)

2006-12-23 Thread Scott Yamahata
Complete newbie here. Purchased software for my OSX Server 10.4.8 to use with MySQL and PHP. I get an installation window that opens and asks for Host: (with a default of localhost). User: site Password: (the one the person who sold me the script provided). Database: site License key: (the

stupid newbie question

2003-11-13 Thread Scott Yamahata
At the command prompt, I'm supposed to type: mysql -h host -u user -p Does that mean that I type, for example: mysql -h localhost -u admin -p with localhost=host and admin=user? When I'm asked for the password, I hit return and it lets me in. But if I try to create a database, by using: GRAN