Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔõÑù½«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µÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

Sqlserver Óï¾äת³ÉMySqlÓï¾ä

Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂð£¿
create table publishers (
publisherID int identity,
publisherName varchar (30) NOT NULL,
constraint pk_publishers primary key (publisherID)
)& ......

mysql root¸ÄÁËÃÜÂ룬ÓÖ×Ô¶¯±äÁË

¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
  1.ÒÔϵͳ¹ ......

mysqlÊý¾Ý¿â - Java / JavaÏà¹Ø

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ