mysqlÔ¶³Ì±¸·Ý
н¨backup.bat
ÉèÖÃmysqldumpÈ«¾Ö»·¾³±äÁ¿»òʹÓÃʱдÈë¾ø¶Ô·¾¶
@echo off
set date0=%date:~0,10%
set time0=%time:~0,8%
set time1=%time:~0,2%
set time2=%time:~3,2%
set time3=%time:~6,2%
echo %time0%
echo %time1%
echo %time2%
echo %time3%
mysqldump -u<Óû§> -p<ÃÜÂë> -h <ip> <database> > "·¾¶Îļþ.sql"
Ïà¹ØÎĵµ£º
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Á¬½Óµ½±¾»úÉϵÄMYSQL¡£Ê×ÏÈ´ò¿ªDOS´°¿Ú£¬È»ºó½øÈëĿ¼mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u root -p£¬»Ø³µºóÌáʾÄãÊäÃÜÂë.×¢ÒâÓû§Ãûǰ¿ÉÒÔÓпոñÒ²¿ÉÒÔûÓпոñ£¬µ«ÊÇÃÜÂëǰ±ØÐëûÓпոñ£¬·ñÔòÈÃÄãÖØÐÂÊäÈëÃÜÂë. Èç¹û¸Õ°²×°ºÃMYSQL£¬³¬¼¶Óû§rootÊÇûÓÐÃÜÂëµ ......
ÔÚXAMPPÀïMYSQLÒÔ·þÎñ·½Ê½Æô¶¯Ê§°Ü£¬Ìáʾ´íÎóÊÇ 1067 ½ø³ÌÒâÍâÖÕÖ¹
½â¾ö·½·¨£º
1¡¢ ½øÈë xampp°²×°Ä¿Â¼
2¡¢½øÈëmysql\bin\Ŀ¼£¬ ´ò¿ªmy.ini £¬ ÐÞ¸Ä
[mysqld]
port= 3306
socket= "/xampp/mysql/mysql.sock"
basedir="/xampp/mysql"
tmpdir="/xampp/tmp"
datadir="/xampp/mysql/data"
°Ñ·¾¶²¹È«£¬±ÈÈçx ......
mysql 4.1µÄ¸Ä±äÔì³ÉµÄÂÒÂë½â¾ö·½·¨
µÚÒ»¸ö·½·¨£º
MySQL 4.1 ÖÐÎÄÂÒÂëµÄÎÊÌâ
×î½üÒª½« MySQL 4.0 Éý¼¶µ½ MySQL 4.1 £¬·¢ÏÖÁËÖÐÎÄÂÒÂëµÄÎÊÌ⣬ϣÍûÒÔϼû½â¶Ô´ó¼ÒÓÐÓá£
1. MySQL 4.1 ÔÚÎÄ×ÖÉÏÓкܴó¸Ä½ø£¬ËüÓÐÁË Character Set Óë Collation µÄ¿®Äî¡£
2. ÔÚ MySQL 4.0 £¬Ò»°ãµÄ³Ìʽ¶¼»á½«ÎÄ×ÖÒÔÀ¶¡ÎÄ ( latin) ......
MySQLÒ×ѧÒ×Óã¬ÇÒ¸½´ø·á¸»µÄ¼¼ÊõÎĵµ£¬Õâ¶þ¸öÒòËØÊ¹Ö®±»¹ã·ºÓ¦Óá£È»¶ø£¬Ëæ×ÅMySQL·¢Õ¹Ö®Ñ¸ËÙ£¬¼´Ê¹Ò»¸öMySQLÀÏÊÖÓÐʱҲ»áΪ¸ÃÈí¼þ³öÆä²»ÒâµÄ¹¦ÄܸÐ̾¡£±¾ÎĽ«ÎªÄã½éÉÜÕâЩ²»ÎªÈËÖªµÄÌØÐÔ¡£
ÒÔXML¸ñʽ²é¿´²éѯ½á¹û
ͨ¹ýʹÓô«Í³—xml
Ñ¡Ïîµ÷ÓÃMySQLÃüÁîÐпͻ§³ÌÐò£¬Äã¿ÉÒÔÒÔXML¸ñʽ(¶ø²»ÊÇ´«Í³µÄÁбíÐÎʽ)À´²é¿´M ......
1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......