Linux commands used in peacetime

Backup database: Mysqldump–uroot (root username)-p123 (123 password) phpbb_db_backup (select backed up database) >/usr/backups/mysql/db_ Backup2008-1-6.sql (backup path and generated file name);

Tip:-u-p is a format;

Restore Database: mysql–uroot-p123 db_backup (database name) </usr/backups/mysql/db_backup2008-1-6.sql (backup file)

Restore the database in the MySQL command: First enter the database source/tmp/db_name.sql (SQL file path) to be imported;

Create folder: mkdir Lemon (folder name);

Remote Copy folder and file: scp-r [email protected] (' Remote server IP '):/(remote file root) test.sql (remote folder or file)./pub/(the path of the current server);

Linux commands used in peacetime