If you are having trouble finding what elements are loading from http instead of https,
- Try WhyNoPadLock.com
- Once you found the elements
- There are a few ways to fix them (can hard code the URLs)
You cannot import mysql database of file size more than 50 MB from your site’s PHPmyAdmin. Even though its compressed with gzip or zip, your_database.sql.gz shouldn’t exceed that maximum file size limit.
So how to import larger mysql database?
The workaround is importing it with Bigdump script. You can download the script from here.
Watch the video below to get started,
NOTE: while importing the DB, you will receive an error saying (At this place the current query includes more than 300 dump lines). So to resolve this issue, simply search for the $max_query_lines and change the value to a greater number.