Тема: Mysql и PostgreSQL
Есть БД сделаная в PostgreSQL около 15 мб(200 тыс строк) ,
[spoiler]
-- PostgreSQL database dump
--
SET client_encoding = 'KOI8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: pgsql
--
COMMENT ON SCHEMA public IS 'Standard public schema';
SET search_path = public, pg_catalog;
--
-- Name: gtsq; Type: SHELL TYPE; Schema: public; Owner: nehpus
--
CREATE TYPE gtsq;
--
-- Name: gtsq_in(cstring); Type: FUNCTION; Schema: public; Owner: nehpus
--
CREATE FUNCTION gtsq_in(cstring) RETURNS gtsq
AS '$libdir/tsearch2', 'gtsq_in'
LANGUAGE c STRICT;
ALTER FUNCTION public.gtsq_in(cstring) OWNER TO nehpus;
--
-- Name: gtsq_out(gtsq); Type: FUNCTION; Schema: public; Owner: nehpus
--
CREATE FUNCTION gtsq_out(gtsq) RETURNS cstring
AS '$libdir/tsearch2', 'gtsq_out'
LANGUAGE c STRICT;
ALTER FUNCTION public.gtsq_out(gtsq) OWNER TO nehpus;
--
-- Name: gtsq; Type: TYPE; Schema: public; Owner: nehpus
--
CREATE TYPE gtsq (
INTERNALLENGTH = 8,
INPUT = gtsq_in,
OUTPUT = gtsq_out,
ALIGNMENT = int4,
STORAGE = plain
);
ALTER TYPE public.gtsq OWNER TO nehpus;
--
-- Name: gtsvector; Type: SHELL TYPE; Schema: public; Owner: nehpus
--
CREATE TYPE gtsvector;
--
-- Name: gtsvector_in(cstring); Type: FUNCTION; Schema: public; Owner: nehpus
--
CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
AS '$libdir/tsearch2', 'gtsvector_in'
LANGUAGE c STRICT;
ALTER FUNCTION public.gtsvector_in(cstring) OWNER TO nehpus;
--
-- Name: gtsvector_out(gtsvector); Type: FUNCTION; Schema: public; Owner: nehpus
--
CREATE FUNCTION gtsvector_out(gtsvector) RETURNS cstring
AS '$libdir/tsearch2', 'gtsvector_out'
LANGUAGE c STRICT;
ALTER FUNCTION public.gtsvector_out(gtsvector) OWNER TO nehpus;
--
-- Name: gtsvector; Type: TYPE; Schema: public; Owner: nehpus
--
CREATE TYPE gtsvector (
INTERNALLENGTH = variable,
INPUT = gtsvector_in,
OUTPUT = gtsvector_out,
ALIGNMENT = int4,
STORAGE = plain
[/spoiler]
примерно вся база построена так
Суть при импорте через phpmyadmin , выдает ошибку #1193 - Unknown system variable 'client_encoding'
Не известная переменая и так везде практически
Вопрос, возможно как то уже имеющую БД сконвентровать для Mysql? может есть скрипты какие то или еще что то