Announcement

Collapse
No announcement yet.

Unable to do backup

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

  • Unable to do backup

    I have attempted to do a backup from the telnet prompt as recommended in the manual.

    mysqldump --opt -uusername -p forums > /usr/home/username/usr/local/etc/httpd/htdocs/cherub/backups/100502.sql

    but I get this error

    /usr/local/mysql/bin/mysqldump: Got error: 1105: File '/usr/local/mysql-3.23.52/
    var/forums/threadrate.MYD' not found (Errcode: 24) when using LOCK TABLES

    Is my syntax wrong? Do I need to put my board in maintenance mode before I attempt this?

    Christine

  • #2
    try using

    Code:
    /usr/local/mysql/bin/mysqldump --opt -u mysqlusername -p forums > /usr/home/username/usr/local/etc/httpd/htdocs/cherub/backups/100502.sql
    see what happens...

    error 24 is too many files open, so i believ it's you mysql configuration

    are you dedicated or shared hosted ? also what version of mysql are you using ?
    :: 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


    • #3
      I am on a virtual hosting machine, but I am currently the only customer on the box not that that matters. I am using mysql 3.23.52.

      I tried the new syntax to no avail,k but I think I might have the path to mysqldump wrong, being on a virt server make things in places be weird.

      So what should I change in my config file so I can run the normal command?

      Thanks
      Chris

      Comment


      • #4
        Don't change anything in config.php.

        What is the latest error you are getting?
        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


        • #5
          Hi Steve,

          I didn't mean the config.php, I meant what should I change in the my.cnf file so I am not getting the Lock Tables error.
          Here is the error I am getting

          % /usr/home/username/usr/local/mysql/bin/mysqldump --opt -u mysqlroot -p forums > /usr/home/username/usr/local
          /etc/httpd/htdocs/cherub/backups/100502.sql
          /usr/libexec/ld-elf.so.1: Shared object "libmysqlclient.so.10" not found

          Comment


          • #6
            did you recently upgrade php or 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


            • #7
              This is the thread where all my server config is listed.

              http://www.vbulletin.com/forum/showt...threadid=55291

              Comment


              • #8
                can you submit a support ticket at http://vbulletin.com/members/support.php with your ssh/telnet login details, root and mysql root passwords as well so i can check this out..
                :: 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


                • #9
                  I submitted a support request.

                  Chris

                  Comment

                  Loading...
                  Working...
                  X