Backup

1. Backup

RUBIA RAMOS
donabuba

(usa Fedora)

Enviado em 19/07/2011 - 09:58h

Estou tentando fazer um backup do servidor dotProject atual para um novo.
Estou fazendo um tar.bz2 do /var/www/html/dotproject e os projetos foram importados. Mas como fazer o import do resto das informações, como tarefas, relatorios, etc? nada mais está sendo mostrado!


  


2. Re: Backup

RUBIA RAMOS
donabuba

(usa Fedora)

Enviado em 19/07/2011 - 10:50h

Um trecho do erro que é retornado:

/var/www/html/dotproject/includes/db_adodb.php(66): Error executing:

INSERT INTO `companies`(`company_id`,`company_module`,`company_name`,`company_phone1`,`company_phone2`,`company_fax`,`company_address1`,`company_address2`,`company_city`,`company_state`,`company_zip`,`company_primary_url`,`company_owner`,`company_description`,`company_type`,`company_email`,`company_custom`) values ('2','0','\'Lojas Maia\'','\'(83) 3214-9000\'','NULL','\'(83) 3214-9000\'','\'BR 230 KM 12',' estrada de cabedelo\'','NULL','\'Cabedelo\'','\'Paraíba\'','58031000','\'http://www.lojasmaia.com.br\'','1','NULL','6','NULL')
INSERT INTO `config`(`config_id`,`config_name`,`config_value`,`config_group`,`config_type`) values ('116','\'ldap_allow_login\'','\'true\'','\'ldap\'','\'checkbox\'')
INSERT INTO `config_list`(`config_list_id`,`config_id`,`config_list_name`) values ('7','98','\'smtp\'')
INSERT INTO `contacts`(`contact_id`,`contact_first_name`,`contact_last_name`,`contact_order_by`,`contact_title`,`contact_birthday`,`contact_job`,`contact_company`,`contact_department`,`contact_type`,`contact_email`,`contact_email2`,`contact_url`,`contact_phone`,`contact_phone2`,`contact_fax`,`contact_mobile`,`contact_address1`,`contact_address2`,`contact_city`,`contact_state`,`contact_zip`,`contact_country`,`contact_jabber`,`contact_icq`,`contact_msn`,`contact_yahoo`,`contact_aol`,`contact_notes`,`contact_project`,`contact_icon`,`contact_owner`,`contact_private`) values ('45','\'Tiago\'','\'França\'','NULL','NULL','NULL','NULL','2','4','NULL','\'tiagofranca@lojasmaia.com.br\'','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','0','\'obj/contact\'','37','0')



INSERT INTO `departments`(`dept_id`,`dept_parent`,`dept_company`,`dept_name`,`dept_phone`,`dept_fax`,`dept_address1`,`dept_address2`,`dept_city`,`dept_state`,`dept_zip`,`dept_url`,`dept_desc`,`dept_owner`) values ('16','4','2','\'Teste e Qualidade\'','3214','NULL','NULL','NULL','NULL','NULL','NULL','NULL','\'Setor responsável pelo teste e qualidade dos sistema\'','4')
INSERT INTO `dpversion`(`code_version`,`db_version`,`last_db_update`,`last_code_update`) values ('2','2','2008','2008')
INSERT INTO `event_queue`(`queue_id`,`queue_start`,`queue_type`,`queue_repeat_interval`,`queue_repeat_count`,`queue_data`,`queue_callback`,`queue_owner`,`queue_origin_id`,`queue_module`,`queue_module_type`) values ('82','0','NULL','0','1','\'a:28:{s:3:\"acc\"

(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `config`(`config_id`,`config_name`,`config_value`,`config_group`,`co' at line 2)

ERROR: /var/www/html/dotproject/includes/db_adodb.php(66): Error executing:

INSERT INTO `companies`(`company_id`,`company_module`,`company_name`,`company_phone1`,`company_phone2`,`company_fax`,`company_address1`,`company_address2`,`company_city`,`company_state`,`company_zip`,`company_primary_url`,`company_owner`,`company_description`,`company_type`,`company_email`,`company_custom`) values ('2','0','\'Lojas Maia\'','\'(83) 3214-9000\'','NULL','\'(83) 3214-9000\'','\'BR 230 KM 12',' estrada de cabedelo\'','NULL','\'Cabedelo\'','\'Paraíba\'','58031000','\'http://www.lojasmaia.com.br\'','1','NULL','6','NULL')
INSERT INTO `config`(`config_id`,`config_name`,`config_value`,`config_group`,`config_type`) values ('116','\'ldap_allow_login\'','\'true\'','\'ldap\'','\'checkbox\'')
INSERT INTO `config_list`(`config_list_id`,`config_id`,`config_list_name`) values ('7','98','\'smtp\'')
INSERT INTO `contacts`(`contact_id`,`contact_first_name`,`contact_last_name`,`contact_order_by`,`contact_title`,`contact_birthday`,`contact_job`,`contact_company`,`contact_department`,`contact_type`,`contact_email`,`contact_email2`,`contact_url`,`contact_phone`,`contact_phone2`,`contact_fax`,`contact_mobile`,`contact_address1`,`contact_address2`,`contact_city`,`contact_state`,`contact_zip`,`contact_country`,`contact_jabber`,`contact_icq`,`contact_msn`,`contact_yahoo`,`contact_aol`,`contact_notes`,`contact_project`,`contact_icon`,`contact_owner`,`contact_private`) values ('45','\'Tiago\'','\'França\'','NULL','NULL','NULL','NULL','2','4','NULL','\'tiagofranca@lojasmaia.com.br\'','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','0','\'obj/contact\'','37','0')



INSERT INTO `departments`(`dept_id`,`dept_parent`,`dept_company`,`dept_name`,`dept_phone`,`dept_fax`,`dept_address1`,`dept_address2`,`dept_city`,`dept_state`,`dept_zip`,`dept_url`,`dept_desc`,`dept_owner`) values ('16','4','2','\'Teste e Qualidade\'','3214','NULL','NULL','NULL','NULL','NULL','NULL','NULL','\'Setor responsável pelo teste e qualidade dos sistema\'','4')
INSERT INTO `dpversion`(`code_version`,`db_version`,`last_db_update`,`last_code_update`) values ('2','2','2008','2008')
INSERT INTO `event_queue`(`queue_id`,`queue_start`,`queue_type`,`queue_repeat_interval`,`queue_repeat_count`,`queue_data`,`queue_callback`,`queue_owner`,`queue_origin_id`,`queue_module`,`queue_module_type`) values ('82','0','NULL','0','1','\'a:28:{s:3:\"acc\"

(You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `config`(`config_id`,`config_name`,`config_value`,`config_group`,`co' at line 2)
Backtrace:
0 /var/www/html/dotproject/includes/db_adodb.php:66 dprint('/var/www/html/dotproject/includes/db_adodb.php',66,0,'Error executing:






Patrocínio

Site hospedado pelo provedor RedeHost.
Linux banner

Destaques

Artigos

Dicas

Tópicos

Top 10 do mês

Scripts