No announcement yet.

Backing up database via ssh

  • Filter
  • Time
  • Show
Clear All
new posts

  • Backing up database via ssh

    Yesterday I upgraded and the forums are working OK. But, I have to change servers. I tried the usual:
    SHIRLEY% mysqldump --opt -c -p -q -v forum > usr/local/etc/httpd/forum_bup-06-21.sq

    Enter password:

    # Connecting to localhost...

    /usr/local/mysql/bin/mysqldump: Got error: 1017: Can't find file: './forum/userpromotion.frm' (errno: 24) when using LOCK TABLES

    Anyone have any idea what './forum/userpromotion.frm' is and what's happening? I can see the file if I ftp in so I know it's there.
    Last edited by Marc Smith; Sat 21 Jun '03, 6:21am.

  • #2
    Error code 24: Too many open files

    This is a server issue. Contact your host.
    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.


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