Error after finish the configuration | Wordpress 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_Feed Topic RSSsp_TopicIcon
Error after finish the configuration
August 13, 2011
3:01 pm
Avatar
Jesus
Member
Members
Forum Posts: 4
Member Since:
August 13, 2011
sp_UserOfflineSmall Offline

Hi,

I've been to install xclone plugin for wordpress in my site http://parfum-oriental.net

After read the documentation, I fill up initial configurations, and its seems to ok:

————

Backup /home4/parfumor/public_html/wp-content/plugins/xcloner-backup-and-restore/administrator/backups/backup_2011-08-13_08-50_parfum-oriental.net-sql-nodrop.tar created, we may continue!

 

Backup Start Path Check: OK (/home4/parfumor/public_html/)

Backup Store Path Check: OK (/home4/parfumor/public_html/wp-content/plugins/xcloner-backup-and-restore/administrator/backups)

Temporary Path Check: OK (/home4/parfumor/public_html/administrator/backups)

Authentication: OK

Backup Ready: YES

—–

And in the Setting->Info , all the setting are onn green

—-

So, I've clicked in the Backup button, I select all the tables and I click continue…

I received the error I put below.

In the  view backup section, it's could seen 3 backups I've done…

 

For the SQL, I've used the same user/pass of phpMyAdmin

 

Any help??

Thanks a lot ¡¡

———

Database backup…

 

[parfumor_wrd1] 11 tables

 

 

There was an error retrieving the JSON data from the server, try again or contact the developers!

 

Details: parsererror — Invalid JSON: Error(Aug 13, 2011 @ 08:50:05) – Invalid query: Access denied; you need the PROCESS,SUPER privilege for this operation {"dumpsize":"939134","newDump":1,"tableName":"BAN_STATISTICS","databaseName":"information_schema","totalRecords":"0","startAtLine":15,"startAtRecord":0,"dumpfile":"/home4/parfumor/public_html/administrator/backups/information_schema-sql.sql","dbbackup_comp":"","dbbackup_drop":""}

 

JSON url: index2.php?task=recurse_database&nohtml=1&dbbackup_comp=&dbbackup_drop=&startAtLine=13&startAtRecord=0&dumpfile=/home4/parfumor/public_html/administrator/backups/database-sql.sql

August 13, 2011
5:45 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Seems to be a mysql error, the mysql user you have there configured does not have access to the PROCESS,SUPER privileges, i would suggest adding a mysql users that has those permited, or simply leave any additional mysql databases you try to backup like the information_schema outside the main backup.

 

Ovidiu

August 13, 2011
8:11 pm
Avatar
Jesus
Member
Members
Forum Posts: 4
Member Since:
August 13, 2011
sp_UserOfflineSmall Offline

Hi Ovidiu,

I've left "information_schema" out, and the backup is going good without errors.

two questions:

1) This information schema is needed to be backed up?

2) The option ADD Drop Syntax....What is this for??

 

Thanks a lot!!

Jesus

August 13, 2011
8:52 pm
Avatar
Jesus
Member
Members
Forum Posts: 4
Member Since:
August 13, 2011
sp_UserOfflineSmall Offline

Hi Ovidiu

I would like to buy premium service for one month...do you have any description of the services??

Thanks a lot. Jesus

August 13, 2011
9:53 pm
Avatar
Jesus
Member
Members
Forum Posts: 4
Member Since:
August 13, 2011
sp_UserOfflineSmall Offline

Hi Ovidiu,

Regarding the error I've posted before, I think I was wrong. I've assumed in the bd option that I have to select tables to do the backup instead to select tables to exclude.

I repeated this backup with all tables including information_schema and the backup is works fine.

What is not clear is the RESTORE process.

I've click over "restore backup" icon in the left panel

And the only thing I got is and information panel, with the instructions to make the restore. The instructions seems to be for restore the backup in another server. 

I've tried to execute xcloner.php (within the "restore" directory of plugin installation) from my browser and i have not permission...?

 

Any help??

Thanks a lot and sorry for the incovenience...

Jesus

August 14, 2011
2:06 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

This restore wiki should help in understanding the restore process /wiki/index.php/Restore_Backup#Restore_Backup_.E2.80.93_Manually

 

Our premium support service offers you private assistance regarding issues related to XCloner, so anything related to that area, backup, restore, site migration, we can help.

 

Regards, Ovidiu

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
D: 21
Andy: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10052
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
piotr K
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0