Post by axelbcn » Sat Nov 26, 2016 3:23 am

Hi,

After do a Restore a have this message:

Warning: The file you uploaded was empty!

1- I Backup in Admin panel- System, on my old working opencart store 1.5.6.4

2- I have another different domine and I installed a clean opencart 1.5.6.4 version new

3- In my new opencart Admin of new clean website I Restored the SQL file from my old store opencart

4- The store didn't change at all and the message in admin system is Warning: The file you uploaded was empty!


The file is 31,7mb from the other opencart.


Someone know the problem???

Newbie

Posts

Joined
Sat Oct 22, 2016 7:14 pm

Post by IP_CAM » Sat Nov 26, 2016 8:02 am

did you use the same DB prefix, i.E. oc_, in both Databases?
And did you really fully install the other Shop, including it's DB, the regular way ?
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by axelbcn » Sat Nov 26, 2016 6:03 pm

I backup and after restore all this list:

oc_address
oc_affiliate
oc_affiliate_transaction
oc_attribute
oc_attribute_description
oc_attribute_group
oc_attribute_group_description
oc_banner
oc_banner_image
oc_banner_image_description
oc_category
oc_category_description
oc_category_filter
oc_category_path
oc_category_to_layout
oc_category_to_store
oc_country
oc_coupon
oc_coupon_category
oc_coupon_history
oc_coupon_product
oc_currency
oc_custom_field
oc_custom_field_description
oc_custom_field_to_customer_group
oc_custom_field_value
oc_custom_field_value_description
oc_customer
oc_customer_ban_ip
oc_customer_field
oc_customer_group
oc_customer_group_description
oc_customer_history
oc_customer_ip
oc_customer_online
oc_customer_reward
oc_customer_transaction
oc_download
oc_download_description
oc_ebay_category
...
etc

And did you really fully install the other Shop, including it's DB, the regular way ?

Mmmm I ftp opencart to new server and installed it, I create a new Database in new server domine.

Now I have default opencart store clean but any change have been made after restore backup file from old store.
I really need the categories and products from old store to the new one.

Thanks

Newbie

Posts

Joined
Sat Oct 22, 2016 7:14 pm

Post by axelbcn » Sat Nov 26, 2016 6:10 pm

Could the problem be that the name of the database in old and new server are not the same?

Seen what is writen in old admin store:

php.ini path: /opt/cpanel/ea-php56/root/etc/php.ini

the database in old store is cpanel and in new store is Databaseopencart.

Should I rename database "cpanel" in new store domine server?

Newbie

Posts

Joined
Sat Oct 22, 2016 7:14 pm

Post by axelbcn » Tue Nov 29, 2016 5:42 pm

any idea?

Newbie

Posts

Joined
Sat Oct 22, 2016 7:14 pm

Post by IP_CAM » Wed Nov 30, 2016 1:03 am

The file you uploaded was empty!
Check your both PHP.INI files in your Opencart software, if you tried to restore the DB by Use of the OpenCart Admin Function:
memory_limit = 64M;
and enlarge it to:
memory_limit = 256M;
and try to restore it again.
---
But, to make sure, you should upload/restore your local Backup by use of the Server MyPhp Admin tool.
---
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by terence81 » Wed May 24, 2017 2:44 pm

Hello,

I have this problem you mentionned.
As you indicated:
The file you uploaded was empty!
Check your both PHP.INI files in your Opencart software, if you tried to restore the DB by Use of the OpenCart Admin Function:
memory_limit = 64M;
and enlarge it to:
memory_limit = 256M;
and try to restore it again.

I changed both ini files (in root and admin), but I got the same error : the file you uploaded was empty!

I made an backup from OC, but now I can not restore it. Who can help please?

Thanks in advance
Terence

Newbie

Posts

Joined
Wed May 24, 2017 2:04 pm

Post by IP_CAM » Thu May 25, 2017 1:02 am

well, the problem is, that OC Default Routines ONLY back up the CONTENT
of the Database Tables, but not the Tables themselfs, so, one has to INSTALL
OC Software on another Server first, the regular way, then, TABLES will exist,
and one could RESTORE a downloaded Backup Copy again, at least, if the
same DB-ACCESS Values are used in the new setup, as they have been in the old one.

Technically at least, and if no Extensions existed in the old Shop, possibly adding
their own Content to a DB, because a new DB would not have such Tables, or Table Sections,
ready to accept/store such Data.

To make sure,one always should use the Server Sited MyPHP Admin Tools, to FULLY BACK UP
a Database, if such Data is used to make another Shop Site to work.
Good Luck ;)
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by terence81 » Thu May 25, 2017 6:18 am

Hello,

Thank you very much for your answer.

2 years ago, I bought Journal template, what was working well, but I downloaded the last version. So I made an backup file from OC before installing the Journal update. Since that I have a problem, because all settings were lost, idem my blog. In that sql file, I can see the articles of my blog, but can not restore the site of this problem.

Luckely, all my procucts, customers, orders are still working. I had to unclick the Journal template.

But, is it possible to restore the OC backup file from phpadmin?

Is there somebody who can help me with this, even I will pay for it.

Thanks
Terence

Newbie

Posts

Joined
Wed May 24, 2017 2:04 pm

Post by IP_CAM » Thu May 25, 2017 10:50 am

But, is it possible to restore the OC backup file from phpadmin?

Well, that should be no problem, but it depends on the MyPHP Tool,
installed on your Server. So, you better contact your hoster, or search in Google,
if you have any specific questions, in order to restore the ENTIRE DB, including Tables
and everything.

And don't ever allow anyone Access to your Server, operating his Business on an anonymous
eMail, and/or a hidden Server Registration, just to warn you, in Case, you'll get contacted !

Good Luck ! ;)
Ernie

My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.


User avatar
Legendary Member

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland
Who is online

Users browsing this forum: No registered users and 185 guests