database management

**grishi_111** · 01-10-2008

hi everyone!
i want to shape my carrier as a DBA. i want to use DBMS on linux.so which is the best DBMS softwares provider. where to find it.

**kakariko81280** · 01-10-2008

Where to start depends on your database experience so far. If you are quite new, I'd suggest MySQL. It is free in every sense and packages are available for lots of distributions to make for an easy install.

Postgres also fits that bill and I've heard good things about it, but I've never used it so I put MySQL first.

Oracle is generally considered the big RDBMS. It sits in the back office of a lot of big companies and governments where MySQL would sit on the webserver. Oracle express edition won't cost you anything and the only limitation I'm aware of is a 4GB max database size. On the other hand, I have installed this on Linux and it's not for the faint of heart.

Honestly I'd go for Oracle if you are up to it, but then I am an Oracle programmer so I'm biased by what I know.

Let us know how you get on,

Chris...

**bigtomrodney** · 01-10-2008

Just start reading up on SQL. You will need it for any RDBMS and the majority of it will work on any platform. Also just familiarise yourself with the concepts of relational data models. It's easy to tool up on specific products once you have the concept and a decent amount of SQL scripting under your belt.

**grishi_111** · 01-11-2008

Originally Posted by bigtomrodney

Just start reading up on SQL. You will need it for any RDBMS and the majority of it will work on any platform. Also just familiarise yourself with the concepts of relational data models. It's easy to tool up on specific products once you have the concept and a decent amount of SQL scripting under your belt.

whether oracle's Enterprise Manager 10g Grid Control is good for me?

**grishi_111** · 01-11-2008

Originally Posted by grishi_111

whether oracle's Enterprise Manager 10g Grid Control is good for me?

what does mean by "Linux86"?

**kakariko81280** · 01-12-2008

To answer your question, linux86 would refer to Linux on one of the x86 family of processors. PC in other words.

If you are having problems at this stage, I'd scrap the Oracle idea for now. I may have mislead you by understating the complexity of installing it if you don't know what you are doing. Last time I did it, it involved editing the install scripts to match my environment, and I had a guy in the next office, who used to work for Oracle, to help me out.

I second bigtomrodney's advice: Learn all the basic SQL first, it is an essential skill and transferable between all database systems. The simplest and most reliable way to get started is to find out which databases come with your distribution and install one of them. Grab a book for it and start studying.

When I started, I went with MySQL because it came with my distribution. Books are widely available as are applications that work with it. It's also making a go of taking business away from Oracle where a database is required but Oracle is over-specified, so you may well end up dealing with it professionally.

Let us know how you get on,

Chris...

**grishi_111** · 01-12-2008

Originally Posted by kakariko81280

To answer your question, linux86 would refer to Linux on one of the x86 family of processors. PC in other words.

If you are having problems at this stage, I'd scrap the Oracle idea for now. I may have mislead you by understating the complexity of installing it if you don't know what you are doing. Last time I did it, it involved editing the install scripts to match my environment, and I had a guy in the next office, who used to work for Oracle, to help me out.

I second bigtomrodney's advice: Learn all the basic SQL first, it is an essential skill and transferable between all database systems. The simplest and most reliable way to get started is to find out which databases come with your distribution and install one of them. Grab a book for it and start studying.

When I started, I went with MySQL because it came with my distribution. Books are widely available as are applications that work with it. It's also making a go of taking business away from Oracle where a database is required but Oracle is over-specified, so you may well end up dealing with it professionally.

Let us know how you get on,

Chris...

thanks kakariko81280;545863!
i m going to install mysql....
so be ready to help me more.....
thanx again

**grishi_111** · 01-12-2008

Originally Posted by grishi_111

thanks kakariko81280;545863!
i m going to install mysql....
so be ready to help me more.....
thanx again

i did following to install mysql :

mysql-5.0.45-linux-i686/ mysql-5.0.45-linux-i686.tar.gz
vector://usr/local/src
root:# cd mysql-5.0.45-linux-i686
vector://usr/local/src/mysql-5.0.45-linux-i686
root:# ls
COPYING bin/ include/ scripts/ tests/
EXCEPTIONS-CLIENT configure* lib/ share/
INSTALL-BINARY data/ man/ sql-bench/
README docs/ mysql-test/ support-files/
vector://usr/local/src/mysql-5.0.45-linux-i686
root:# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you. If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing MySQL system tables...
OK
Filling help tables...
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h vector.linux.net password 'new-password'
See the manual for more instructions.
You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with mysql-test-run.pl
cd mysql-test ; perl mysql-test-run.pl

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
MySQL AB :: The world's most popular open source database
Support MySQL by buying support/licenses at http://shop.mysql.com
Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
vector://usr/local/src/mysql-5.0.45-linux-i686
root:# Starting mysqld daemon with databases from /usr/local/src/mysql-5.0.45-linux-i686/data
STOPPING server from pid file /usr/local/src/mysql-5.0.45-linux-i686/data/vector.linux.net.pid
080112 22:41:04 mysqld ended

i m not sure if it is installed?
so what should be my next step?

***elija*** · 01-12-2008

Try this (as root)

This should start the Mysql Server

Code:

/etc/init.d/mysql start

And then to log into the client as root

Code:

mysql -u root -p

As an example of a couple of commands try

Code:

use mysql;
show tables;

**grishi_111** · 01-14-2008

Originally Posted by elija

Try this (as root)

This should start the Mysql Server

Code:

/etc/init.d/mysql start

And then to log into the client as root

Code:

mysql -u root -p

As an example of a couple of commands try

Code:

use mysql;
show tables;

sorry!
the first commond does not start the server
some one plz help me?

Thread Tools

Display

database management

Posting Permissions