Convert bz2 ....?

lazykik

I have a sql backup that has been exported as a bz2 and apparently I can't import that file type with my webhost. So I opened it up and tried manually but the structure is different than a normal sql backup and wouldn't import. Is there anyway to convert the data back to a format I can use? Could be a version problem too, the exported was on 5 but mine is 4

MarkR

All you need to do is

bzcat mybackup.sql.bz2 | mysql (parameters for mysql)

If your web host doesn't give you shell access, dump them in favour of one who does.

MySQL dumps are not bz2 or gzip normally. MySQL just dumps the output in a plain file. Moreover, the clever way MySQL does it, going from 5 to 4 should work as well provided no MySQL5 specific features were used (but the application may not work if it was designed for v5).

You say "You tried manually"?

The only correct way of importing a mysql dump is putting it into the CLI mysql tool. Nothing else, including pasting, using phpmyadmin (which is a useless piece of junk), etc, will get it right, so don't bother.

Mark

lazykik

I dont know too much about mysql so trying to understand a little more

'INSERT INTO `eqdkp_auth_options` VALUES ( 1, 'a_event_add', 'N' ) , ( 2, 'a_event_upd', 'N' ) ,

Is is where the error starts. So Im assuming thats a version 5 specific feature? It looks completely different from the dumps i create in 4 using an insert into line for each record instead of ( ) ,

MarkR

What tool did you use to create the dump? I assume it was mysqldump?

If not, throw that dump away and take a new one with mysqldump. phpmyadmin is a useless piece of junk.

Apart from the initial quote, it looks fine.

Mark