win_linux_db_bak

注意： win mysql 安装不要有空格

 

@echo off
C:/Program_Files/MySQL/MySQL_Server_5.1/bin/mysqladmin -u root --password=admin shutdown
C:/Program_Files/MySQL/MySQL_Server_5.1/bin/mysqldump --opt -u root --password=admin test_nzc > D:/bbs.sql

C:/Program_Files/MySQL/MySQL_Server_5.1/bin/mysqld-nt

 

win rar bak -db.data :

 

net stop mysql

del d:/mysql/data /q

c:/progra~1/winrar/winrar a -ag -k -r -s d:/mysql.rar C:/Program Files/MySQL/MySQL Server 5.0/data

net start mysql

 

 

 

linux sh db_bak:

 

#!/bin/bash
#innoDB
#backup database to dir : /opt/backup/db

bak_home = /opt/backup/db
mysqlid="test_manager"
mysql_alias=test_manager
year='date+%Y'
month='date+%m'
day='date+%d'

datenow=$year$month$day
mysql_name=$mysql_alias$datenow
mysqldump -hsh4-dt-517 -uroot -padmin --opt -R --single-transaction $mysqlid >$bak_home/$mysql_name.sql
tar fzc $bak_home/$mysql_name.tar.gz $bak_home/$mysql_name.sql
rm $bak_home/$mysql_name.sql
find $bak_name/*.tar.gz -mtime + 30 -exec rm -f {}/;

 

 

 

 

package com.marvell.testmanager.conf;import java.io.IOException;public class BackDatabase {public static final String user = "root";public static final String password = "admin";public static final String database = "test_manager";public static final String bak_home = "d://test_manager2";public static void backup() {StringBuffer buff = new StringBuffer();buff.append(" mysqldump ");buff.append(database);buff.append(" -h sh4-dt-517 ");buff.append(" -u " + user);buff.append(" -p " + password);buff.append(" --default-character-set=utf8");buff.append(" --result-file=" + bak_home);buff.append(" --opt -R ");try {Runtime.getRuntime().exec(buff.toString());System.out.println("Data have been derived to file : " + bak_home );} catch (IOException e) {e.printStackTrace();}}public static void main(String[] args) {backup();}}

 

 

 

备份MySQL数据库的命令

mysqldump -hhostname -uusername -ppassword databasename > backupfile.sql

备份MySQL数据库为带删除表的格式
备份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 < backupfile.sql

还原压缩的MySQL数据库

gunzip < backupfile.sql.gz | mysql -uusername -ppassword databasename

将数据库转移到新服务器

mysqldump -uusername -ppassword databasename | mysql –host=*.*.*.* -C databasename