rain13 Posted July 23, 2014 Share Posted July 23, 2014 Hello.I am developing my site in development environment and then when I reach to some good point I'll update live. I was wondering if there's any easy tool to patch live datapases? On live server I can only run PHP scripts but I can allow SQL connections from my development machine if needed. I am looking for something that would add missing columns with defaut values or optionally values from dev database dump, that would rename columns if needed and that would create new tables if neede, but not touch the existing data. The reason why I am asing this is that if I just export and then import dump then my articles on live also get overwritten with test data, but if I exclude articles from SQL dump then I would have to update this table manyally from phpmyadmin. Is there any quick and easy tool for that? Link to comment Share on other sites More sharing options...
niche Posted July 23, 2014 Share Posted July 23, 2014 sql is your answer. learn it so you can unleash its power. sounds like you're intimidated by sql in some ways. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now