CODEWITHSUNDEEP
postgresqlrestore
Kresimir Pendic
Kresimir Pendic

Reputation: 3614

Error when trying to restore backup

This line(518):

COPY wp_commentmeta (meta_id, comment_id, meta_key, meta_value) FROM stdin;
\.

is giving this error:

[ERROR ] 518.0: syntax error, unexpected character

What is this?

I have done backup before with this database, and now I'm just trying to restore all the tables back to the database.

Upvotes: 3

Views: 3527

Answers (1)

Robert H
Robert H

Reputation: 11730

The error: 

ERROR:  syntax error at or near "\"
LINE 1: ...a (meta_id, comment_id, meta_key, meta_value) FROM stdin; \.
                                                                     ^


********** Error **********

ERROR: syntax error at or near "\"
SQL state: 42601
Character: 77

points to the \ in the \. as being the issue. Are you sure you require the \.?

Per the documentation:

End of data can be represented by a single line containing just backslash-period (.). An end-of-data marker is not necessary when reading from a file, since the end of file serves perfectly well; it is needed only when copying data to or from client applications using pre-3.0 client protocol.

Try removing your \. from the line and see if your copy works as expected.

Upvotes: 1

Related Questions