Forum export question

classic Classic list List threaded Threaded
29 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

Harvey
My developer says that it should be simple to go from postgres to mysql but something is unusual about the format you sent.

Is it a standard postgres database?
HTTPS Please!
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

fffilimnov
Administrator
Yes, it's standard postgres sql dump generated with pg_dump.
You can restore it with command like this:
psql dbname < infile

In database will be created new schema.
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

Harvey
This is what we get:

$ ./psql nyskiblog < /datastore/incoming/site_932206_986289252.zip
invalid command \h% ���T8����4TR����Q*����P�
invalid command \ا"�2Y��W�
invalid command \_���7�`�e�d"&��_��9�Ӛ��ʣ��s��Q��i1�7�ӹ��y숍16�µb�#��Ã��m�C �q���I�"Mʕ�e��/��/��@Ζ�)
invalid command \��7���DU��qmc�»�d�iZT
invalid command \�kR�b�����P�s�F6<"H��
invalid command \)b_[�d=X��!]u-�T"
ERROR:  invalid byte sequence for encoding "UTF8": 0xe2 0xe1 0x97
invalid command \���
invalid command \�^pG��Ƌ��:
ERROR:  invalid byte sequence for encoding "UTF8": 0xa9
invalid command \��6����!<������x[h��+�E�5����Bk�9-B������,�|���O��+DgAl��*�jP�60C%�9N~�A0f�8���zU�&���!��ʏNJ��c��G��X�@�9������GTG�8=�H+�:
invalid command \�o�8��*�B�f�az�������G����,�i“�_�
invalid command \ȅ����s����� �+mN
invalid command \Zޤ'
invalid command \�>��ƈ����ji�JnV_��.��0VJ���*�P/��������~)G�c$�Vn�M���L�,A
                                                                          �Vfn(�l�:ڙd���uo�y|�����:�t��:*!�o�8�J;��Pa�s�
invalid command \�*�R�W�gN�BC"�N�31ir�O����r�if�O��/���T��J���y<��ȃ�܃<>�AzR�Y)]���Q�C�l
invalid command \�4:�'�y
invalid command \j�B�)t���ЏX0��z}�
invalid command \��r�{�/w`�z�i�b֬��טw��,R��:l:�BGJ/r���mZ
invalid command \+��
invalid command \�a�{��{KM�;(pԏn���������Ҫ6#
invalid command \a�����aBʆRX��^��NӢ��`�+ю?�����
HTTPS Please!
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

fffilimnov
Administrator
You are using wrong file.
I sent you raw sql, not zip archive.
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

Harvey
I think the problem is that I am in the middle between two guys who know what they are doing and I am clueless.

 Can you resend and I will try again?

On Wed, Oct 25, 2017 at 12:43 AM, fffilimnov [via Nabble Support] <[hidden email]> wrote:
You are using wrong file.
I sent you raw sql, not zip archive.


If you reply to this email, your message will be added to the discussion below:
http://support.nabble.com/Forum-export-question-tp7598637p7598866.html
To unsubscribe from Forum export question, click here.
NAML



--
HTTPS Please!
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

Harvey
It looks like this may have been my mistake> I thought I sent he right file to the developer. Can you make the link live again?
HTTPS Please!
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

fffilimnov
Administrator
Sent via email
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

Harvey
What version of PostGres is this?
HTTPS Please!
Reply | Threaded
Open this post in threaded view
|

Re: Forum export question

fffilimnov
Administrator
9.5
12