1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Need help moving MySQL db from one server to another

Discussion in 'MySQL' started by jawinn, Dec 18, 2006.

  1. Shahnawaz

    Shahnawaz Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #21
    u can use the PHP myadmin to export ur data in sql format. and with this u can import also. its easy cauz its visual.
     
    Shahnawaz, Dec 21, 2006 IP
  2. frankcow

    frankcow Well-Known Member

    Messages:
    4,859
    Likes Received:
    265
    Best Answers:
    0
    Trophy Points:
    180
    #22
    And you might want to include a IF NOT EXISTS statement in front of the create database statement
     
    frankcow, Dec 21, 2006 IP
  3. Shahnawaz

    Shahnawaz Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #23
    does ur server support the php myadmin. if so then login into php myadmin with ur database password and account name. then select the export option. after that select the database u want to export. select it to export as an sql format. and in bottom select as a file radio link button to save it as a sql text file. and for import login to ur desired server phpadmin. select import then select the file.
     
    Shahnawaz, Dec 21, 2006 IP