Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2006
    Posts
    36
    Plugin Contributions
    0

    bug DB won't restore -at a loss

    Hi,

    I followed the instructions for backing up my database. Then I went to restore it, and it is not restoring anything.

    Here is part of the restore file, I can't find a problem.

    -- phpMyAdmin SQL Dump
    -- version 2.11.8.1
    -- http://www.phpmyadmin.net
    --
    -- Host: 127.0.0.1:3306
    -- Generation Time: Nov 21, 2008 at 07:45 PM
    -- Server version: 4.1.20
    -- PHP Version: 4.3.11

    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;

    --
    -- Database: `center_zcart`
    --

    -- --------------------------------------------------------

    --
    -- Table structure for table `zen_address_book`
    --

    DROP TABLE IF EXISTS `zen_address_book`;
    CREATE TABLE IF NOT EXISTS `zen_address_book` (
    `address_book_id` int(11) NOT NULL auto_increment,
    `customers_id` int(11) NOT NULL default '0',
    `entry_gender` char(1) NOT NULL default '',
    `entry_company` varchar(64) default NULL,
    `entry_firstname` varchar(32) NOT NULL default '',
    `entry_lastname` varchar(32) NOT NULL default '',
    `entry_street_address` varchar(64) NOT NULL default '',
    `entry_suburb` varchar(32) default NULL,
    `entry_postcode` varchar(10) NOT NULL default '',
    `entry_city` varchar(32) NOT NULL default '',
    `entry_state` varchar(32) default NULL,
    `entry_country_id` int(11) NOT NULL default '0',
    `entry_zone_id` int(11) NOT NULL default '0',
    PRIMARY KEY (`address_book_id`),
    KEY `idx_address_book_customers_id_zen` (`customers_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=469 ;

    --
    -- Dumping data for table `zen_address_book`
    --

    INSERT INTO `zen_address_book` (`address_book_id`, `customers_id`, `entry_gender`, `entry_company`, `entry_firstname`, `entry_lastname`, `entry_street_address`, `entry_suburb`, `entry_postcode`, `entry_city`, `entry_state`, `entry_country_id`, `entry_zone_id`) VALUES
    (32, 43, '', '', 'James', 'Syrw', '245 Iron Horse', '', '97789', 'Walnut', '', 223, 12),
    (24, 35, '', '', 'Jimmy', 'mtdau', '725 Iron Horse', '', '94769', 'Walnut', '', 223, 12),

    I am desparate to get this back up. Thank you for any help you can give me. Rhonda

  2. #2
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,571
    Plugin Contributions
    1

    Default Re: DB won't restore -at a loss

    What methods are being used, to create to the backup and to do the restore?

  3. #3
    Join Date
    Aug 2006
    Posts
    36
    Plugin Contributions
    0

    Default Re: DB won't restore -at a loss

    Hi I used Import/Export in pHpMyadmin

    I finally got the files in after dropping all the tables. But none of the products show up in the Admin. I am contacting the ISP.

 

 

Similar Threads

  1. Profit + Loss fuctionality?
    By Gaark in forum General Questions
    Replies: 1
    Last Post: 16 Jul 2008, 09:37 AM
  2. profit and loss
    By enquirer66 in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 15 Apr 2008, 07:16 AM
  3. OK, I'm at a loss here..
    By therealbelladonna in forum General Questions
    Replies: 21
    Last Post: 18 Apr 2007, 04:53 AM
  4. Loss of footer div
    By PeteH in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 7 Sep 2006, 01:21 PM
  5. I'm At A Loss.
    By hrmn8r in forum Installing on a Linux/Unix Server
    Replies: 12
    Last Post: 29 Jun 2006, 12:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR