Booyakan
10-15-2011, 10:29 PM
I am trying to import a database.sql file into another new database. (switching hosts)
I am receiving the error below. Can someone please help me out with what I need to change?
Error
SQL query:
INSERT INTO `filedata` (`filedataid`, `userid`, `dateline`, `thumbnail_dateline`, `filedata`, `filesize`, `filehash`, `thumbnail`, `thumbnail_filesize`, `extension`, `width`, `height`, `thumbnail_width`, `thumbnail_height`, `refcount`) VALUES (16, 21, 1302331460, 1302331460, 0x504b03041400020008007aab833ebd7c0b7d9e8b0000c4af 00000900000028313130292e6a7067 ec3a095453d7b6e7669e18420282205cc60818324120612680 c48268c401da6a4372814806cc2048 ad73f5b5b55a017d55eb8476b00eadbeaab5d55aadd6f6d5aa 38cf555bea545bad459fb69a7fee4d 0801b1ed7febf5fdf5d7e264dd9b7df6bcf739f79c9ddce33c e5bc08fc8714aa0b0142424011fc00 e725da8d82064315002525200100c000742400902184c00f40 fa032a01035089847ae0f1c840370f 09de24f81df0e16545a41e78f61c03a0b8f9df80d717f02a72 f789ef5cbda5124387d558ec165b8d a50e4d4d1203a9589caa94489452292a5128539295c962c80a c82b912e9f56923af522392bc91ef8 2270351a4276f3d2bcfd4782bafc47c2bdfd87b9e8d41147f2 e8a6ee74ebebe6b3b3b71cde041c22 9671aa12c8f123f0257a403f8d90380b66010e83c16032384c 2687cb66b1b9817e1c8e5f60308f17 c8e[...]
MySQL said:
#1064 - 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 '<br />
<b>Fatal error</b>: Out of memory (allocated 63963136) (tried to allocat' at line 2
I am receiving the error below. Can someone please help me out with what I need to change?
Error
SQL query:
INSERT INTO `filedata` (`filedataid`, `userid`, `dateline`, `thumbnail_dateline`, `filedata`, `filesize`, `filehash`, `thumbnail`, `thumbnail_filesize`, `extension`, `width`, `height`, `thumbnail_width`, `thumbnail_height`, `refcount`) VALUES (16, 21, 1302331460, 1302331460, 0x504b03041400020008007aab833ebd7c0b7d9e8b0000c4af 00000900000028313130292e6a7067 ec3a095453d7b6e7669e18420282205cc60818324120612680 c48268c401da6a4372814806cc2048 ad73f5b5b55a017d55eb8476b00eadbeaab5d55aadd6f6d5aa 38cf555bea545bad459fb69a7fee4d 0801b1ed7febf5fdf5d7e264dd9b7df6bcf739f79c9ddce33c e5bc08fc8714aa0b0142424011fc00 e725da8d82064315002525200100c000742400902184c00f40 fa032a01035089847ae0f1c840370f 09de24f81df0e16545a41e78f61c03a0b8f9df80d717f02a72 f789ef5cbda5124387d558ec165b8d a50e4d4d1203a9589caa94489452292a5128539295c962c80a c82b912e9f56923af522392bc91ef8 2270351a4276f3d2bcfd4782bafc47c2bdfd87b9e8d41147f2 e8a6ee74ebebe6b3b3b71cde041c22 9671aa12c8f123f0257a403f8d90380b66010e83c16032384c 2687cb66b1b9817e1c8e5f60308f17 c8e[...]
MySQL said:
#1064 - 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 '<br />
<b>Fatal error</b>: Out of memory (allocated 63963136) (tried to allocat' at line 2