跟着ArthurXF学FreeBSD28——vi替换命令用法详解
开源测试工具的完整解决方案
2007/08/01 21:53
1.从postgresql导出表结构，例如下面的结构
2.选择出最重要的建表语句到mysql的数据库中执行，例如将下面的内容进行执行：
特别注意：如果表名有双引号的，一定要去除。
3.从postgresql导出表纯数据，导出SQL格式的数据文件，例如：
4.使用vi删除sql文件中下面的内容：
如果有必要，就是使用vi替换命令:% s/"/`/g，将"替换成`符号。
5.登录mysql,转换到你要导入的数据库，执行sql文件即可完成导入，下面例子仅作参考：
引用
--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: classes; Type: TABLE; Schema: public; Owner: jobzone; Tablespace:
--
CREATE TABLE classes (
cid smallint NOT NULL,
gid character(1) NOT NULL,
cname character varying(100) NOT NULL
);
ALTER TABLE public.classes OWNER TO jobzone;
--
-- Name: pk_classes; Type: CONSTRAINT; Schema: public; Owner: jobzone; Tablespace:
--
ALTER TABLE ONLY classes
ADD CONSTRAINT pk_classes PRIMARY KEY (gid, cid);
--
-- Name: fk_classes_reference_groups; Type: FK CONSTRAINT; Schema: public; Owner: jobzone
--
ALTER TABLE ONLY classes
ADD CONSTRAINT fk_classes_reference_groups FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- PostgreSQL database dump complete
--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: classes; Type: TABLE; Schema: public; Owner: jobzone; Tablespace:
--
CREATE TABLE classes (
cid smallint NOT NULL,
gid character(1) NOT NULL,
cname character varying(100) NOT NULL
);
ALTER TABLE public.classes OWNER TO jobzone;
--
-- Name: pk_classes; Type: CONSTRAINT; Schema: public; Owner: jobzone; Tablespace:
--
ALTER TABLE ONLY classes
ADD CONSTRAINT pk_classes PRIMARY KEY (gid, cid);
--
-- Name: fk_classes_reference_groups; Type: FK CONSTRAINT; Schema: public; Owner: jobzone
--
ALTER TABLE ONLY classes
ADD CONSTRAINT fk_classes_reference_groups FOREIGN KEY (gid) REFERENCES groups(gid) ON UPDATE RESTRICT ON DELETE RESTRICT;
--
-- PostgreSQL database dump complete
--
2.选择出最重要的建表语句到mysql的数据库中执行，例如将下面的内容进行执行：
引用
CREATE TABLE classes (
cid smallint NOT NULL,
gid character(1) NOT NULL,
cname character varying(100) NOT NULL
);
cid smallint NOT NULL,
gid character(1) NOT NULL,
cname character varying(100) NOT NULL
);
特别注意：如果表名有双引号的，一定要去除。
3.从postgresql导出表纯数据，导出SQL格式的数据文件，例如：
引用
--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
--
-- Data for Name: classes; Type: TABLE DATA; Schema: public; Owner: jobzone
--
INSERT INTO classes VALUES (2750, 'C', '生物制品业');
INSERT INTO classes VALUES (4183, 'C', '电子计算机修理业');
INSERT INTO classes VALUES (100, 'A', '农业');
INSERT INTO classes VALUES (2800, 'C', '化学纤维制造业');
INSERT INTO classes VALUES (4189, 'C', '其他电子设备修理业');
INSERT INTO classes VALUES (110, 'A', '种植业');
INSERT INTO classes VALUES (2810, 'C', '纤维素纤维制造业');
INSERT INTO classes VALUES (4190, 'C', '其他电子设备制造业');
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
--
-- Data for Name: classes; Type: TABLE DATA; Schema: public; Owner: jobzone
--
INSERT INTO classes VALUES (2750, 'C', '生物制品业');
INSERT INTO classes VALUES (4183, 'C', '电子计算机修理业');
INSERT INTO classes VALUES (100, 'A', '农业');
INSERT INTO classes VALUES (2800, 'C', '化学纤维制造业');
INSERT INTO classes VALUES (4189, 'C', '其他电子设备修理业');
INSERT INTO classes VALUES (110, 'A', '种植业');
INSERT INTO classes VALUES (2810, 'C', '纤维素纤维制造业');
INSERT INTO classes VALUES (4190, 'C', '其他电子设备制造业');
4.使用vi删除sql文件中下面的内容：
引用
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
--
-- Data for Name: classes; Type: TABLE DATA; Schema: public; Owner: jobzone
--
--
SET client_encoding = 'UTF8';
SET check_function_bodies = false;
SET client_min_messages = warning;
SET search_path = public, pg_catalog;
--
-- Data for Name: classes; Type: TABLE DATA; Schema: public; Owner: jobzone
--
如果有必要，就是使用vi替换命令:% s/"/`/g，将"替换成`符号。
5.登录mysql,转换到你要导入的数据库，执行sql文件即可完成导入，下面例子仅作参考：
引用
#mysql -u root -p
mysql>use jobzone
mysql>\. /aaa.sql
mysql>use jobzone
mysql>\. /aaa.sql
