#5 Cannot work out how to Import the POC database tables
open
nobody
None
5
2003-06-16
2003-06-16
Anonymous
No
I am trying to workout how to import the Import the
POC database tables into my MySQL database, I have
no idea here what i should do or what a command shell i
should use! please help
First, I'd like to suggest getting the most recent phpmyadmin..
(note: the added text below I found searching google with
import poc mysql, it's vague though). What I did, since
mine is not online, I created the name of the database, then
I went into that database, then I hit sql tab and clicked on
browse instead of using the text.. (I had it on my pc, not
online) and it imported it that way. Youo are talking about
the db.schema I hope.
It's located in main chat directory :)
I hope I'ved helped someone (number 2 is the command if not
"browsing" for it)
I just saw the dang date!!! LMBO submitted june of 2003..
that was LAST YEAR. None the less, someone else might be
having trouble and it may help them so I'll continue on and
post.
xts
Import the POC database tables
Open a command-shell and do a:
First point only, if you want to have the POC-SQL-tables in
a separate tablespace. In the most cases, user have already
such a tablespace and there are no problems to import
POC-SQL-tables into this tablespace.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=1149577
First, I'd like to suggest getting the most recent phpmyadmin..
(note: the added text below I found searching google with
import poc mysql, it's vague though). What I did, since
mine is not online, I created the name of the database, then
I went into that database, then I hit sql tab and clicked on
browse instead of using the text.. (I had it on my pc, not
online) and it imported it that way. Youo are talking about
the db.schema I hope.
It's located in main chat directory :)
I hope I'ved helped someone (number 2 is the command if not
"browsing" for it)
I just saw the dang date!!! LMBO submitted june of 2003..
that was LAST YEAR. None the less, someone else might be
having trouble and it may help them so I'll continue on and
post.
xts
Import the POC database tables
Open a command-shell and do a:
1. # mysqladmin create poc
2. # mysql poc < /path/to/poc/db.schema
First point only, if you want to have the POC-SQL-tables in
a separate tablespace. In the most cases, user have already
such a tablespace and there are no problems to import
POC-SQL-tables into this tablespace.