Results 1 to 7 of 7
  1. #1

    Question SQL Database - increase space?

    How do you increase the allotted size on your drive so that your SQL db's can be bigger?

    I have 500 megs in my /var folder for db's but I need it to be bigger.

  2. #2
    Join Date
    Dec 2000
    Location
    San Diego, CA
    Posts
    1,571
    There's no way to increase the size of a partition without destroying all the data on the drive. What you can do though is move the databases to /home or another large partition and create a symlink:

    /etc/rc.d/init.d/mysql stop
    mv /var/lib/mysql /home/
    ln -s /home/mysql /var/lib/mysql
    /etc/rc.d/init.d/mysql start

    I hope that helps.
    -Mooneer
    Thoughtbug Software: Hosting shouldn't require any thought.
    Legitimate host? Support the Code of Ethical Conduct

  3. #3
    one question?!

    how about temporarily move all mysql to somewhere else, add an extra harddrive into the system, then mount part of the new drive as /var/lib/mysql, move back mysql files

    will this be feasible?

  4. #4
    Join Date
    Jun 2002
    Posts
    233
    Originally posted by mind21_98
    [B]There's no way to increase the size of a partition without destroying all the data on the drive.
    I use partition magic to resize drives all the time..

  5. #5
    Join Date
    Dec 2000
    Location
    San Diego, CA
    Posts
    1,571
    Originally posted by SynHost
    I use partition magic to resize drives all the time..
    Yeah, but he might not have Windows on that server.
    -Mooneer
    Thoughtbug Software: Hosting shouldn't require any thought.
    Legitimate host? Support the Code of Ethical Conduct

  6. #6
    Join Date
    Oct 2002
    Posts
    702
    not everyone is silly enough to use windows. To those who I offended, sorry.

  7. #7
    Join Date
    Jun 2002
    Posts
    233
    Why do you need Windows to use Partition Magic? I use the boot disks without need for an OS at all.

Posting Permissions

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