i am using mysql migration software to upload a table of data to a server.

When i go through the steps it produces two sections of code within the software that can be edited the first is.

CREATE DATABASE IF NOT EXISTS `craig_Database1`
CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `craig_Database1`;

This is for the database itself then the table section is

DROP TABLE IF EXISTS `craig_Database1`.`Craig_songlyrics2`;
CREATE TABLE `craig_Database1`.`Craig_songlyrics2` (
`Field2` VARCHAR(255) NULL,
`Field3` VARCHAR(255) NULL,
`Field4` VARCHAR(255) NULL,
`Field5` VARCHAR(255) NULL,
`Field6` VARCHAR(255) NULL,
`Field7` VARCHAR(255) NULL,
`Field8` VARCHAR(255) NULL,
`Field9` LONGTEXT NULL,
`Field10` VARCHAR(255) NULL,
`Field11` VARCHAR(255) NULL
)
ENGINE = INNODB;

Each time is use the software it will delete the previous data and upload the data in the database on my computer only.

what i want to do is update the data on the server with fresh data from teh database on my computer and not delete the records on the sql server all ready.

Can any one help
Thanks :-)
Craig

your migration software should be able to do that easily