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
For documentation see the reference manual for your version on the mysql website.
Mobile +44(0)7812 451238
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer
Sent from HP IPAQ mobile device.
From: F.A.I.Z.A.L <sac.faizal@stripped>
Sent: Wednesday, September 30, 2009 8:05 AM
Subject: iam new bee to mysql
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
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..
GSM : 9840118673