regex101: PCRE2 (PHP) Substitution Workspace

^start of line

Group 1(basedir[ ]*=[ ]*")

basedirthe literal text basedir (case sensitive)

Character Class[ ]*

*matches any number of characters from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

=the literal = (61₁₀ / 75₈ / 3D₁₆)

Character Class[ ]*

*matches any number of characters from the set below:

the literal (32₁₀ / 40₈ / 20₁₆)

"the literal " (34₁₀ / 42₈ / 22₁₆)

Group 2(.)

.any character (except for line terminators)

Group 3(:[\/\\])

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Character Class[\/\\]

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

Group 4([a-zA-Z0-9]*)

Character Class[a-zA-Z0-9]*

*matches any number of characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Group 5([\/\\]?.*)

Character Class[\/\\]?

?matches at most one character from the set below:

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

.*any character (except for line terminators), repeated any number of times

$end of line

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Search reference

Regular Expression

^(basedir[ ]*=[ ]*")(.)(:[\/\\])([a-zA-Z0-9]*)([\/\\]?.*)$

New

[mysqld]
#skip-innodb

# The TCP/IP Port the MySQL Server will listen on
port=3306
max_allowed_packet=16M


#Path to installation directory. All paths are usually resolved relative to this.
#basedir="C:/Program Files/MySQL/MySQL Server 5.1/"
basedir="C:/MySQL/"

#Path to the database root
#datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
datadir="C:/MySQLData/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=utf8

Regular Expressions 101

Regular Expression

Extraction