پاسخ : آموزش تهیه پشتیبان از دیتابیس IBSng و باز گرداندن آن
موقع بک آپ که وقتی دستور رو مینویسم فقط با ۱ ثانیه تاخیر فقط میره خط بعد. یعنی هیچ اطلاعات و نوشته خاصی نمیاد. فایل ایجاد میشه تو postgre و وقتی هم ریستور میکنم فقط قسمت گروپ انگار درست هستش ولی تا دلت بخواد جلوی همه خط ها نوشته error.
---------- Post added at 11:34 AM ---------- Previous post was at 11:21 AM ----------
اینم از لاگ. تا جایی که نشونم داد کپی گرفتم.
setval
--------
7
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
3513
(1 row)
setval
--------
355
(1 row)
setval
--------
30
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
4
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
523
(1 row)
setval
--------
1
(1 row)
setval
--------
713
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
ERROR: insert or update on table "add_user_save_details" violates foreign key constraint "add_user_save_details_add_user_save_id_fkey"
DETAIL: Key (add_user_save_id)=(2) is not present in table "add_user_saves".
ERROR: insert or update on table "add_user_saves" violates foreign key constraint "add_user_saves_admin_id_fkey"
DETAIL: Key (admin_id)=(1) is not present in table "admins".
ERROR: duplicate key violates unique constraint "admin_deposit_change_pkey"
CONTEXT: COPY admin_deposit_change, line 1: "1 0 2 9999999999.00 2011-06-05 19:24:45.529509 109.162.224.83 9999999999"
ERROR: duplicate key violates unique constraint "admin_perms_pkey"
CONTEXT: COPY admin_perms, line 1: "0 GOD "
ERROR: duplicate key violates unique constraint "admins_pkey"
CONTEXT: COPY admins, line 5: "0 system $1$4AppbjNA$JCUbDbfizrC8o0.rYOIiW. -297.00 0.00 IBS Internal System Account 0"
ERROR: duplicate key violates unique constraint "charge_rule_day_of_weeks_pkey"
CONTEXT: COPY charge_rule_day_of_weeks, line 1: "1 0"
ERROR: duplicate key violates unique constraint "charge_rule_ports_pkey"
CONTEXT: COPY charge_rule_ports, line 1: "1 _ALL_"
ERROR: duplicate key violates unique constraint "charges_pkey"
CONTEXT: COPY charges, line 1: "1 *** Internet 0 t"
ERROR: duplicate key violates unique constraint "connection_log_pkey"
CONTEXT: COPY connection_log, line 1: "216 66 0.00 2011-06-06 04:19:13 2011-06-06 04:23:58 t 1 1"
ERROR: duplicate key violates unique constraint "connection_log_details_pkey"
CONTEXT: COPY connection_log_details, line 1: "216 username hd3m60"
invalid command \.
invalid command \.
invalid command \np0
invalid command \n.
invalid command \n.
invalid command \np0
invalid command \n.
invalid command \np0
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \nS'0.0.0.0'
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \n.
invalid command \nS'127.0.0.1'
invalid command \n.
invalid command \np0
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \N
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
invalid command \.
ERROR: syntax error at or near "2" at character 1
LINE 1: 2 0 1 1.00 1.00 2011-06-05 1646.308733 89.165.4.79
---------- Post added at 11:36 AM ---------- Previous post was at 11:34 AM ----------
همین کار رو میکنم. با FTP برش داشتم. الان هم تو root دارمش هم تو pgsql.
حجم فایلم بعد بک آپ با ۳۰۰ تا یوزر 1.3mb هستش !!
پاسخ با نقل قول