Post by SVN » Mon Oct 31, 2011 1:38 am

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 !!

User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm

Post by cashman9 » Mon Oct 31, 2011 1:58 am

use NaviCat for MySql software to do importing of large databases.

Active Member

Posts

Joined
Wed Nov 17, 2010 4:28 am

Post by SVN » Mon Oct 31, 2011 2:04 am

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

User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm

Post by SVN » Mon Oct 31, 2011 2:45 am

Error log

Attachments


User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm

Post by webpie it. » Mon Oct 31, 2011 5:32 am

I had thisproblem. Best to ask your host to do this, they did it for me in this situation.

Regards

Chris


Active Member

Posts

Joined
Mon Jan 31, 2011 7:28 pm

Post by uksitebuilder » Tue Nov 01, 2011 10:21 pm

TRUNCAT should be TRUNCATE

User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by SVN » Tue Nov 01, 2011 10:34 pm

uksitebuilder wrote:TRUNCAT should be TRUNCATE
Owkay, sometimes it's in the smallest things :-)

Thank you !!!

User avatar
SVN
Active Member

Posts

Joined
Mon Jan 03, 2011 11:59 pm
Who is online

Users browsing this forum: No registered users and 99 guests