Professional Web Applications Themes

Moving a mysql database on a different partition on the server - MySQL

Hi, I'm looking to move an entire mysql databse from its current location into a newly installed much larger partition on our Microsoft Small Business 2003 server. Can anyone please explain how I could go about doing this? The way I am looking to do it at the moment it to backup the DB, uninstall mysql from its current location, install it into the new partition, and then change all existing connections to point here from now on.......this will take me a lot of time :) is there an easier/quicker way to do this? Help as always is much appreciated...

Sponsored Links
  1. #1

    Default Moving a mysql database on a different partition on the server

    Hi,

    I'm looking to move an entire mysql databse from its current location
    into a newly installed much larger partition on our Microsoft Small
    Business 2003 server. Can anyone please explain how I could go about
    doing this?
    The way I am looking to do it at the moment it to backup the DB,
    uninstall mysql from its current location, install it into the new
    partition, and then change all existing connections to point here from
    now on.......this will take me a lot of time :)
    is there an easier/quicker way to do this?

    Help as always is much appreciated

    Sponsored Links
    kunaal84@gmail.com Guest

  2. #2

    Default Re: Moving a mysql database on a different partition on the server

    com wrote: 

    If you're just moving the data, and not MySQL itself, you can stop
    MySQL, copy the files over to the new partition, change your my.ini file
    and restart the database.

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    JDS Computer Training Corp.
    net
    ==================
    Jerry Guest

  3. #3

    Default Re: Moving a mysql database on a different partition on the server

    Thanks Jerry,

    Appreciate that, it seems to have worked :)

    kunaal84@gmail.com Guest

Similar Threads

  1. Replies: 1
    Last Post: March 15th, 12:22 PM
  2. Moving SQL Server database from localhost to remote?
    By Mark Fenton in forum Dreamweaver AppDev
    Replies: 3
    Last Post: April 11th, 03:35 PM
  3. moving a database from one server to another.
    By Strangiato in forum Informix
    Replies: 2
    Last Post: August 12th, 08:00 AM
  4. Moving /home to its own partition.
    By alex in forum Debian
    Replies: 15
    Last Post: August 8th, 08:00 PM
  5. Jaguar - Moving Appplications Folder to seperate partition (/etc/fstab)
    By Stuart Norris in forum Mac Applications & Software
    Replies: 2
    Last Post: July 21st, 10:30 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139