MySQL Import-Export Database-mac version, mysql-mac

MySQL Import-Export Database-mac version, mysql-mac
MySQL Import-Export Database-mac

• Export Database-table structure, and data

Mysqldump-u account-p database name table> file name. SQL

For example:Mysqldump-u root-p testdatabase tablename> test. SQL

Enter the password.

• Export table structure

Mysqldump-u account-p Database Name-DTable> file name. SQL

For example:Mysqldump-u root-p test-d indicant_of_day_by_time> test. SQL

Enter the password.

• Import data to view the table structure

Mysqldump-u account-p Database Name<File Name. SQL

For example:Mysql-u root-p test<Test. SQL