1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

how to backup all mysql databases of all clients

Discussion in 'Plesk for Windows - 8.x and Older' started by igoldman, Nov 17, 2005.

  1. igoldman

    igoldman Regular Pleskian

    26
    23%
    Joined:
    Sep 14, 2004
    Messages:
    212
    Likes Received:
    0
    Hello,

    I would like to know how to backup all mysql databases of all my domain accounts in the server.

    I found the following command :

    mysqldump.exe -uadmin -p(admin password) --all-databases

    but I don't know how to use this command and which argumants I need to use in order to backup all mysql databases
     
  2. jbuts

    jbuts Guest

    0
     
    If you want to backup all client databases you should execute the following commands:
    cmd> cd %plesk_dir%\databases\mysql\bin
    cmd> mysqldump.exe -uadmin -padmin_passwd -P3306 --all-databases > backup_all_databases.txt
    The backup_all_databases.txt file will be locate in %plesk_dir%\databases\mysql\bin folder.
    But if you want to backup the Plesk's databases you should execute the following commands:
    cmd> cd %plesk_dir%\mysql\bin
    cmd> mysqldump.exe -uadmin -padmin_passwd -P8306 --all-databases > backup_all_databases.txt
    The backup_all_databases.txt file will be locate in %plesk_dir%\mysql\bin folder.
     
  3. igoldman

    igoldman Regular Pleskian

    26
    23%
    Joined:
    Sep 14, 2004
    Messages:
    212
    Likes Received:
    0
    Hello ,
    first of all thanks about your reply ,

    I would like to ask what happend if I don't want to dump all the databases to 1 file but I do want that each database will be dump to seperate file , so what I need to do ?
     
  4. JackL

    JackL Guest

    0
     
    1.Create batch file e.g. dump.cmd
    2.mysqldump.exe -uadmin -padmin_passwd -P3306 first_db > first_db.sql
    3.mysqldump.exe -uadmin -padmin_passwd -P3306 second_db > second_db.sql

    and so on ....

    John S.G.
     
Loading...