For large and very large SQL file, the best approach is to login your server via SSH and directly import it in the database by this command line after uploading the SQL file in /root via FTP:
mysql -u <username> -p <databasename> < <filename.sql>
mysql -u root -p wordpress < wordpress.sql
And enter the password when it prompts you. It will then start importing wordpress.sql into the databasename database.
milind sahu
January 2, 2018Nice Post it help us alot keep sharing with us.
Website: http://milindtech.in