- Desde
- 30 Nov 2008
- Mensajes
- 29
Hola, me he cambiado de host y tengo los back ups de la base de datos lista para subirla al nuevo host,
stoi usando el bigdump y desde el cpanel del host
el problema pngo la base de datos a subir y me sale en el bigdump:
Error at the line 232: (1001, 74, 0);
Query: --
--
INSERT INTO `access` (`userid`, `forumid`, `accessmask`) VALUES
(4, 64, 1),
(4, 44, 1),
(4, 43, 1),
(4, 45, 1),
(4, 25, 1),
(4, 17, 1),
(4, 16, 1),
(4, 15, 1),
(4, 6, 1),
(4, 59, 1),
(4, 63, 1),
(4, 62, 1),
(4, 61, 1),
(4, 58, 1),
(4, 36, 1),
(4, 35, 1),
(4, 9, 1),
(4, 57, 1),
(4, 56, 1),
(4, 55, 1),
(4, 54, 1),
(4, 19, 1),
(4, 18, 1),
(4, 8, 1),
(4, 34, 1),
(4, 24, 1),
(4, 23, 1),
(4, 7, 1),
(4, 42, 1),
(4, 41, 1),
(4, 40, 1),
(4, 39, 1),
(4, 21, 1),
(4, 22, 1),
(4, 20, 1),
(4, 11, 1),
(4, 69, 1),
(4, 68, 1),
(4, 67, 1),
(4, 66, 1),
(4, 53, 1),
(4, 52, 1),
(4, 51, 1),
(4, 50, 1),
(4, 10, 1),
(4, 4, 1),
(4, 38, 1),
(4, 31, 1),
(4, 30, 1),
(4, 29, 1),
(4, 28, 1),
(4, 14, 1),
(4, 3, 1),
(4, 65, 1),
(4, 48, 1),
(4, 47, 1),
(4, 46, 1),
(4, 37, 1),
(4, 27, 1),
(4, 13, 1),
(4, 2, 1),
(4, 1, 1),
(4, 12, 1),
(4, 49, 1),
(4, 33, 1),
(4, 32, 1),
(4, 5, 1),
(1001, 5, 0),
(1001, 32, 0),
(1001, 105, 0),
(1001, 71, 0),
(1001, 72, 0),
(1001, 33, 0),
(1001, 49, 0),
(1001, 70, 0),
(1001, 109, 0),
(1001, 12, 0),
(1001, 110, 0),
(1001, 111, 0),
(1001, 112, 0),
(1001, 113, 0),
(1001, 1, 0),
(1001, 2, 0),
(1001, 13, 0),
(1001, 27, 0),
(1001, 142, 0),
(1001, 143, 0),
(1001, 37, 0),
(1001, 46, 0),
(1001, 47, 0),
(1001, 48, 0),
(1001, 65, 0),
(1001, 75, 0),
(1001, 83, 0),
(1001, 84, 0),
(1001, 130, 0),
(1001, 93, 0),
(1001, 94, 0),
(1001, 88, 0),
(1001, 89, 0),
(1001, 90, 0),
(1001, 91, 0),
(1001, 92, 0),
(1001, 3, 0),
(1001, 14, 0),
(1001, 28, 0),
(1001, 29, 0),
(1001, 30, 0),
(1001, 31, 0),
(1001, 38, 0),
(1001, 144, 0),
(1001, 145, 0),
(1001, 66, 0),
(1001, 67, 0),
(1001, 68, 0),
(1001, 69, 0),
(1001, 98, 0),
(1001, 87, 0),
(1001, 106, 0),
(1001, 4, 0),
(1001, 76, 0),
(1001, 107, 0),
(1001, 108, 0),
(1001, 51, 0),
(1001, 52, 0),
(1001, 53, 0),
(1001, 141, 0),
(1001, 10, 0),
(1001, 50, 0),
(1001, 11, 0),
(1001, 20, 0),
(1001, 22, 0),
(1001, 21, 0),
(1001, 39, 0),
(1001, 40, 0),
(1001, 41, 0),
(1001, 42, 0),
(1001, 7, 0),
(1001, 23, 0),
(1001, 24, 0),
(1001, 34, 0),
(1001, 8, 0),
(1001, 18, 0),
(1001, 19, 0),
(1001, 54, 0),
(1001, 55, 0),
(1001, 56, 0),
(1001, 57, 0),
(1001, 114, 0),
(1001, 115, 0),
(1001, 117, 0),
(1001, 119, 0),
(1001, 124, 0),
(1001, 125, 0),
(1001, 120, 0),
(1001, 116, 0),
(1001, 118, 0),
(1001, 126, 0),
(1001, 123, 0),
(1001, 121, 0),
(1001, 122, 0),
(1001, 9, 0),
(1001, 35, 0),
(1001, 36, 0),
(1001, 58, 0),
(1001, 61, 0),
(1001, 62, 0),
(1001, 63, 0),
(1001, 59, 0),
(1001, 127, 0),
(1001, 128, 0),
(1001, 129, 0),
(1001, 6, 0),
(1001, 15, 0),
(1001, 16, 0),
(1001, 17, 0),
(1001, 25, 0),
(1001, 45, 0),
(1001, 77, 0),
(1001, 43, 0),
(1001, 131, 0),
(1001, 44, 0),
(1001, 64, 0),
(1001, 132, 0),
(1001, 85, 0),
(1001, 134, 0),
(1001, 140, 0),
(1001, 136, 0),
(1001, 137, 0),
(1001, 138, 0),
(1001, 139, 0),
(1001, 73, 0),
(1001, 74, 0);
MySQL: Duplicate entry '4-64' for key 1
Yo de esto no entiendo nada XD, alguien sabe por que me sale eso?
Saludos y gracias de antemano
EDITO:
Solo tuve que borrar la tabla acess de la base de datos ya subida y me cambio de error aora me sale esto:
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.
Edito 2:
Al hacer la copia de la base solo habia que quitar la opcion de extended inserts y se arreglo
Ahora ya e podido subir la base e instalar el vbulletin pero como no tengo mas problemas
no puedo entrar con mi usuario administrador ni ver los temas
Saludos(stoi resubiendo los archivos del vb)
stoi usando el bigdump y desde el cpanel del host
el problema pngo la base de datos a subir y me sale en el bigdump:
Error at the line 232: (1001, 74, 0);
Query: --
--
INSERT INTO `access` (`userid`, `forumid`, `accessmask`) VALUES
(4, 64, 1),
(4, 44, 1),
(4, 43, 1),
(4, 45, 1),
(4, 25, 1),
(4, 17, 1),
(4, 16, 1),
(4, 15, 1),
(4, 6, 1),
(4, 59, 1),
(4, 63, 1),
(4, 62, 1),
(4, 61, 1),
(4, 58, 1),
(4, 36, 1),
(4, 35, 1),
(4, 9, 1),
(4, 57, 1),
(4, 56, 1),
(4, 55, 1),
(4, 54, 1),
(4, 19, 1),
(4, 18, 1),
(4, 8, 1),
(4, 34, 1),
(4, 24, 1),
(4, 23, 1),
(4, 7, 1),
(4, 42, 1),
(4, 41, 1),
(4, 40, 1),
(4, 39, 1),
(4, 21, 1),
(4, 22, 1),
(4, 20, 1),
(4, 11, 1),
(4, 69, 1),
(4, 68, 1),
(4, 67, 1),
(4, 66, 1),
(4, 53, 1),
(4, 52, 1),
(4, 51, 1),
(4, 50, 1),
(4, 10, 1),
(4, 4, 1),
(4, 38, 1),
(4, 31, 1),
(4, 30, 1),
(4, 29, 1),
(4, 28, 1),
(4, 14, 1),
(4, 3, 1),
(4, 65, 1),
(4, 48, 1),
(4, 47, 1),
(4, 46, 1),
(4, 37, 1),
(4, 27, 1),
(4, 13, 1),
(4, 2, 1),
(4, 1, 1),
(4, 12, 1),
(4, 49, 1),
(4, 33, 1),
(4, 32, 1),
(4, 5, 1),
(1001, 5, 0),
(1001, 32, 0),
(1001, 105, 0),
(1001, 71, 0),
(1001, 72, 0),
(1001, 33, 0),
(1001, 49, 0),
(1001, 70, 0),
(1001, 109, 0),
(1001, 12, 0),
(1001, 110, 0),
(1001, 111, 0),
(1001, 112, 0),
(1001, 113, 0),
(1001, 1, 0),
(1001, 2, 0),
(1001, 13, 0),
(1001, 27, 0),
(1001, 142, 0),
(1001, 143, 0),
(1001, 37, 0),
(1001, 46, 0),
(1001, 47, 0),
(1001, 48, 0),
(1001, 65, 0),
(1001, 75, 0),
(1001, 83, 0),
(1001, 84, 0),
(1001, 130, 0),
(1001, 93, 0),
(1001, 94, 0),
(1001, 88, 0),
(1001, 89, 0),
(1001, 90, 0),
(1001, 91, 0),
(1001, 92, 0),
(1001, 3, 0),
(1001, 14, 0),
(1001, 28, 0),
(1001, 29, 0),
(1001, 30, 0),
(1001, 31, 0),
(1001, 38, 0),
(1001, 144, 0),
(1001, 145, 0),
(1001, 66, 0),
(1001, 67, 0),
(1001, 68, 0),
(1001, 69, 0),
(1001, 98, 0),
(1001, 87, 0),
(1001, 106, 0),
(1001, 4, 0),
(1001, 76, 0),
(1001, 107, 0),
(1001, 108, 0),
(1001, 51, 0),
(1001, 52, 0),
(1001, 53, 0),
(1001, 141, 0),
(1001, 10, 0),
(1001, 50, 0),
(1001, 11, 0),
(1001, 20, 0),
(1001, 22, 0),
(1001, 21, 0),
(1001, 39, 0),
(1001, 40, 0),
(1001, 41, 0),
(1001, 42, 0),
(1001, 7, 0),
(1001, 23, 0),
(1001, 24, 0),
(1001, 34, 0),
(1001, 8, 0),
(1001, 18, 0),
(1001, 19, 0),
(1001, 54, 0),
(1001, 55, 0),
(1001, 56, 0),
(1001, 57, 0),
(1001, 114, 0),
(1001, 115, 0),
(1001, 117, 0),
(1001, 119, 0),
(1001, 124, 0),
(1001, 125, 0),
(1001, 120, 0),
(1001, 116, 0),
(1001, 118, 0),
(1001, 126, 0),
(1001, 123, 0),
(1001, 121, 0),
(1001, 122, 0),
(1001, 9, 0),
(1001, 35, 0),
(1001, 36, 0),
(1001, 58, 0),
(1001, 61, 0),
(1001, 62, 0),
(1001, 63, 0),
(1001, 59, 0),
(1001, 127, 0),
(1001, 128, 0),
(1001, 129, 0),
(1001, 6, 0),
(1001, 15, 0),
(1001, 16, 0),
(1001, 17, 0),
(1001, 25, 0),
(1001, 45, 0),
(1001, 77, 0),
(1001, 43, 0),
(1001, 131, 0),
(1001, 44, 0),
(1001, 64, 0),
(1001, 132, 0),
(1001, 85, 0),
(1001, 134, 0),
(1001, 140, 0),
(1001, 136, 0),
(1001, 137, 0),
(1001, 138, 0),
(1001, 139, 0),
(1001, 73, 0),
(1001, 74, 0);
MySQL: Duplicate entry '4-64' for key 1
Yo de esto no entiendo nada XD, alguien sabe por que me sale eso?
Saludos y gracias de antemano
EDITO:
Solo tuve que borrar la tabla acess de la base de datos ya subida y me cambio de error aora me sale esto:
At this place the current query includes more than 300 dump lines. That can happen if your dump file was created by some tool which doesn't place a semicolon followed by a linebreak at the end of each query, or if your dump contains extended inserts. Please read the BigDump FAQs for more infos.
Edito 2:
Al hacer la copia de la base solo habia que quitar la opcion de extended inserts y se arreglo
Ahora ya e podido subir la base e instalar el vbulletin pero como no tengo mas problemas
no puedo entrar con mi usuario administrador ni ver los temas
Saludos(stoi resubiendo los archivos del vb)