restoring database previous mysql version

2006-04-03 Thread murat .

Dear Sir,

I have 8 mb total SQL database, i'm currently using mysql version: 
4.1.11-debian.


Our database uses latin5 character set and collate: latin5_turkish_ci

And now... how can i restore this database without problem; previous mysql 
version?


previous mysql version is: 4.0.25-standart

Note: I have SSH Access.

This is very important for me, thank you.

_
Hava durumunu bizden ögrenin ve evden öyle çikin! 
http://www.msn.com.tr/havadurumu/



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: restoring database previous mysql version

2006-04-03 Thread Kishore Jalleda
if I have to put in one line, then just taka a copy (zip, gzip, tar or
whatever) of your old mysql data directory, like /usr/local/mysql/data, and
then restore it into your new data directory under 4.1.x, and this should be
fine assuming you have taken care of other things, also please refer to the
doc on mysql for the upgrade 

http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html
http://dev.mysql.com/doc/refman/4.1/en/upgrading-to-arch.html

Kishore Jalleda
http://kjalleda.googlepages.com


On 4/3/06, murat . [EMAIL PROTECTED] wrote:

 Dear Sir,

 I have 8 mb total SQL database, i'm currently using mysql version:
 4.1.11-debian.

 Our database uses latin5 character set and collate: latin5_turkish_ci

 And now... how can i restore this database without problem; previous mysql
 version?

 previous mysql version is: 4.0.25-standart

 Note: I have SSH Access.

 This is very important for me, thank you.

 _
 Hava durumunu bizden ögrenin ve evden öyle çikin!
 http://www.msn.com.tr/havadurumu/


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]