Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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"


Ïà¹ØÎĵµ£º

MySQLµÄcµ÷ÓÃ


1. ¸½¼ÓÏîÒ»¶¨ ¼ÓÉÏlibmysql.lib¡£
2. include Ò»¶¨¼ÓÉÏ mysqlµÄinclude£¨ÒòΪҪÅÜÕâ¹Ø¼üÒ»¾ä
#include <mysql.h>£©
3  lib Ò»¶¨¼ÓÉÏ mysqlµÄlib
 
ºÃÁËÏÂÃæÊÇʵÀýºÍphpº¯Êý»ù±¾Ò»ÑùµÄ¡£±¾È˲»¿ÉÄܸøÄã·­ÒëÎĵµ£¬º¯Êý²»¶®×Ô¼º¿´¡£
#include
<windows.h>//ÓÃÕâ¸ö·½±ã£¬°üº¬winsock.hËùÒ ......

mysqlµÄmaster/slaveÊý¾Ýͬ²½ÅäÖÃ[ת]

ÎҵIJâÊÔ»·¾³.»ù±¾ÉÏÊý¾ÝÊÇ˲¼äͬ²½£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú

redhat 9.0
mysql3.23.57


mysqlÊý¾Ýͬ²½±¸·Ý

A·þÎñÆ÷£º 192.168.1.2 Ö÷·þÎñÆ÷master
B·þÎñÆ÷£º 192.168.1.3 ¸±·þÎñÆ÷slave


A·þÎñÆ÷ÉèÖÃ

#mysql –u root –p
mysql>GRANT FILE ON *.* TO backup@192.168.1 ......

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 3

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, but most of the steps ought to be valid for all
Linux-like operating ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ