Files on Localhost, Database on Server

Yes, the 404 is because the local and remote server URLs are different. As a solution:

  • You should set the local domain to be the same as the remote server
  • In wp-config.php connect to the remote DB
  • When you will need to access the remote server you’ll need to update the file hosts and comment out the line with your remote url
    • If your hosts file is updated on start/stop of your local server you can just stop the server and you’ll have acces to the remote

If your domain name is xdirtseries.co.za you should set in vhost the server name and alias to match the domain, so that when you local server is started you’ll see the local version, otherwise your online version.

ServerName xdirtseries.co.za
ServerAlias www.xdirtseries.co.za

And the hosts file:

127.0.0.1 xdirtseries.co.za www.xdirtseries.co.za

This should work 🙂

Related Posts:

  1. Delete all post meta except featured image
  2. Set Display Name to first and last name (phpmyadmin SQL Query)
  3. Emojis getting converted to “?”
  4. Delete all post meta except featured image Using SQL
  5. WordPress database import: Row size too large
  6. Changing root password in PHPMyAdmin for WordPress Database when going live
  7. Can’t update WordFence Options, clear data manually
  8. Installing local to live WP into subdirectory
  9. DB prefix not updating
  10. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  11. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  12. Missing latest posts and options after DB migration via phpMyAdmin
  13. Check if a database is well installed
  14. Deleting WordPress posts and media files based on author via MYSQL database
  15. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  16. MySQL SELECT increment counter
  17. phpMyAdmin – Error > Incorrect format parameter?
  18. How to create a foreign key in phpmyadmin
  19. MySQL Database User: Which Privileges are needed?
  20. Why is my database import losing text widget data?
  21. Will it break my site if I delete all transient records in wp_options table?
  22. Please explain how WordPress works with MySQL character set and collation at a low level
  23. Reset Post IDs to less than 64bit integer
  24. Restoring WordPress posts from database only
  25. WordPress database scalability from the code perspective
  26. Does WordPress use the InnoDB engine for MySQL by default?
  27. Can I use MariaDB instead of MySQL in wordpress?
  28. What are conventions about the schema of the $table_prefix
  29. Split WP install between 2 databases?
  30. Inserting Post Meta From SQL
  31. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  32. Why does dbDelta() not catch MysqlErrors?
  33. Is deleting orphaned wp_options entries safe?
  34. Is altering a default WordPress database table update safe?
  35. How to solve slow WordPress site caused by attachment_metadata
  36. Custom DB_COLLATE (collation) value not working on fresh install?
  37. Export only pages and posts with mysql dump
  38. What causes the “max_user_connections” warning on WordPress frontend?
  39. what to do when your WordPress database is too large?
  40. Change all http to https in mysql databse?
  41. Large database causes slow load
  42. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  43. Database slowdown after update to 3.4.1
  44. WordPress and automated MySQL backups to a different host
  45. How to insert data into MySQL database from the form created in WordPress site
  46. How Do I Merge Categories With phpMyAdmin
  47. Size article thumbnails and retrieve them directly from database
  48. WordPress site uses MyISAM, should I switch to InnoDB necessary?
  49. WordPress mysql table double prefixes
  50. Advanced SELECT query with condtional statements
  51. Why do mass updates to post_content shows in front end, but not in edit screen?
  52. Error establishing database connection – high traffic?
  53. Improve performance by removing unnecessary database queries
  54. Redirecting to old domain after migration website
  55. WordPress Database Huge wp_usermeta Table
  56. A MySQL DB within a MySQL DB
  57. Switching Databases in LocalHost
  58. Will changing the folder name two directories above a fresh wordpress installation break the site?
  59. Is there a way to recover the table wp_term_relationships?
  60. Unable to set a default serialized array using dbdelta()
  61. How to prevent/delay MySQL connections when an object cache is used?
  62. Migrating from PDO using SQLite to clean new install using MySQL
  63. Better ads plugin has 500.000 entries in wp_postmeta
  64. Duplicated site isn’t recognized as a site
  65. Error establishing a database connection,
  66. How to properly check if a table exists in WordPress Database using Show Tables Query
  67. Post Views / Hit Counter Problem?
  68. How and where is wordpress adding mySQL content to database?
  69. How to create more than one new wpdb object?
  70. SELECT SQL_CALC_FOUND_ROWS with wordpress search
  71. Remote database -> massive response time increase?
  72. wp_option table error while importing
  73. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  74. Cloning blog to localhost via WAMP
  75. Only allow user to access a link once a year, based on their joining date
  76. Delete user with only subscriber role
  77. Can’t log into wordpress site – I have made a new user and still cant access
  78. Counting post and changing roles in mysql database. Query not code
  79. MSQL database wp_postmeta has meta key tve_revision
  80. How to edit custom table data in frontend
  81. local wordpress broke after changing URL
  82. “BS_” rows in postmeta table
  83. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  84. Duplicate database to roll back theme & content changes
  85. WP website showing blank page after moving from subdomain to main domain
  86. How to create index (sql) to a meta_key?
  87. WPCLI search and replace in a particlar site dir effect another site-dir
  88. mySQL database size large, but tables size less
  89. How To connect to the same WordPress database with different database user
  90. Hang Up Followed By Can’t select database
  91. WordPress character set issue
  92. Create a new table on the database and save parameters from a contact form
  93. Changed meta_key value in structures, now dashboard shows zero users
  94. Why is converting my database to UTF-8 truncating entries?
  95. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  96. export individual posts to text files or a single csv file
  97. How to find fresh (last modified) and sql backup?
  98. SQL errors when querying for something with apostrophes
  99. Database table prefix different between wp-config.php and in database
  100. Naming conventions for database tables