unable to restore database | 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
unable to restore database
January 8, 2011
4:17 pm
Avatar
Guest
Guests

At the end of the procedure an error appeared:

XCloner Automatic Restore!

Configuration updated!

Unable to read the
database backup file
/home/circolo8/public_html/SLI//administrator/backups/database-sql.sql ,
database was not imported!
All should be done! Click here to continue...


XCloner Restore Version 1.9.0

For support and questions please visit us at XCloner.com - Website Backup Made Easy

 

What can I do?

Please help me!

Isabella

January 8, 2011
5:32 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Hi there! Try and recheck your ftp upload path from the XCloner.php and make sure it matches the Install dir: location you configured, if you are unsure of that, better use the "Install files directly" option instead of ftp

 

Hope it helps! Ovidiu

January 8, 2011
6:25 pm
Avatar
Guest
Guests

I just tried it and now:

XCloner Automatic Restore!

TAR error: Extracted file
/home/circolo8/public_html/SLI/administrator/backups/database-sql.sql
does not have the correct file size '1289364' (2950579 expected).
Archive may be corrupted.

Files succesfully copied to /home/circolo8/public_html/SLI/

Configuration updated!

January 8, 2011
6:31 pm
Avatar
Guest
Guests

Now I noticed the different sql size and reuploaded to that dir the database-sql.

The procedure went ok but with a long error file starting with:

##Mysql Query:
########
CREATE TABLE `joom_attachments` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `filename` varchar(80) NOT NULL,  `filename_sys` varchar(255) NOT NULL,  `file_type` varchar(128) NOT NULL,  `file_size` int(11) unsigned NOT NULL,  `url` text NOT NULL,  `uri_type` enum('file','url') DEFAULT 'file',  `url_valid` tinyint(1) unsigned NOT NULL DEFAULT '0',  `display_name` varchar(80) NOT NULL DEFAULT '',  `description` varchar(255) NOT NULL DEFAULT '',  `icon_filename` varchar(20) NOT NULL,  `uploader_id` int(11) NOT NULL,  `published` tinyint(1) unsigned NOT NULL DEFAULT '0',  `user_field_1` varchar(100) NOT NULL DEFAULT '',  `user_field_2` varchar(100) NOT NULL DEFAULT '',  `user_field_3` varchar(100) NOT NULL DEFAULT '',  `parent_type` varchar(100) NOT NU

I can try to delete all files and restart from scratch... 🙁

January 8, 2011
7:13 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Did you use an empty database for restore? Try that, and see if it helps with the Mysql error

 

Ovidiu

January 8, 2011
8:30 pm
Avatar
Guest
Guests

YES!!!!!! It worked, thank you VERY much and have a nice YEAR!

Isabella

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:
Emmanuel Joachim
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0