Wordpress basic scripts

Site URL and Home URL

SELECT * from wp_options WHERE option_name = 'home' OR option_name = 'siteurl';

update wp_options set option_value = 'http://bottlemeamessage.com' where option_name = 'home';

update wp_options set option_value = 'http://bottlemeamessage.com' where option_name = 'siteurl';

To change theme

# In table wp_options

>edit option name >>'current_theme'

>>'template'

>>stylesheet

~~~~~~~~~~

SELECT * from wp_options WHERE option_name = 'current_theme';

UPDATE wp_options SET option_value = 'twentytwelve' WHERE option_name = 'template';

UPDATE wp_options SET option_value = 'twentytwelve' WHERE option_name = 'stylesheet';

UPDATE wp_options SET option_value = 'twentytwelve' WHERE option_name = 'current_theme';

~~~~~~~~~~~`````