moving databases

Ok, I've set my root password and have found (by creating a db) that the databases are stored (Mac OSX Server 10.3) in /private/var/mysql. I have my old system on a separate hard disk; however, mysql is not functioning there, but I do have my databases there. Can I copy these database to their

help with startup accesss

Hello, I've reinstalled my system (Mac OS 10.3 Server). In trying to get MySQL going again. I can run mysql_install_db, but I can't access the mysql db and I can not set a root user password. If I try to login: mysql -u root it says access denied to [EMAIL PROTECTED] If I simply type "mysql" (n

bit of help? root@localhost denied

Hello, I've reinstalled my system (Mac OS 10.3 Server). In trying to get MySQL going again. I can run mysql_install_db, but I can't access the mysql db and I can not set a root user password. If I try to login: mysql -u root it says access denied to [EMAIL PROTECTED] If I simply type "mysql" (n

Re: establishing a relationship

Yes, a "linking" table or a "map" table or a "join" table. "Linking" is what I see it called in books I have; yes I understand that. I hope to understand the advice for a third more thoroughly, too. I am doing this for practice so the theory of what I'm being taught is what I'm after and afai

establishing a relationship

I have a friend teaching me but I want more :-) (second opinions), please. A simple Database: 2 tables a one-to-many relationship each table has a Primary Key: table1 (one) Primary Key = peopleID; table2 (many) Primary Key = machinesID Normally, I would put the peopleID also in table2 as a For

Re: my first select

SELECT thankyou, thankyou FROM thankyou.thankyou WHERE thankyou = thankyou. It's nice to end the weekend and go to bed with one small success! Though my persistence is unending. ;-) I added ORDER BY lastName on the end, et viola! Thanks and goodnight! Ted On Monday, June 2, 2003, at 03:26 AM, P

my first select

I made a small DB of people and machines, where one person can have more than one machine, each machine can be assigned to only one person. people | machines, one-to-many. I have a primary key ID field in each table (peopleID, machineID) and in the machines table I have the peopleID, the foreig

confusion clearing up

Ok, list friends... I think I get it. My tables are ALREADY populated except for a Foreign Key column. What I think I "get" is that there is no way that the DB can possibly know or be told which row from the master table to insert/correspond (Foreign Key) to which row(s) in the slave ("many")

Re: becoming unconfused

I appreciate this and I have read it several times, the problem is it ain't easy to find a practical example, one with real data. That would I could figure out what "symbol" was. In fact what I am doing now is trying to build a small DB so I can learn these things --the books and I've got lot

Re: becoming unconfused

Thanks, so is this correct, do I run this on table1? table1 table2 studentID -->PK classID -->PK student_name class_name studentID (foreign key) [CONSTRAINT symbol] FOREIGN KEY (studentID) REFERENCES table2 (st

swapping data

how can I swap the data between to columns in the same table? Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: becoming unconfused

I just came from the bookstore where I perused "Mastering MySQL 4". Specifically, I wanted to know how to specify a Foreign Key. After a thorough, albeit short lived search, and reading every page the index on "Foreign Key" pointed to, I deduced that all one needs do is put the blasted field

Re: Inserting data?

I'd be glad to share.. you mean what the db is supposed to be? Ok, there are 3 tables: table1 = people, people_id = primary key table2 = machines, machines_id = primary key One person can have many machines, one machine can only be assigned to one person. The way I was taught, in my limited educ

Inserting data?

I have a table, in the table is a field called name_id; in a second table (a linking table) I also have the field name_id, this should be the same/reference the same name_id as in the first table. The first table is fully populated. How do write a SQL statement to get the data from the name_i

establishing relationship

Someone here (Mike) has been quite kind and responded elaborately to me off-list, thanks Mike! I wanted to go ahead and put this "final" question here: In my database that I'm working on I already have data --a 'one to many' people to machines db. I had made each table with a primary key field

database newbie

Ok, since this is THE place for MySQL and related discussion/questions, here goes: I'm trying to understand Keys, I do for the most part, but in reading the well recommended book 'Database Design for Mere Mortals' I got a bit confused. A check for worthy primary key designation is to ask what

RDBMS listserv?

I'm trying to study some books, like "Database Design for Mere Mortals". I'm finding that I could really use a listserv to get some occasional questions out. Anyone know of any? (Preferably a listserv, but forums will do as well.) Thanks, Ted -- MySQL General Mailing List For list archives: http

Re: database permissions

Thanks, I get: (B (B[localhost:~] ted% ps ax |grep mysql (B 180 ?? S 0:00.04 sh /usr/bin/safe_mysqld (B 197 ?? S 0:00.21 /usr/libexec/mysqld (B 2054 std R+ 0:00.00 grep mysql (B (Bdoes this look good? safe? (B (BThanks again, (BTed (B (B (B (BOn Wednesday, May

Re: database permissions

On Wednesday, May 28, 2003, at 06:31 AM, Jon Haugsand wrote: * [EMAIL PROTECTED] What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. On my system the mysqld deamon runs as mysql and files are owned by mysql

Re: database permissions

oops, oh yeah. I fixed it. TR On Wednesday, May 28, 2003, at 05:56 AM, [EMAIL PROTECTED] wrote: What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list

database permissions

What the permissions/ownership be on my database directory? I think is the cause of my problem of only being able to startup mysqld as 'root'. Thanks. Ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: help with load from file

We, ok. Thank you all. This worked quite nicely and I learned something to boot! TR On Tuesday, May 27, 2003, at 11:00 PM, Steve Gums wrote: The numbers should be without the quotes and the end of line character can stay as is. Once you have this you should be able to do something like this

Re: help with load from file

Yes, I simply don't understand this: === LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES [ST

Re: help with load from file

I also have it prepared like this: "1","Mac","SE30","314784","LOV","115","","","" "2","Mac","Performa6300CD","338211","LOV","109","","","" Also, I did have all the "\" as "\N" previously. But what about at the end of lines. What I had with "\N" wouldn't take so I was hoping someone might out wh

help with load from file

Hi, I have a text file where lines look like this: 3 Mac Performa6300CD 338211 LOV 109 \ \ \ 4 Mac G3BT/266350755 LOV 003 \ 9.1 104.103 Except they are not wrapped like in this email! Each column

about hostnames after setup of MySQL

Mac OS XS 10.2 when you install the OS you have the oppt'y to put in a machine name (not the AppleTalk, Sharing name). i almost always put in a name. that name (mbase), it is also my default web host; that name also shows up at my terminal prompt (instead of the usual "localhost"). if i loo

Re: MySQL database design

on 8/11/02 2:47 PM, Pekka Saarinen, typed: > At 8/11/2002, you wrote: >> MySQL queries.. tables... design. >> >> http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif >> >> There you will see a rough draft of what I am trying to do. >> >> Perhaps you will see some places that I will need to use a

Re: Mysql Problem Query

did you also install the databases that are part of the mysql installation? -Ll on 8/11/02 5:59 AM, Anish Mathew, typed: > my sqlserver is not running > > when i issue the command " mysql" > > the response i got was " cant connect to local mysql > server through socket /var/lib/mysql.sock (

MySQL database design

MySQL queries.. tables... design. http://garnet.acns.fsu.edu/~tlr7425/my_tables.gif There you will see a rough draft of what I am trying to do. Perhaps you will see some places that I will need to use a table_map? Or you can advise me of how to arrange my keys, or otherwise develop this db? I

Re: MySQL 3.23.51 install on OS X

try using "localhost". you have to set the hostname in the install script. on 8/10/02 1:08 PM, Alex Pilson, typed: > I am installing a new MySQL installation on a new Xserve and I am > getting this message; > > [xserve:/usr/local/mysql] admin% sudo ./scripts/mysql_install_db > Sorry, the host

MySQL and Web Objects5 (OS X)

Does anyone know how to cause WO to recognize and offer MySQL as an adaptor? i.e., how to get WO5 to use MySQL?) Thanks in advance. Ted Rogers FSU MathNet | Apple Systems - Before posting, please check: http://www.mysql.com

use of RENAME???

[mysql] is this how to change the the name of an existing populated db? RENAME DATABASE old_name TO new_name; TR - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

change db name???

what is the [MySQL] command to change an existing db name? (is there a book or manual with straightforward question and answer like this?) TIA TR - Before posting, please check: http://www.mysql.com/manual.php (the manual

thank you all!

i'm in the dbs and the book i wanted to be in!!! it was http://home.ubalt.edu/abento/797/mysql/ that helped so much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Permission

this page is helping me A LOT! thank you. At 3:46 PM +0300 7/5/01, Ilan Fait wrote: > Hi, > Check out this URL it is very good to start with. > URL: http://home.ubalt.edu/abento/797/mysql/ > > I hope that it will help > > Best Regards, > Ila

granting ALL!

can i create a new user and 'grant all' to that user on all dbs and THEN add/import new databases and that user will still have all permissions on those as well? - Before posting, please check: http://www.mysql.com/manual.ph

Re: Mac OS X Server 10.0.4 and startup

go here: and put it in that folder. http://www.diax.ch/users/liyanage/software/macosx/mysql-startupitem.pkg.tar.gz note that the user might have to be changed from its default "mysql" at the line: /usr/local/bin/safe_mysqld --user=mysql --err- TR At 11:06 PM -0400 7/5/01, Patrick Larkin wrot

got nowhere faster :(

[MySQL] what does this mean and how can i fix it? Access denied for user: 'niban@localhost' to database 'tracking'Could not drop database tracking thanks. p.s. in this case i believe drop refers to adding or creating... if that is possible... because i am trying to add this db with a script.

still struggling, still here! "owner vs. root"

MySQL. i installed a a package install of the latest MySQL -of the unix [Mac OS X] variety. here's what i did (after the package installed installed itself): - i did this logged in as an administrator (me) AND below wherever it says mysql (as username) i entered my own username... so on the c

started over! root and user pw (easy questions?)

where in the manual does it explain how to set up the root password after an install? i understand that should be the first thing done. as the admin of mysql on my server, should the only method i use to login be by root and said password? OR should i make another username/password for myself

Re: TCP/IP Sockets, UNIX Sockets

unrelated: many times an error reported will say unable to connect me @localhost... what do i do to use a remote host? e.g., [EMAIL PROTECTED] thank you. At 11:27 PM +0200 6/22/01, Benjamin Pflugmann wrote: >Hi. > >On Fri, Jun 22, 2001 at 09:04:14PM +0200, [EMAIL PROTECTED] wrote: >> How do

Re: Knowing if a table exits

1. mysql> SHOW databases; 2. mysql> USE MessageNotification; 3. mysql> SHOW TABLES FROM MessageNotification; hth At 10:58 AM +0200 6/22/01, Tiwonge Nathan Kawonga wrote: >How can I query the database to know that a specific table exists in a >given database. > >for example my database is Messag

what does this mean please?

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and how you fix it? thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

change table name?

how do i change a table's name without recreating it? - 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 <[EMA

Re: Connect mySQL with HTML or something

yes. get MySQL/PHP Database Applications. by J. Greenspan and Brad Burger. enjoy. p.s. your hotmail email addy doesn't work. At 2:03 PM -0300 6/21/01, Laura Lía Marcello wrote: >I need to know if there is a way to create a searchable database that >returns results as a web page... >As you c

complete delete to begin again, instructions please

could someone tell me how to make a clean sweep of MySQL from my system so i can start over? (i need to toss phpMyAdmin temporarily too i get asked for a password at every bend and none of the ones i use' hardly ever' work ;) e. i just don't get the root stuff and winder whay i can't

simple commands, no joy

what's wrong with this please: mysql> -u jjames -psd342 dbtheNetee < /Library/WebServer/web1/book/install/netsloth.dump; -> (as i understand it a .dump = .sql file) thanks. - Before posting, please check: http://ww

RE: .dump files

i guess that is confusing to me because it says "query". i'm really stuck though -see my recent 'please help' post to the mysql list. thanks. At 2:48 AM -0600 6/18/01, Chris Bolt wrote: > > thank you. >> that's sort of what i thought. >> >> now for the silly question: >> i know how to do it w

please help (dumb permissions thing?)

Access denied for user: '@localhost' to database 'netsloth'Could not drop database netsloth (i asume "drop" means to "drop 'in'" in this case?) is what i get back when i try to install the db 'netsloth.dump' from J Greenspan's book and CD. please tell this newcomer what he has to do to fix th

import entire db (small) via phpMyAdmin

Is importing an entire db (small) into MySQL via phpMyAdmin possible? If so, how. Thanks in advance. Ted Rogers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: content management.. was .dump files

i'd like to use the db i sent but unless i'm importing wrong there's an error in it somewhere and thus it won't import. i don't suppose anyone who has it could take a peek? or knows where i can get something like it? Thank you. Ted Rogers At 4:30 AM -0600 6/17/01, Chris Bolt wrote: >That is

RE: .dump files

thank you. that's sort of what i thought. now for the silly question: i know how to do it with 'monitor' (CLI), but where/how do you "import" using phpMyAdmin, please? (this i'd love to know :) i looked through the manual but didn't see anything for "import" db. Ted At 4:30 AM -0600 6/17/01,

RE: .dump files

i had some others that i browsed into phpmyadmin and they seemed to work, but others, like this one, showed a Query error -but that "method" of "imported population" was probably wrong anyway, i guess. thanks here's the file: # MySQL dump 6.8 # # Host: localhostDatabase: netsloth #

.dump files

hello, i have some files from a Cd that are .dump files, how do i get these db into mysql? (is it possible using phpMyAdmin). again, these are ".dump" files, not ".sql" files. thank you. - Before posting, please check: htt