mysqldump - Suay.Site

How to transfer a database between DBMS servers without creating a database dump file (MySQL and MariaDB)

Posted by Alex On April 7, 2025

Contents Is it possible to transfer a database from one MySQL / MariaDB server to another without creating an intermediate file How to transfer a database from one server to another How to transfer a database from one MySQL/MariaDB instance to another when both MySQL/MariaDB instances are running on the same machine How to transfer a database from one MySQL/MariaDB...

mysqldump in PowerShell corrupts non-Latin characters when exporting database (SOLVED)

Posted by Alex On October 23, 2022

mysqldump is a MySQL utility for creating database and table backups. Unlike phpMyAdmin, which, although it offers a web interface, is a slower tool due to the limitations of intermediates such as PHP and Apache, mysqldump is a much more efficient tool without limitations for backing up very large data. But on Windows, mysqldump has some nuances. Due to the...

Output encoding issues in PowerShell and third-party utilities running in PowerShell (SOLVED)

Posted by Alex On October 23, 2022

What encoding is used in PowerShell by default. How to change the default output encoding to UTF-8 in PowerShell If you run the following command in PowerShell 5: "Testing" > test.file And check the encoding in the newly created test.file, it turns out that it is UTF-16LE. If you run the following command in PowerShell 7: "Testing" > test.file And...