Docs for changing hostname is incorrect for mysql 5

[thomas@…]

http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.15 shows this command for changing the hostname:

$ cat mythtv_backup.sql | sed s/\'frontend1\'/\'kidsroom\'/ >> mythtv_restore.sql

But with mysql 5, you have to use:

$ cat mythtv_backup.sql | sed s/\'frontend1\'/\'kidsroom\'/g >> mythtv_restore.sql

[anonymous]

I'd imagine this is due to the use of mysql extended insert syntax which allows multiple rows to be inserted in a single sql statement and is considerably faster than separate insert operations. This mode can be enabled in mysql 4 too via the -e option or the --opt option, so the docs should probably just be updated to include the global /g specifier for all cases.

[cpinkham]

(In [10553]) Add a 'g' to the example sed command for changing the hostname in an SQL backup since MySQL 5 puts more than one SQL statement on a single line by default.

Closes #1814.