SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Guru dwzemens's Avatar
    Join Date
    Mar 2005
    Location
    United States
    Posts
    768
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to transfer MySQL database to another server?

    This is my first attempt at using a database driven website. I am using PHP and MySQL. I have a rather large MySQL database on my development and testing server. I am about ready to go live with the clients website. How can I transfer this database to the cleint's server?

    Thanks for the help.

    - dwz

  2. #2
    _ silver trophy ses5909's Avatar
    Join Date
    Jul 2003
    Location
    NoVa
    Posts
    5,466
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)
    What you need to do is export the database to a sql file (structure and inserts). Do you have shell access or what is your control panel for your host?
    Sara

  3. #3
    SitePoint Guru dwzemens's Avatar
    Join Date
    Mar 2005
    Location
    United States
    Posts
    768
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply. phpMyAdmin is the user interface....I am pretty stupid about this, so if you can offer me a few details it would be great.

    - dwz

  4. #4
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    please use the search feature. there are lots of posts in the mysql forum with details on how to use the export feature in phpmyadmin to backup a database and the import feature to restore.

  5. #5
    Wadge! F4nat1c's Avatar
    Join Date
    Oct 2005
    Location
    South Wales, UK
    Posts
    1,134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    OMFG SitePoint ROXORZ TEH BIG ONE111!
    Wish you were invisible?

  6. #6
    SitePoint Enthusiast
    Join Date
    May 2005
    Posts
    60
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    recommend navicat

    go download navicat (has a trial period).

    Really userfriendly.

    Create a connection to ur mysql server,
    right click it, hit "DUMP SQL"
    And voila, u have a nice SQL file of all ur data.

    U can then create a new connection to your NEW mysql server,
    and run that sql file as a query.

    Voila! You have mirrored your sql server.

    It also has a "data transfer" option. But i find that kinda slow.

    There are a bunch of database admin tools, but i find navicat really good.

  7. #7
    SitePoint Guru dwzemens's Avatar
    Join Date
    Mar 2005
    Location
    United States
    Posts
    768
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks to all who offered advice. I used this process, as suggested in one of the posts, and it worked:

    "If you are used to phpMyADMIN and have permission, simply create a new database on the homepage. Select it from the dropdown on the left and click on the SQL tab. It will allow you to import your locahost.sql file."

    - dwz
    Web Design, Marketing, Etc .............
    ....


Bookmarks

Posting Permissions

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