This is a fairly simple question but I would like to get rid of any doubt I have with this question. I have WordPress installed on my site as this: http://www.mysite.com/beta/wordpress which is password protected for me to make finishing touches to it before I make it live, now the question I have is can I just move the files to make wordpress the root site after removing the old site? That shouldn’t affect the database in any way, right?
Although you will want to make sure to change the ‘Site URL’ in the general settings option. Then make sure to log into PHPMyAdmin and do a search for ‘beta’ to make sure there aren’t any urls leftover.