MYSQL errors on restore | Joomla Support | Forum Archive

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

Avatar
sp_LogInOut Log In
Lost password?
sp_Search Search
Advanced Search
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
Go to Bottom
The forums are currently locked and only available for read only access
sp_TopicIcon
MYSQL errors on restore
April 5, 2011
7:05 pm
Avatar
Guest
Guests
Go to Top
1sp_Permalink sp_Print

I'm getting a lot of these errors when I try to run a restore on a different server than the one the backup file was generated on.

###MYSQL error
Column count doesn't match value count at row 1
###On Query:

 

What am I doing wrong?

April 5, 2011
7:43 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline
sp_UserWebsite sp_Twitter sp_GooglePlus
Go to Top
2sp_Permalink sp_Print

Hi Owen! Can you indicate what is your software version for the original mysql server as well as the new mysql server?

 

When generating a backup with XCloner, did you activated the mysqldump option in XCloner Config?

 

It would also help if you could post the full mysql query related to that error as it's being displayed on the output page.

 

Ovidiu

sp_Feed All RSS
Go to top
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