MySQL Forums
Forum List  »  Backup

Restore on MySQL aministrator
Posted by: Juan Javaloyes
Date: April 28, 2005 02:32PM

I´m using an InnoDB for my project, I created the backup with the NO CREATE and COMPLETE INSERTS options.
I checked the backup file and everything's ok. but then I executed the restore, opened the file and everything's executed fine... except there's no data on my entire DB, what may be the problem?
I tried using the phpmyadmin, but when I executed the sql from the file this message prompts

consulta SQL:

SET@OLD_CHARACTER_SET_CLIENT = @ @CHARACTER_SET_CLIENT
MySQL ha dicho:

#1064 - Algo estᠥquivocado en su sintax cerca 'SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT' en la linea 1

what's the matter??? This is urgent, my project has stopped because of this

Options: ReplyQuote


Subject
Views
Written By
Posted
Restore on MySQL aministrator
3316
April 28, 2005 02:32PM
2116
August 04, 2005 10:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.