Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 25, 2012, 07:49:10 AM

Pages: [1]   Go Down
  Print  
Author Topic: MySQL file locations  (Read 456 times)
vertex2
Trekkie
**
Offline Offline

Posts: 11


WWW
« on: April 15, 2003, 10:54:10 AM »

Hi,


I want to run a MySQL server at home but i am wondering, after I set it up, where do database files go?  can i have multiple in the same location? can I have multiple in different folder locations?  does mysql use a wwwroot folder system like IIS?  if so can i just drop a database in any folder in the root and then connect a webpage via odbc?  or do i have to configure the server somehow?

My purpose is to use a MySQL database for a intranet to run webpages.  I only have experience use IIS and Access databases.  will this switch be easy?

Thanks for your help.

 - Phillip
Logged
stephan
Guest
« Reply #1 on: April 15, 2003, 11:27:58 AM »

The mySQL server doesn't store it's files in the public_html or wwwroot directory.

It doesnt' tell you where your file is stored, because the user doesn't need to know.

You connect to it using a username and password.

It's not really like an access database system.

There's much more information on www.mysql.org
Logged
vertex2
Trekkie
**
Offline Offline

Posts: 11


WWW
« Reply #2 on: April 15, 2003, 12:14:50 PM »

So if i login as a user after i set it up..., i can copy a MySQL database to a location that i am allowed access to.  and then use odbc to connect a webpage to the database?
if this is so, do i need to know anysort of file location? or do i just connect with odbc and use the file name of the database?  then the server does the rest?

If i login as a user, how do i do that from anouther computer?  ftp? webpage interface? special mysql client software?
I seem to have trouble finding the answers i need on mysql.com

thanks again,
 - Phillip
Logged
stephan
Guest
« Reply #3 on: April 15, 2003, 01:55:55 PM »

The server takes care of all actual physical file locations.

A useful tool for databases is phpmyadmin, it's a web interface for mysql. You can get it here http://www.phpwizard.net/projects/phpMyAdmin/

Of course, on lunarpages, phpmyadmin is installed for you anyway.

You can connect to a database on lunarpages remotely, from home.

I would really recommend you use the lunarpages one, especially for security. Running your own server can be a big security problem, unless you are very experienced in this.
Logged
TWebMan
Quantum Encyclopedia Writer
*****
Offline Offline

Posts: 3112



WWW
« Reply #4 on: April 22, 2003, 09:14:03 PM »

The physical location of the data really doesn't matter because mysql is a server application.  Another program that helps you manage mysql databases is Mysql Front.  There's a copy at http://twebman.lunarpages.com/files/MySQL-Front_2.2_Setup.zip

You wouldn't use OBDC on a Linux box, and even if you run the server on a Windows box, though you could use ODBC, you could also use php (you would have to install php on your machine, not difficult).  On the servers, you would want to use either php or if you use perl, the DBI/DBD module.  There's some information on the first sql page of the control panel, and there's plenty of information at http://www.mysql.com

As Stephan said, running any server on your computer opens a potential security risk and you should only run it when you need to, and run a firewall that monitors activity.  You can also tell many firewalls not to let a server program accept connections from the Internet, but to accept them from your local network.  This is an excellent way to maintain security and still work on your pages locally in an application environment.
Logged

"Computers cause people to make more mistakes than any other invention in history, with the possible exception of handguns and tequila."  - Unknown
"Liberty of any kind is seldom lost all at once." - D. Hume
Every day is an Ode to Joy
The planet will be fine... and so will your site
Pages: [1]   Go Up
  Print  
 
Jump to: