Post by oc5 » Fri Jan 14, 2011 6:46 pm

Hi, i having a problem restoring my Database in PHPmyAdmin, i got this error when reaches 90% of uploading my backup.sql
"Error
SQL query:

TRUNCATE TABLE `address` ;


MySQL said:

#1146 - Table 'nakalici_ocar642.address' doesn't exist"

can anyone help me please, i don't know what to do & how to overcome this problem :/
Thanks

oc5
New member

Posts

Joined
Fri Jan 07, 2011 7:50 pm

Post by oc5 » Sat Jan 15, 2011 12:20 am

any help please, will be very much appreciated :) thanks in advance :)

oc5
New member

Posts

Joined
Fri Jan 07, 2011 7:50 pm

Post by i2Paq » Sat Jan 15, 2011 3:21 am

Can you still access the original database?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by oc5 » Sat Jan 15, 2011 1:15 pm

yes, i still can access my store & adminstration panel, i use the backup option inside the admin. i'm able to backup success, but when restore till90%, error.

oc5
New member

Posts

Joined
Fri Jan 07, 2011 7:50 pm

Post by i2Paq » Sat Jan 15, 2011 10:27 pm

Try making a backup with phpMyAdmin instead.

You can also use phpMyAdmin to restore the backup.

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by oc5 » Mon Jan 17, 2011 1:19 am

Ok, i will try with the phpadmin then. worst come, i've to re do all again. :P :) thanks for your help i2Paq :) very much appreciate :D

oc5
New member

Posts

Joined
Fri Jan 07, 2011 7:50 pm

Post by KipFX » Thu Jun 23, 2011 4:26 am

Arrgghhh! I have done the same thing, I was pulling the mySQL to figure out the product fields to do a mass upload, and dropped it!

Getting:

Code: Select all

TRUNCATE TABLE  `address` ;


MySQL said: 

#1146 - Table '####_#######.address' doesn't exist 
Any way of resolving this, as due to the fact I am a :crazy: idiot and removed the php completely I cannot get into backup (obviously)!

Thanks to any wizards in advance!

Newbie

Posts

Joined
Thu Jun 23, 2011 4:22 am

Post by KipFX » Fri Jun 24, 2011 1:02 am

Solved! Won't be doing that again in a hurry! ;)

Newbie

Posts

Joined
Thu Jun 23, 2011 4:22 am

Post by infraredstudios » Tue Aug 12, 2014 8:56 pm

hi KipFX,

i realise this is an old post but i'm having the same problem. Can you recall how you solved it?

Would be much appreciated…


Posts

Joined
Tue Aug 12, 2014 8:54 pm

Post by tcustomgolf » Mon Jan 05, 2015 1:23 am

Hey, I'm in the same boat. Did a backup from my admin but go to restore and get that message also. The sql file from the opencart backup looks good, but only shows the table name as 'address'. Does it need any pre wording?

Newbie

Posts

Joined
Wed Apr 18, 2012 10:28 pm

Post by ian84 » Mon Jun 22, 2015 10:02 pm

Know its a old thread...


I Just had the problem, the sql file was backup by opencart backend. i am running open cart V1.5.1.3

I am unable to acess the Database anymore... due to a mistake and over writing the database...

All i have is a 17MB Backup.sql file

Error
SQL query:

TRUNCATE TABLE `address` ;


MySQL said: Documentation

#1146 - Table 'hobbyzon_opencart.address' doesn't exist

I am guessing the database is an older version due to a older version of OC...

Please note, i have tried to import within the Opencart back end also.... but all i get is the file sis empty Error. and does not import successfully. even when i do a clean install of OC V1.5.1.3

Newbie

Posts

Joined
Mon Jun 22, 2015 4:34 pm

Post by i2Paq » Mon Jun 22, 2015 10:25 pm

And your question is?

Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by ian84 » Mon Jun 22, 2015 10:30 pm

oh i forgot the question!! the QUESTION!!

How do i use import this DB.... how do i get it back into the system as to say.... make it use able again.

thanks for your reply.

Newbie

Posts

Joined
Mon Jun 22, 2015 4:34 pm

Post by ian84 » Mon Jun 22, 2015 11:05 pm

here is the DB if it can be useful to find out whats wrong and solution.

Cheers.

Attachments

OC export SQL Db


Newbie

Posts

Joined
Mon Jun 22, 2015 4:34 pm
Who is online

Users browsing this forum: No registered users and 9 guests