How to event a full backup

User, date Message
Written by notuo
5 months ago
Category: Running SQL scripts
1 posts since Tue, 22 Apr 14
Hi all.

I am newbie here. My host doesn't allow me to use the php system function in order to perform a full backup using mysqldump (I like to use cron as well to perform a daily backup). They referred me here and I am not seeing the way to full backup.

I finally open the event tab but I am really lost in how to enter the commands to do this backup. (The timing part of that is no problem, just the MySQL commands)

Any advise is appreciated,

Best regards
Written by jfalchMoney, Euro
5 months ago
412 posts since Sat, 17 Oct 09
cf this
Written by kalvaro
5 months ago
601 posts since Thu, 29 Nov 07
You don't need to type commands. Just go to "Tools/ Export database as SQL". But HeidiSQL is mainly a GUI tool; it isn't designed for unattended or automated tasks like backup scheduling.

I'm probably missing context but mysqldump is a standalone tool and a regular MySQL client. As such:

1. You don't need PHP to run it
2. You can run it from any other computer as long as you have access to the database

P.S. Next time you need hosting you already know what to check ;-)

Please login to leave a reply, or register at first.