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
Bookmarks