Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Language specific forums Russian (Русский) Сервер баз данных
  • Search

Не работает Backup из за базы

Вопросы по работе Сервера баз данных
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Locked
  • Print view
Advanced search
3 posts • Page 1 of 1
Skorsa
Posts: 341
Joined: Thu Oct 17, 2013 1:31 pm

Не работает Backup из за базы

Post by Skorsa » Tue Mar 04, 2014 11:24 am

Вообщем, бэкап моего админ аккаунта уже второй день не получается из за одной базы admin_palk.

Но проблема в том что сайт нормально работает, ручной дамп базы тоже получается.

2014-03-04 01:48:01 mysql admin_palk
mysqldump: Got error: 145: Table './admin_palk/rft_postmeta' is marked as crashed and should be repaired when using LOCK TABLES
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Error: dump admin_palk failed
Top

vedavrat
Posts: 25
Joined: Thu Jun 11, 2015 3:02 pm
Contact:
Contact vedavrat
Website Facebook Google+

Os: Debian 8x
Web: apache + nginx
Re: Не работает Backup из за базы

Post by vedavrat » Thu Oct 01, 2015 1:22 pm

бэкап моего админ-аккаунта не получается

2014-03-04 01:48:01 mysql admin_palk
mysqldump: Got error: 145: Table './admin_palk/rft_postmeta' is marked as crashed and should be repaired when using LOCK TABLES
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Error: dump admin_palk failed
У меня последние 4 строки с ошибками такие же:

sudo /usr/local/vesta/bin/v-backup-user admin
-- SYSTEM --
-- WEB -- 2015-10-01 15:21:52 *** 1 domain ***
-- DNS -- 2015-10-01 15:21:52 *** 1 domain ***
-- MAIL -- 2015-10-01 15:21:52 *** 1 domain ***
-- DB -- 2015-10-01 15:21:52 *** 1 database ***
-- User Dir -- 2015-10-01 15:21:52 *** 1 user directory ***
-- SUMMARY --
2015-10-01 15:21:52 Local: /backup/prool.2015-10-01.tar ; Size: 1 Mb ; Runtime: 1 minute
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
job-working-directory: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
shell-init: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Не работает Backup из за базы

Post by skurudo » Wed Jun 08, 2016 12:23 pm

С переменными окружения все ок? Можете добавить, проверить?

Code: Select all

export VESTA=/usr/local/vesta/
Плюс нет ли чего-то вроде (не обязательно такие названия, к примеру не смогло сдампить базу):

Code: Select all

Can't dump database admin_torque
mysqldump: Got error: 145: Table './admin_torque/sq4587rjpbnd_icl_translate' is marked as crashed and should be repaired when using LOCK TABLES
Продолжить при желании можем в топике - viewtopic.php?f=42&t=11542#p44959
Top


Locked
  • Print view

3 posts • Page 1 of 1

Return to “Сервер баз данных”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password