How to import MySQL tables from Linux?

2003-06-11 Thread CM Miller
Instead of creating tables manually in MySQL, I would like to import them. I have done this under Oracle, with the following @a:\sqlfiles\foo.sql How do I import sql files into mysql using Linux? I have a directory under /root/sql thanks -Chris = GTFG GAIM ID: cmmiller1973

Re: Can't insert data from Apache/PHP

2003-06-10 Thread CM Miller
>I started troubleshooting the code and discovered the >problem was the >new >register globals which is defaulted to off in PHP 4.22. >The PHP >wasn't >holding session and wasn't inserting the records into >the mySQL >database. >I got it working now by switching the register globals >back to

Logging Into MySQL

2003-06-09 Thread CM Miller
Hello. Been lurkin' on the list for awhile, I have the summer off, got Paul's book MySQL next to me, so I'm gonna hunker down and learn mysql on RH 8.0. Anyway, I'm learning about logging in. I saw the thread about user mysql and not having a password. When I do the following for logging int

Still Cannot Get MySQL To Run

2003-01-07 Thread CM Miller
Have a new years resolution, to get MySQL to run Here are the errors that I keep getting... I don't understand what this is telling me? from /var/log 021214 19:13:21 mysqld started 021214 19:13:21 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (er rno: 13) 021214 19:13:21

Missing my.cnf file

2002-11-04 Thread CM Miller
Having some other folks helping me out here with this MySQL problems that I am having. I have found out that I am missing the my.cnf from the /etc directory and I am trying to create the file from scratch, this is what I have so far and also MySQL is installed from .tgz in this directory. /usr

Cannot Log into MySQL

2002-11-01 Thread CM Miller
Still workin' at it here. Ok, I've added to my PATH /usr/local/MySQL/mysql-3.23.-52-pc-linux-gnu-i686/bin and at least I'm getting this now $ mysql Error 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) I'm not sure what it is trying to tell me, btw, I'm run

Still not getting a mysql prompt

2002-10-31 Thread CM Miller
t; >restart mysql. > > >-Original Message- >From: CM Miller [mailto:cmmiller1973@;yahoo.com] >Sent: Thursday, October 31, 2002 9:42 AM >To: [EMAIL PROTECTED] >Subject: How do I log into MySQL? > > > >I can start/stop the daemon for MySQL with no problem.

How do I log into MySQL?

2002-10-31 Thread CM Miller
I can start/stop the daemon for MySQL with no problem. And, if i ps -aux | grep mysql I show that it is running, but if I check the log I get the following output: 021025 20:11:44 mysqld started 021025 20:11:44 /usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld: Can't create/write to

MySQL newbie installation question

2002-10-18 Thread CM Miller
Very new to MySQL and I've done a search on google.com, but really couldn't find the answer that I am looking for. Where should I install MySQL? I'm running RH 7.3 and I've installed the tgz file under my directory /home/CMMiller, is this right, or anywhere else? I see it is also under /usr/s