SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    will code HTML for food Michel V's Avatar
    Join Date
    Sep 2000
    Location
    Corsica
    Posts
    552
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'd like to transfer a database from one server to another, using PhpMyAdmin (the only way I can manae the database)...
    Only problem is I don't know how to do it.

    The database isn't gigantic, so perhaps an idea would be to download it and upload it on the other server, but can this be done ? Any SQL wizards to give me an hand ?
    [blogger: zengun] [blogware contributor: wordpress]

  2. #2
    SitePoint Wizard
    Join Date
    Mar 2001
    Posts
    3,537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Try this:

    Reply To This Message
    RE: Local Table upload
    Author: prosper (210.176.120.---)
    Date: 03-12-2001 03:08

    select View dump (schema) of database from phpMyAdmin in your local machine.
    Then select Structure and data and click "go" button.
    And copy the data under the following line from result page
    # Dumping data for table ...
    insert ...
    insert...

    Then paste these insert statements into the following text area under the words"
    Run SQL query/queries on database mysql" in PhpMyadmin at the company hosting your webpage. These procedure will only copy the data to your table website.

    If you don't have any table on the website , you should copy the structure of the table and those insert statements.


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
  •