Share Share on Facebook Share on Twitter Pinterest Email Import : mysql -u root -p database < database.sql Export : mysqldump –host=database.host.net –password –user=username database > database.sql mysqldump –host=’localhost’ –password –user=username database > database.sql 0 Siddharth Shukla Website Related Posts Find all tables containing column with specified name – MS SQL Server August 3, 2022 mysqldump: Couldn’t execute. Unknown table ‘column_statistics’ in information_schema June 7, 2022 [SOLVED] ERROR 2006 (HY000): MySQL server has gone away April 27, 2022 How to add MySQL to $PATH variable to resolve “mysql: command not found”? December 1, 2021 Write A Comment Cancel Reply Save my name, email, and website in this browser for the next time I comment.