I used mysqldump to export a database. If I deleted the code at the top of the export and just left the INSERT statements, would bringing that file in fail/replace/or add to the table I'm importing? Make sence? Thanks.
Line used to dump database:
mysqldump -c -u root -p databaseName > file.sql;
Line I generally use to import databases:
mysql -u root -p databaseName < file.sql;
Example dump:
-- MySQL dump 9.08
-- Host: localhost Database: databaseName
-- Server version 4.0.13-standard
--
-- Table structure for table 'testing'
CREATE TABLE new (
id int(11) NOT NULL auto_increment,
header varchar(200) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
--
-- Dumping data for table 'testing'
INSERT INTO testing (id, header) VALUES (1,'header1');
INSERT INTO testing (id, header) VALUES (2,'header2');
INSERT INTO testing (id, header) VALUES (3,'header3');
INSERT INTO testing (id, header) VALUES (4,'header4');
