LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
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.

Notices

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

Rep: Reputation: 15
mysql database restore problem


sir,

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, 06:36 AM   #2
Guttorm
Senior Member
 
Registered: Dec 2003
Location: Trondheim, Norway
Distribution: Debian and Ubuntu
Posts: 1,134

Rep: Reputation: 218Reputation: 218Reputation: 218
Hi

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


Reply


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 04:11 AM
How do I restore a MySQL database simply dobriain Linux - Software 2 04-19-2006 12:05 PM
I lost my urpmi database...how to restore it ? riccisit Mandriva 14 01-22-2006 03:14 AM
Problem importing database back to MySql shubb Programming 3 11-29-2005 01:36 PM
Had to restore database from backup - about 5 minutes lost jeremy LQ Suggestions & Feedback 0 01-21-2001 10:31 PM


All times are GMT -5. The time now is 08:59 AM.

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