MySQL: Import and Export Databases in MySQL or MariaDB
Jump to navigation
Jump to search
Export
mysqldump -u username -p database_name > data-dump.sql
Import
mysql -u username -p new_database < data-dump.sql
mysqldump -u username -p database_name > data-dump.sql
mysql -u username -p new_database < data-dump.sql