Permissions for import and export of MySQL databases and liunx

1. Export the entire database

Mysqldump-u user name-p database name > exported file name

Mysqldump-u wcnc-p SMGP_APPS_WCNC > Wcnc.sql

2. Export a table

Mysqldump-u user name-P database name Table name > exported file name

Mysqldump-u wcnc-p SMGP_APPS_WCNC users> wcnc_users.sql

3. Export a database structure

Mysqldump-u Wcnc-p-D--add-drop-table SMGP_APPS_WCNC >d:wcnc_db.sql

-D No data--add-drop-table add a drop table before each CREATE statement

4. Import Database

Common source Commands

Enter the MySQL database console,

such as Mysql-u root-p

Mysql>use Database

Then use the source command, followed by the script file (such as the. SQL used here)

Mysql>source D:wcnc_db.sql

Alan found that sometimes source will appear garbled, especially under the Liunx, you can also import

Import Database Mysql-u root-p Dbmane < Db.sql;

=====================================

In addition to the order to organize the Liunx permission, each time to be a directory of the permissions

-RWX------: equals the number representing 700.

-rwxr-r--: equals the number representing 744.

-rw-rw-r-x: equals the number representing 665.

Drwx-x-x: equals the number representing 711.

DRWX------: equals the number representing 700.

chmod 777/home/user Single Directory permissions

Chmod-r 777/home/user All subdirectories