1.首先进入shell~2.进入服务器后,输入mysql -h localhost -u root -p,进入MySql; 3.输入MySql密码;4.将脚本复制到服务器,具体怎么做,可以用Xftp;5.例如,我执行的test.sql,在/usr/local/test.sql目录下,在shell中输入source
/usr/local/test.sql原文:http://www.cnblogs.com/xinma/p/xinma.html
打开powerdesigner,选择File --> Reverse Engineer --> Database……Model name是模型名称,DBMS选MySQL 5.0然后确定在Selection选项卡中选:Using scripts files:添加刚才的导出的sql脚本(wpblog.sql)Options选项卡中的File Encoding 选择:UTF8+QuickDetect,应该导入进来了。原文:http://www.cnblogs.com/smiler/p/6811206.html
简述InstallShield已经内建了对MySQL和Oracle的支持。但是这个功能是通过ODBC实现的,它对SQL脚本的格式要求非常严格,因此已经通过官方客户端测试的脚本在IS中执行时往往就会报错。一般来说,数据库脚本只保证通过官方客户端测试即可,同时维护一份供IS执行的脚本费时费力。因此,考虑安装程序对两数据库的支持通过官方客户端实现。MySQL function InstallMySQLComponent(szComponent)NUMBER nResult;STRING szServer,szDB,szUse...
1.查省2.查市3.查区4.Mysql脚本/*
Navicat MySQL Data TransferSource Server : MySQL
Source Server Version : 50022
Source Host : 127.0.0.1:3306
Source Database : xljTarget Server Type : MYSQL
Target Server Version : 50022
File Encoding : 65001Date: 2014-07-19 21:22:47
*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for china
-- ---------...
CREATE PROCEDURE `insertMenu14`()
BEGINDECLAREmenuCount INT;DECLAREmidStr VARCHAR(64);SELECTcount( 1 ) INTO menuCount FROMsys_menu WHEREMenuNo = ‘MeiTuanMarket‘;SELECTid INTO midStr FROMsys_menu WHEREMenuNo = ‘Market‘;IFmenuCount = 0 THENINSERT INTO `sys_menu` (`ID`, `ParentId`, `MenuNo`, `MenuName`, `MenuType`, `MenuIcon`, `LinkAddr`, `Target`, `SortIndex`, `IsDelete`, `IsEnabled`, `IsShow`,...
我正在尝试从命令行运行一些mysql脚本.一个是自动生成的,它不会事先选择数据库.现在我有两个脚本:mysql -u <user> -p<password> < script1.sql
mysql -u <user> -p<password> < script2.sqlscript1的最后一行是USE mydatabase;但是当我运行script2时,它表示没有选择数据库.有没有办法指定用于script2的数据库?解决方法:像这样添加参数-Dmysql -u<username> -p<password -D<database> < script.sql
代码如下:// Name of the file$filename = 'churc.sql';// MySQL host$mysql_host = 'localhost';// MySQL username$mysql_username = 'root';// MySQL password$mysql_password = '';// Database name$mysql_database = 'dump';// Connect to MySQL servermysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());// Select databasemysql_select_db($mysql...
MySQL备份脚本,mysql脚本mysqlbackup.php:php//备份mysqlset_time_limit(0);date_default_timezone_set('PRC');//配置$configs = array('host1'=>array('localhost','root','root',array(), //为空备份全部数据库,否则备份这些数据库'D:/xampp/mysql/bin/mysqldump', //备份工具dirname(__FILE__)."/localhost", //目录加主机名5, //删除前5天的SQL文件),);foreach($configs as $config) {$logsfile = $config[5].'/'.date...
代码如下:// Name of the file$filename = 'churc.sql';// MySQL host$mysql_host = 'localhost';// MySQL username$mysql_username = 'root';// MySQL password$mysql_password = '';// Database name$mysql_database = 'dump';// Connect to MySQL servermysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());// Select databasemysql_select_db($mysql...
代码如下:// Name of the file$filename = 'churc.sql';// MySQL host$mysql_host = 'localhost';// MySQL username$mysql_username = 'root';// MySQL password$mysql_password = '';// Database name$mysql_database = 'dump';// Connect to MySQL servermysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());// Select databasemysql_select_db($mysql...
代码如下:<?php// Name of the file$filename = 'churc.sql';// MySQL host$mysql_host = 'localhost';// MySQL username$mysql_username = 'root';// MySQL password$mysql_password = '';// Database name$mysql_database = 'dump';// Connect to MySQL servermysql_connect($mysql_host, $mysql_username, $mysql_password) or die('Error connecting to MySQL server: ' . mysql_error());// Select databasemysql_select_db($...
代码如下:#!/usr/bin/python import os import time import ftplib import traceback #config vars systempathchr="/" #路径分割符,*nix用"/" win32用"\\" dbuser="root" #数据库用户名 dbpwd="dbpwd" #数据库密码 dbnamelist=["dbone","dbtwo","dbthree"] #需要备份那些数据库 workdir="/path/to/backup/" #本地备份文件夹 errlogfile="databack.log" #错误日志名 ftp_addr="192.168.0.2" #ftp地址 ftp_port="2102"...
source C:/users/liaolongjun/Desktop/miduo_fileinfo.sql;
注意,必须是正斜杆。
如果是反斜杆,那么会报错,但也会执行。
mysql> LOAD DATA LOCAL INFILE "C:/users/liaolongjun/desktop/llj.txt" INTO TABLEllj;
路径要引起来。
MySQL执行sql脚本标签:本文系统来源:http://www.cnblogs.com/liaolongjun/p/4493116.html
开整: 注释都用英文写了,有些英语基础的朋友应该都可以看得懂了!#!/usr/bin/env python
#backup the gtshop
#author:ley
#encoding=utf8
#date:2015-06import os,sys,datetime,time
from stat import *#mysqlbackup user
User = ‘root‘#mysqlbackup passwordPassword = ‘root‘#mysqlbackup commandMysqlcommand = ‘/usr/local/mysql/bin/mysqldump‘#gzip command Gzipcommand = ‘/bin/gzip‘#backup mysql databaseMysq...
#只运行,不导出
mysql> source /home/user/to_run.sql;#导出
$ mysql -h host -u user -ppassword database < to_run.sql | sed ‘s/\t/,/g‘ > out.csvmysql 运行sql脚本文件标签:本文系统来源:http://www.cnblogs.com/lein-wang/p/4580987.html