Backup (MySQL) problem

[putude]

Dear All,

I try to make a auto backup using bash script and crontab.

formerly, in kloxo-mr 6.5.x there is no problem,
but in kloxo-mr 7, it fail to create mysql backup.
(No tables created).

when I run backup script, there are some warnings appear.
------
sh /script/backup --class=client --name=admin
------
.....
.....
Taking backup of 'mysqldb:mydatabase_db'
sed: can't read /tmp/mysqldumpzKbgGE/mysql-mydatabase_db.dump: No such file or directory
....
....

What is happen ? and how to make it back to normal ?
please help me..

best regards,
Putude

[MRatWork]

Make sure all table using myisam as storage-engine. Or disable 'skip-innodb' in /etc/my.cnf.d/server.cnf.

[putude]

Hi..

* I've check all tables and they are MyISAM already.
* I disable 'skip-innodb' in /etc/my.cnf.d/server.cnf
* restart mysql
* then try again the backup script.
the problem still appear. No clue from Google.

I'm very grateful for your help.

rgds,
Putude

[MRatWork]

Try 'sh /script/backup --class=client --name=admin --accounts=all'.

[putude]

Hello Mustafa,

sadly the warning is still appears. but luckily, the file produced (backup) is ok for restoring the database.
Thank you so much for your help, Mustafa.

[MRatWork]

Did 'mydatabase_db' already exists in database (check via phpmyadmin)?.

[ViN]

RESTORE BACKUP OTION NOT WORKING PROPERLY.
i have backup data, but in Admin CP Restoring not restore my FULL DB.
i m noobs as well

[MRatWork]

Inform here 'cat /usr/local/lxlabs/kloxo/log/restore'.

[ViN]

there must be problem with its GUI backup n restore system.
my all data lost. i have back but not restoring properly in GUI admin panel.

[ViN]

Also when i have downloaded backup, and extracted sql , its in dump extension, and it not able to upload in phpmyadmin.

[MRatWork]

Every backup and restore process will be create backup and restore log in 'cat /usr/local/lxlabs/kloxo/log/'.

So, without this log we don't know what's the problem is.

[ViN]

Log show no error,
i m fed up.
my all backup is corrupted.

[MRatWork]

Inform here your 'cat /usr/local/lxlabs/kloxo/log/backup' (in old server) and 'cat /usr/local/lxlabs/kloxo/log/restore' (in new server).

[MRatWork]

Try 'sh /script/restore --class=admin --name=admin --accounts=all /home/kloxo/client/admin/__backup/kloxo-scheduled-7.0-admin-2015-Aug-06-1438855986.tgz'.

[ViN]

[root@boxslot ~]# sh /script/restore --class=admin --name=admin --accounts=all /home/kloxo/client/admin/__backup/kloxo-scheduled-7.0-admin-2015-Aug-06-1438855986.tgz
-bash: [root@boxslot:


Not restored even after running this command