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

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"


Ïà¹ØÎĵµ£º

XamppÀïMysql·þÎñÆô¶¯²»ÆðÀ´£¬´íÎó1067

 ÔÚ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ÄÄЩÐèÒªÄãÖªµÀ

MySQLµÄ»ù±¾ÃüÁî
¡¡¡¡[ ]ÖеÄÄÚÈÝΪ¿ÉÑ¡Ïî
¡¡¡¡--´´½¨Êý¾Ý¿â
¡¡¡¡mysql> create database Êý¾Ý¿âÃû³Æ
¡¡¡¡--´´½¨±í
¡¡¡¡mysql> create table ±íÃû (
¡¡¡¡ÁеÄÃû×Ö£¨id£©ÀàÐÍ£¨int£¨4£©£©primary key(¶¨ÒåÖ÷¼ü) auto_increment£¨ÃèÊö ×ÔÔö£©,
¡¡¡¡……£¬
¡¡¡¡£©£»
¡¡¡¡--²é¿´ËùÓÐÊý¾Ý¿â
¡¡¡¡mys ......

MySQLÊ®ÌõÌØÊâ¼¼ÇÉ

MySQLÒ×ѧÒ×Óã¬ÇÒ¸½´ø·á¸»µÄ¼¼ÊõÎĵµ£¬Õâ¶þ¸öÒòËØÊ¹Ö®±»¹ã·ºÓ¦Óá£È»¶ø£¬Ëæ×ÅMySQL·¢Õ¹Ö®Ñ¸ËÙ£¬¼´Ê¹Ò»¸öMySQLÀÏÊÖÓÐʱҲ»áΪ¸ÃÈí¼þ³öÆä²»ÒâµÄ¹¦ÄܸÐ̾¡£±¾ÎĽ«ÎªÄã½éÉÜÕâЩ²»ÎªÈËÖªµÄÌØÐÔ¡£
ÒÔXML¸ñʽ²é¿´²éѯ½á¹û
ͨ¹ýʹÓô«Í³—xml
Ñ¡Ïîµ÷ÓÃMySQLÃüÁîÐпͻ§³ÌÐò£¬Äã¿ÉÒÔÒÔXML¸ñʽ(¶ø²»ÊÇ´«Í³µÄÁбíÐÎʽ)À´²é¿´M ......

mysql³£ÓÃÃüÁî

1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......

how to install apache, PHP and MySQL on Linux

how to install apache, PHP and MySQL on Linux
This tutorial explains the installation of Apache web server, bundled with PHP and MySQL server on a Linux machine. The tutorial is primarily for SuSE 9.2, 9.3, 10.0 & 10.1 operating systems, but most of the steps ought to be valid for all Linux-lik ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ