Re: Can't Restore Back-Up

Went out to eat, came back and like a true geek, went back to work.  I finally 
really started tearing into the SQL syntax that administrator had made on 
Fedora.  It was all screwy.  I don't know what happened, but I can now make a 
back-up and restore from a back-up successfully on SuSE.  So, SuSE is the way 
to go.  Glad I made that decision correctly.

So, I just rewrote all of the syntax until it was finally right, which wasn't 
easy considering my limited eperience, and finally made it go in table by 
table through the command line.

--andy

On Saturday 05 February 2005 6:18 pm, Andy Choens wrote:
> 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

-- 
"Somewhere", said Father Vittorini, "did Blake not speak of the
Machineries of Joy?  That is, did not God promote environments, then
intimidate these Natures by provoking the existence of flesh, toy men
and women, such as are we all?  And thus happily sent forth, at our
best, with good grace and fine wit, on calm noons, in fair climes, are
we not God's Machineries of Joy?"

"If Blake said that", said Father Brian, "he never lived in Dublin."
		-- R. Bradbury, "The Machineries of Joy"

-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]