win

注意： 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