Ubuntu Server Guide 12.04 - MySQL Advanced configuration mistakes

For raring, issue 1 has already been solved.
For issue 2, it seems this:

mysqldump --all-databases --all-routines -u root -p > ~/fulldump.sql

Should change to:

mysqldump --all-databases --routines -u root -p > ~/fulldump.sql

I can confirm that "--all-routines" does not work, and that "--routines" does. However, am not a subject matter expert here, and I can not confirm if the contents of fulldump.sql are complete.

Sorry, my mistake. Issue 1 needs fixing in the raring branch also, and as described.

I have a branch ready to merge. See the attached bzr diff output.
However, I would still like a subject matter expert to confirm the mysqldump command.

Confirmed that the diff is correct, --routines is the appropriate flag.

Will you also backport to precise and quantal? If not feel free to assign that to me.

Bryan, thanks for your confirmation. I will go ahead and put this into the raring main branch.
With time running out for the raring string freeze (April 4th), and so much to do, I have been only doing raring changes, leaving the others.

hi all

just to re-iterate what has been said before issue (3) "sudo service start mysql" should read "sudo service mysql start".

aaron@aaron-VirtualBox:/xx/xx/xx$ sudo service mysql start
mysqld: unrecognized service

aaron@aaron-VirtualBox:/xx/xx/xx$ sudo service start mysql
start: unrecognized service

in both cases i got the same error - correction i found is

1) aaron@aaron-VirtualBox:/xx/xx/xx$ start mysql

start: Rejected send message, 1 matched rules; type="method_call", sender=":1.88" (uid=1000 pid=10537 comm="start mysql ") interface="com.ubuntu.Upstart0_6.Job" member="Start" error name="(unset)" requested_reply="0" destination="com.ubuntu.Upstart" (uid=0 pid=1 comm="/sbin/init")

2) check the status - MySQL server

aaron@aaron-VirtualBox:~$ sudo netstat -tap | grep mysql
tcp 0 0 localhost:mysql *:* LISTEN 10369/mysqld

3) to stop the service.

aaron@aaron-VirtualBox:~$ sudo stop mysql

thanks.

Works fine for me:

doug@s15:~$ sudo service mysql stop
mysql stop/waiting
doug@s15:~$ sudo service mysql start
mysql start/running, process 9243
doug@s15:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 12.04.3 LTS
Release: 12.04
Codename: precise
doug@s15:~$ uname -a
Linux s15 3.2.0-56-generic #86-Ubuntu SMP Wed Oct 23 09:20:45 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

ok .. i got it now, must be a typo error on my end, thanks for your help.

aaron@aaron-VirtualBox:~$ sudo service mysql start
mysql start/running, process 11974

aaron@aaron-VirtualBox:~$ sudo netstat -tap | grep mysql
tcp 0 0 localhost:mysql *:* LISTEN 11974/mysqld