1. Please take a little time for this simple survey! Thank you for participating!
    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...