[ BASICS.MYSQL ]

[ BASICS.MYSQL ]

# DUMP ALL MYSQL DB TO DESKTOP
mysqldump -u root -MySqlservername.or.ip --all-databases > /home/server/Desktop/dump.sql

# DUMP ONE MYSQL DB
mysqldump -u root -MySqlservername.or.ip rsyslog > rsyslog.sql

# DUMP MANY MYSQL DB
mysqldump -u root -MySqlservername.or.ip --databases rsyslog syslog > rsyslog_syslog.sql

# DUMP MYSQL DB STRUCTURE ONLY NO DATA
mysqldump -u root -MySqlservername.or.ip -–no-data rsyslog > rsyslog_structure.sql

# DUMP MYSQL DB DATA ONLY
mysqldump -u root -MySqlservername.or.ip --no-create-db --no-create-info rsyslog > rsyslog_data.sql

# DUMP ONE TABLE FROM ONE MYSQL DB
mysqldump -u root -MySqlservername.or.ip wordpress wp_posts > wordpress_posts.sql

# DUMP MANY TABLES OF MYSQL DB
mysqldump -u root -MySqlservername.or.ip wordpress wp_posts wp_comments > wordpress_posts_comments.sql

# DUMP REMOTE MYSQL DB
mysqldump -h 172.16.25.126 -u root -ptecmint gallery > gallery.sql

# MYSQL EXT DB IMPORT
# IMPORT EXT MYSQL DB LOCALLY
mysqlimport -u root -MySqlservername.or.ip rsyslog < rsyslog.sql