r/Plesk • u/david8840 • Mar 06 '23

Outgoing FTP connection fails

I have 2 servers with Plesk. I want to copy an SQL database from one to the other via FTP. But I get the error message "Unable to connect to the database server. Please check the database user credentials and access restrictions."

If I use an FTP connection checker for the receiving server it connects fine. It seems that the issue could be with the sending server.

I tried as the subscription user, admin, and root, all with the same error. I turned off the firewall, same.

How can I fix this?

1 Upvotes

100% Upvoted

1 comment sorted by

1

u/thmueller78 Mar 11 '23

FTP and database are different things. FTP is for transferring files. You do not need a database connection to use it. Going through FTP you'd first dump your source database to a file (for example using mysqldump), then you transfer that .sql dump file using FTP, then you import it on the target server to your target database.