2,306
edits
Changes
Jump to navigation
Jump to search
Line 5:
Line 5: + + +
→add .sql to MySQL database
restore:
restore:
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
restore .sql.gz
zcat /path/to/file.sql.gz | mysql -u 'root' -p 'password' your_database