Great tool, but database restore fails | Joomla Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_TopicIcon
Great tool, but database restore fails
July 30, 2014
1:06 pm
Avatar
Arnulf
New Member
Members
Forum Posts: 2
Member Since:
July 30, 2014
sp_UserOfflineSmall Offline

Hi,

 

XCloner works with creating backups, and I can see that database-sql.sql is included in the resulting tar file.

 

However when I try to restore the website from a previous backup I get to this error:

http://i.imgur.com/m1w7nFa.jpgImage Enlarger

 

Edit: I use Joomla 3.3.3, mysql5. I checked the database-sql.sql, it has the correct contents. I tried different installation paths, but to no avail.

Just wanted to let you know. Since it is a bit error-prone and cumbersome to extract the database-sql.sql via mysql client into the database.

July 30, 2014
8:24 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

When restoring, did you check the disk space available that's being left? try extracting the backup archive manually and restart the resrtore process with "Skip files restore" option checked and see if that helps

 

Ovidiu

August 1, 2014
10:08 am
Avatar
Arnulf
New Member
Members
Forum Posts: 2
Member Since:
July 30, 2014
sp_UserOfflineSmall Offline

XCloner! Support said:

When restoring, did you check the disk space available that's being left? try extracting the backup archive manually and restart the resrtore process with "Skip files restore" option checked and see if that helps

 

Ovidiu


Thank you for the quick reply.

 

I tried your suggestion, still the same error.

However, I manually extracted the database-sql.sql and put it where the system expects it:

$JOOMLA3_DIR/administrator/backups/database-sql.sql

On the source system, right next to the backup tar files. (I've made several now, so space was not the issue here.)

 

And this time, it worked! No error message.

I've yet to check if the DB has the backup'ed contents now, though.

 

My guess is that somehow the extraction from the tar file is skipped.

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
Andy: 21
D: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10030
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Omar Vera
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0