Professional Web Applications Themes

Can I do MySQL 4.1 -> 5.1 update just like this? - MySQL

My phpBB version is 2.0.19. Can I do MySQL 4.1 -> 5.1 update just like this: 1.. Export phpbb -table with phpMyAdmin (SQL-options [x] Structure: [x] Add AUTO_INCTRMENT value [x] Enclose table and field names with backquates [x] Data: [x] Use hexadecimal for binary fileds Export type: INSERT) 2.. Uninstall MySQL 4.1 and delete folder 3.. Install MySQL 5.1 4.. Import phpbb.sql with phpMyAdmin I use same dbusername and dbpasswd, but is somekind mysql_fix_privilege_tables needed?...

  1. #1

    Default Can I do MySQL 4.1 -> 5.1 update just like this?

    My phpBB version is 2.0.19. Can I do MySQL 4.1 -> 5.1 update just like this:
    1.. Export phpbb -table with phpMyAdmin

    (SQL-options

    [x] Structure:
    [x] Add AUTO_INCTRMENT value
    [x] Enclose table and field names with backquates
    [x] Data:
    [x] Use hexadecimal for binary fileds
    Export type: INSERT)


    2.. Uninstall MySQL 4.1 and delete folder

    3.. Install MySQL 5.1

    4.. Import phpbb.sql with phpMyAdmin


    I use same dbusername and dbpasswd, but is somekind mysql_fix_privilege_tables needed?
    ShK Guest

  2. #2

    Default Re: Can I do MySQL 4.1 -> 5.1 update just like this?

    Hi,

    with your strategy, you don't take care of the mysql database which stores
    the current privileges. So you will have the default user root without
    password after this kind of update.

    If you know exactly what you do, you can of course update straight from 4.1
    to 5.1, but unless you're absolutely familar with what goes on behind the
    scenes, I would recommand you to do it the way that's described in the
    manual:

    [url]http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html[/url]

    [url]http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-5-0.html[/url]

    and upgrade from one version to another.

    You should also know that MySQL 5.1 is still alpha and not recommanded for
    production use (you should rather use 5.0.18 for a production server) and
    also that MySQL 5.1 is not yet supported by phpBB. So if you have a problem
    with phpBB and MySQL 5.1, none of the phpBB guys will care about it! I'm not
    even sure if they have already solved all the MySQL 5.0 related problems
    that might arise when you use a strict mode option.

    So if you need your database server primarily for phpBB, you would probably
    do best with MySQL 5.0.18 and not using strict mode (although you could try
    it and eventually switch back if you find any problems).

    Markus


    Markus Popp Guest

  3. #3

    Default Re: Can I do MySQL 4.1 -> 5.1 update just like this?

    "Markus Popp" <mfpgmx.li> wrote in message
    > with your strategy, you don't take care of the mysql database which stores
    > the current privileges. So you will have the default user root without
    > password after this kind of update.
    I use same username (root) with same password what it was with 4.1.
    > If you know exactly what you do, you can of course update straight from 4.1
    > to 5.1, but unless you're absolutely familar with what goes on behind the
    > scenes, I would recommand you to do it the way that's described in the
    > manual:
    > [url]http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html[/url]
    > [url]http://dev.mysql.com/doc/refman/5.1/en/upgrading-from-5-0.html[/url]
    > and upgrade from one version to another.
    I am just a newbie with this issue. I try to read that 'upgrading-from-4-1.html'
    but I dont find clear path to upgrade MySQL on Windows. Especially how I
    handle the database backup and restore.
    > So if you need your database server primarily for phpBB, you would probably
    > do best with MySQL 5.0.18 and not using strict mode (although you could try
    > it and eventually switch back if you find any problems).
    Thanks for a tip. I stick in 5.0.18 without strict mode. I have 1.75Ghz Sempron
    and 786Mb memory. Only use to computer is MySQL -server (with apache & phpbb).
    What is a fastes config to MySQL on my case? I choose those like this:

    [ ] Developer Machine
    [ ] Server Machine
    [x] Dedicated MySQL server machine

    [ ] Multifunctional Database
    [x] Transactional Database Only
    [ ] Non-Transactional Database Only

    [ ] Decision Support
    [x] Online Transaction Processing
    [ ] Manual Setting

    Is there any benefit to convert Standard Character Set (Latin1) to Multilingualism (UTF8)?

    Everything seem to work ok, but is what is that mysql_fix_privilege_tables?

    ShK Guest

Similar Threads

  1. mySQL Update Date
    By woribhabor in forum Coldfusion Database Access
    Replies: 2
    Last Post: January 16th, 04:40 AM
  2. PHP and mySQL database update
    By Timeridder in forum Dreamweaver AppDev
    Replies: 0
    Last Post: May 23rd, 02:38 PM
  3. php & mysql update problem
    By Harald Servat Gelabert in forum PHP Development
    Replies: 2
    Last Post: November 21st, 05:19 PM
  4. HOW TO -- ARRAY UPDATE MYSQL
    By Suresh Babu.A in forum PHP Development
    Replies: 2
    Last Post: July 20th, 01:12 PM
  5. UPDATE a record in MYSQL DB with PHP
    By James in forum PHP Development
    Replies: 1
    Last Post: July 8th, 05:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139