dumping sql table 1

dumping sql table

mysqldump -u username -ppassword database_name table_name > single_table_dump.sql

Here is what the above code is Doing:
1. The -u flag specifies the username.
2. The -p flag tells MySQL to prompt for a password.
3. The database_name is the name of the database you want to back up.
4. The table_name is the name of the table you want to back up.
5. The > single_table_dump.sql tells MySQL to write the output to a file named single_table_dump.sql.

Similar Posts