How do I import an SQL file using the command line in MySQL?
Try: mysql -u username -p database_name < file.sql Check MySQL Options.. Note 1: It is better to use the full path of the SQL file file.sql. Note 2: Use -R and --triggers to keep the routines and triggers of original database. They are not copied by default. Note 3 You may have to create the (empty) database from MySQL if it doesn't exist already and the exported SQL don't contain …
DA: 52 PA: 81 MOZ Rank: 63