Dumping a MySQL database remotely

[toolbox]

I took over a project from an IT guy that refused to explain the inner working of things, here it goes:

 

We have server that we have functional remote access to that is running:

 

-Cent OS

-Xoops 2.4.4

-PHP Version 5.16

-MySQL 5.0.77

 

Apparently on this server is all the outstanding medical billing information that the company needs to have exported. If possible, I want to dump all the data that i assume is located in a MySQL database into a cvs file or something manageable to forward the raw data to the billing team. I have searched a fair amount and it looks like it should be fairly easy, but i'm at loss. If possible, I need directions on how to locate the data and then dump it from the database as text. I have root access to the server, but do not to my knowledge have the MySQL password. (I do not know if they are one in the same). I have found guides on backup for typing into command line but I do not know where on the server the database is stored. I apologize for the lack of information, but as I stated I am definitely a novice with this software. Any information supplied will be greatly appreciated.

 

As stated, the server is offsite so I cant simply pull the drives and pull the data. I do however have ftp access if that makes a difference.

 

 

[sunfighter]

Non - technical answer.

 

I would go to his boss and explain that the IT guy will not help you and you need that help. If that gets no response go to your boss or better, the man that gave you the assignment. You need knowledge before you can do anything and this IT guy might have put some traps in just so he does not lose control. You never know, with his attitude he just might have.

[fenway]

If you have root access to the server, simply restart mysql and skip-grants.