ÔõÑù½«MySQLÊý¾Ý¿â±¸·ÝÎļþÓÃʱ¼äÃüÃû
ÔõÑù½«MySQLÊý¾Ý¿â±¸·ÝÎļþÓÃʱ¼äÃüÃû ¸÷λ´óϺ Ö¸µãÏ ×îºÃÊÇ´úÂë »òÕßʵÀý!
±¸·ÝÎļþÄã°®ÔõôÃüÃû²»¾ÍÔõôÃüÃûÂð£¿ÕâÓÐʲôÎÊÌâÄØ¡£
Java code:
// ¶ÁÈ¡ÊôÐÔÖµ
public static Properties getPprVue(String properName) {
InputStream inputStream = mysql_util.class.getClassLoader().getResourceAsStream(properName);
Properties p = new Properties();
try {
p.load(inputStream);
inputStream.close();
} catch (IOException e) {
e.printStackTrace();
}
return p;
}public String backupMysql() {
Properties pros = getPprVue("prop.properties");
// ÕâÀïÊǶÁÈ¡µÄÊôÐÔÎļþ£¬Ò²¿ÉÒÔÖ±½ÓʹÓÃ
String username = pros.getProperty("username");
String password = pros.getProperty("password");
// µÃµ½MYSQLµÄÓû§ÃûÃÜÂëºóµ÷Óà mysql µÄ cmd:
String mysqlpaths = pros.getProperty("mysqlpath");
String databaseName = pros.getProperty("databaseName");
String address = pros.getProperty("address");
String sqlpath = pros.getProperty("sql");
File backupath = new File(sqlpath);
if (!backupath.exists()) {
backupath.mkdir();
}
StringBuffer sb = new StringBuffer();
sb.app
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......