DB Version

[LuisMartins]

hey everyone, hey Russellb , i am posting my thread here like you recommended me. Thank you.

Well, here it goes, i will try to be as clear as possible.
I am building a website and i want to make it available for my visitors to be able to create a small profile with their own photos/videos, i also want to make it available for other visitors to be able to browse, with choice to instant message eachother.

I have already purchased this program "NuSphere PhpED" and downloaded the free version of MySQL "MySQL Server 5.0" .

Unfortunatly i have tried to get in touch with my web host since tuesday , by phone and by email and didnt get a reply yet. I wanted to find out what database system i will use.So i searched for myself and found this, i hope that enough info :
Server Information

operating system - FreeBSD 4.11-STABLE

mysql version - mysql Ver 12.22 Distrib 4.0.16

perl version - perl, v5.8.3

php version - PHP 4.4.1


What do i need to do to start building my own database ??
Do i have all the software needed ?

Thanks again a million.

Happy New Year,

Luis Martins

[felgall]

What control panel does your web hosting provide? There is usually an option there to allow you to create a database.

[LuisMartins]

its : phpMyAdmin 2.7.0
says : MySQL 4.0.16 running on localhost
and i just created the database, or at least gave it a name.

[LuisMartins]

sorry, i forgot to mention that it does not let me create the kind of database mention above unless i use something else to do it.

thanks

[NogDog]

Your hosting service likely has a separate interface that allows you to create/delete databases and database users. (For security reasons, this will be separate from the phpMyAdmin application, so that they can control access to the MySQL user account who has the permissions to do those actions.) Once you've used whatever application they supply for creating databases in their control panel, then you can use phpMyAdmin to define and populate tables in that database.

[LuisMartins]

i am confused. i created a database there, but i dont use it since its not going to do what i want

[NogDog]

i am confused. i created a database there, but i dont use it since its not going to do what i want
I am confused, too. I'm afraid I do not understand what you mean.

[LuisMartins]

ok, on "databases"

installed databases = 1
user =1

which says : Once set up, you can administrate your databases through phpMyAdmin (you must re-enter your username and password to administrate).

i click phpMyAdmin reenter my user and password

and this is what comes up :

Show MySQL runtime information
Show MySQL system variables
Show processes
Storage Engines
Databases
Export
Import
Log out

Theme / Style: Darkblue/orangeOriginal
phpMyAdmin documentation
Official phpMyAdmin Homepage
[ChangeLog] [CVS] [Lists]


does it make any sense ?
thanks again

[NogDog]

The database you created should be available for selection in the left column of the phpMyAdmin screen in the "Database" drop-down widget.

[LuisMartins]

but that is the think, what do i have to select to start it ? what do i need to do first /
thanks again mate

[NogDog]

Learning SQL using phpMyAdmin (http://www.php-editors.com/articles/sql_phpmyadmin.php)
Getting Started With MySQL (http://dev.mysql.com/tech-resources/articles/mysql_intro.html)

[LuisMartins]

what do you mean ?

[LuisMartins]

sorry i got you. so if i read those will i be able to get this thing to work?
do i need to use nusphere phped and mysql server 5 from my pc right?

[NogDog]

sorry i got you. so if i read those will i be able to get this thing to work?
I don't know, but if not, then you probably aren't ready to jump right into creating a database without spending some time and effort to learn the basics of databases and software programming, and then more specifics about MySQL and PHP (or whatever server-side language you choose to build your application).

do i need to use nusphere phped and mysql server 5 from my pc right?
I don't even know what Nusphere is.

You don not have to install anything on your PC, but it will likely be a safer place to experiment. You might want to look into downloading and installing something like XAMPP (http://www.apachefriends.org/en/xampp.html) onto your PC.

[LuisMartins]

i understand. i finally got thru with my web host and i found out that it already has MySQL installed on the system and this is the sytem db version.
it is alot but that whats there :


AnyDBM_File
Apache
Apache - AuthDBI
Apache - Connection
Apache - Constants
Apache-Constants::Exports
Apache-DBI
Apache-Debug
Apache-ExtUtils
Apache-FakeRequest
Apache-File
Apache-httpd_conf
Apache-Include
Apache-Leak
Apache-Log
Apache-ModuleConfig
Apache-MyConfig
Apache-Opcode
Apache-Options
Apache-PerlRun
Apache-PerlRunXS
Apache-PerlSections
Apache-RedirectLogFix
Apache-Registry
Apache-RegistryBB
Apache-RegistryLoader
Apache-RegistryNG
Apache-Resource
Apache-RPC::Server
Apache-RPC::Status
Apache-Server
Apache-SIG
Apache-SizeLimit
Apache-SOAP
Apache-src
Apache-StatINC
Apache-Status
Apache-Symbol
Apache-Symdump
Apache-Table
Apache-test
Apache-URI
Apache-Util
Apache-XMLRPC-Lite
AppConfig
AppConfig-Args
AppConfig-CGI
AppConfig-File
AppConfig-Getopt
AppConfig-State
AppConfig-Sys
Archive-Tar
Archive-Tar-Constant
Archive-Tar-File
Attribute-Handlers
attributes
attrs
AutoLoader
AutoSplit
autouse
B
B-Asmdata
B-Assembler
B-Bblock
B-Bytecode
B-C-Section
B-CC
B-Concise
B-Debug
B-Deparse
B-Disassembler::BytecodeStream
B-Lint
B-Showlex
B-Stackobj
B-Stash
B-Terse
B-Xref
base
Benchmark
bigint
bignum
bigrat
Bit-Vector
Bit-Vector-Overload
blib
BSD-Resource
Bundle-Apache
Bundle-DBD-CSV
Bundle-DBD-mysql
Bundle-DBI
Bundle-LWP
ByteLoader
bytes
Carp
Carp-Clan
CGI
CGI-Carp
CGI-Cookie
CGI-Fast
CGI-Pretty
CGI-Push
CGI-Util
charnames
Class-ISA
Class-Struct
Clone
Compress-Zlib
Config
constant
CPAN
CPAN-Mirrored-By
CPAN-Nox
Crypt-Cracklib
Crypt-PasswdMD5
Crypt-SSLeay
Crypt-SSLeay-Conn
Crypt-SSLeay-CTX
Crypt-SSLeay-Err
Crypt-SSLeay-MainContext
Crypt-SSLeay-X509
Cwd
Data-Dumper
Date-Calc
Date-Calc-Object
Date-Calendar

Date-Calendar-Year
DB
DBD-CSV
DBD-DBM
DBD-ExampleP
DBD-File
DBD-mysql
DBD-mysql-GetInfo
DBD-NullP
DBD-Proxy
DBD-Sponge
DBI
DBI-Const-GetInfo-ANSI
DBI-Const-GetInfo-ODBC
DBI-Const-GetInfoReturn
DBI-Const-GetInfoType
DBI-DBD
DBI-DBD-Metadata
DBI-FAQ
DBI-Profile
DBI-ProfileData
DBI-ProfileDumper
DBI-ProfileDumper-Apache
DBI-ProxyServer
DBI-SQL-Nano