Difference between revisions of "Hostname change"

From MythTV Official Wiki
Redirect page
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