Opened 14 years ago

Closed 13 years ago

#1814 closed defect (fixed)

Docs for changing hostname is incorrect for mysql 5

Reported by: thomas@… Owned by: Isaac Richards
Priority: minor Milestone: unknown
Component: mythtv Version: 0.19
Severity: low Keywords:
Cc: Ticket locked: no

Description

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

Change History (2)

comment:1 Changed 14 years ago by 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.

comment:2 Changed 13 years ago by cpinkham

Resolution: fixed
Status: newclosed

(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.

Note: See TracTickets for help on using tickets.