SQL database export-import

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

Related posts

1 comment

  1. 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

Comments are closed.