Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Non-*NIX Forums > Programming
User Name
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.


  Search this Thread
Old 07-01-2007, 03:06 AM   #1
Registered: Sep 2005
Location: kannur
Posts: 59

Rep: Reputation: 15
mysql database restore problem


i have installed koha 2.2 in a fedora core 3 machine and i want to restore the koha database backup.

i have taken the database backup from a fedora core 4 machine(with mysql4.1.11).

when i try to restore this backup to a fedora core 3 machine ( with mysql 3.x) i get the following error

ERROR 1064 at line 30: You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
KEY `acctsborridx` (`borrowernu' at line 11

how can i solve this problem ...

it is not possible to dump backup file to lower version of mysql
Old 07-01-2007, 07:36 AM   #2
Senior Member
Registered: Dec 2003
Location: Trondheim, Norway
Distribution: Debian and Ubuntu
Posts: 1,203

Rep: Reputation: 265Reputation: 265Reputation: 265

mysqldump has an option you need to use. When using it, try the --compatible option. Like:
mysqldump --compatible=mysql323 ...


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
to restore the database Ameii83 General 3 06-09-2006 05:11 AM
How do I restore a MySQL database simply dobriain Linux - Software 2 04-19-2006 01:05 PM
I lost my urpmi to restore it ? riccisit Mandriva 14 01-22-2006 04:14 AM
Problem importing database back to MySql shubb Programming 3 11-29-2005 02:36 PM
Had to restore database from backup - about 5 minutes lost jeremy LQ Suggestions & Feedback 0 01-21-2001 11:31 PM

All times are GMT -5. The time now is 12:55 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration