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
Written by
To use a specific port with the mysqldump command, you can provide the –port (or -P) option followed by the port number you want to use. The –port option specifies the TCP/IP port number to use when connecting to the MySQL server. When using -P remember to use an uppercase P, because the lowercase option…
-
mysqldump: how to exclude or include tables
Written by
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…