2,306
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + +
→add .sql to MySQL database
=== add .sql to MySQL database ===
=== add .sql to MySQL database ===
mysql -u username -p database_name < file.sql
backup:
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
restore:
mysql -u root -p[root_password] [database_name] < dumpfilename.sql