北京建设工程交易服务中心网站,网站做电商资质,如何编写代码,网页设计需要学编程吗mysql 5.1.71升级到5.6.30mysqldump-h主机名 -P端口 -u用户名 -p密码 (–database) 数据库名 文件名.sql备份MySQL数据库的命令mysqldump-hhostname -uusername -ppassword databasename backupfile.sql备份MySQL数据库为带删除表的格式#xff0c;能够让该备份覆盖已…mysql 5.1.71升级到5.6.30mysqldump-h主机名 -P端口 -u用户名 -p密码 (–database) 数据库名 文件名.sql备份MySQL数据库的命令mysqldump-hhostname -uusername -ppassword databasename backupfile.sql备份MySQL数据库为带删除表的格式能够让该备份覆盖已有数据库而不需要手动删除原有数据库。mysqldump-–add-drop-table -uusername -ppassword databasename backupfile.sql直接将MySQL数据库压缩备份mysqldump-hhostname -uusername -ppassword databasename | gzip backupfile.sql.gz备份MySQL数据库某个(些)表mysqldump-hhostname -uusername -ppassword databasename specific_table1 specific_table2 backupfile.sql同时备份多个MySQL数据库mysqldump-hhostname -uusername -ppassword --databases databasename1 databasename2 databasename3 multibackupfile.sql仅仅备份数据库结构mysqldump –-no-data --databases databasename1 databasename2 databasename3 structurebackupfile.sql备份服务器上所有数据库mysqldump –all-databases allbackupfile.sql还原MySQL数据库的命令mysql-hhostname -uusername -ppassword databasename 还原压缩的MySQL数据库gunzip backupfile.sql.gz | mysql -uusername -ppassword databasename将数据库转移到新服务器mysqldump-uusername -ppassword databasename | mysql –host*.*.*.* -C databasename1、备份配置文件[rootwebmaildb01~]#cat /etc/my.cnf | egrep -v ^$|^#[mysqld]skip-name-resolveport 3306skip-external-lockingquery-cache-type 1query-cache-size 64Mquery_cache_limit10Mthread_cache_size 8innodb_file_per_tablessl-cert /etc/pki/tls/certs/iRedMail.crtssl-key /etc/pki/tls/private/iRedMail.keyssl-cipher ALLserver-id 1log_bin /var/log/mysqld/mysql-bin.loglog-slave-updateslog-bin-index /var/log/mysqld/mysqld-log-bin.indexlog-error /var/log/mysqld/error.logrelay-log /var/log/mysqld/relay.logrelay-log-info-file /var/log/mysqld/relay-log.inforelay-log-index /var/log/mysqld/relay-log.indexauto_increment_increment 10auto_increment_offset 1binlog_do_dbamavisdbinlog_do_dbiredadminbinlog_do_dbroundcubemailbinlog_do_dbvmailbinlog-ignore-dbtestbinlog-ignore-dbinformation_schemabinlog-ignore-dbmysqlbinlog-ignore-dbiredapdbinlog-ignore-dbsogobinlog-ignore-dbtestlog-slave-updatesreplicate-ignore-dbtestreplicate-ignore-dbinformation_schemareplicate-ignore-dbmysqlreplicate-ignore-dbiredapd[client]default-character-setutf8[mysqld_safe]log-error /var/log/mysqld/mysqld.log##############################################################[rootwebmaildb02~]#cat /etc/my.cnf | egrep -v ^$|^#[mysqld]port 3306skip-external-lockingquery-cache-type 1query-cache-size 64Mquery_cache_limit10Mthread_cache_size 8innodb_file_per_tablessl-cert /etc/pki/tls/certs/iRedMail.crtssl-key /etc/pki/tls/private/iRedMail.keyssl-cipher ALLskip-name-resolveserver-id 2log_bin /var/log/mysqld/mysqld-bin.loglog-slave-updateslog-bin-index /var/log/mysqld/log-bin.indexlog-error /var/log/mysqld/error.logrelay-log /var/log/mysqld/relay.logrelay-log-info-file /var/log/mysqld/relay-log.inforelay-log-index /var/log/mysqld/relay-log.indexauto_increment_increment 10auto_increment_offset 1binlog_do_dbamavisdbinlog_do_dbiredadminbinlog_do_dbroundcubemailbinlog_do_dbvmailbinlog-ignore-dbtestbinlog-ignore-dbinformation_schemabinlog-ignore-dbmysqlbinlog-ignore-dbiredapdbinlog-ignore-dbsogolog-slave-updatesreplicate-ignore-dbtestreplicate-ignore-dbinformation_schemareplicate-ignore-dbmysqlreplicate-ignore-dbiredapd[client]default-character-setutf8[mysqld_safe]log-error /var/log/mysqld/mysqld.log2、关闭数据库备份全部数据库,和部分数据库表结构######################################################################同时备份多个MySQL数据库mysqldump-hhostname -uusername -ppassword –-databases databasename1 databasename2 databasename3 multibackupfile.sql仅仅备份数据库结构mysqldump –-no-data –-databases databasename1 databasename2 databasename3 structurebackupfile.sql备份服务器上所有数据库mysqldump-uroot -p密码 --all-databases allbackupfile.sql还原MySQL数据库的命令mysql-hhostname -uusername -ppassword databasename 先备份全库mysqldump-uroot -p密码 --all-databases allbackupfile.sql备份mysql,amavisd,iredadmin,iredapd,roundcubemail,vmailmysqldump-uroot -p密码 --databases amavisd iredadmin iredapd roundcubemail vmail mysql multibackupfile.sql备份表结构mysqldump-uroot -p密码 --no-data --databases amavisd iredadmin iredapd roundcubemail vmail mysql structurebackupfile.sql2.1、删除/var/lib/mysql所有文件删除/var/log/mysqld/下的所有的文件3、上传数据包安装升级包如果遇到冲突的包就卸载他,本次遇到的冲突包为mysql-libs4、还原数据库SET PASSWORD PASSWORD(密码);还原MySQL数据库的命令mysql-uroot -p密码mysql source /root/allbackupfile.sql
