iam new bee to mysql

--0016367f94b4cafae50474c62aab
Content-Type: text/plain; charset=ISO-8859-1

hello experts

I am new to mysql. in my server mysql application is installed just like
that. there is no proper driectory strutured maintained.
now my question is. how can i find the datafiles, archive files, backup
location.

i don't have root authentication. is it possible to login to the database?

please assist me and i need mysql dba documents. if anyone has please
provide that too..

thanks in advance..


Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com

--0016367f94b4cafae50474c62aab--

RE: iam new bee to mysql

If you have a mysql username/password you can start mysql client from the c=
ommand line and log in like so

mysql -uusername -ppassword

Where username is your username and password is your password.

Once logged in you can issue the command

Show variables like 'datadir%';

This will tell you where the data files are stored but if the system is set=
up correctly you probably wont have access to them.

Backups could be anywhere but ideally should not be stored on the machine r=
unning the server.

For documentation see the reference manual for your version on the mysql we=
bsite.

Regards

John Daisley
Mobile +44(0)7812 451238
Email john@butterflysystems.co.uk

Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer

-----------------------
Sent from HP IPAQ mobile device.



-----Original Message-----
From: F.A.I.Z.A.L
Sent: Wednesday, September 30, 2009 8:05 AM
To: mysql@lists.mysql.com
Subject: iam new bee to mysql

hello experts

I am new to mysql. in my server mysql application is installed just like
that. there is no proper driectory strutured maintained.
now my question is. how can i find the datafiles, archive files, backup
location.

i don't have root authentication. is it possible to login to the database?

please assist me and i need mysql dba documents. if anyone has please
provide that too..

thanks in advance..


Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: iam new bee to mysql

--0015175dd8b840d9f00474c8c242
Content-Type: text/plain; charset=ISO-8859-1

Hi

1. can you please explain me about mysql 5 architecture and background
process..
2. how to create a schema in mysql
3. is there anything like tablespace in oracle..
4. if yes, how to create tablespace.
5. how is storage system in mysql.
in oracle, tablespace->segment->extend->block, is there anything
like that in mysql
6. how to create user, grant privilege to them

thanks in advance..

Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


On Wed, Sep 30, 2009 at 1:51 PM, John Daisley
wrote:

> If you have a mysql username/password you can start mysql client from the
> command line and log in like so
>
> mysql -uusername -ppassword
>
> Where username is your username and password is your password.
>
> Once logged in you can issue the command
>
> Show variables like 'datadir%';
>
> This will tell you where the data files are stored but if the system is set
> up correctly you probably wont have access to them.
>
> Backups could be anywhere but ideally should not be stored on the machine
> running the server.
>
> For documentation see the reference manual for your version on the mysql
> website.
>
> Regards
>
> John Daisley
> Mobile +44(0)7812 451238
> Email john@butterflysystems.co.uk
>
> Certified MySQL 5 Database Administrator (CMDBA)
> Certified MySQL 5 Developer
> Cognos BI Developer
>
> -----------------------
> Sent from HP IPAQ mobile device.
>
>
>
> -----Original Message-----
> From: F.A.I.Z.A.L
> Sent: Wednesday, September 30, 2009 8:05 AM
> To: mysql@lists.mysql.com
> Subject: iam new bee to mysql
>
> hello experts
>
> I am new to mysql. in my server mysql application is installed just like
> that. there is no proper driectory strutured maintained.
> now my question is. how can i find the datafiles, archive files, backup
> location.
>
> i don't have root authentication. is it possible to login to the database?
>
> please assist me and i need mysql dba documents. if anyone has please
> provide that too..
>
> thanks in advance..
>
>
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>

--0015175dd8b840d9f00474c8c242--

Re: iam new bee to mysql

Hi,

> 1. can you please explain me about mysql 5 architecture and background
> process..
> 2. how to create a schema in mysql
> 3. is there anything like tablespace in oracle..
> 4. if yes, how to create tablespace.
> 5. how is storage system in mysql.
> in oracle, tablespace->segment->extend->block, is there anything
> like that in mysql
> 6. how to create user, grant privilege to them

This can all be found in the Documentation, freely available at
www.mysql.com

Have you tried reading any of it?


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: iam new bee to mysql

--001636418605892fa20474c8dca6
Content-Type: text/plain; charset=ISO-8859-1

hi tonies

no, i don't see this portal before. for my quick view, can u please answer
my question in previous email..

thanks for ur link..

Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


On Wed, Sep 30, 2009 at 3:46 PM, Martijn Tonies wrote:

> Hi,
>
> 1. can you please explain me about mysql 5 architecture and background
>> process..
>> 2. how to create a schema in mysql
>> 3. is there anything like tablespace in oracle..
>> 4. if yes, how to create tablespace.
>> 5. how is storage system in mysql.
>> in oracle, tablespace->segment->extend->block, is there anything
>> like that in mysql
>> 6. how to create user, grant privilege to them
>>
>
> This can all be found in the Documentation, freely available at
> www.mysql.com
>
> Have you tried reading any of it?
>
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>

--001636418605892fa20474c8dca6--

Re: iam new bee to mysql

Hello Faizal,

>no, i don't see this portal before.

You didn't see " www.mysql.com " before? Geesh...

>for my quick view, can u please answer my question in previous email..

I fail to see why I should answer if you don't even bother to look up these
things yourself in about 5 minutes... Is your time more valuable than mine?

I don't have any problem with answering questions as long as the person
who asks them at least for a bit that he tried finding the answers
themselves.

I showed you the place where you can find the answers to your questions,
now, use that keyboard and your internet connection.

Good luck.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com



thanks for ur link..

Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com



On Wed, Sep 30, 2009 at 3:46 PM, Martijn Tonies
wrote:

Hi,


1. can you please explain me about mysql 5 architecture and background
process..
2. how to create a schema in mysql
3. is there anything like tablespace in oracle..
4. if yes, how to create tablespace.
5. how is storage system in mysql.
in oracle, tablespace->segment->extend->block, is there anything
like that in mysql
6. how to create user, grant privilege to them



This can all be found in the Documentation, freely available at
www.mysql.com

Have you tried reading any of it?


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: iam new bee to mysql

Basic answers under each of your questions below


-----Original Message-----
From: F.A.I.Z.A.L
Sent: Wednesday, September 30, 2009 11:11 AM
To: John Daisley
Cc: mysql@lists.mysql.com
Subject: Re: iam new bee to mysql

Hi

1. can you please explain me about mysql 5 architecture and background
process..

You need to read the manual for this. Start here http://dev.mysql.com/doc/r=
efman/5.1/en/features.html

2. how to create a schema in mysql

Create schema schema_name;
Create database schema_name;

3. is there anything like tablespace in oracle..

Yes and no! Read the manual sections relating to storage engines especially=
innodb. http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html

4. if yes, how to create tablespace.

Create tablespace .....
See the ref manual for the full syntax but make sure you understand how an=
d when mysql uses tablespace. http://dev.mysql.com/doc/refman/5.1/en/create=
-tablespace.html
=20
5. how is storage system in mysql.
in oracle, tablespace->segment->extend->block, is there anything
like that in mysql

Read the manual section on storage engines as it varies by engine
http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html

6. how to create user, grant privilege to them

Grant priv on schema.table to user@host identified by 'password';

Read the manual section on grant http://dev.mysql.com/doc/refman/5.1/en/gra=
nt.html

thanks in advance..

Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


On Wed, Sep 30, 2009 at 1:51 PM, John Daisley
wrote:



[The entire original message is not included]=


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: iam new bee to mysql

--0016e64ba3fa30b1740474c9564b
Content-Type: text/plain; charset=ISO-8859-1

hi tonies..

you mistaken me. I am exploring many forums and discussion. these questions
are only my doubts. iam started to explore mysql.com. but i need some quick
inputs to complete my task. if u or anyone experienced in mysql can answer
this because iam sitting in urgent task.

anyways thanks for your help.

if anyone would like to answer my question? just share your knowledge please

Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


On Wed, Sep 30, 2009 at 3:57 PM, Martijn Tonies wrote:

> Hello Faizal,
>
> no, i don't see this portal before.
>>
>
> You didn't see " www.mysql.com " before? Geesh...
>
> for my quick view, can u please answer my question in previous email..
>>
>
> I fail to see why I should answer if you don't even bother to look up these
> things yourself in about 5 minutes... Is your time more valuable than mine?
>
> I don't have any problem with answering questions as long as the person
> who asks them at least for a bit that he tried finding the answers
> themselves.
>
> I showed you the place where you can find the answers to your questions,
> now, use that keyboard and your internet connection.
>
> Good luck.
>
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>
>
>
> thanks for ur link..
>
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
>
> On Wed, Sep 30, 2009 at 3:46 PM, Martijn Tonies
> wrote:
>
> Hi,
>
>
> 1. can you please explain me about mysql 5 architecture and background
> process..
> 2. how to create a schema in mysql
> 3. is there anything like tablespace in oracle..
> 4. if yes, how to create tablespace.
> 5. how is storage system in mysql.
> in oracle, tablespace->segment->extend->block, is there anything
> like that in mysql
> 6. how to create user, grant privilege to them
>
>
>
> This can all be found in the Documentation, freely available at
> www.mysql.com
>
> Have you tried reading any of it?
>
>
> With regards,
>
> Martijn Tonies
> Upscene Productions
> http://www.upscene.com
>
> Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
> Anywhere, MySQL, InterBase, NexusDB and Firebird!
>
> Database questions? Check the forum:
> http://www.databasedevelopmentforum.com
>

--0016e64ba3fa30b1740474c9564b--

Re: iam new bee to mysql

--002354471a344503660474c95ccc
Content-Type: text/plain; charset=ISO-8859-1

hi Daisley

thanks for your answers

Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com


On Wed, Sep 30, 2009 at 4:20 PM, John Daisley
wrote:

> Basic answers under each of your questions below
>
>
> -----Original Message-----
> From: F.A.I.Z.A.L
> Sent: Wednesday, September 30, 2009 11:11 AM
> To: John Daisley
> Cc: mysql@lists.mysql.com
> Subject: Re: iam new bee to mysql
>
> Hi
>
> 1. can you please explain me about mysql 5 architecture and background
> process..
>
> You need to read the manual for this. Start here
> http://dev.mysql.com/doc/refman/5.1/en/features.html
>
> 2. how to create a schema in mysql
>
> Create schema schema_name;
> Create database schema_name;
>
> 3. is there anything like tablespace in oracle..
>
> Yes and no! Read the manual sections relating to storage engines especially
> innodb. http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html
>
> 4. if yes, how to create tablespace.
>
> Create tablespace .....
> See the ref manual for the full syntax but make sure you understand how
> and when mysql uses tablespace.
> http://dev.mysql.com/doc/refman/5.1/en/create-tablespace.htm l
>
> 5. how is storage system in mysql.
> in oracle, tablespace->segment->extend->block, is there anything
> like that in mysql
>
> Read the manual section on storage engines as it varies by engine
> http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html
>
> 6. how to create user, grant privilege to them
>
> Grant priv on schema.table to user@host identified by 'password';
>
> Read the manual section on grant
> http://dev.mysql.com/doc/refman/5.1/en/grant.html
>
> thanks in advance..
>
> Best Regards
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
>
> On Wed, Sep 30, 2009 at 1:51 PM, John Daisley
> wrote:
>
>
>
> [The entire original message is not included]
>

--002354471a344503660474c95ccc--