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 … Read more