Plesk Question posted in
The official documentation for Plesk Obsidian can be found here.

Parallels Plesk MySql Database

Who to download mySQL Database(Full or part of them) from Parallel Plesk Server running latest Ubuntu 14.04 LTS 64bit + Plesk 12.0 through a MacBook Terminal(SSH). The Plesk server only allow mySQL from local host.enter image description here

Tags:

3

Answers


  1. 0

    It’s remote databases access setting. if you enable “Allow remote connection from any host” then you can access your databases from all IP’s. But you need to enable mysql port in server firewall if you want to allow remote mysql access on your server.

    Login or Signup to reply.
  2. 0

    You can dump your database over ssh and later download it with ftp/sftp.

    Create a MySQL-Dump:

    mysqldump -u [YOURUSER] -p'[YOURPASSWORD]' [YOURDATABASE] > /your/path/

    Make sure you replace /your/path with a Directory you have access with sftp to.
    (Keep in mind that it may be necassary to adjust the file-permissions)

    Or Dump it to /var/www/vhosts/[YOURSITE]/[HTTP ROOT DIR] and download it via http(s).

    Login or Signup to reply.
  3. 0

    Plesk is shipped with phpMyAdmin, so you can access it from Plesk > Subscriptions > example.com > Databases > phpMyAdmin and create a database dump from there.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search