View unanswered posts    View active topics

Board index KnoppMyth General

All times are UTC - 6 hours





Post new topic Reply to topic  Page 2 of 3
  [ 40 posts ] 
Go to page Previous  1, 2, 3  Next
Print view Previous topic   Next topic  
Author Message
Search for:
tjc
 Post subject:
PostPosted: Mon Feb 26, 2007 9:48 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
What does this show?
Code:
cat /etc/hosts
Top
 Profile  
 
ninten
 Post subject:
PostPosted: Mon Feb 26, 2007 9:57 pm 
Offline
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
Code:
root@mythtvbk:/etc# cat /etc/hosts
127.0.0.1       mythtvbk localhost

# The following lines are desirable for IPv6 capable hosts
# (added automatically by netbase upgrade)

::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Mon Feb 26, 2007 10:25 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
How about?
Code:
root@black2:~# mysql -u root mythconverg -e "select count(*) from settings"
+----------+
| count(*) |
+----------+
|      536 |
+----------+
Top
 Profile  
 
ninten
 Post subject:
PostPosted: Mon Feb 26, 2007 10:33 pm 
Offline
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
Code:
root@mythtvbk:/home/mythtv# mysql -u root mythconverg -e "select count(*) from settings"
ERROR 1146 (42S02) at line 1: Table 'mythconverg.settings' doesn't exist
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Mon Feb 26, 2007 10:37 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
WTH! :shock:

How about:
Code:
ls -al /var/lib/mysql/mythconverg
Top
 Profile  
 
ninten
 Post subject:
PostPosted: Mon Feb 26, 2007 10:39 pm 
Offline
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
Code:
root@mythtvbk:/home/mythtv# ls -al /var/lib/mysql/mythconverg
total 68
drwx------ 2 mysql mysql 4096 Feb 25 10:37 .
drwxr-xr-x 4 mysql mysql 4096 Feb 26 23:32 ..
-rw-rw---- 1 mysql mysql    0 Feb 25 10:37 callsignnetworkmap.MYD
-rw-rw---- 1 mysql mysql 1024 Feb 25 10:37 callsignnetworkmap.MYI
-rw-rw---- 1 mysql mysql 8630 Feb 25 10:37 callsignnetworkmap.frm
-rw-rw---- 1 mysql mysql   92 Feb 25 10:37 capturecard.MYD
-rw-rw---- 1 mysql mysql 2048 Feb 25 15:22 capturecard.MYI
-rw-rw---- 1 mysql mysql 9908 Feb 25 10:37 capturecard.frm
-rw-rw---- 1 mysql mysql   72 Feb 25 10:37 cardinput.MYD
-rw-rw---- 1 mysql mysql 2048 Feb 25 15:22 cardinput.MYI
-rw-rw---- 1 mysql mysql 9210 Feb 25 10:37 cardinput.frm
-rw-rw---- 1 mysql mysql   65 Feb 25 10:37 db.opt
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Mon Feb 26, 2007 10:49 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
That ain't good! There should be more than 200 files in that directory...
Code:
root@black2:~# ls -al /var/lib/mysql/mythconverg/ | wc -l
256

Let's take a closer look at your backup...
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Mon Feb 26, 2007 10:55 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Code:
gzip -dc /myth/backup/mythconverg.sql.gz | grep 'CREATE TABLE'  | wc -l
Top
 Profile  
 
ninten
 Post subject:
PostPosted: Mon Feb 26, 2007 10:56 pm 
Offline
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
Code:
root@mythtvbk:/home/mythtv# ls -al /var/lib/mysql/mythconverg/ | wc -l
13
DAMN!! Do we have Any other options left? :cry:
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Mon Feb 26, 2007 10:57 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Crossed in flight. Check the backup...
Top
 Profile  
 
ninten
 Post subject:
PostPosted: Mon Feb 26, 2007 11:03 pm 
Offline
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
Hmmm, I have mythconverg.sql and a bunch of bz2 files, not mythconverg.sql.gz in my backup dir...
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Mon Feb 26, 2007 11:08 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Trivial change...
Code:
bzip2 -dc /myth/backup/mythconverg.sql.bz2 | grep 'CREATE TABLE'  | wc -l

BTW - how's the disk space on that partition?
Code:
df -m ; df -i
Top
 Profile  
 
ninten
 Post subject:
PostPosted: Mon Feb 26, 2007 11:18 pm 
Offline
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
My bz2 files have a number at the end of each of them, which one do you want me to run it on? I should have posted my backup dir first :wink:. And, do the permissions look ok on those files? I would think that root would need access right :? ?
Code:
root@mythtvbk:/home/mythtv# ls -l /myth/backup
total 399940
-rw------- 1 mythtv mythtv 135319833 Feb 23 23:26 mythconverg.sql
-rw------- 1 mythtv mythtv   6911814 Dec 17 15:47 mythconverg.sql.bz2.1
-rw------- 1 mythtv mythtv   6747777 Nov 23 02:22 mythconverg.sql.bz2.2
-rw------- 1 mythtv mythtv   6133525 Oct 24 21:05 mythconverg.sql.bz2.3
-rw------- 1 mythtv mythtv   6224118 Sep 30 12:49 mythconverg.sql.bz2.4
-rw------- 1 mythtv mythtv   6096770 Sep 17 16:03 mythconverg.sql.bz2.5
-rw------- 1 mythtv mythtv   5818229 Aug  7  2006 mythconverg.sql.bz2.6
-rw------- 1 mythtv mythtv   5653583 Jul 19  2006 mythconverg.sql.bz2.7
-rw------- 1 mythtv mythtv   5325326 Jun 17  2006 mythconverg.sql.bz2.8
-rw------- 1 mythtv mythtv   5260167 Jun 10  2006 mythconverg.sql.bz2.9
-rw------- 1 mythtv mythtv 101317673 Feb 23 23:42 savedfiles.tar.bz2
-rw------- 1 mythtv mythtv  14679632 Dec 17 15:49 savedfiles.tar.bz2.1
-rw------- 1 mythtv mythtv  10003185 Nov 23 02:23 savedfiles.tar.bz2.2
-rw------- 1 mythtv mythtv   9973531 Oct 24 21:07 savedfiles.tar.bz2.3
-rw------- 1 mythtv mythtv   9630287 Sep 30 12:50 savedfiles.tar.bz2.4
-rw------- 1 mythtv mythtv   9629684 Sep 17 16:04 savedfiles.tar.bz2.5
-rw------- 1 mythtv mythtv   9628553 Aug  7  2006 savedfiles.tar.bz2.6
-rw------- 1 mythtv mythtv   9627782 Jul 19  2006 savedfiles.tar.bz2.7
-rw------- 1 mythtv mythtv  22503935 Jun 17  2006 savedfiles.tar.bz2.8
-rw------- 1 mythtv mythtv  22475587 Jun 10  2006 savedfiles.tar.bz2.9

Disk space:
Code:
root@mythtvbk:/home/mythtv# df -m ; df -i
Filesystem           1M-blocks      Used Available Use% Mounted on
/dev/hda1                 4716      2346      2132  53% /
/dev/hda3               280789    125120    155670  45% /myth
tmpfs                      188         1       188   1% /dev/shm
Filesystem            Inodes   IUsed   IFree IUse% Mounted on
/dev/hda1             500992  102071  398921   21% /
/dev/hda3              70208   42611   27597   61% /myth
tmpfs                  47903       3   47900    1% /dev/shm
Top
 Profile  
 
tjc
 Post subject:
PostPosted: Mon Feb 26, 2007 11:22 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Root has access to everything so it's not a problem on that count. As for the backup you need to look in the uncompressed file in this case...
Code:
grep 'CREATE TABLE' /myth/backup/mythconverg.sql | wc -l
Top
 Profile  
 
ninten
 Post subject:
PostPosted: Mon Feb 26, 2007 11:28 pm 
Offline
Joined: Thu Feb 16, 2006 2:07 pm
Posts: 21
Code:
root@mythtvbk:/home/mythtv# grep 'CREATE TABLE' /myth/backup/mythconverg.sql | wc -l
67
Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  Page 2 of 3
  [ 40 posts ] 
Go to page Previous  1, 2, 3  Next


Board index KnoppMyth General

All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 25 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu