1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Rep Power
    I'm sorry if this has been asked. I have a hosting company who does the mysql database for me. I'm thinking of moving the existing data onto my own machine. Is there a simple way to do this or should I just write a PHP script to do it?

    thanks in advance.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Rep Power
    You can use mysqldump -p database > filename to extract the tables. Follow up on the new computer just running the dumpfile into the system.

Similar Threads

  1. Need advice designing a usage tracking database (MySQL)
    By Randolpho in forum Database Management
    Replies: 0
    Last Post: February 13th, 2004, 04:11 PM
  2. Replies: 3
    Last Post: February 11th, 2004, 08:30 AM
  3. Replies: 14
    Last Post: February 8th, 2004, 01:28 PM
  4. Replies: 0
    Last Post: January 31st, 2004, 02:15 AM
  5. MYSQL database
    By isheikh in forum MySQL Help
    Replies: 3
    Last Post: January 14th, 2004, 10:58 PM

IMN logo majestic logo threadwatch logo seochat tools logo