How Tos > Move Database to another Drive

Move Database to another Drive

Tags:  

Move Database to another Drive

To move the Central or Probe database to another drive, follow the below steps.
  1. Stop the Central or Probe service.
  2. copy the mysql/data folder and mysql/tmp folder from c:\programfiles\adventnet\me\central\mysql\ to the drive you want say e:\data and e:\tmp. [DONT DELETE THESE FOLDERS FROM THE ORIGINAL LOCATION ..... JUST COPY THEM....IF THESE FOLDERS ARE MISSING IN THE DEFAULT PATH MYSQL WONT WORK PROPERLY] 
  3. Open the startMysql.bat file [<central/probe home>\bin].
  4. Open the startMysql.bat file [<central/probe home>\bin], look for
    defaults-file="..\data\my.cnf"
    datadir=..\data
    tmpdir=..\tmp


    and update the new location where the 'data' and 'tmp' files are available.

    example:
    defaults-file="e:\mysql\data\my.cnf"
    datadir=e:\mysql\data
    tmpdir=e:\mysql\tmp
  5. Start the Central or Probe service.




 RSS of this page

rtttrrb