MySql Dump
Import SQL file
# mysqldump -u dbuser -p[pwd]
MySql Dump without data (only structure)--
opt databasename > database_backup.sql
# mysqldump -u dbuser -p[pwd]
or
# mysqldump -u dbuser -p[pwd] -d databasename
MySql Dump without structure (no drop/create table)--
no-data databasename > database_backup.sqlor
# mysqldump -u dbuser -p[pwd] -d databasename
--
no-data > database_backup.sql# mysqldump -u dbuser -p[pwd] --no-create-db --no-create-info databasename > database_backup.sql
mysql -u user_name -p database_name < /path/to/file.sql
No comments:
Post a Comment