1

I develop websites containing WordPress blogs as well as other PHP pages I design. When I make changes to sites locally on my test server I do a SQL database dump using myPHPAdmin. How can I avoid overwriting the content of the client's WordPress Calendar entrys and other Calendar settings? If I simply deselect the calendar tables on my localhost db dump will the client's db maintain those client entry to the tables on the remote server after the import?

Thanks in advance

Improve this question
1
  • Maybe. What calendar plugin are they using? In the future, why not pull their site down, make changes to that, and then push back to production? You shouldn't need to do much to the live database that can't be accomplished with a few minutes of downtime while you assign pages to templates and what not. Commented Oct 29, 2013 at 3:55

1 Answer 1

Reset to default
2

backup only all tables you need from localhost so your .sql file contain only the tables you need & after this go to your live server keep your databse as it the use the following cmd from unix/linux SSH to keep the old tables & only restore the new tables 

mysql -u username -ppassword databasename -D < /pathto/datbase.sql

this cmd is used for restoring only some tables & let other tables as it

don't forget please backup every thing before trying this to avoid any problems

Improve this answer
2
  • Pretty clever. Would this be typically doable by pure php? I don't know the PHP db drivers very well, can they do a dump restore like this in a simple way? Commented Apr 26, 2015 at 20:33
  • Glad this help, this is command not you can use it from mysql console or from SSH, i think there is alot of alternative ways with PHP, but this is for the big 7 huge sizes is better Commented Apr 26, 2015 at 21:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.