Skip to content

Instantly share code, notes, and snippets.

@crazyyy

crazyyy/_readme.md

Last active September 20, 2023 23:07
Show Gist options
  • Save crazyyy/2e9875faf5c3f88c596b43ef382fdccd to your computer and use it in GitHub Desktop.
Save crazyyy/2e9875faf5c3f88c596b43ef382fdccd to your computer and use it in GitHub Desktop.
Download ZIP
#mysql #sql || mysql gists
Raw
_readme.md

Mysql

Import from commandline

mysql --host=localhost.mysql.ihc.ru --user=user_name --database=database_name --password=password > database.sql
mysql -h localhost.mysql.ihc.ru -u user_name -D database_name -p password < database.sql
mysql --host="localhost.mysql.ihc.ru" --user="user_name" --password="password" --database="database_name" < db.sql

Export from commandline

mysql -h localhost -u user_name -D database_name -p password > database.sql
mysql -h localhost.mysql.ihc.ru -u user_name -D database_name -p password > database.sql
mysqldump -u DBUSER -p DBNAME > database2.sql
mysqldump -u DBUSER -p -databases DBNAME1 DBNAME2 DBNAME3 > database2.sql
mysqldump -u DBUSER -p –all-databases > database2.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment