'How to export a large table in csv format with 8 millions rows in mysql?

I tried to export my table in csv format through phpmyadmin but it contains 8 millions rows so my local server stops itself after rendering browser for a long time without giving my result. So, I am wanting for a solution to convert those data into csv format.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source