can’t able to access database , ,,,even don’t know which database used ..let me know how to get it .. last developer mashed up with me ....and i am not so tech person ..

is there any way so we can get sql file ..

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

A sql file can be exported from a running MySQL instance by:

1.) Log in via ssh (on Windows you can use a client like PuTTY

2.) Run the following command, providing your MySQL root password when it’s requested.

mysqldump -uroot -p your_db_name > export.sql

You can now use SFTP or another method to download the export.sql file.