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 :(
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-09-30
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 :(
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
You need to use PHPMyAdmin.
Install it and it will allow you to choose a sql file (db.schema) to run. The file has instructions on how to create the tables in a db. PHPMyAdmin carries out those instructions.
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 :(
You need to use PHPMyAdmin.
Install it and it will allow you to choose a sql file (db.schema) to run. The file has instructions on how to create the tables in a db. PHPMyAdmin carries out those instructions.