I am new to wordpress. I develop my whole wordpress site online. I use a maintenance plug in that allows me to set a maintenance message while I can make changes and test my site online. (the site is open for admin but close for others)
I heard some people develop it offline with a software from the pc. But if I develop it offline, then each time I have to update my database and website content files isn't it?
Also, I faced problems while replacing database through cPanel's Restore Back Up option. I restored database from my computer which overrode and replaced the existing one or merged with the old database, I don't know for sure. What's the most convenient way of updating a database? I can access the database with my SQL database wizard and PHP MyAdmin but can not find its location so that I manually delete it and replace it with newer version of database or an old database if something goes wrong (like activating a faulty theme and site goes blank)
I would like to know how you guys develop your wordpress site and also looking for some suggestions about my concerns.