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