Can't Restore Back-Up

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.

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/[email protected]