Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    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;
    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    your migration software should be able to do that easily
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •