Page 1 of 1

Database more than 10Mb Problem

Posted: Mon Oct 31, 2011 1:38 am
by SVN
Hi,

I backuped my DB with the backup option standard in OC 1.4.9.6. Now I started a new clean shop and would like to import this DB, but I get an error that the DB is to big and that it has to be max 10Mb. What can I do ???

Already tried to import with the MySql console, but also there I get error that is't to big !

Thx for the replies !!

Re: Database more than 10Mb Problem

Posted: Mon Oct 31, 2011 1:58 am
by cashman9
use NaviCat for MySql software to do importing of large databases.

Re: Database more than 10Mb Problem

Posted: Mon Oct 31, 2011 2:04 am
by SVN
cashman9 wrote:use NaviCat for MySql software to do importing of large databases.
Already tried, get error
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to you MySQL server version for the right syntax to use near i>>?TRUNCAT TABLE 'address' at line 1

Re: Database more than 10Mb Problem

Posted: Mon Oct 31, 2011 2:45 am
by SVN
Error log

Re: Database more than 10Mb Problem

Posted: Mon Oct 31, 2011 5:32 am
by webpie it.
I had thisproblem. Best to ask your host to do this, they did it for me in this situation.

Re: Database more than 10Mb Problem

Posted: Tue Nov 01, 2011 10:21 pm
by uksitebuilder
TRUNCAT should be TRUNCATE

Re: Database more than 10Mb Problem

Posted: Tue Nov 01, 2011 10:34 pm
by SVN
uksitebuilder wrote:TRUNCAT should be TRUNCATE
Owkay, sometimes it's in the smallest things :-)

Thank you !!!