Help fast please...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Rob461
    New Member
    • Jul 2003
    • 6

    Help fast please...

    "Database error in vBulletin 3.0.0:

    Invalid SQL:
    SELECT pm.*, pmtext.*
    , icon.title AS icontitle, icon.iconpath
    FROM vb3pm AS pm
    LEFT JOIN vb3pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
    LEFT JOIN vb3icon AS icon ON(icon.iconid = pmtext.iconid)
    WHERE pm.userid=1 AND pm.folderid=0
    ORDER BY pmtext.dateline DESC
    LIMIT 0, 50

    mysql error: Can't create/write to file '/tmp/#sql_3a8e_0.MYI' (Errcode: 13)

    mysql error number: 1

    Date: Thursday 06th of May 2004 10:04:18 PM
    Script: http://www.zeldalegacies.com/forums/private.php?
    Referer: http://www.zeldalegacies.com/forums/
    Username: Rob
    IP Address: 64.91.38.183"

    or you can find it here:


    Please help me my people arn't to happy...I am sure they would send me lots of PMs...if they could.
  • George L
    Former vBulletin Support
    • May 2000
    • 32996
    • 3.8.x

    #2
    1. make sure your have free space on your mysql data partition
    2. make sure mysql database's files have correct file permissions and user/group ownerships
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment

    • Rob461
      New Member
      • Jul 2003
      • 6

      #3
      I am rather new to this..how would I go about doing that?

      Comment

      • George L
        Former vBulletin Support
        • May 2000
        • 32996
        • 3.8.x

        #4
        for first part in ssh telnet as root user type

        df -h

        you'll end up with output like

        Code:
        Filesystem            Size  Used Avail Use% Mounted on
        /dev/sda1              17G  5.8G   10G  37% /
        /dev/sdb1              17G   11G  5.9G  63% /data
        as you can see no partition is 100% in use

        As to 2nd that really depends on how your server is configured. Easiest way is to compare file permissions ownership on an existing databases other than your vB forum database

        i.e. for my own forums my mysql database data files are located at where vbforum is the database name

        /usr/local/mysql/data/vbforum

        1. change to that directory for your databasename and type ls -alh

        so in ssh telnet type:

        cd /usr/local/mysql/data/databasename

        then type

        ls -alh

        which will output something like

        Code:
        total 947M
        drwx------    2 mysql    mysql        8.0k Apr  5 07:02 ./
        drwx------   20 mysql    mysql        4.0k May  5 12:25 ../
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 03:58 access.frm
        -rw-rw----    1 mysql    mysql        9.4k Apr  5 03:58 access.MYD
        -rw-rw----    1 mysql    mysql         15k May  1 13:30 access.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 adminhelp.frm
        -rw-rw----    1 mysql    mysql         46k Apr  5 04:47 adminhelp.MYD
        -rw-rw----    1 mysql    mysql         52k May  1 13:30 adminhelp.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 administrator.frm
        -rw-rw----    1 mysql    mysql          96 Apr  5 04:36 administrator.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 administrator.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 adminlog.frm
        -rw-rw----    1 mysql    mysql        493k May  6 23:53 adminlog.MYD
        -rw-rw----    1 mysql    mysql         75k May  6 23:53 adminlog.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 03:58 adminutil.frm
        -rw-rw----    1 mysql    mysql        9.6k Apr  5 03:58 adminutil.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 adminutil.MYI
        -rw-rw----    1 mysql    mysql        8.7k Apr  5 03:58 announcement.frm
        -rw-rw----    1 mysql    mysql         25k May  6 23:27 announcement.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  6 20:54 announcement.MYI
        -rw-rw----    1 mysql    mysql        8.8k Apr  5 03:58 attachment.frm
        -rw-rw----    1 mysql    mysql         24M May  7 00:08 attachment.MYD
        -rw-rw----    1 mysql    mysql        1.1M May  6 20:00 attachment.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 attachmenttype.frm
        -rw-rw----    1 mysql    mysql         700 Apr  5 03:58 attachmenttype.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 attachmenttype.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 03:58 attachmentviews.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 03:58 attachmentviews.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  7 00:10 attachmentviews.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 avatar.frm
        -rw-rw----    1 mysql    mysql        135k Apr  5 03:58 avatar.MYD
        -rw-rw----    1 mysql    mysql        9.0k May  1 13:30 avatar.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 03:58 bbcode.frm
        -rw-rw----    1 mysql    mysql         848 Apr  5 03:58 bbcode.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:30 bbcode.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 03:58 calendarcustomfield.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 03:58 calendarcustomfield.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:30 calendarcustomfield.MYI
        -rw-rw----    1 mysql    mysql        8.8k Apr  5 04:46 calendar.frm
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 calendarmoderator.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 03:58 calendarmoderator.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:30 calendarmoderator.MYI
        -rw-rw----    1 mysql    mysql         116 Apr  5 07:02 calendar.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:30 calendar.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 calendarpermission.frm
        -rw-rw----    1 mysql    mysql         225 Apr  5 03:58 calendarpermission.MYD
        -rw-rw----    1 mysql    mysql        4.0k May  1 13:30 calendarpermission.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 03:58 cron.frm
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 cronlog.frm
        -rw-rw----    1 mysql    mysql        8.1k May  7 00:02 cronlog.MYD
        -rw-rw----    1 mysql    mysql        7.0k May  7 00:02 cronlog.MYI
        -rw-rw----    1 mysql    mysql         784 May  7 00:10 cron.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  7 00:10 cron.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 customavatar.frm
        -rw-rw----    1 mysql    mysql        2.7M May  6 02:37 customavatar.MYD
        -rw-rw----    1 mysql    mysql         14k May  6 09:15 customavatar.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 customprofilepic.frm
        -rw-rw----    1 mysql    mysql        9.1k Apr 26 01:50 customprofilepic.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 customprofilepic.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 03:58 datastore.frm
        -rw-rw----    1 mysql    mysql        466k May  7 00:10 datastore.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  7 00:10 datastore.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 deletionlog.frm
        -rw-rw----    1 mysql    mysql         744 Apr 19 12:27 deletionlog.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 deletionlog.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 editlog.frm
        -rw-rw----    1 mysql    mysql        1.2M May  6 20:20 editlog.MYD
        -rw-rw----    1 mysql    mysql        535k May  6 20:20 editlog.MYI
        -rw-rw----    1 mysql    mysql        8.8k Apr  5 03:58 event.frm
        -rw-rw----    1 mysql    mysql        1.6k Apr  5 03:58 event.MYD
        -rw-rw----    1 mysql    mysql        4.0k May  1 13:30 event.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 faq.frm
        -rw-rw----    1 mysql    mysql        1.3k Apr  5 03:58 faq.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:30 faq.MYI
        -rw-rw----    1 mysql    mysql        9.1k Apr  5 03:58 forum.frm
        -rw-rw----    1 mysql    mysql        424k May  7 00:10 forum.MYD
        -rw-rw----    1 mysql    mysql        5.0k May  6 19:57 forum.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 forumpermission.frm
        -rw-rw----    1 mysql    mysql         473 Apr  5 03:58 forumpermission.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:30 forumpermission.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 holiday.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 03:58 holiday.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:30 holiday.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 icon.frm
        -rw-rw----    1 mysql    mysql        2.8k Apr  5 03:58 icon.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 icon.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 imagecategory.frm
        -rw-rw----    1 mysql    mysql          84 Apr  5 03:58 imagecategory.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 imagecategory.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 03:58 imagecategorypermission.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 03:58 imagecategorypermission.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:30 imagecategorypermission.MYI
        -rw-rw----    1 mysql    mysql         11k Apr  5 04:46 language.frm
        -rw-rw----    1 mysql    mysql        486k Apr  5 07:02 language.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 language.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 mailqueue.frm
        -rw-rw----    1 mysql    mysql         56k May  7 00:10 mailqueue.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  7 00:10 mailqueue.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 03:58 moderation.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 03:58 moderation.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:30 moderation.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 moderator.frm
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 03:58 moderatorlog.frm
        -rw-rw----    1 mysql    mysql         17k May  6 02:36 moderatorlog.MYD
        -rw-rw----    1 mysql    mysql        4.0k May  6 08:48 moderatorlog.MYI
        -rw-rw----    1 mysql    mysql        1.3k Apr  5 03:58 moderator.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 moderator.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 03:58 passwordhistory.frm
        -rw-rw----    1 mysql    mysql        2.1k May  1 12:37 passwordhistory.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 passwordhistory.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:58 phrase.frm
        -rw-rw----    1 mysql    mysql        940k May  6 20:01 phrase.MYD
        -rw-rw----    1 mysql    mysql        267k May  6 22:12 phrase.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:59 phrasetype.frm
        -rw-rw----    1 mysql    mysql         12k Apr  5 04:46 phrasetype.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:30 phrasetype.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:59 pm.frm
        -rw-rw----    1 mysql    mysql        1.8M May  6 23:55 pm.MYD
        -rw-rw----    1 mysql    mysql        3.5M May  6 23:47 pm.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 03:59 pmreceipt.frm
        -rw-rw----    1 mysql    mysql        1.9M May  7 00:00 pmreceipt.MYD
        -rw-rw----    1 mysql    mysql        1.0M May  7 00:00 pmreceipt.MYI
        -rw-rw----    1 mysql    mysql        8.7k Apr  5 03:59 pmtext.frm
        -rw-rw----    1 mysql    mysql         60M May  6 21:53 pmtext.MYD
        -rw-rw----    1 mysql    mysql        1.4M May  6 22:14 pmtext.MYI
        -rw-rw----    1 mysql    mysql        8.7k Apr  5 03:59 poll.frm
        -rw-rw----    1 mysql    mysql         95k May  6 20:57 poll.MYD
        -rw-rw----    1 mysql    mysql        4.0k May  6 22:14 poll.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 03:59 pollvote.frm
        -rw-rw----    1 mysql    mysql        232k May  6 20:57 pollvote.MYD
        -rw-rw----    1 mysql    mysql        283k May  6 22:12 pollvote.MYI
        -rw-rw----    1 mysql    mysql        8.8k Apr  5 03:59 post.frm
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:00 posthash.frm
        -rw-rw----    1 mysql    mysql        1.9k May  7 00:10 posthash.MYD
        -rw-rw----    1 mysql    mysql        5.0k May  7 00:10 posthash.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:00 postindex.frm
        -rw-rw----    1 mysql    mysql        169M May  7 00:10 postindex.MYD
        -rw-rw----    1 mysql    mysql        231M May  7 00:10 postindex.MYI
        -rw-rw----    1 mysql    mysql        360M May  7 00:10 post.MYD
        -rw-rw----    1 mysql    mysql         26M May  7 00:10 post.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:00 post_parsed.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:00 post_parsed.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:30 post_parsed.MYI
        -rw-rw----    1 mysql    mysql        8.9k Apr  5 04:06 profilefield.frm
        -rw-rw----    1 mysql    mysql         372 Apr  5 04:06 profilefield.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:31 profilefield.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 ranks.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 ranks.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 ranks.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:06 regimage.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 regimage.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 regimage.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 04:06 reminder.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 reminder.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 reminder.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 reputation.frm
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 reputationlevel.frm
        -rw-rw----    1 mysql    mysql         640 Apr  5 04:06 reputationlevel.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:31 reputationlevel.MYI
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 reputation.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 reputation.MYI
        -rw-rw----    1 mysql    mysql        8.9k Apr  5 04:06 search.frm
        -rw-rw----    1 mysql    mysql        236k May  7 00:06 search.MYD
        -rw-rw----    1 mysql    mysql        5.0k May  7 00:06 search.MYI
        -rw-rw----    1 mysql    mysql        8.8k Apr  5 04:06 session.frm
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 04:06 setting.frm
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:06 settinggroup.frm
        -rw-rw----    1 mysql    mysql        1.9k Apr  5 04:47 settinggroup.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:31 settinggroup.MYI
        -rw-rw----    1 mysql    mysql         37k Apr 24 01:18 setting.MYD
        -rw-rw----    1 mysql    mysql        6.0k May  1 13:31 setting.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 smilie.frm
        -rw-rw----    1 mysql    mysql         20k Apr  5 05:15 smilie.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:31 smilie.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 stats.frm
        -rw-rw----    1 mysql    mysql        1020 May  7 00:00 stats.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  7 00:00 stats.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:06 strikes.frm
        -rw-rw----    1 mysql    mysql        1.2k May  6 23:41 strikes.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  6 23:41 strikes.MYI
        -rw-rw----    1 mysql    mysql        8.7k Apr  5 04:06 style.frm
        -rw-rw----    1 mysql    mysql        529k Apr 14 13:25 style.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:31 style.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:06 subscribeevent.frm
        -rw-rw----    1 mysql    mysql           9 Apr  5 04:06 subscribeevent.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:31 subscribeevent.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 subscribeforum.frm
        -rw-rw----    1 mysql    mysql        8.7k Apr  5 04:06 subscribeforum.MYD
        -rw-rw----    1 mysql    mysql         26k May  1 13:31 subscribeforum.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 subscribethread.frm
        -rw-rw----    1 mysql    mysql        966k May  6 14:34 subscribethread.MYD
        -rw-rw----    1 mysql    mysql        1.6M May  6 15:50 subscribethread.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 04:06 subscription.frm
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 04:06 subscriptionlog.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 subscriptionlog.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 subscriptionlog.MYI
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 subscription.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 subscription.MYI
        -rw-rw----    1 mysql    mysql        8.7k Apr  5 04:06 template.frm
        -rw-rw----    1 mysql    mysql        2.4M Apr 14 13:25 template.MYD
        -rw-rw----    1 mysql    mysql         26k May  1 13:31 template.MYI
        -rw-rw----    1 mysql    mysql        9.0k Apr  5 04:06 thread.frm
        -rw-rw----    1 mysql    mysql        5.8M May  7 00:10 thread.MYD
        -rw-rw----    1 mysql    mysql        1.6M May  7 00:10 thread.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 threadrate.frm
        -rw-rw----    1 mysql    mysql         990 Apr  8 14:59 threadrate.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:31 threadrate.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:06 threadviews.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 threadviews.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  6 23:56 threadviews.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 upgradelog.frm
        -rw-rw----    1 mysql    mysql         34k Apr  5 04:47 upgradelog.MYD
        -rw-rw----    1 mysql    mysql        7.0k May  1 13:31 upgradelog.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 useractivation.frm
        -rw-rw----    1 mysql    mysql         147 May  6 13:05 useractivation.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  6 13:41 useractivation.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 04:06 userban.frm
        -rw-rw----    1 mysql    mysql          56 Apr  5 04:06 userban.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:31 userban.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 userfield.frm
        -rw-rw----    1 mysql    mysql        330k May  6 12:01 userfield.MYD
        -rw-rw----    1 mysql    mysql         53k May  6 12:30 userfield.MYI
        -rw-rw----    1 mysql    mysql        9.9k Apr  5 04:47 user.frm
        -rw-rw----    1 mysql    mysql        9.5k Apr  5 04:06 usergroup.frm
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:06 usergroupleader.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 usergroupleader.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 usergroupleader.MYI
        -rw-rw----    1 mysql    mysql        9.8k Apr 17 00:32 usergroup.MYD
        -rw-rw----    1 mysql    mysql        3.0k May  1 13:31 usergroup.MYI
        -rw-rw----    1 mysql    mysql        8.5k Apr  5 04:06 usergrouprequest.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 usergrouprequest.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 usergrouprequest.MYI
        -rw-rw----    1 mysql    mysql        825k May  7 00:10 user.MYD
        -rw-rw----    1 mysql    mysql        139k May  7 00:02 user.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 04:06 usernote.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 usernote.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 usernote.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 04:06 userpromotion.frm
        -rw-rw----    1 mysql    mysql           0 Apr  5 04:06 userpromotion.MYD
        -rw-rw----    1 mysql    mysql        1.0k May  1 13:31 userpromotion.MYI
        -rw-rw----    1 mysql    mysql        8.6k Apr  5 04:06 usertextfield.frm
        -rw-rw----    1 mysql    mysql        366k May  6 23:49 usertextfield.MYD
        -rw-rw----    1 mysql    mysql         53k May  6 23:49 usertextfield.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:06 usertitle.frm
        -rw-rw----    1 mysql    mysql        2.2k Apr  5 04:06 usertitle.MYD
        -rw-rw----    1 mysql    mysql        2.0k May  1 13:31 usertitle.MYI
        -rw-rw----    1 mysql    mysql        8.4k Apr  5 04:06 word.frm
        -rw-rw----    1 mysql    mysql         28M May  6 23:22 word.MYD
        -rw-rw----    1 mysql    mysql         11M May  6 23:22 word.MYI
        which shows first the file permission and then the user and group being mysql
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment

        • Rob461
          New Member
          • Jul 2003
          • 6

          #5
          I do hate to be a bother, but this kinda stuff I know almost nothing about..could you eplain a little bit better? Or can anyone here help me personaly?

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...