Difference between revisions of "MySQL"
Jump to navigation
Jump to search
Rafahsolis (talk | contribs) |
Rafahsolis (talk | contribs) |
||
| Line 2: | Line 2: | ||
backup: | backup: | ||
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql | mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql | ||
| + | backup .sql.gz | ||
| + | mysql -uroot -ppassword mydb > myfile.sql.gz | ||
restore: | restore: | ||
Revision as of 06:32, 6 August 2015
add .sql to MySQL database
backup:
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
backup .sql.gz
mysql -uroot -ppassword mydb > myfile.sql.gz
restore:
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