Results 1 to 5 of 5
  1. #1

    moving mysql database

    hello, when my server was setup var partition was set to only 500mb, which is a little small espcially as has mysql databases in sub dir. i have space on another drive and would like to move a couple of databases there.

    Could i just move the database dir (user_vbulletin ) to new drive and put sym link to it in /var/lib/mysql/

  2. #2
    Join Date
    Nov 2001
    Location
    Ann Arbor, MI
    Posts
    2,978
    It should work. Let us know if it doesn't.
    -Mark Adams
    www.bitserve.com - Secure Michigan web hosting for your business.
    Only host still offering a full money back uptime guarantee and prorated refunds.
    Offering advanced server management and security incident response!

  3. #3
    bobcares is offline [email protected]
    Join Date
    Nov 2001
    Location
    India, US, Germany
    Posts
    1,598
    Yes. It would work. However remember to stop mysql when you carrying out this operation.
    Have a great day

    Regards
    Amar
    A student once asked his teacher, "Master, what is enlightenment?"
    The master replied, "When hungry, eat. When tired, sleep. When you need care, come to bobcares...."

  4. #4
    Thanks for reply, i will try it, i may also just move the whole /var/lib/mysql/ but leave /var/lib/ in same place, could i use same method?

    many thanks

  5. #5
    bobcares is offline [email protected]
    Join Date
    Nov 2001
    Location
    India, US, Germany
    Posts
    1,598
    Yes. That would be a good idea...
    amar
    A student once asked his teacher, "Master, what is enlightenment?"
    The master replied, "When hungry, eat. When tired, sleep. When you need care, come to bobcares...."

Posting Permissions

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