Difference between revisions of "Hostname change"

From MythTV Official Wiki
Jump to: navigation, search
(SQL script for amending hostname in all tables.)
 
 
Line 1: Line 1:
= Change Hostname =
+
#REDIRECT[[Database_Backup_and_Restore#Change_the_hostname_of_a_MythTV_frontend_or_backend]]
 
 
If you need to change your hostname, you will need to bring the mythconverg tables along with you. 
 
 
 
Could also apply if you move your mythconverg database to another machine.
 
 
 
Search/replace oldhost with your actual former hostname, same with newhost for the name of your new machine, found in /etc/hostname, or by typing '''hostname'''
 
 
 
This SQL is for 0.23
 
 
 
<pre>
 
update capturecard          set hostname='newhost' where hostname='oldhost';
 
update displayprofilegroups set hostname='newhost' where hostname='oldhost';
 
update inuseprograms        set hostname='newhost' where hostname='oldhost';
 
update jobqueue            set hostname='newhost' where hostname='oldhost';
 
update jumppoints          set hostname='newhost' where hostname='oldhost';
 
update keybindings          set hostname='newhost' where hostname='oldhost';
 
update music_playlists      set hostname='newhost' where hostname='oldhost';
 
update profilegroups        set hostname='newhost' where hostname='oldhost';
 
update recorded            set hostname='newhost' where hostname='oldhost';
 
update recordedfile        set hostname='newhost' where hostname='oldhost';
 
update settings            set hostname='newhost' where hostname='oldhost';
 
update storagegroup        set hostname='newhost' where hostname='oldhost';
 
update weatherscreens      set hostname='newhost' where hostname='oldhost';
 
</pre>
 
 
 
 
 
[[Category:HOWTO]]
 

Latest revision as of 11:02, 26 September 2013