Move Database file in MySQL and MsSQL
1.MsSQL
Stop all SQL service
![](/MoveDatabase/MoveDataBase-1_1.png)
Set permission to new folder
![](/MoveDatabase/MoveDataBase-2_1.png)
Detect names and location of each files
![](/MoveDatabase/MoveDataBase-3_1.png)
Alter database to new location
![](/MoveDatabase/MoveDataBase-4_1.png)
Set database offline
Move files
![](/MoveDatabase/MoveDataBase-5_1.png)
Set database online
![](/MoveDatabase/MoveDataBase-6_1.png)
2.MySQL
Detect location of data and control file
![](/MoveDatabase/MoveDataBase-1_1.png)
Stop service
Change location in config
![](/MoveDatabase/MoveDataBase-2_1.png)
If needed change other parameters include default data directory by GUI
![](/MoveDatabase/MoveDataBase-3_1.png)
Move data and start server again
![](/MoveDatabase/MoveDataBase-4_1.png)
![](/MoveDatabase/MoveDataBase-5_1.png)
Comments (
)
![](http://forum.vb-net.com/GetTopicCount.png?id=7d02a135-106a-409b-b28c-bf18059d7f8f)
<00>
<01>
<02>
<03>
<04>
<05>
<06>
<07>
<08>
<09>
<10>
<11>
<12>
<13>
<14>
<15>
<16>
<17>
<18>
<19>
<20>
<21>
<22>
<23>
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> <CHAT ME> <ABOUT ME> < THANKS ME> |