Mysql: Difference between revisions
No edit summary |
|||
| Line 16: | Line 16: | ||
<source lang="bash"> | <source lang="bash"> | ||
mysqldump -u FOOUSER > foodump.sql | mysqldump -u FOOUSER FOO > foodump.sql | ||
gzip foodump.sql | gzip foodump.sql | ||
</source> | </source> | ||
Revision as of 16:08, 26 June 2019
Create a database + user for a project
sudo su
mysql -u root
create database FOO;
grant all on FOO.* to FOOUSER@'localhost' identified by 'FOOPASS';
NB: localhost means *really* localhost -- it means that only logins are allowed from the same machine and is a *good idea* for most uses. This creates a database named FOO with user FOOUSER and password FOOPASS;
To dump the database
mysqldump -u FOOUSER FOO > foodump.sql
gzip foodump.sql