[mythtv-users] How to repair mysql?
UB40D
ub40dd at googlemail.com
Tue Mar 19 22:39:53 UTC 2013
On Tue, Mar 19, 2013 at 11:33 AM, Ian Clark <mrrooster at gmail.com> wrote:
> On 16 March 2013 16:38, UB40D <ub40dd at googlemail.com> wrote:
> ...there we go. Still not purged. Looks like I can't fully clean up the
> > system unless I also purge mythtv.
> > How can I reinstall and revive mysql without disturbing mythtv?
> >
> dpkg -P --force-depends <packages> should remove a package with
> dependencies.
>
> (--force-depends turns dependency errors into warnings)
>
Aha! Now we're cooking with gas! At last, this one worked! Thanks a
million, Ian.
# dpkg -l "mysql*"
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-==============-============-============-=================================
un mysql-client <none> (no description available)
un mysql-client-4 <none> (no description available)
un mysql-client-5 <none> (no description available)
un mysql-client-5 <none> (no description available)
pi mysql-client-5 5.5.29-0ubun amd64 MySQL database client binaries
un mysql-client-c <none> (no description available)
pi mysql-client-c 5.5.29-0ubun amd64 MySQL database core client
binari
pi mysql-common 5.5.29-0ubun all MySQL database common files,
e.g.
un mysql-common-4 <none> (no description available)
un mysql-server <none> (no description available)
un mysql-server-5 <none> (no description available)
un mysql-server-c <none> (no description available)
# dpkg -P --force-depends mysql-client-5.5 mysql-client-core-5.5
mysql-common
dpkg: mysql-client-core-5.5: dependency problems, but removing anyway as
you requested:
mysql-client-5.5 depends on mysql-client-core-5.5.
(Reading database ... 322130 files and directories currently installed.)
Removing mysql-client-core-5.5 ...
dpkg: mysql-common: dependency problems, but removing anyway as you
requested:
mysql-client-5.5 depends on mysql-common (>= 5.5.29-0ubuntu0.12.10.1).
libmysqlclient18:amd64 depends on mysql-common (>=
5.5.29-0ubuntu0.12.10.1).
Removing mysql-common ...
Purging configuration files for mysql-common ...
dpkg: mysql-client-5.5: dependency problems, but removing anyway as you
requested:
mythtv-common depends on mysql-client; however:
Package mysql-client is not installed.
Package mysql-client-5.5 which provides mysql-client is to be removed.
Removing mysql-client-5.5 ...
Processing triggers for man-db ...
# dpkg -l "mysql*"
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-==============-============-============-=================================
un mysql-client <none> (no description available)
un mysql-common <none> (no description available)
un mysql-server <none> (no description available)
un mysql-server-5 <none> (no description available)
# aptitude clean
# aptitude autoclean
Freed 0 B of disk space
# aptitude install mysql-client mysql-common mysql-server
The following NEW packages will be installed:
mysql-client mysql-client-5.5{a} mysql-client-core-5.5{a} mysql-common
mysql-server mysql-server-5.5{a} mysql-server-core-5.5{a}
0 packages upgraded, 7 newly installed, 0 to remove and 35 not upgraded.
Need to get 25.1 MB of archives. After unpacking 90.5 MB will be used.
Do you want to continue? [Y/n/?]
Get: 1 http://gb.archive.ubuntu.com/ubuntu/ quantal-updates/main
mysql-common all 5.5.29-0ubuntu0.12.10.1 [13.5 kB]
Get: 2 http://gb.archive.ubuntu.com/ubuntu/ quantal-updates/main
mysql-client-core-5.5 amd64 5.5.29-0ubuntu0.12.10.1 [1,936 kB]
Get: 3 http://gb.archive.ubuntu.com/ubuntu/ quantal-updates/main
mysql-client-5.5 amd64 5.5.29-0ubuntu0.12.10.1 [8,306 kB]
Get: 4 http://gb.archive.ubuntu.com/ubuntu/ quantal-updates/main
mysql-server-core-5.5 amd64 5.5.29-0ubuntu0.12.10.1 [5,987 kB]
Get: 5 http://gb.archive.ubuntu.com/ubuntu/ quantal-updates/main
mysql-server-5.5 amd64 5.5.29-0ubuntu0.12.10.1 [8,839 kB]
Get: 6 http://gb.archive.ubuntu.com/ubuntu/ quantal-updates/main
mysql-client all 5.5.29-0ubuntu0.12.10.1 [11.5 kB]
Get: 7 http://gb.archive.ubuntu.com/ubuntu/ quantal-updates/main
mysql-server all 5.5.29-0ubuntu0.12.10.1 [11.6 kB]
Fetched 25.1 MB in 6s (3,647
kB/s)
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 322073 files and directories currently installed.)
Unpacking mysql-common (from
.../mysql-common_5.5.29-0ubuntu0.12.10.1_all.deb) ...
Selecting previously unselected package mysql-client-core-5.5.
Unpacking mysql-client-core-5.5 (from
.../mysql-client-core-5.5_5.5.29-0ubuntu0.12.10.1_amd64.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from
.../mysql-client-5.5_5.5.29-0ubuntu0.12.10.1_amd64.deb) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from
.../mysql-server-core-5.5_5.5.29-0ubuntu0.12.10.1_amd64.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.29-0ubuntu0.12.10.1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 322221 files and directories currently installed.)
Unpacking mysql-server-5.5 (from
.../mysql-server-5.5_5.5.29-0ubuntu0.12.10.1_amd64.deb) ...
Selecting previously unselected package mysql-client.
Unpacking mysql-client (from
.../mysql-client_5.5.29-0ubuntu0.12.10.1_all.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from
.../mysql-server_5.5.29-0ubuntu0.12.10.1_all.deb) ...
Processing triggers for ureadahead ...
Processing triggers for man-db ...
Setting up mysql-client-core-5.5 (5.5.29-0ubuntu0.12.10.1) ...
Setting up mysql-client-5.5 (5.5.29-0ubuntu0.12.10.1) ...
Setting up mysql-server-core-5.5 (5.5.29-0ubuntu0.12.10.1) ...
Setting up mysql-server-5.5 (5.5.29-0ubuntu0.12.10.1) ...
mysql start/running, process 9349
Setting up mysql-client (5.5.29-0ubuntu0.12.10.1) ...
Processing triggers for ureadahead ...
Setting up mysql-server (5.5.29-0ubuntu0.12.10.1) ...
Current status: 0 broken [-2].
# dpkg -l "mysql*"
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Architecture Description
+++-==============-============-============-=================================
ii mysql-client 5.5.29-0ubun all MySQL database client
(metapackag
un mysql-client-4 <none> (no description available)
un mysql-client-5 <none> (no description available)
un mysql-client-5 <none> (no description available)
ii mysql-client-5 5.5.29-0ubun amd64 MySQL database client binaries
un mysql-client-c <none> (no description available)
ii mysql-client-c 5.5.29-0ubun amd64 MySQL database core client
binari
ii mysql-common 5.5.29-0ubun all MySQL database common files,
e.g.
un mysql-common-4 <none> (no description available)
ii mysql-server 5.5.29-0ubun all MySQL database server
(metapackag
un mysql-server-4 <none> (no description available)
un mysql-server-5 <none> (no description available)
un mysql-server-5 <none> (no description available)
ii mysql-server-5 5.5.29-0ubun amd64 MySQL database server binaries
an
un mysql-server-c <none> (no description available)
un mysql-server-c <none> (no description available)
un mysql-server-c <none> (no description available)
ii mysql-server-c 5.5.29-0ubun amd64 MySQL database server binaries
# dpkg -l "mysql*" | fgrep ii
ii mysql-client
5.5.29-0ubuntu0.12.10.1 all MySQL database
client (metapackage depending on the latest version)
ii mysql-client-5.5
5.5.29-0ubuntu0.12.10.1 amd64 MySQL database
client binaries
ii mysql-client-core-5.5
5.5.29-0ubuntu0.12.10.1 amd64 MySQL database
core client binaries
ii mysql-common
5.5.29-0ubuntu0.12.10.1 all MySQL database
common files, e.g. /etc/mysql/my.cnf
ii mysql-server
5.5.29-0ubuntu0.12.10.1 all MySQL database
server (metapackage depending on the latest version)
ii mysql-server-5.5
5.5.29-0ubuntu0.12.10.1 amd64 MySQL database
server binaries and system database setup
ii mysql-server-core-5.5
5.5.29-0ubuntu0.12.10.1 amd64 MySQL database
server binaries
#
#
Now the service is running, at last!
All that remains is to put mythconverg back where it was in var. I'll do
that some other time so I don't have to interrupt halfway through if things
don't go to plan.
But again THANKS A LOT Ian! (And Igor, whose commands I ran after that.)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130319/d41f58fc/attachment.html>
More information about the mythtv-users
mailing list