Gente... Estou com um problema aqui...
Quero saber se o CakePHP tem algum pulo do gato pra fazer uma carga de um arquivo .sql (que é bem grande e demorado, portanto não dá pra subir via import do phpmyadmin pq dá erro).
Já tentei tb fazer a carga via prompt do mysql (Executei source C:\Users\Priscila\escritorio\banco_de_dados.sql) porém disparou alguns erros nessa execução :
mysql> source C:\Users\Priscila\escritorio\banco_de_dados.sql
Query OK, 0 rows affected (0.08 sec)
Query OK, 101 rows affected (0.02 sec)
Records: 101 Duplicates: 0 Warnings: 0
ERROR 1067 (42000): Invalid default value for 'dt_hr_inicio'
Query OK, 0 rows affected (0.05 sec)
Query OK, 9 rows affected (0.01 sec)
Records: 9 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.04 sec)
Query OK, 43 rows affected, 22 warnings (0.01 sec)
Records: 43 Duplicates: 0 Warnings: 22
Query OK, 0 rows affected (0.21 sec)
ERROR 1366 (HY000): Incorrect string value: '\xC3\xA7\xC3\xA3o' for column 'ds_atividade' at row 1
ERROR 1067 (42000): Invalid default value for 'data_ativ'
ERROR 1146 (42S02): Table 'escritorio.atividade_report' doesn't exist
Query OK, 0 rows affected (0.04 sec)
Query OK, 148 rows affected (0.01 sec)
Records: 148 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.05 sec)
ERROR 1366 (HY000): Incorrect string value: '\xC3\xA9 uma...' for column 'ds_aviso' at row 1
ERROR 1067 (42000): Invalid default value for 'data_cadastro'
ERROR 1146 (42S02): Table 'escritorio.banco_de_horas' doesn't exist
Query OK, 0 rows affected (0.10 sec)
Query OK, 1009 rows affected (0.04 sec)
Records: 1009 Duplicates: 0 Warnings: 0
Query OK, 0 rows affected (0.32 sec)
ERROR 1366 (HY000): Incorrect string value: '\xC3\xA7\xC3\xA3o' for column 'vencimento' at row 5
Query OK, 0 rows affected (0.03 sec)
Query OK, 17 rows affected (0.01 sec)
Records: 17 Duplicates: 0 Warnings: 0
ERROR 1067 (42000): Invalid default value for 'data_solic'
ERROR 1146 (42S02): Table 'escritorio.bonus_status' doesn't exist
Query OK, 0 rows affected (0.21 sec)
ERROR 1366 (HY000): Incorrect string value: '\xC3\xAAncia' for column 'descricao' at row 2
Query OK, 0 rows affected (0.03 sec)
ERROR 1366 (HY000): Incorrect string value: '\xC3\xA3o Pa...' for column 'no_cidade' at row 1
Query OK, 0 rows affected (0.04 sec)
Query OK, 7053 rows affected, 703 warnings (1.18 sec)
Records: 7053 Duplicates: 0 Warnings: 703
ERROR 1067 (42000): Invalid default value for 'dt_contato'
ERROR 1146 (42S02): Table 'escritorio.cliente_contato' doesn't exist
ERROR 1067 (42000): Invalid default value for 'dt_efetuado'
ERROR 1146 (42S02): Table 'escritorio.comissao' doesn't exist
Query OK, 0 rows affected (0.08 sec)
Query OK, 0 rows affected (0.16 sec)
Query OK, 106 rows affected (0.01 sec)
Records: 106 Duplicates: 0 Warnings: 0