A few tips on moving a drupal 7 production site to a local server:
On production site:
Turn off clean-urls
Clear cache (see phpmyadmin for cache table & “Empty” button)
In phpmyadmin backup the database to your local machine. Remember name of database
In filezilla (ftp) copy over your full drupal installation directory (drupal) to your local pc
Setup new LAMP server and install phpmyadmin
Remember name and password for mysql and phpmyadmin
and change file upload_max_filesize to 20M from 2M (or a bigger size than your database is) and post_max_size to 0.
Copy/Move your downloaded drupal directory to /var/www/html/drupal on LAMP server
Open phpmyadmin on LAMP server and create database with name you remembered earlier.
Import database saved to new database you just created
On LAMP server edit /var/www/html/drupal/sites/default/settings.php
Scroll to bottom of file and edit database info for new user and password.
To get drupal site to open at IP address or domain name, edit /etc/apache2/sites-available/000-default.conf
and change DocumentRoot to /var/www/html/drupal.
sudo service apache2 reload
If you can only get the homepage to appear and 404s for everything else, it is likely that clean-urls is still active.
Edit /var/www/html/drupal/sites/default/settings.php again and add $conf[‘clean-url’] = 0; to the bottom of the file.