~$ sudo apt-get

Create a .htaccess within the document root with the following.

RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.example.com/$1 [R,L]

You must ensure AllowOverride is set to All within the apache configuration or it will not read the .htaccess.

If you wish to pull a single table from a large mysqldump, the following commands will accomplish this.

# grep -n "CREATE TABLE" databasedump.sql

If the table you want starts on line 100, and the proceeding table is on line 150, run the following commands to parse the dump.

# head -n 142 databasedump.sql > parsed.sql


# tail -n 100 parsed.sql > table.sql

Do not use the exact line number returned from grep as you will have the create table statement from the next table.