From: Aaron Morris (meaaronmorris.org)
Date: Tue Nov 15 2005 - 13:24:16 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I have a very simple database I am trying to backup.

I run myslqdump and it gives me the code below.

Which does nothing but cause errors when I try to run it.

Thank you in advance for your help
-Aaron

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 4.1.11-nt

/*!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 */;

/*!40014 SET OLD_UNIQUE_CHECKS=UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET OLD_FOREIGN_KEY_CHECKS=FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET OLD_SQL_MODE=SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

--
-- Create schema `inventory`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `inventory`;
USE `inventory`;

--
-- Table structure for table `inventory`.`bug_item`
--

DROP TABLE IF EXISTS `bug_item`;
CREATE TABLE `bug_item` (
  `id` int(4) NOT NULL default '0',
  `title` text NOT NULL,
  `description` text,
  `pageLink` text,
  `status_id` int(4) NOT NULL default '0',
  `user_id` int(4) NOT NULL default '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`.`bug_item`
--

/*!40000 ALTER TABLE `bug_item` DISABLE KEYS */;
/*!40000 ALTER TABLE `bug_item` ENABLE KEYS */;

--
-- Table structure for table `inventory`.`bug_item_log`
--

DROP TABLE IF EXISTS `bug_item_log`;
CREATE TABLE `bug_item_log` (
  `log_id` int(4) NOT NULL default '0',
  `bug_id` int(4) NOT NULL default '0',
  `dt_timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
  `title` text NOT NULL,
  `description` text,
  `pageLink` text,
  `status_id` int(4) NOT NULL default '0',
  `user_id` int(4) NOT NULL default '0',
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`.`bug_item_log`
--

/*!40000 ALTER TABLE `bug_item_log` DISABLE KEYS */;
/*!40000 ALTER TABLE `bug_item_log` ENABLE KEYS */;

--
-- Table structure for table `inventory`.`bug_status`
--

DROP TABLE IF EXISTS `bug_status`;
CREATE TABLE `bug_status` (
  `status_id` int(4) NOT NULL default '0',
  `title` text NOT NULL,
  PRIMARY KEY (`status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`.`bug_status`
--

/*!40000 ALTER TABLE `bug_status` DISABLE KEYS */;
/*!40000 ALTER TABLE `bug_status` ENABLE KEYS */;

--
-- Table structure for table `inventory`.`bug_user`
--

DROP TABLE IF EXISTS `bug_user`;
CREATE TABLE `bug_user` (
  `user_id` int(4) NOT NULL default '0',
  `email` text NOT NULL,
  `password` varchar(50) NOT NULL default '',
  `user_name` varchar(200) default NULL,
  `phone` varchar(50) default NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`.`bug_user`
--

/*!40000 ALTER TABLE `bug_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `bug_user` ENABLE KEYS */;

--
-- Table structure for table `inventory`.`inv_item`
--

DROP TABLE IF EXISTS `inv_item`;
CREATE TABLE `inv_item` (
  `inv_id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(150) default NULL,
  `description` text,
  `inv_list` varchar(150) default NULL,
  `inv_stock_num` varchar(150) default NULL,
  `inv_serial` varchar(150) default NULL,
  `inv_year` varchar(150) default NULL,
  `inv_make` varchar(150) default NULL,
  `inv_model` varchar(150) default NULL,
  `inv_color` varchar(150) default NULL,
  PRIMARY KEY (`inv_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`.`inv_item`
--

/*!40000 ALTER TABLE `inv_item` DISABLE KEYS */;
INSERT INTO `inv_item`
(`inv_id`,`title`,`description`,`inv_list`,`inv_stock_num`,`inv_serial`,`inv
_year`,`inv_make`,`inv_model`,`inv_color`) VALUES
 (2,'2000 Ford Truck','<P><STRONG>THIS TRUCK IS THE CHIT</STRONG>
</P>\r\n<H2><FONT face=\"Arial, Helvetica, sans-serif\" size=4>Seriouely I
love this thing!</FONT></H2>','$20000','124','6587943156854','2005','4dr
Truck','EXT','Black'),
 (3,'2005 Jaguar S-Type','<H3 class=subheader>What\'s New for the 2005
Jaguar S-Type?</H3>\r\n<DIV class=photo><IMG height=100 alt=\"2005 Jaguar
S-Type\"
src=\"http://us.autos1.yimg.com/img.autos.yahoo.com/i/buyersguide/small/s-ty
pe11.jpg\" width=200> </DIV>\r\n<DIV class=content>Jaguar\'s 2005 S-Type
receives a muscular-looking redesign this year, as well as an updated
interior that features Bronze Madrona wood accents, a new instrument panel,
clearer displays, and available aluminum trim to replace the traditional
wood appliques. A new VDP Edition is available on the S-Type 4.2 V8, which
includes leather upholstery with contrasting piping, deep-pile foot well
rugs, heated seats, burl walnut trim, walnut and leather trim for the
steering wheel and shift knob, auto-leveling xenon headlamps, unique 17-inch
multi-spoke wheels and an electronic rear sunshade. The high-performance
2005 Jaguar S-Type R also receives a revised rear spoiler and a new front
fascia with integrated intercooler air intakes. \r\n<H3
class=subheader>Advantages of the 2005 Jaguar
S-Type:</H3>\r\n<UL>\r\n<LI>Distinguished, distinctive styling
\r\n<LI>Elegantly appointed interior \r\n<LI>Blistering acceleration with
the Jaguar S-Type R </LI></UL>\r\n<H3 class=subheader>Objections to the 2005
Jaguar S-Type:</H3>\r\n<UL>\r\n<LI>Underwhelming base V6 \r\n<LI>Fussy
J-gate shifter operation \r\n<LI>No manual transmission option for the
S-Type R \r\n<LI>Cramped front seats for larger people </LI></UL>\r\n<H3
class=subheader>AutoSite\'s Advice:</H3>\r\n<P>Six years into its product
cycle, the 2005 Jaguar S-Type still manages to turn heads with its
retro-chic design. A range of three models appeals to a wide variety of
luxury consumers, from the daily driver who just wants an impressive looking
car to the driving enthusiast addicted to super-legal speeds. No matter
which model you choose, one thing is certain - this is a great looking car.
</P></DIV>','$15,000','123','123','2005','Jaguar','S-Type','green');
/*!40000 ALTER TABLE `inv_item` ENABLE KEYS */;

--
-- Table structure for table `inventory`.`inv_item_img`
--

DROP TABLE IF EXISTS `inv_item_img`;
CREATE TABLE `inv_item_img` (
  `inv_id` int(10) unsigned NOT NULL default '0',
  `file_name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`.`inv_item_img`
--

/*!40000 ALTER TABLE `inv_item_img` DISABLE KEYS */;
INSERT INTO `inv_item_img` (`inv_id`,`file_name`) VALUES
 (0,'Attayac-Logo.gif'),
 (0,'Attayac-Logo.gif'),
 (0,'LETSROCK.jpg'),
 (0,'Attayac-Logo.gif'),
 (0,'Attayac-Logo.gif'),
 (0,'Attayac-Logo.gif'),
 (3,'st.jpg'),
 (3,'st.jpg');
/*!40000 ALTER TABLE `inv_item_img` ENABLE KEYS */;

--
-- Table structure for table `inventory`.`inv_item_thumb_img`
--

DROP TABLE IF EXISTS `inv_item_thumb_img`;
CREATE TABLE `inv_item_thumb_img` (
  `inv_id` int(10) unsigned NOT NULL default '0',
  `file_name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `inventory`.`inv_item_thumb_img`
--

/*!40000 ALTER TABLE `inv_item_thumb_img` DISABLE KEYS */;
INSERT INTO `inv_item_thumb_img` (`inv_id`,`file_name`) VALUES
 (2,'thumb_s-type11.jpg'),
 (3,'thumb_st.jpg');
/*!40000 ALTER TABLE `inv_item_thumb_img` ENABLE KEYS */;

/*!40101 SET SQL_MODE=OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=OLD_CHARACTER_SET_CLIENT */;

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]