Maybe you should try doing a fresh install of wordpress on your local computer and simply import your website using the wordpress.xml file created via Tools > Export. If you do that, you can take a good look at the wp_options table as this may give you a clue as to what might be going wrong when you import the .sql file.
Chances are that your database query is not catching all the cases in wp_options (or the posts table for that matter – though you may not want to bother with the content, if you intend to reverse the process).
But first, find the link to style.css on the page that 404ed, as that may give you the clue you need.
Then go through wp_options, row by row if necessary, and last search the whole database to see what else needs catching.
Related Posts:
- How do I optimize a custom post type admin page with 25,000 posts?
- Bad Request (Invalid Hostname) on working server, database problem
- Text snippets shared across posts
- Add Admin User via SQL
- Get a listing of portfolio items and categories
- page not updating with database
- Create a WordPress administrator without access to back-end
- /wp-admin/install.php redirecting to 123-reg
- Does an administrator access allow someone to access to the WordPress database?
- “sufficient permissions” error for admin after duplicating WP database to new install
- my wordpress configuration locally vs live server
- How to change the publishing date of each posts?
- If the only thing I use MySQL for is WordPress, do I need MySQL’s timezone tables?
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Rename a table in MySQL
- getting error HTTP Status 405 – HTTP method GET is not supported by this URL but not used `get` ever?
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Case statement in MySQL
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- Can’t find mysqladmin on Mac OSX 10.6.8
- Export Pervasive to MySQL (C#)
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
- How do I restore a dump file from mysqldump?
- How do I quickly rename a MySQL database (change schema name)?
- Authentication plugin ‘caching_sha2_password’ cannot be loaded
- MySQL SELECT increment counter
- Create a new database with MySQL Workbench
- Error Code: 2013. Lost connection to MySQL server during query
- How to get size of mysql database?
- how to drop partition without dropping data in MySQL?
- 1052: Column ‘id’ in field list is ambiguous
- 1052: Column ‘id’ in field list is ambiguous
- difference between primary key and unique key
- Creating a search form in PHP to search a database?
- phpMyAdmin – Error > Incorrect format parameter?
- Create mysql table directly from CSV file using the CSV Storage engine?
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- MySQL equivalent of DECODE function in Oracle
- How to create a foreign key in phpmyadmin
- importing a CSV into phpmyadmin
- How to check if mysql database exists
- Is there a Profiler equivalent for MySql?
- How to do a batch insert in MySQL
- MySQL: Cloning a MySQL database on the same MySql instance
- How get value from URL
- Error: Duplicate entry ‘0’ for key ‘PRIMARY’
- WordPress site migration – icons missing
- Data is not constantly loading from custom wordpress table
- Using wpdb to connect to a separate database
- MySQL Database User: Which Privileges are needed?
- What are the standard admin CSS id/class tags?
- Why is my database import losing text widget data?
- Admin Ajax is returning 0
- Add custom column to Users admin panel
- wp_verify_nonce vs check_admin_referer
- Add a Separator to the Admin Menu?
- How to determine whether we are in add New page/post/CPT or in edit page/post/CPT in wordpress admin?
- how to know if admin is in edit page or post [duplicate]
- How to return number of found rows from SELECT query
- Modal window from within WordPress admin
- Where in WP can I check history or log of updates of plugins etc?
- Adding a custom admin page
- Will it break my site if I delete all transient records in wp_options table?
- How does admin-ajax.php work?
- Checking if Database Table exists
- How to remove entire admin menu?
- WordPress (MyISAM) database is slow, should I switch to InnoDB?
- How do I remove dashboard access from specific user roles?
- Please explain how WordPress works with MySQL character set and collation at a low level
- How can I speed up my WP admin section?
- How to pass parameters to admin_notices?
- Admin: very slow edit page caused by core meta query
- The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
- if admin is logged in
- Search posts by ID in admin
- How to Change the Default Home Page for the WordPress Dashboard?
- Setting admin edit panels & metaboxes positions and visibility for ALL users and admins
- Find out which moderator approved comment?
- The website cannot display the page
- How To Remove WordPress Version From The Admin Footer
- Sort pages in loop by admin’s page attributes order field?
- Edit “thank you for creating with WordPress” in version 3.3.1
- Hide other users’ posts in admin panel
- Set Default Admin Colour For All Users
- How to fetch Data in WordPress using MySQLi or $wpdb
- Editor Styles and Typekit
- WordPress Database lost auto increment
- WordPress admin stylesheet
- This CSS Stuffing Works, But Is This A Good Practice?
- Connect to database using wordpress wp-config file
- Is it possible to create a WordPress tour? V3.3.1
- Add WordPress MU Network Admin via Database
- Securing Admin Accounts – Username Discovery
- What’s a good strategy for planning WordPress DB growth?
- Get url of product’s images (woocommerce)
- wpdb->insert multiple record at once
- is_admin() returns true when using admin-ajax.php from front end script