mysqldump -u root -pmysql -h localhost table_schema_name table_name > file_name.sql
mysqldump -u root -pmysql -h localhost table_schema_name table_name_1 table_name_2.. > file_name.sql
mysqldump -u root -pmysql -h localhost table_schema_name table_name --no-data > file_name.sql
-- How to take
in
different way
SHOW CREATE TABLE table_name;
mysqldump -u root -pmysql -h localhost table_schema_name table_name --no-create-info > file_name.sql
mysqldump -u root -pmysql -h from_host from_db table_name | mysql -u root -pmysql -h to_host to_db
mysqldump -u root -pmysql db_name table_name --where=
"id > 1000"
> file_name.sql
mysqldump -u root -pmysql db_name --ignore-table=table_name_1 --ignore-table=table_name_2 > file_name.sql
Do you want to delete a "" lesson. Warning! This delete will remove all it's sub lessons and contents.
Do you want to delete a "" sub lesson. Warning! This delete will remove all it's contents.
Do you want to delete content.
Do you want to remove selected book from favorite books.
Do you want to delete selected author from your authors list.
