Re: Upgrading from mysql 4.0 to mysql 4.1

From: stud rocket (stud.rocket_at_gmail.com)
Date: 06/28/05

  • Next message: belahcene: "re:Where sarge HD installer" 
    Date: Tue, 28 Jun 2005 14:04:10 -0500
To: debian-user@lists.debian.org

    On 6/28/05, Adam Majer <adamm@zombino.com> wrote:
    > 1. Backup all databases. `man mysqldump` will help you here

    Definitely. I was also planning to just backup the binary db files in
    hopes I can just drop them into MySQL 4.1.

    > 2. Upgrade to 4.1
    > 3. Purge 4.0 (a little while back this step used to remove the databases
    > for 4.1 as well, but it should be fixed now).

    Can I switch steps 2 & 3? Synaptic wants to Remove 4.0 before installing 4.1.

    > 4. You may need to run /usr/bin/mysql_fix_privilege_tables. On second
    > though, you probably should run that script :)

    That's the sort of information I wanted to know about! Thanks! I
    tried finding documentation on how to do this upgrade, but no one else
    in Debian-land seems to care much about the difference between
    4.0/4.1.

    Thanks again for the help!

    michael

  • Next message: belahcene: "re:Where sarge HD installer"

    Relevant Pages

    • Re: How to create my own VB backup program for a remote MySQL DB
      ... MySQL has an OLEDB driver, ... Both data and schema are stored in the output file. ... the recordset to an open connection, call UpdateBatch and ADO and the server ... > I understand that the basic principles to create a TCP/IP backup program ...
      (microsoft.public.vb.database)
    • Re: [opensuse] Moving the database directories
      ... (I'm already kicking off the apps from a script to backup the data after ... I close the app - but if the backup doesn't work than I'm back to square ... For MySQL I would not copy/move the physical files... ... Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org ...
      (SuSE)
    • Upgrade: MySQL Auto Backup 1.28
      ... Download MySQL Auto Backup at http://www.swordsky.com to help you. ... Backups your data automatically from MySQL Database Server ... Save task log to TXT file and save task log to LOG file. ...
      (php.general)
    • Re: to backup mysql,what file should I copy?
      ... I do not know about mysql, but I do know about other dbms's. ... use the backup tools _in the dbms_ to backup a dbms. ... or ext3 file system stuff), the maximum size might be larger because it ...
      (comp.os.linux.misc)
    • Re: [opensuse] Backup Process
      ... I see that KDAR is no longar maintained so I'd like to move on to something ... I currently use a custom bash script that does mysql and subversion ... generates a list of files to backup from a set of simple ... I am working on a Perl script that does all the above with a bit more ...
      (SuSE)