Page 1 of 1

Regarding restoring a backup!!!

PostPosted: Wed May 31, 2006 1:15 am
Author: Mighty07
I've been doing some backups using the backup tool in the ACP.
So far good, problem is that now i'm trying to restore one, and i'm getting errors.
First the backup has more than 80MB and i guess the restore tool in ACP can't handle it.
If i try directly in mysql i got syntax errors in the .sql dump file.
Does anyone ever tried this?

PostPosted: Wed May 31, 2006 4:25 am
Author: Adrian Rea
the problem is the size of the db. you need a program like mysql dumper or bigdump to upload it into the db. The problem is that the db software can only accept up to 2mb at a time going into it. These progs are quite easy to get to grips with.

A

Re: Regarding restoring a backup!!!

PostPosted: Wed May 31, 2006 8:12 am
Author: Mighty07
The problem of the size i'm aware of it.
The real problem is the sql syntax created by the ACP tool. Because if i use bigdump.php or try to directly import using the shell to mysql i got syntax errors.
And both the mysql servers are in 4.x.x version of mysql, the one from where the backup came and the one where i'm trying to restore too.