transfer data from 1 database to another

Discussion in 'MySQL' started by dougvcd, Aug 9, 2007.

  1. #1
    hi all
    i have a mysql database and i want to transfer the entries from one database to another on diff server
    i guess its export and import but i tried that and told me table already exists
    but it not the table i want its the data in table
    cheers
    Doug
    ps
    or is it better to delete the second table and import the whole thing
     
    dougvcd, Aug 9, 2007 IP
  2. dougvcd

    dougvcd Peon

    Messages:
    267
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    ok deleted the table and imported it
    is this the only way
    cheers
    Doug
     
    dougvcd, Aug 9, 2007 IP
  3. falcondriver

    falcondriver Well-Known Member

    Messages:
    963
    Likes Received:
    47
    Best Answers:
    0
    Trophy Points:
    145
    #3
    if you use phpmyadmin, tick the box "drop if exists" at the export-options, then import the file into the new server.
     
    falcondriver, Aug 9, 2007 IP