Re: Can't Restore Back-Up

Andy -

You da man!!  Thanks for your feedback on SuSE.  I've got  some 
production MySQL databases, and was wondering if SuSE would be a good 
choice.

- James


On Feb 5, 2005, at 8:53 PM, Andy Choens wrote:

> 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]
>


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