Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQFA6-00DJr9-13 for pgsql-general@arkaria.postgresql.org; Sun, 30 Jul 2023 22:45:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qQFA2-00AsPq-GV for pgsql-general@arkaria.postgresql.org; Sun, 30 Jul 2023 22:45:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQFA2-00AsM7-3W for pgsql-general@lists.postgresql.org; Sun, 30 Jul 2023 22:45:14 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qQF9y-001Llc-8h for pgsql-general@lists.postgresql.org; Sun, 30 Jul 2023 22:45:13 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-1bba1816960so3025254fac.3 for ; Sun, 30 Jul 2023 15:45:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690757108; x=1691361908; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=BCczRwWtyIzXOYJcQAk+whaLbARK35aDh85aj+TqcZA=; b=m9kUPERk4lCJ13Zz9enRPqaEtLB7wTHBYjZFfBDtktDLwJLYFxlAMW8wLdtg5H6j3j q7Qja+NxZbIj4td9W5cxJVjmvHfRActiEeiqgLCTj0PNCDPkjSMl4aYZ+wrpkOmcbuk/ LPhs2Aq3HfXJ9B9cUSJK15bo20PtZnWiKH2qBO/1qzbIAIyCTF4PqILQoI3Qsl2cu4eA ElBHXKdfGtCKVQHcsTmzvFRyxeUHQysyUM32atfTinnXdz452h2fveUBi6VKXXRZ5D9h uCAOmhRBus/nEh4LPAayrntCm5fnSsvRwL7WaCEAopC+1qfO4Zu/J/yYjKXJmLg36D// 2DIw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690757108; x=1691361908; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=BCczRwWtyIzXOYJcQAk+whaLbARK35aDh85aj+TqcZA=; b=TVv9Fn/S20s+kcJZX0YgBELX9eck0hE4Fu/OobE5VaWxow6+xTimuI25Tq3rMXFITT 3A155NE9umWLjiVT1yJOivycBshEoM1rJmBhm2O/okgGWpi0z4P/QJSjj7s/HjDyynZv w+wBkYnpqmvbxextUYJHqeAEd6P89CxtEVlnoAeLP/F8/1zKF4PDXihqkKVbRKtHxhv7 7OOLR9iIYYPdVaqFW/QIAGwYfjSmTb22BEtuXFOJ4tN1juNoE8wlVa7gd/wZcEKTF+iO 8rp3H4U7ebsTROJ7OraMiFF30DjNgNhcSUnp36R7aOX4KJoo5LToMfldbk/Cw+8F30zH Pp0w== X-Gm-Message-State: ABy/qLYI1kL6I/SdfGJWAlzM57THRKtXIQHGFJmr+1iZV5Ap2K7uZEXv tTP2Pg482ZKJDXxnCzKnRShELbbQYGY= X-Google-Smtp-Source: APBJJlE9H5y62k5ls104MFPvzlL84r0wTYzyb5XWDXWe57f6I1bczDYYtW+3M2nJde8LjqNHjVb6cQ== X-Received: by 2002:a05:6870:4396:b0:1bb:8b8a:2b1b with SMTP id r22-20020a056870439600b001bb8b8a2b1bmr11003808oah.54.1690757107885; Sun, 30 Jul 2023 15:45:07 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:9cea:c878:3644:a2fd? ([2600:1700:bd2c:b810:9cea:c878:3644:a2fd]) by smtp.googlemail.com with ESMTPSA id t14-20020a81830e000000b0057a560a9832sm2639145ywf.1.2023.07.30.15.45.07 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 30 Jul 2023 15:45:07 -0700 (PDT) Message-ID: Date: Sun, 30 Jul 2023 17:45:07 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: Migrating MySQL DB to PostgreSQL DB. Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/30/23 09:01, Kaushal Shriyan wrote: > Hi, > > I am running MySQL DB 8.0.34 on Red Hat Enterprise Linux release 8.7 > (Ootpa). Is there a way to import MySQL DB along with data to PostgreSQL > 14 database server? > > Please suggest. Thanks in advance. Depending on the size of the database, the "exoticness" of the datatypes, the amount of downtime available and how complicated any stored procedures and triggers are, simple CSV export/import might do the trick. -- Born in Arizona, moved to Babylonia.