I am going to design / create a WordPress website for client that wants me to construct the website on his server. I favor to build up in your area, and without lag time, but Let me look for a middle ground that actually works for the two of us.

I've transmit for FTP and know there's a method to synchronize a nearby folder using the server. Although, My anxiety about this really is that although the .php, plug ins, images, .css, .js will transfer in by doing this, the my SQL tables won't.

It is possible to method to fully sync up a nearby WordPress directory with one located with an FTP server to help keep mySQL tables with posts, wordpress plugin configurations etc. in tact?

Thanks!

here i have found someone utilizing an SSH script to offer the synchronization of files and database: http://hecode.com/simple-way-to-backup-clone-sync-online-wordpress-website-to-local-development-website-by-using-ssh/

sincerely i don't comprehend it (i am unfamiliar with ssh) but maybe it will help.

Two ways: periodically export your database in the client's host, import it at local, then alter the domain along with other Web addresses within the database in your area by having an sql query in phpmyadmin, while you will not have the ability to login to Wordpress in your area until you've changes the bottom site Web addresses.

UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';

after which update posts:

UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');

Or: you are able to call a non-localhost MySQL server in wordpress-config to you can preserve one copy from the database for host and native, as lengthy because the target server is set up to simply accept outdoors connections. In wordpress-config.php:

define('DB_HOST', 'mysql.example.com');  or 
define('DB_HOST', 'mysql.example.com:4454');

You may even have to open ports in your local machine's firewall.