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>
<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> |