How to Move MySQL D/B Files (Windows)

2023-11-27 Udar Gromov MySQL 1

Locate your MySQL installation files and central configuration file

basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
Your MySQL configuration is stored in "my.ini" file

Locate your MySQL Database location:

datadir="C:/Documents and Settings/All Users/
Application Data/MySQL/MySQL Server 5.1/Data/"

Stop MySQL service.

Modify My.ini file to point to a new D/B location and Save.

Move your Data directory to a new location

Restart MySQL service.

You are done.  All pages (even if you were in the middle of the editing) continue to work.  Amazing!

(Visited 196 times, 1 visits today)

Related Articles

SQL Server

Automate Database Backup with SQL Express

2024-06-03 Udar Gromov SQL Server 8

This article describes, how to automate database backup in SQL Express with mixed Windows and SQL Authentication running on Windows 2008 Server.   This material was tested with Microsoft SQL Server 2008 R2 Express. SQL Server 2008 Enterprise comes with Maintenance Plan feature.  That feature allows amazing flexibility and auditing.  SQL […]

Windows

You can sign PowerShell certificates with New-SelfSignedCertificate and without MakeCert

2024-08-14 Udar Gromov Windows 1

  For those who can’t wait, here is the solution right away. Next two lines actually work – without using MakeCert.exe: New-SelfSignedCertificate -DnsName STA07 -Type CodeSigning Set-AuthenticodeSignature C:\T\add-signature.ps1 @(gci Cert:\LocalMachine\My -DnsName STA07 -codesigning)[0] First command creates a certificate in both Current User and Local Computer  Intermediate Certification Authorities.  Second command […]

1 Trackback / Pingback

  1. How to Work with MySQL – Basic Tasks | Domain Web Center

Your question, correction or clarification Ваш вопрос, поправка или уточнение