易截截图软件、单文件、免安装、纯绿色、仅160KB

mysql数据库备份

E:\databases\MySQL\MySQL Server 5.1\bin>mysqldump --help
mysqldump  Ver 10.13 Distrib 5.1.30, for Win32 (ia32)
By Igor Romanenko, Monty, Jani & Sinisa
This software comes with ABSOLUTELY NO WARRANTY. This is free softwa
and you are welcome to modify and redistribute it under the GPL lice
Dumping definition and data mysql database or table
Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
Default options are read from the following files in the given order
C:\WINDOWS\my.ini C:\WINDOWS\my.cnf C:\my.ini C:\my.cnf E:\databases
 Server 5.1\my.ini E:\databases\MySQL\MySQL Server 5.1\my.cnf
The following groups are read: mysqldump client
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit
--no-defaults           Don't read default options from any options
--defaults-file=#       Only read default options from the given fil
--defaults-extra-file=# Read this file after the global files are re
  -a, --all           Deprecated. Use --create-options instead.
  -A, --all-databases Dump all the databases. This will be same as -
                      with all databases selected.
  -Y, --all-tablespaces
                      Dump all the tablespaces.
  -y, --no-tablespaces
                      Do not dump any tablespace informati


相关文档:

VC用MYSQL提供的LIB查询数据库

#include "winsock.h"
#include "mysql.h"
void query_example(void)
{
MYSQL *pDbCon = NULL;
char *pszHost = "localhost";
char *pszUser = "guest";
char *pszPsw = "";
char *pszDbName = "mysql_db_name";
int iPort = 3306;
pDbCon = mysql_init((MYSQL*) 0);
if (NULL != pDbCon)
{ ......

Amfphp与Flex交互:读取mysql数据

服务器端代码,amfphp的services目录下建立readData.php文件,代码如下
<?php
    class ReadDB
    {
              function getData()
            &nb ......

Mysql_命令归类 91KGE

.连接mysql    mysql -uroot -padmin -hlocalhost
.连接mysqladmin命令行客户端程序 mysqladmin -uroot -padmin -hlocalhost
.启动mysql   mysqld
.关闭  mysqladmin -uroot -padmin -hlocalhost shutdown
.修改密码
set password for 'root'@'localhost' = password('admin')
update ......

LAMP(Linux+Apache+Mysql+PHP)部署日志

本文记录一下本人安装LAMP的全过程
本人使用的Linux为RedHat Enterprise 5 X64
第一步:安装Mysql
Mysql的安装比较简单,为了避免出现文件找不到的情况,我依次下载安装了以下4个RPM包
MySQL-server-community-5.1.46-1.rhel5.x86_64.rpm
MySQL-client-community-5.1.46-1.rhel5.x86_64.rpm 
MySQL-devel-commu ......

mysql中中字符串截取函数

MySQL 字符串截取函数:left(), right(), substring(), substring_index()。还有 mid(), substr()。其中,mid(), substr() 等价于 substring() 函数,substring() 的功能非常强大和灵活。 1. 字符串截取:left(str, length) mysql> select left('sqlstudy.com', 3);+-------------------------+| left('sqlstudy.com', 3) | ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号