possible to set SQL_MODE="NO_AUTO_VALUE_ON_ZERO"

Hi!

I'm trying to restore an old backup of my magento online-shop but can't quite manage.

as far as i can see the problem is that magento stores some shop-ids with auto-increment-values of 0.

And when trying to import that, the id's aren't preserved. (see this thread

)

Is it possible to set SQL_MODE="NO_AUTO_VALUE_ON_ZERO" as standard?

Thanks in advance for ur help!

Oh, I should probably mention that I'm talking about the chaptertwobooks.org.uk-domain...

NetHosted Staff Joined: 22 Mar 2004 Posts: 7017

Hi,

You should insert:

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

into your dump file to set this.

Thanks,

Andrew

Posted: Tue Mar 16, 2010 4:54 pm Post subject:

thanks!

I know this. There is a problem, though: the file is quite big (7 MB, gzipped), so it's too big to use the normal phpMyAdmin-approach, because I get a timeout, before the import completes. (I've tried it.)

Instead - and because It's much more handy, anyway - I'm using a script called mysqldumper

to do the backup and restore. and there I cannot edit the dump-file before I do the restore.

NetHosted Staff Joined: 22 Mar 2004 Posts: 7017

In this case please upload the backup to your webspace and let us know which database you want it restored into. I will restore it for you.

Thanks,

Andrew

Posted: Tue Mar 16, 2010 6:35 pm Post subject:

Thanks! Problem solved: Everything else via PM

(although I'd still like to be able to restore backups myself, in the future ...)

NetHosted Staff Joined: 22 Mar 2004 Posts: 7017

Client Support	Community	Server Status	Contact Us	Client Login
Email Hosting	Website Hosting	Reseller Hosting	VPS Hosting	Dedicated Servers