toolbox Posted July 20, 2011 Share Posted July 20, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/242495-dumping-a-mysql-database-remotely/ Share on other sites More sharing options...
sunfighter Posted July 21, 2011 Share Posted July 21, 2011 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. Quote Link to comment https://forums.phpfreaks.com/topic/242495-dumping-a-mysql-database-remotely/#findComment-1245834 Share on other sites More sharing options...
fenway Posted July 22, 2011 Share Posted July 22, 2011 If you have root access to the server, simply restart mysql and skip-grants. Quote Link to comment https://forums.phpfreaks.com/topic/242495-dumping-a-mysql-database-remotely/#findComment-1246251 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.