Default Applies to interactive and batch mode. This option can be given multiple times to produce less and less output. This option results in nontabular output format and escaping of special characters. See --auto-rehash. See --column-names.
Set by default, see --comments to enable. See --line-numbers. See --progress-reports. See --reconnect. Starting with MariaDB In order to verify the server certificate, the user must specify the --ssl-verify-server-cert option. This option requires that you use the absolute path, not a relative path. This option implies the --ssl option. The directory specified by this option needs to be run through the openssl rehash command. This option is only supported if the client was built with OpenSSL.
This is the default for interactive use, but can be used to produce table output in batch mode. Does not work in batch mode. Disable with --disable-tee. A TLS protocol version will only be enabled if it is present in this list. All other TLS protocol versions will not be permitted. This option was added in MariaDB See the mysqldump --xml option for more. Option Description --print-defaults Print the program argument list and exit. Available starting with MariaDB For example, mysqldump.
This is useful for options like socket and port, which is common between the server and the clients. Command Description? Optional arguments are db and host. Same as quit. Execute an SQL script file. Takes a file name as an argument. Execute a system shell command. Only works in Unix-like systems. Append everything into given outfile. Takes database name as argument. Might be needed for processing binlog with multi-byte charsets. Comments loading Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB.
The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party. Enable automatic rehashing. No automatic rehashing. Print results using tab as the column separator, with each row on a new line. Directory for character set files. Write column names in results. Preserve comments. Notify the server that this client is prepared to handle expired password sandbox mode even if --batch was specified.
On debugging builds, write a debugging log. Set the default character set. Execute statement and quit. Ignore space after function names. Write line numbers for errors. The maximum packet length to send to or receive from server. Enable named commands. Ignore statements except those those that occur while the default database is the one named on the command line. Pager to use to display results Unix only. Password to use when connecting to server.
Port number to use for connection or 0 for default to, in order of preference, my. Share on pinterest. Share on whatsapp. Share on email. Related articles. Hypervisors: definition, types and open source and commercial solutions.
Linux: from a hobby to a collaborative tech revolution. We use cookies to provide you with the best experience in our website. Read our privacy policy. Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website.
Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. This makes it easier to transfer and move databases.
The command will produce no visual output, but you can inspect the contents of data-dump. If any errors occur during the export process, mysqldump will print them to the screen.
This database will hold the imported data. First, log in to MySQL as root or another user with sufficient privileges to create new databases:. This command will bring you into the MySQL shell prompt. Next, create a new database with the following command.
From the normal command line, you can import the dump file with the following command:. If any errors occur during the process, mysql will print them to the terminal instead.
To check if the import was successful, log in to the MySQL shell and inspect the data. You then imported that data dump into a new database. You can learn more about from the official mysqldump documentation page. I like making impossible things possible. And I need tea. Where would you like to share this to?
0コメント