Can 't Restore Back-Up 2005-02-05 - By Andy Choens
Back
Ok,
I've got a bit of a problem, and could really use a hand here. (obviously) I
am going to tell the whole story so nobody can say I left anything out, so
here goes.
I work at a camp for special needs kids (thus I have to be careful what info I
post) and we used a combination of Red Hat and OpenOffice.org for a database
needs. It worked really well. After the split, I decided to go with Fedora,
because RHEL was more than we were up for paying. I've kept the server
updated. But, when MySQL released the new 4.0 branch I decided to ignore RH
and I upgraded to this so I could take advantage of the new GUI tools.
Upgrading was a little bit of a hassle, but no disasters. I have slowly
become displeased by Fedora, and don't see it as being as stable as RH9 used
to be. But, it wasn't worth the HOURS of work it would take to install
something else. But, then last week, the hard-drive blew out on the server.
I had done a back-up the day before so I wasn't worried about the database,
our secretaries would only have to do 1 day's worth of work over again, NOT
the end of the world, and I have the perfect excuse to move the server onto
something else. So, I went out and bought SuSE 9.2. I'd heard good things
about it, and decided if I liked it as the server I might start migrating the
desktops to it, and away from Fedora. So, I installed SuSE, and started in
on getting the office back up and running. Everything EXCEPT the database is
now working just fine.
I went and downloaded the mysql-administrator rpm for suse and installed, and
everything seems fine. I can easily connect to mysql, and to make sure it
was working I created a bs schema in test. All was well. So, I pulled out
the sql back-up and tried to restore, and administrator reports success, but
I don't get any tables. That's Not what I call a success. So, I tried to
use the sql file from the commandline and here at least I got some errors.
I used the command:
mysql -p tlp < /home/achoens/TLP_2005-02-02_17\:50\:11.sql
I have already su'd to root and have full access to the database tlp. I get
the following error.
ERROR 1193 at line 1: Unknown system variable 'CHARACTER_SET_CLIENT'
I realize that this is all from the commandline, but I felt like I should
provide some error information, and that's all I have.
I would really like to be able to use this sql file I made with Administrator
back on Fedora Core. Both servers are/were using 4.x so I don't think
versions should be a problem here, and of course, everything is in UTF-8 (See http://UTF-8.ora-code.com).
Any thoughts, ideas or commentary for the confused?
It's Saturday night and I've been at this all day, I'm going out now.
--andy
--
"I'm returning this note to you, instead of your paper, because it
(your paper) presently occupies the bottom of my bird cage."
-- English Professor, Providence College
--
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe: http://lists.mysql.com/gui-tools?unsub=mysql@(protected)
|
|
