Welcome to dbForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Where should be placed the DB ?

 
   Database Forums (Home) -> PHP RSS
Next:  What does it mean????  
Author Message
bettina

External


Since: Jun 24, 2005
Posts: 7



(Msg. 1) Posted: Tue Jul 12, 2005 10:21 am
Post subject: Where should be placed the DB ?
Archived from groups: comp>lang>php (more info?)

On my server I have all my site under /public_html... where should I
put my DB?

 >> Stay informed about: Where should be placed the DB ? 
Back to top
Login to vote
Jerry Stuckle

External


Since: Aug 11, 2004
Posts: 1292



(Msg. 2) Posted: Tue Jul 12, 2005 1:51 pm
Post subject: Re: Where should be placed the DB ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

bettina.RemoveThis@coaster.ch wrote:
> On my server I have all my site under /public_html... where should I
> put my DB?
>

Someplace other than under /public_html - unless you want someone to be able to
download it!

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex.RemoveThis@attglobal.net
==================

 >> Stay informed about: Where should be placed the DB ? 
Back to top
Login to vote
steve




Joined: Jan 06, 2004
Posts: 655



(Msg. 3) Posted: Tue Jul 12, 2005 3:23 pm
Post subject: Re: Where should be placed the DB ? [Login to view extended thread Info.]

To clarify, public_html is typically the path of your website. When you set up mysql, it sets up a directory somewhere on your disk, by default. It is not in the same path, as previously explained.
 >> Stay informed about: Where should be placed the DB ? 
Back to top
Login to vote
bettina

External


Since: Jun 24, 2005
Posts: 7



(Msg. 4) Posted: Tue Jul 12, 2005 10:48 pm
Post subject: Re: Where should be placed the DB ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Yes, DB is my database. It was originally an Access DB. Then I created
the same structure with phpMyAdmin and exported my Access DB to MySql.
It was located under mysql/data.... and everything was ok. Now I
wanted to send everything to my server. The provider supports MySql and
PHP. Should I first reproduce the structure of my local DB with
phpMyAdmin on my server? And then import the data? In phpMyAdmin I see
only the button Exportieren... Should I export from my phpMyAdmin local
to the server??
 >> Stay informed about: Where should be placed the DB ? 
Back to top
Login to vote
Jerry Stuckle

External


Since: Aug 11, 2004
Posts: 1292



(Msg. 5) Posted: Wed Jul 13, 2005 11:58 am
Post subject: Re: Where should be placed the DB ? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

bettina DeleteThis @coaster.ch wrote:
> Yes, DB is my database. It was originally an Access DB. Then I created
> the same structure with phpMyAdmin and exported my Access DB to MySql.
> It was located under mysql/data.... and everything was ok. Now I
> wanted to send everything to my server. The provider supports MySql and
> PHP. Should I first reproduce the structure of my local DB with
> phpMyAdmin on my server? And then import the data? In phpMyAdmin I see
> only the button Exportieren... Should I export from my phpMyAdmin local
> to the server??
>

Bettina,

Yes, you must export your data from the local database. Ensure you export both
structure and data.

Then simply create the new database on the server (same name), and use
phpMyAdmin to execute the file you just exported as SQL statements.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex DeleteThis @attglobal.net
==================
 >> Stay informed about: Where should be placed the DB ? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Simple question?? PHP..ODBC..and...dBASE - Ok this may be a dumb question to some but for the first time this evening I have to access dBASE file through ODBC.. I'm trying to do simple queries of SELECT * FROM ??? however I can't for the life of me figure out what to put in place of the ???. Any....

PHP for Dummies (Me being the dummy) - Maybe it is just cos it is Friday and my head is already gone away for the weekend but I just cannot get sessions working! Anyway - two pages. Page one starts session and registers a sesison variable, Page 2 tries to then print out the session..

online reference to mysql_errno() codes? - I want to do something like this: while(false == ($result = mysql_query($query)) ) { switch(mysql_errno()) { case $fixableError[0]: case $fixableError[1]: /* fix the errors */ break; default: die..

XHTML validator not liking onMouseOver event - Hi, I am trying to validate my website against XHTML 1.0 transitional. Unfortunetely it throws up an error because I have used javascript event onMouseOver <span onMouseOver="Swap_Image(... .... and it gives me an error saying that there is no...

SESSION variables not available an all pages - <? session_start(); print_r($_SESSION); ?> How come when I put this code on one page it says: Array ( [userid] => 24 [loginid] => 1 ) but if I put it on another page it simply says: Array ( ) What is going on ? I thought the session variabl...
   Database Forums (Home) -> PHP All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]