I got POC to work on a Windoze XP machine and a Linux server. The db.schema should go in quietly with no problems. I think you aren't connecting to your database.
Does the database "poc" exist? For my Windoze installation, I had to create it. I used the mysqladmin command the POC guys give you:
mysqladmin create poc
Or something like that. For my Linux installation, my ISP already had a database for me, so I didn't create one.
Once you create the database (or have one already) you need to connect to it then send it the mysql commands listed in the schema.db file.
I see one problem with your second mysql command. Where you have "-p password" won't work. Either you need "-pass=password" or "-ppassword" (note no space) or just "-p" and then you will get prompted for a password.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Oh yeah, to run the mysql commands I used Cygwin. That's a Windoze program that allows you to make a Unix shell. It's a wonderful thing for Unix junkies. You can download it off the web (it's open source).
There may be a way to run mysql commands with DOS or some Windoze thing. Dunno.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I should have said to run the mysql commands "on Windoze" I used Cygwin. That gave me a Unix environment.
To run them on my ISP's Linux server, I asked them for a SSH connection. They gave it to me (nice guys). I was able to log in, find their mysql binary, and run the above commands from my own directory on the server.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2004-09-03
You know, PhpMyAdmin is a real cool tool and I would honestly suggest you use it.
Other methods can be confusing for the rookie/newbe. PHP authors like myself are sensitive to the language we use in our instructions, but some speek the technical language that confuses. Just because there smart with PHP doesn't mean than can communicate any other way.
Jared.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm totally new to MySQL and PHP - and I've gotten everything set up to the point where I need to mess with db.schema.
I have absolutley no idea what I need to do with this file, I've tried to use the commands that were on the test page, but nothing seems to work.
The directory structure is c:\mysql\data\chat for the database
and db.schema is in c:\mysql\bin\db.schema
What am I doing wrong :(
When I input what I think is right, I get spammed with a bunch of stuff, to include
local-infile FALSE
no-beep FALSE
host (No default value)
html FALSE
xml FALSE
line-numbers TRUE
unbuffered FALSE
column-names TRUE
port 3306
prompt mysql>
quick FALSE
raw FALSE
socket (No default value)
table FALSE
debug-info FALSE
user three_sixteen
safe-updates FALSE
i-am-a-dummy FALSE
connect_timeout 0
max_allowed_packet 16777216
net_buffer_length 16384
select_limit 1000
max_join_size 1000000
But nothing new shows up in the database :(
Ive tried
mysql poc < /mysql/bin/db.schema
mysql -u three_sixteen -p password poc < /mysql/bin/db.schema
I can't figure out what I'm doing wrong. The server is on my own computer.
I got POC to work on a Windoze XP machine and a Linux server. The db.schema should go in quietly with no problems. I think you aren't connecting to your database.
Does the database "poc" exist? For my Windoze installation, I had to create it. I used the mysqladmin command the POC guys give you:
mysqladmin create poc
Or something like that. For my Linux installation, my ISP already had a database for me, so I didn't create one.
Once you create the database (or have one already) you need to connect to it then send it the mysql commands listed in the schema.db file.
I see one problem with your second mysql command. Where you have "-p password" won't work. Either you need "-pass=password" or "-ppassword" (note no space) or just "-p" and then you will get prompted for a password.
Oh yeah, to run the mysql commands I used Cygwin. That's a Windoze program that allows you to make a Unix shell. It's a wonderful thing for Unix junkies. You can download it off the web (it's open source).
There may be a way to run mysql commands with DOS or some Windoze thing. Dunno.
Bah. I'm really confusing things.
I should have said to run the mysql commands "on Windoze" I used Cygwin. That gave me a Unix environment.
To run them on my ISP's Linux server, I asked them for a SSH connection. They gave it to me (nice guys). I was able to log in, find their mysql binary, and run the above commands from my own directory on the server.
You know, PhpMyAdmin is a real cool tool and I would honestly suggest you use it.
Other methods can be confusing for the rookie/newbe. PHP authors like myself are sensitive to the language we use in our instructions, but some speek the technical language that confuses. Just because there smart with PHP doesn't mean than can communicate any other way.
Jared.