Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # To export to file (data only)
- mysqldump -u [user] -p[pass] -h host --column-statistics=0 --no-create-info mydb > mydb.sql
- # To export to file (structure only)
- mysqldump -u [user] -p[pass] -h host --column-statistics=0 --no-data mydb > mydb.sql
- # To import to database
- mysql -u [user] -p[pass] mydb < mydb.sql
Add Comment
Please, Sign In to add comment