Error base de datos

olympus Seguir

Alfa
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
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)
 
Arriba