After uploading the my local db on server my site was not working and what I was getting was white screen of death. After few hours of struggling I found that as the server was not configured for clean url and the in the database the clean url settings was ON that was causing the problem.
Is there any way we can come to know if the problem is of the clean url in such scenario.
Also I can't use the backup and migrate module as the database size was too large.
apachectl -t -D DUMP_MODULES
and scan the list forrewrite_module