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
<j...@butterflysystems.co.uk>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 j...@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 <sac.fai...@gmail.com>
> 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
>
>
