T
|
thesofa 3/25/2007 |
When I need to import large amounts of data into a MYSQL table, I use an SQL file, this can be loaded in either via the command line interface on the sql server machine, or via a utility like Navicat which gives you a terrific GUI for managing mysql databases. / MySQL Data Transfer Source Host: 192.168.0.44 Source Database: det Target Host: 192.168.0.44 Target Database: det Date: 25/03/2007 15:05:40 / SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for _printers -- ---------------------------- CREATE TABLE `_printers` ( `PrinterID` int(11) NOT NULL auto_increment, `model` varchar(30) NOT NULL, PRIMARY KEY (`PrinterID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `_printers` VALUES ('1', 'Canon S750'); INSERT INTO `_printers` VALUES ('2', 'Canon BJC5500'); INSERT INTO `_printers` VALUES ('3', 'Canon i865'); INSERT INTO `_printers` VALUES ('4', 'Canon i965'); INSERT INTO `_printers` VALUES ('5', 'Epson Stylus Photo R300'); INSERT INTO `_printers` VALUES ('6', 'HP Colour Laserjet 1500'); INSERT INTO `_printers` VALUES ('7', 'HP Colour Laserjet 2500'); INSERT INTO `_printers` VALUES ('8', 'HP Colour Laserjet 2600N'); INSERT INTO `_printers` VALUES ('9', 'HP Colour Laserjet 4550'); INSERT INTO `_printers` VALUES ('10', 'HP Deskjet 1220'); INSERT INTO `_printers` VALUES ('11', 'HP Deskjet 990c'); INSERT INTO `_printers` VALUES ('12', 'HP Laserjet 1100'); INSERT INTO `_printers` VALUES ('13', 'HP Laserjet 1200'); INSERT INTO `_printers` VALUES ('14', 'HP Laserjet 1300'); INSERT INTO `_printers` VALUES ('15', 'HP Laserjet 2420'); INSERT INTO `_printers` VALUES ('16', 'Kyocera FS1700'); INSERT INTO `_printers` VALUES ('17', 'Kyocera FS1900'); INSERT INTO `_printers` VALUES ('18', 'Kyocera FS1920'); INSERT INTO `_printers` VALUES ('19', 'Kyocera FS8000C'); INSERT INTO `_printers` VALUES ('20', 'Kyocera FSC8008N');
|
J
|
Jay author 3/25/2007 |
Hi and thank you for the tip. |
J
|
Jane 3/26/2007 |
Jay, |