• Registered: 2017-05-15
  • Posts: 722

Topic: BACKUP MYSQL

Hello MVD!

I need a help to have a procedure how to backup mysql database.

Thanks in advance

manixs

2 Reply by adiziktdy (edited by adiziktdy 2019-04-25 06:01:52)

  • Registered: 2018-02-02
  • Posts: 134

Re: BACKUP MYSQL

procedure menu_Button1_OnClick (Sender: TObject; var Cancel: boolean);
begin
OpenFile('dump.bat');
Showmessage('Done');
end;


dump.bat

mysqldump.exe --host=192.168.X.XXX --port=3306 -uUSER -pPASSWORD DATABASE>namebackup.sql

192.168.X.XXX - IP adress host database
USER - username connected to database
PASSWORD - password connected to database
DATABASE - name yours database
namebackup.sql - name result script  backup

Yana
  • Registered: 2017-05-15
  • Posts: 722

Re: BACKUP MYSQL

WOW THANKS!   ADIZIKTDY!

  • Registered: 2018-02-02
  • Posts: 134

Re: BACKUP MYSQL

manixs2013 wrote:

WOW THANKS!


You are welcome smile

Yana