SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast rmacca's Avatar
    Join Date
    Dec 2000
    Location
    Hamilton, New Zealand
    Posts
    39
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Can ne1 tell me how to save MySQL databases so that i can transfer them between computers or onto a web server from my personal computer?
    What about making backups of a MySQL database?

    L8az, Rob

  2. #2
    You talkin to me? Anarchos's Avatar
    Join Date
    Oct 2000
    Location
    Austin, TX
    Posts
    1,438
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Use mysqldump

  3. #3
    SitePoint Wizard
    Join Date
    Mar 2001
    Posts
    3,537
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If I develop my database locally is it possible to upload the contents of the tables into the database held at my hosting company using PHPAdmin.


    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
  •