Export and Import a MySQL or MariaDB database

[Remix]

Export your database via the command line

Code: [Select]

mysqldump --host=server --user=user --port=port --password=password database_name > database_name.sql

Import your database via the command line

Code: [Select]

cat database_name.sql | mysql --host=server --user=user --port=port --password=password database_name