Difference between revisions of "MySQL"
Jump to navigation
Jump to search
Rafahsolis (talk | contribs) (Created page with "=== add .sql to MySQL database === mysql -u username -p database_name < file.sql") |
Rafahsolis (talk | contribs) |
||
| Line 1: | Line 1: | ||
=== add .sql to MySQL database === | === add .sql to MySQL database === | ||
| − | mysql -u | + | backup: |
| + | mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql | ||
| + | |||
| + | restore: | ||
| + | mysql -u root -p[root_password] [database_name] < dumpfilename.sql | ||
Revision as of 13:02, 3 August 2015
add .sql to MySQL database
backup:
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
restore:
mysql -u root -p[root_password] [database_name] < dumpfilename.sql