var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sql migration problems
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;
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
your migration software should be able to do that easily