With Wordpress, is it possible to work on localhost but have the DB on a server? So that workflow will be:
1) Work on localhost (but connected to remote database)
2) Upload JUST files via backup software daily
This would eliminate the pain of uploading the database each time (logging into cPanel, dropping DB, uploading DB, running SQL find&replace command, logging into site and updating permalinks...)
I know how to connect to the actual remote database with wp-config.php, but it results in a 404 page because (I'm guessing) it has the wrong site URL in the DB?
#wamp <VirtualHost *:80> ServerAdmin email@example.com DocumentRoot "c:/wamp/www" ServerName localhost ServerAlias localhost.com www.localhost.com ErrorLog "logs/locahost-error.log" CustomLog "logs/localhost-access.log" common <Directory "c:/wamp/www"> AllowOverride All Require local </Directory>
#site.local <VirtualHost *:80> ServerAdmin firstname.lastname@example.org DocumentRoot "c:/wamp/www/site" ServerName site.localhost ServerAlias www.site.local ErrorLog "logs/site.local-error.log" CustomLog "logs/site.local-access.log" common <Directory "c:/wamp/www/site"> AllowOverride All Require local </Directory>
127.0.0.1 localhost 127.0.0.1 site.local