Restoring a backup I have this error version 1.5.1.1

Error: Table 'address' already exists
Error No: 1050
-- phpMyAdmin SQL Dump -- version 2.8.0.1 -- http://www.phpmyadmin.net -- -- Host: custsql-ipg03.eigbox.net -- Generation Time: Sep 23, 2011 at 08:59 PM -- Server version: 5.0.91 -- PHP Version: 4.4.9 -- -- Database: `opencart_2010` -- -- -------------------------------------------------------- -- -- Table structure for table `address` -- CREATE TABLE `address` ( `address_id` int(11) NOT NULL auto_increment, `customer_id` int(11) NOT NULL, `firstname` varchar(32) collate utf8_bin NOT NULL default '', `lastname` varchar(32) collate utf8_bin NOT NULL default '', `company` varchar(32) collate utf8_bin NOT NULL, `address_1` varchar(128) collate utf8_bin NOT NULL, `address_2` varchar(128) collate utf8_bin NOT NULL, `city` varchar(128) collate utf8_bin NOT NULL, `postcode` varchar(10) collate utf8_bin NOT NULL, `country_id` int(11) NOT NULL default '0', `zone_id` int(11) NOT NULL default '0', PRIMARY KEY (`address_id`), KEY `customer_id` (`customer_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1


Im tryin gto do a restore becaue I have no images no logos, no product images I need help

When you did your backup, you should have chosen to Drop tables if they already exists.

You should now manually drop all your tables in the database (if you are sure your backup is sound)

I dont know how to manually drop tables and which one . I did the backup of all tables . In my opencart Isee all the information but theres no images no product images not logo not banners no images at all

The backup in OC only backs up your database, not the images. It is assumed you have these locally or can download them via ftp if you dont.

The backup code you posted above is a backup from PHPMyAdmin, so you must have done that via your hosting control panel, rather than via the OC admin panel.


When you did the backup, you should have selected the checkbox to 'Drop tables if they exist' this would have put the DROP sql queries in to your back file so that when run, the old tables are dropped and then recreated with the data from your backup.

To drop all tables in your database, log in to PHPMyAdmin

Click on your database name on the left.

You should now see all of your tables listed in the main area with a checkbox to the left of each one.

Scroll to the bottom, just below your last table name and there is a checkbox which when ticked/checked will tick/check all of the above checkboxes. Then to the right of that is a red 'X' - This will drop all the ticked/checked tables.

Once done you can then run/import your backup.sql file to restore the database.


The above assumes that you backed it up correctly in the first place of course.

How do I download the images via ftp. Or Do I need to I insert the images all over again one by one everything is going to be fine ? I did the back up like you said (add drop table) and now the file size is 869Kb before was 865 kb .

The option are :

Structure
Add DROP TABLE ( I check marked only this one . Is that ok? )
Add IF NOT EXISTS
Add AUTO_INCREMENT value
Enclose table and field names with backquotes
Add into comments:
Creation/Update/Check dates

That's fine for the backup

You should be able to just download the images via ftp (i.e. the whole image folder including subfolders and files.)

If I do that how to I put every image with the corresponding product ? or Can If I put every image one by one all over again do you think everything is going to be fine ?

Are you moving from one server to another ?

If not, there is no reason to restore the backup, you will just be replacing the same data

Yes I transfered all my files and domain to another company If I go to my opencart all my info is there only the product images and logo are not

If they are not there on the old server, what happened to them ?

I pu the product images manually. I have another question when I was inserting my images sometimes I got this error (Notice: Undefined index: bits in /home/kqbzxdot/public_html/system/library/image.php on line 16 ) Can you tell me what it is?

Delete the contents of your image/cache folder

Can you please tell me how to do that thanks

by magicsavings » Mon Oct 03, 2011 8:52 pm

Can you please tell me how to do that thanks?