Home | Community | Message Board


FreeSpores.com
Please support our sponsors.

General Interest >> Science and Technology

Welcome to the Shroomery Message Board! You are experiencing a small sample of what the site has to offer. Please login or register to post messages and view our exclusive members-only content. You'll gain access to additional forums, file attachments, board customizations, encrypted private messages, and much more!

Jump to first unread post. Pages: 1
Invisiblesherm
sherman
 User Gallery

Registered: 10/02/03
Posts: 20,498
Loc: Euthanasia
mysql hint please
    #4358769 - 07/01/05 10:16 AM (11 years, 5 months ago)

i must
create a database
create a user

and then

-execute the create table comands and the starting table content from
/usr/share/doc/phpbb2/shemas/&dbms_{schema,basic}.sql

what does it mean "starting table content"
that line gets me lost?

a little push in the right direction would be great.
thanks


--------------------
shroomery.
not even once.



Post Extras: Print Post  Remind Me! Notify Moderator
OfflineSeussA
Error: divide byzero

Folding@home Statistics
Registered: 04/27/01
Posts: 23,480
Loc: Caribbean
Last seen: 26 days, 1 hour
Re: mysql hint please [Re: sherm]
    #4358789 - 07/01/05 10:31 AM (11 years, 5 months ago)

My guess is that "starting table content" is the default values that are stored in the tables on a fresh install... just a guess...

usually, something like:

mysql -hlocalhost -uroot -p database_name < data.sql


--------------------
Just another spore in the wind.


Post Extras: Print Post  Remind Me! Notify Moderator
Invisiblesherm
sherman
 User Gallery

Registered: 10/02/03
Posts: 20,498
Loc: Euthanasia
Re: mysql hint please [Re: Seuss]
    #4358870 - 07/01/05 11:17 AM (11 years, 5 months ago)

oooohh.....
thanks
your right
it wants me to load the default values to get started

now i just have to figure out how to do that  :confused:


my book says i can do it like this

mysql> LOAD DATA INFILE "/*/what_i_need.sql" INTO TABLE phpbb2;

does this sound about right?


--------------------
shroomery.
not even once.



Post Extras: Print Post  Remind Me! Notify Moderator
InvisibleautomanM
blasted chipmunk
 User Gallery

Registered: 09/18/03
Posts: 7,866
Re: mysql hint please [Re: sherm]
    #4359071 - 07/01/05 12:23 PM (11 years, 5 months ago)

man, when i set up phpbb2 i just used phpmyadmin to create the table and user before i started the phpbb2 install. during the course of the BB install, it filled in the default database all by itself.


--------------------
No, no, you're not thinking, you're just being logical. ~ Niels Bohr


Post Extras: Print Post  Remind Me! Notify Moderator
Invisiblesherm
sherman
 User Gallery

Registered: 10/02/03
Posts: 20,498
Loc: Euthanasia
Re: mysql hint please [Re: automan]
    #4359378 - 07/01/05 02:00 PM (11 years, 5 months ago)

i used apt-get to install it
maybe i should try manual


--------------------
shroomery.
not even once.



Post Extras: Print Post  Remind Me! Notify Moderator
Invisiblesherm
sherman
 User Gallery

Registered: 10/02/03
Posts: 20,498
Loc: Euthanasia
Re: mysql hint please [Re: sherm]
    #4360184 - 07/01/05 05:17 PM (11 years, 5 months ago)

woooooo

thanks guys
i got it working

i'll be back to bug you about something else in a while.
:laugh: :laugh: :laugh: :laugh:


--------------------
shroomery.
not even once.



Post Extras: Print Post  Remind Me! Notify Moderator
Invisiblesherm
sherman
 User Gallery

Registered: 10/02/03
Posts: 20,498
Loc: Euthanasia
Re: mysql hint please [Re: sherm]
    #4360523 - 07/01/05 06:51 PM (11 years, 5 months ago)

i need a little more help please
i don't quite understand what this wants me to do.
it says

"For the web server, the php files are in /usr/share/phpbb2/site, use the apache config snippet in /etc/phpbb2/apache.conf if you have an apache flavour web server."

does this mean to use the code snippet in my /etc/apache/httpd.conf?
where would i put it?




does this sound about right?


--------------------
shroomery.
not even once.



Post Extras: Print Post  Remind Me! Notify Moderator
Invisiblesherm
sherman
 User Gallery

Registered: 10/02/03
Posts: 20,498
Loc: Euthanasia
Re: mysql hint please [Re: sherm]
    #4360575 - 07/01/05 07:06 PM (11 years, 5 months ago)

haha
i just lost my httpd.conf
what do i do now?
this sucks


--------------------
shroomery.
not even once.



Post Extras: Print Post  Remind Me! Notify Moderator
Invisiblesherm
sherman
 User Gallery

Registered: 10/02/03
Posts: 20,498
Loc: Euthanasia
Re: mysql hint please [Re: sherm]
    #4360592 - 07/01/05 07:10 PM (11 years, 5 months ago)

ok i got it back
im back in action
:stoned:


--------------------
shroomery.
not even once.



Post Extras: Print Post  Remind Me! Notify Moderator
Offlinecadam
The Extremist

Registered: 11/10/04
Posts: 818
Last seen: 11 years, 4 months
Re: mysql hint please [Re: sherm]
    #4360822 - 07/01/05 08:24 PM (11 years, 5 months ago)

dude, download phpmyadmin

type it in google


--------------------
If you strike me down, I shall become more powerful than you could ever imagine


Post Extras: Print Post  Remind Me! Notify Moderator
InvisibleautomanM
blasted chipmunk
 User Gallery

Registered: 09/18/03
Posts: 7,866
Re: mysql hint please [Re: cadam]
    #4360981 - 07/01/05 09:25 PM (11 years, 5 months ago)

Quote:

cadam said:
dude, download phpmyadmin

type it in google





:thumbup:


--------------------
No, no, you're not thinking, you're just being logical. ~ Niels Bohr


Post Extras: Print Post  Remind Me! Notify Moderator
Jump to top. Pages: 1

General Interest >> Science and Technology

Similar ThreadsPosterViewsRepliesLast post
* PHP/MySQL question daytripper05 721 7 04/28/08 06:43 PM
by daytripper05
* phpmyadmin ChromeCrow 279 0 10/01/06 02:51 PM
by ChromeCrow
* hooking openoffice to mysql automanM 595 2 07/22/05 04:54 PM
by automan
* ATTN: PHP/MySQL Gurus
( 1 2 all )
elbisivni 1,418 20 09/04/07 08:04 PM
by elbisivni
* PHP/MySQL help daytripper05 941 7 04/21/08 12:48 AM
by ectolysergic
* mysql help automanM 496 4 11/20/07 07:56 PM
by automan
* MySQL Q elbisivni 464 4 12/24/07 02:05 PM
by Sillicybin
* PHP, MySQL Programmer (job offer in craigslist chicago!) ZippoZM 443 0 07/11/06 04:20 PM
by ZippoZ

Extra information
You cannot start new topics / You cannot reply to topics
HTML is disabled / BBCode is enabled
Moderator: Lana, trendal, Diploid, automan
656 topic views. 0 members, 4 guests and 1 web crawlers are browsing this forum.
[ Toggle Favorite | Print Topic | Stats ]
Search this thread:
Mushrooms.com
Please support our sponsors.

Copyright 1997-2016 Mind Media. Some rights reserved.

Generated in 0.035 seconds spending 0.002 seconds on 14 queries.