Database Restore error

[kartik786]

Dear community,

My old hosting gave me a database backup dump split in 2 files. The total database is of the size 2.5 gb split in files of 1.5gb and 1 gb.

We concatenated the files with the command

cat db.tar.a db.tar.b >> db.tar

After unpacking the .sql file and importing it, we got the following error


ERROR at line 5804: Unknown command '\"'.

When checking in the tables phpmyadmin, the attachment tables which are the most important part of the site are missing.

Please guide as to how to go about solving this issue.

[SEOvB]

any chance you can just get one large DB backup from your host?

[kartik786]

NO, unfortunately the old host has said that they have sent the final database split in 2 files and thats about it

they have a http download limit of 2 gb and hence the 2 files split. I emailed them, but they replied negative.

[WEBDosser]

the missing tables.. are they in either of the two backup files and what did they split the file with?. or did they just select parts of the database for each file?..

--------------- Added [DATE]1212337097[/DATE] at [TIME]1212337097[/TIME] ---------------

maybe also try zcat.

[kartik786]

I am unable to see the missing tables because when restoring the database, I get the following error

ERROR at line 5804: Unknown command '\"'.

I am assuming that the attachment tables are missing because of this error.

did they just select parts of the database for each file?..

No, they dumped the whole database.

--------------- Added [DATE]1212337375[/DATE] at [TIME]1212337375[/TIME] ---------------

maybe also try zcat.

please elaborate.

[WEBDosser]

do a search google for zcat.. works like gzip & gunzip

options here..
http://www.esrl.noaa.gov/gmd/hats/in...xman/gzip.html

[kartik786]

Okay, since I am not tech savvy kiril_cvetkov has offered his services

I will update him about your suggestion.

[SEOvB]

Originally Posted by kartik786

NO, unfortunately the old host has said that they have sent the final database split in 2 files and thats about it

they have a http download limit of 2 gb and hence the 2 files split. I emailed them, but they replied negative.

That sucks, i can't beleive they wouldn't even let you use SSH to transfer a site/db that is so large.

You'll have to put the two files together using the method you already tried, then open up the .sql file that results go to line 5804 and see what it says.

[kiril_cvetkov]

the database is more then 2gb in 2 parts.. the attachment table is the main table (takes the most of the space).. i try to fix.. but it's a huge thing..
I can't help

[kartik786]

Okay, the database file size is huge.. any other suggestions that can solve the problem ?