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 [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40014 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; /*!40101 SET [EMAIL PROTECTED] */; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
