Skip to content

Instantly share code, notes, and snippets.

@st4lk
Created October 26, 2012 10:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save st4lk/3958188 to your computer and use it in GitHub Desktop.
Save st4lk/3958188 to your computer and use it in GitHub Desktop.
MySQL: dump database
1)Создание базы для Django:
CREATE DATABASE database_name CHARACTER SET utf8;
CREATE USER 'user_name'@'localhost' IDENTIFIED BY 'user_password';
GRANT ALL ON database_name.* TO 'user_name'@'localhost';
2) Дамп базы
Сохранение: mysqldump -u имя_пользователя -p -h имя_сервера_БД имя_базы > dump.sql
Восстановление: mysql -u имя_пользователя -p -h имя_сервера_БД имя_базы < dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment