Copy MySQL query results to MariaDB table

Want to transfer data from MySQL query results to MariaDB table?

Try Withdata DBCopier, a MySQL to MariaDB converter for Windows, Mac, and Linux, Copy MySQL query to MariaDB, Easy and Fast.

Download Withdata DBCopier Download DBCopier

Transfer data from MySQL query To MariaDB table

Login to MySQL and MariaDB -> Enter source MySQL query -> Set target MariaDB table -> Copy MySQL query data to MariaDB table

Choose source MySQL database and logon.

convert MySQL query to MariaDB table - Choose MySQL and logon

Choose target MariaDB database and logon.

save MySQL query results to MariaDB table - Choose MariaDB and logon

Click “Convert From Query” at task dialog.

Import data from MySQL query results to MariaDB table - Task Window

then show the wizard.

1. Set a MySQL query.

Convert data from MySQL query results to MariaDB table - open query results

2. Select a destination MariaDB table and config fields.

Extract MySQL query results data to MariaDB table - select table

3. Preview data.

Migrage data from MySQL query results to MariaDB table - preview

4. Transfer data from MySQL query result to MariaDB table.

save data from MySQL query results to MariaDB table - import


More about MySQL to MariaDB converter

See also:

MySQL → MariaDB reference

Command line

SideCommand
MySQLmysqldump, or mysql -e "SELECT ..." > out.csv
MariaDBmariadb-dump
MariaDB (load)mariadb-import, or LOAD DATA INFILE
MySQL (load)mysqlimport, or LOAD DATA INFILE

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.


Posted

in

by