Using mysqldump
- The mysqldump utility is a database back-up
+ The mysqldump utility is a database back-up
utility capable of copying everything on a specific MySQL server
— both the structure and the data. It can also be used to copy
a number of databases, one particular database, one or more tables
@@ -294,7 +294,7 @@
‘>’. Since the
option is not specified, it defaults to
localhost. Likewise,
- will default to 33306. Since no password is given at the
+ will default to 3306. Since no password is given at the
command line, you will be prompted for one.
@@ -483,7 +483,7 @@
- shell> mysql -u username -p db_name< dump.sql
+ shell> mysql -u username -p db_name < dump.sql
@@ -627,7 +627,7 @@
Apart from exporting databases in various text formats, it is also
possible to export to other database formats such as MS
- SQL Sever, PostgreSQL, or even to
+ SQL Server, PostgreSQL, or even to
convert to earlier versions of MySQL. This is done using the
option. Using this option makes a best guess at transforming MySQL