Good way to re-index data in magento without admin panel is SSH.Also I have been locked in admin panel and unable to reindex all data the SSH is the good practice to do.Sometime if we don’t have access to SSH
How to import export sql file from command line
I was trying to export a database file of big in size then I could not because max-time in server in less so that’s why I was getting timeout error then I searched a lot and got to know its