Announcement

Collapse
No announcement yet.

User table is DELETED !!

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • User table is DELETED !!

    I don't know what i do now !!

    the user table is deleted coz (( pressure at DB ))
    >> Can i retreave user table ?? or NO
    Good times are for friends to share

  • #2
    Ouch, ouch, ouch...have you backed up your database recently? If so, you would be best of restoring that.
    5 vBulletin licenses and counting!

    Comment


    • #3
      As Martin said the only way is to restore from a backup.
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        i have old DB in ( 27 DEC ) can i get only members table

        and thanx for all
        Good times are for friends to share

        Comment


        • #5
          sorry

          but the old DB not in SQL file , I saved DB DIR from telnet to my account
          Good times are for friends to share

          Comment


          • #6
            You could try it but since the tables are interdependent this may cause a lot of database problems. However at this point it doesn't appear you have much to lose.

            You would need to manually edit the backup file and extract just the user and userfield table queries, then run those queries in phpMyAdmin.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              i merge ( user table from DB backup ) in new DB but this table ( in use )

              can i repair it ??
              Good times are for friends to share

              Comment


              • #8
                Try this query:

                REPAIR TABLE user;

                Note that you need to restore the userfield table as well.
                Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                Change CKEditor Colors to Match Style (for 4.1.4 and above)

                Steve Machol Photography


                Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                Comment


                • #9
                  from phphMyAdmin:
                  >>>> Can't find file: './site_vb/user1.frm' (errno: 13)

                  from repair.php:
                  >>>> result
                  Checking table user1TableOperationTypeTextsite_vb.user1checkerrorCan't find file: './site_vb/user1.frm' (errno: 13)Repairing table user1site_vb.user1repairerrorCan't find file: './site_vb/user1.frm' (errno: 13)
                  Good times are for friends to share

                  Comment


                  • #10
                    Error code 13: Permission denied

                    Where is 'user1' coming from? That's not a valid name for any vB table.
                    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                    Change CKEditor Colors to Match Style (for 4.1.4 and above)

                    Steve Machol Photography


                    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                    Comment


                    • #11
                      it sounds like you've moved the file into the mysql data directory but not changed the owner / group of the file and permissions to the appropriate MySQL ones.
                      Scott MacVicar

                      My Blog | Twitter

                      Comment


                      • #12
                        yess it is right

                        -rw-rw---- 1 mysql mysql 8688 Nov 24 01:35 threadrate.frm
                        -rw-rw---- 1 mysql mysql 1456 Feb 21 07:36 threadrate.MYD
                        -rw-rw---- 1 mysql mysql 3072 Feb 21 08:11 threadrate.MYI
                        -rw-r----- 1 root root 10178 Feb 21 06:59 user1.frm
                        -rw-r----- 1 root root 5143152 Feb 21 07:00 user1.MYD
                        -rw-r----- 1 root root 1418240 Feb 21 07:00 user1.MYI
                        -rw-rw---- 1 mysql mysql 8702 Nov 24 01:35 useractivation.frm
                        -rw-rw---- 1 mysql mysql 484295 Feb 21 07:36 useractivation.MYD
                        -rw-rw---- 1 mysql mysql 258048 Feb 21 08:11 useractivation.MYI

                        bUT can i change ( user1 files ) chmod to -rw-rw---- ??

                        Good times are for friends to share

                        Comment


                        • #13
                          sorry
                          all table files in mysql but (user1 files in root )

                          must be chang to mysql also or no ?
                          Good times are for friends to share

                          Comment


                          • #14
                            now i will take user1 table 660 permition

                            -rw-rw---- 1 mysql mysql 8688 Nov 24 01:35 threadrate.frm
                            -rw-rw---- 1 mysql mysql 1456 Feb 21 07:36 threadrate.MYD
                            -rw-rw---- 1 mysql mysql 3072 Feb 21 08:11 threadrate.MYI
                            -rw-rw---- 1 root root 10178 Feb 21 06:59 user1.frm
                            -rw-rw---- 1 root root 5143152 Feb 21 07:00 user1.MYD
                            -rw-rw---- 1 root root 1418240 Feb 21 07:00 user1.MYI
                            -rw-rw---- 1 mysql mysql 8702 Nov 24 01:35 useractivation.frm
                            -rw-rw---- 1 mysql mysql 484295 Feb 21 07:36 useractivation.MYD
                            -rw-rw---- 1 mysql mysql 258048 Feb 21 08:11 useractivation.MYI


                            but the problem still until now !!
                            Good times are for friends to share

                            Comment


                            • #15
                              thanks for all ..

                              user1 is ok now

                              but i have at other table in post ( in use) ( Error 28 ) and i used 73% from DB space !!
                              Good times are for friends to share

                              Comment

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