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


Ïà¹ØÎĵµ£º

¡¶PHP Óë MySQL Web ¿ª·¢¡·¶ÁÊé±Ê¼Ç £¨Ò»£©

¸ÅÊö
1.PHP ÊÇʲô£¿
   PHP ÊÇ·þÎñÆ÷¶Ë½âÊ͵Ľű¾ÓïÑÔ£¬ËüÊÇĿǰ×îÁ÷ÐÐµÄ web ±à³ÌÓïÑÔÖ®Ò»¡£  ÔÚÒ»¸ö HTML Ò³ÃæÖпÉÒÔǶÈëPHP´úÂ룬ÕâЩ´úÂëÔÚÿ´ÎÒ³Ãæ·ÃÎÊʱִÐС£PHP ´úÂ뽫ÔÚ Web ·þÎñÆ÷Öб»½âÊͲ¢ÇÒÉú³É HTML»òÕß·ÃÎÊÕß¿´µ½ÆäËûÊä³ö½á¹û¡£
2.My SQL ÊÇʲô£¿
   My SQL ÊÇ»ùÓÚ SQL µÄÍê ......

sudo gem install mysql³ö´íµÄ½â¾ö·½·¨

Installing the MySQL Driver
ÏȲ鿴ËùȱʧµÄÏà¹Ø°ü£º
$ apt-cache search libmysqlclient
libcrypt-mysql-perl - Perl module to emulate the MySQL PASSWORD() function.
libglpk0 - linear programming kit with integer (MIP) support
libmysqlclient16 - MySQL database client library
libmysqlclient16-dev - ......

ÐÞ¸ÄMYSQLÃÜÂëºÍÃÜÂëÆÆ½âµÄ³£Ó÷½·¨

·½·¨Ò»
ʹÓÃphpmyadmin£¬ÕâÊÇ×î¼òµ¥µÄÁË£¬ÐÞ¸Ämysql¿âµÄuser±í£¬²»¹ý±ðÍüÁËʹÓÃPASSWORDº¯Êý¡£
·½·¨¶þ
ʹÓÃmysqladmin£¬ÕâÊÇÇ°ÃæÉùÃ÷µÄÒ»¸öÌØÀý¡£
mysqladmin -u root -p password mypasswd
ÊäÈëÕâ¸öÃüÁîºó£¬ÐèÒªÊäÈërootµÄÔ­ÃÜÂ룬ȻºórootµÄÃÜÂ뽫¸ÄΪmypasswd¡£
°ÑÃüÁîÀïµÄroot¸ÄΪÄãµÄÓû§Ãû£¬Äã¾Í¿ÉÒ ......

ÈçºÎÌá¸ßMySQLÐÔÄÜ

Ò»¡¢ÎÊÌâµÄÌá³ö

¡¡¡¡ÔÚÓ¦ÓÃϵͳ¿ª·¢³õÆÚ£¬ÓÉÓÚ¿ª·¢Êý¾Ý¿âÊý¾Ý±È½ÏÉÙ£¬¶ÔÓÚ²éѯSQLÓï¾ä£¬¸´ÔÓÊÓͼµÄµÄ±àдµÈÌå»á²»³öSQLÓï¾ä¸÷ÖÖд·¨µÄÐÔÄÜÓÅÁÓ£¬µ«ÊÇÈç¹û½«Ó¦ÓÃϵͳ
Ìύʵ¼ÊÓ¦Óúó£¬Ëæ×ÅÊý¾Ý¿âÖÐÊý¾ÝµÄÔö¼Ó£¬ÏµÍ³µÄÏìÓ¦ËٶȾͳÉΪĿǰϵͳÐèÒª½â¾öµÄ×îÖ÷ÒªµÄÎÊÌâÖ®Ò»¡£ÏµÍ³ÓÅ»¯ÖÐÒ»¸öºÜÖØÒªµÄ·½Ãæ¾ÍÊÇSQLÓï¾äµÄÓÅ»¯¡£ ......

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ºÅ