How To Change a MariaDB Data Directory to a New Location on CentOS

1 — Moving the MariaDB Data Directory

To prepare for moving MariaDB’s data directory, let’s verify the current location by starting an interactive session using the administrative credentials.

#mysql -u root -p

When prompted, supply the MariaDB root password. Then from the mysql prompt, select the data directory:

> select @@datadir;

/var/lib/mysql/

This output confirms that MariaDB is configured to use the default data directory, /var/lib/mysql/, so that’s the directory we need to move.

To ensure the integrity of the data, we’ll stop service - MariaDB before we actually make changes to the data directory:

# systemctl stop mariadb

to check if the service is stopped use the command:

#systemctl status mariadb

Sep 11 12:21:04 mysql systemd[1]: Stopped MariaDB database server.

Now that the server is shut down, we’ll copy the existing database directory to the new location with rsync. Using the -a flag preserves the permissions and other directory properties, while-v provides verbose output so you can follow the progress.

SQL. Search for any text or integer in the database

Small queries to search for any number or text in the desired MS SQL database.

Find an integer.

1. set nocount on
2. declare @name varchar(128), @substr bigint, @column varchar(128)
3. set @substr = 462083 -- ИСКОМОЕ ЦЕЛОЕ ЧИСЛОВОЕ ЗНАЧЕНИЕ
4. /* Create a table for output */
5. create table #rslt2
6. (table_name varchar(128), field_name varchar(128), value bigint)
7. /* Populate the created table with the found data */
8. declare s cursor for select table_name as table_name from information_schema.tables where table_type = 'BASE TABLE' order by table_name
9. open s
10. fetch next from s into @name
11. while @@fetch_status = 0
12. begin
13. declare c cursor for
14.       select quotename(column_name) as column_name from information_schema.columns
15.            where data_type in ('int', 'bigint') and table_name = @name
16. set @name = quotename(@name)
17. open c
18. fetch next from c into @column
19. while @@fetch_status = 0
20. begin
21.       print 'Processing table - ' + @name + ', column - ' + @column
22.       exec('insert into #rslt2 select ''' + @name + ''' as Table_name, ''' + @column + ''', ' + @column +
23.            ' from' + @name + ' where ' + @column + ' = ' + @substr )
24. fetch next from c into @column
25. end
26. close c
27. deallocate c
28. fetch next from s into @name
29. end
30. select table_name as [Table Name], field_name as [Field Name], count(*) as [Found Mathes] from #rslt2
31. group by table_name, field_name
32. order by table_name, field_name
33. /* Display found values ​​if needed (uncomment next line) */
34. -- select * from #rslt2 order by table_name, field_name
35. drop table #rslt2
36. close s
37. deallocate s

Wyszukaj ciąg znaków.

1. set nocount on
2. declare @name varchar(128), @substr nvarchar(4000), @column varchar(128)
3. set @substr = '%Пружинкин%' -- ФРАГМЕНТ ИСКОМОЙ СТРОКИ
4. /* Create a table for output */
5. create table #rslt
6. (table_name varchar(128), field_name varchar(128), value ntext)
7. /* Populate the created table with the found data */
8. declare s cursor for select table_name as table_name from information_schema.tables where table_type = 'BASE TABLE' order by table_name
9. open s
10. fetch next from s into @name
11. while @@fetch_status = 0
12. begin
13. declare c cursor for
14.       select quotename(column_name) as column_name from information_schema.columns
15.            where data_type in ('text', 'ntext', 'varchar', 'char', 'nvarchar', 'char', 'sysname') and table_name = @name
16. set @name = quotename(@name)
17. open c
18. fetch next from c into @column
19. while @@fetch_status = 0
20. begin
21.       print 'Processing table - ' + @name + ', column - ' + @column
22.       exec('insert into #rslt select ''' + @name + ''' as Table_name, ''' + @column + ''', ' + @column +
23.            ' from' + @name + ' where ' + @column + ' like ''' + @substr + '''')
24.       fetch next from c into @column
25. end
26. close c
27. deallocate c
28. fetch next from s into @name
29. end
30. select table_name as [Table Name], field_name as [Field Name], count(*) as [Found Mathes] from #rslt
31. group by table_name, field_name
32. order by table_name, field_name
33. /* Display found values ​​if needed (uncomment next line) */
34. --select * from #rslt order by table_name, field_name
35. drop table #rslt
36. close s
37. deallocate s

RDCMan manages multiple remote desktop connections

Microsoft has found a vulnerability in the Remote Desktop Connection Manager (RDCMan) application after detecting the CVE-2020-0765 vulnerability. If you are using this program, it is worth updating it to the latest version released on January 27, 2022 - v2.90

RDCMan manages multiple remote desktop connections. It is useful for managing server labs where you need regular access to each machine such as automated checkin systems and data centers.

The Menu

There are several top-level menus in RDCMan:

• File - load, save, and close RDCMan file groups
• Edit - add, remove, and edit the properties of servers and groups.
• Session - connect, disconnect and log off sessions
• View - options to control the visibility of the server tree, virtual groups and size of the client area
• Remote Desktops - allows access to the groups and servers in a hierarchical fashion, similar to the server tree; primarily useful when the Server Tree is hidden
• Tools - change application properties
• Help - learn about RDCMan (you probably already found this)

The Tree

Most work, such as adding, removing, and editing servers and groups, can be accomplished via right-clicking on a tree node. Servers and groups can be moved using drag-and-drop.

Keyboard shortcuts:

• Enter: Connect to selected server.
• Shift+Enter: Connect to the selected server using the Connect As feature.
• Delete: Remove selected server or group.
• Shift+Delete: Remove selected server or group without question.
• Alt+Enter: Open properties dialog for selected server or group.
• Tab: If a connected server is selected, give it focus.

Use the [View.Server tree location] menu option to locate the tree at the left or right edge of the window.

Full Screen Mode

To work with a server in full screen mode, select the server to give it focus and press Ctrl+Alt+Break (this key is configurable, see Shortcut Keys.) To leave full screen mode, press Ctrl+Alt+Break again or use the minimize/restore buttons in the connection title bar. Multiple monitors can be spanned if enabled by the monitor spanning option.

Download

 Download Remote Desktop Connection Manager (519 KB)
Run now from Sysinternals Live.

Runs on:

• Client: Windows 8.1 and higher.
• Server: Windows Server 2012 and higher.

Policies

RDCMan retrieves policy information from the HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\RDCMan registry key.

• DisableLogOff - Create this DWORD value as non-zero to disable the log off command throughout RDCMan.