Jump to content

Any easy way to updae live databases?


rain13

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...