(Notes) Notes (2012)

Move Database file in MySQL and MsSQL

1.MsSQL

Stop all SQL service



Set permission to new folder



Detect names and location of each files



Alter database to new location



Set database offline


Move files



Set database online



2.MySQL

Detect location of data and control file



Stop service


Change location in config



If needed change other parameters include default data directory by GUI



Move data and start server again





Comments ( )
<00>  <01>  <02>  <03>  <04>  <05>  <06>  <07>  <08>  <09>  <10>  <11>  <12>  <13>  <14>  <15>  <16>  <17>  <18>  <19
Link to this page: //www.vb-net.com/MoveDatabase/Index.htm
<SITEMAP>  <MVC>  <ASP>  <NET>  <DATA>  <KIOSK>  <FLEX>  <SQL>  <NOTES>  <LINUX>  <MONO>  <FREEWARE>  <DOCS>  <ENG>  <MAIL ME>  <ABOUT ME>  < THANKS ME>