Tag: mysqldump
Mysqldump is a command-line utility used for creating backups of MySQL databases by exporting their contents into SQL format, allowing for easy restoration or migration.
-
mysqldump: how to use a specific port
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. By default, the mysqldump command uses the port 3306 to connect to the database. To use a different port, you can provide the –port (or -P) option followed by the port number…
-
mysqldump: how to exclude or include tables
mysqldump is a command-line tool used for creating database backups in MySQL. By default, mysqldump includes all tables of the specified database when creating the dump. In some cases, it is useful to exclude some of the tables or even include only some of them. For me, this helped to exclude one of the biggest…