SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: MySQL Questions

  1. #1
    SitePoint Addict certify's Avatar
    Join Date
    May 2001
    Location
    Malaysia
    Posts
    216
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Questions

    How do you move a mysql database to another server?

    I am going to change server and I want to know how do I do that.


    And How do you change MySQL root password?

    Thanks.
    Your WebHosting Partner - RouterWebHost.com
    eXam SIMulation Software - ExamSim.net
    geeks forums -ProgrammingTutor.com
    BMWClub of Malaysia - BMWClub.com.my
    unofficial MU Fan Club coming soon - ManchesterUnited.com.my


  2. #2
    SitePoint Wizard
    Join Date
    Jul 1999
    Location
    Chicago
    Posts
    2,629
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    To move the DB, you need to do a mysqldump on it. There are about 20 threads on that already, so check http://www.sitepointforums.com/searc...der=descending .

    To chnge the root password, you need to use mysqladmin. I think it's like "mysqladmin -u root -p new-password 'NEWPASSWORD'" but read the docs if that's not the case.


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
  •