نمایش نتایج: از شماره 1 تا 2 , از مجموع 2

موضوع: آپگرید mysql 4 به 4.1 در سی پنل

  1. #1
    مدیر کل Vahid آواتار ها
    تاریخ عضویت
    Aug 2008
    نوشته ها
    2,724
    تشکر تشکر کرده 
    435
    تشکر تشکر شده 
    6,959
    تشکر شده در
    2,085 پست

    پیش فرض آپگرید mysql 4 به 4.1 در سی پنل

    Overview:
    MySQL 4.1 has been available for quite some time but many server admins still haven’t gotten around to getting their MySQL 4.0 upgraded to 4.1 We offer a quick and easy method to get this accomplished through your Cpanel/WHM server.
    You’ll need about 30-45 minutes to complete this, maybe a bit longer. We have to update Cpanel, update MySQL and rebuild Apache/PHP.
    Check what version of MySQL you currently have installed. It’s probably 4.0x but you can check through shell by doing the following:
    # mysql -V

    Upgrading MySQL 4.0 to 4.1
    There are some excellent documentation and notes you should read before proceeding with this upgrade tutorial. We aren’t going to cover everything so I suggest you take a minute to read this, upgrading MySQL is a major upgrade and is irreversible!
    MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 2.11.1 Upgrading from MySQL 4.0 to 4.1
    Installing MySQL 4.1 - the upgrade begins

    The first thing we need to do is make sure Cpanel is updated to the latest version. You can do the update through WHM Upgrade to Latest Version or through shell # /scripts/upcp
    Once the update completes you want to go into WHM.
    Server Configuration, Tweak Settings section

    Select MySQL 4.1 option, do no check use old authentication.
    Scroll to the bottom and hit Save.

    You’ll then see the next screen such as this:
    Your changes have been saved
    If you made changes to the mysql version, please Click Here after waiting 30 seconds to have them take effect.
    Restarting....Done
    So we’ll wait 30 seconds and then click the link =)
    Cpanel will then go through a bit process of grabbing the latest MySQL version 4.1.13 at the time of this tutorial and install it automatically through RPMs.
    Once this page completes you need to do a few more steps to complete the update.
    You should see a Complete message that’s bolded when its done.
    Updating PHP to support MySQL 4.1
    Now you need to recompile Apache/PHP to support the changes as quick as possible because PHP will currently not work with MySQL. You might see something like this in console:
    # php -v
    php: error while loading shared libraries: libmysqlclient.so.12: cannot open shared object file: No such file or directory
    This is normal and fine, lets proceed with the Apache update. See our detailed /scripts/easyapache tutorial here.
    # /scripts/easyapache
    Don’t change any of the default MySQL options here, select the other settings you want. Save the changes and let it rebuild. This usually takes 20 minutes or so to complete:

    Now that Apache has finished recompiling we want to make sure it works properly! In shell again do the following command. It should produce your PHP version information without any errors:
    # php –v
    PHP 4.4.1 (cli) (built: Dec 8 2005 2056)
    Copyright (c) 1997-2004 The PHP Group
    Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies
    You can also check the MySQL version with the following:
    # mysql –V
    mysql Ver 14.7 Distrib 4.1.13, for pc-linux-gnu (i686) using readline 4.3
    Upgrade is complete! Give yourself a pat on the back for some hard work and take a deep breath because you got through this haha =)
    MySQL 4.1 upgrade Problems?
    Make sure you follow all the steps, especially rebuilding Apache/PHP if you don’t the libraries will be out of sync and no websites will be able to connect to databases.
    Notes:
    The 4.0 to 4.1 MySQL upgrade changes many aspects of databases. For example, when you’re trying to restore a 4.0 database to a 4.1 database it will not work. The opposite is also true. This is because it ads new fields, etc to tables that each version doesn’t support. So if you have many machines, upgrade them all or none because if you’re moving databases around you’re going to hit a brick wall..
    برای پیش رفت در علم آسانسوری وجود ندارد پله ها را باید پیاده رفت /./ همیشه این یادتان باشد که دست بالای دست بسیار است.
    يادمان باشد براي يك بار ايستادن صد ها بار افتاده ايم /./ بک آپ مهمترین رمز موفقیت هاستینگ /./ امنیت مطلق نیست.
    ارتباط مستقیم با من :
    Admin -{(@)}- WebHostingTalk . ir

  2. تعداد تشکر ها ازVahid به دلیل پست مفید


  3. # ADS




     

  4. #2
    عضو جدید DedicatedBOX آواتار ها
    تاریخ عضویت
    Aug 2008
    نوشته ها
    69
    تشکر تشکر کرده 
    49
    تشکر تشکر شده 
    109
    تشکر شده در
    62 پست

    پیش فرض

    سلام سایت خیلی خوبی دارید ممنون
    راستی امضای خیلی خیلی جالبی دارید! مخصوصا اون ضرب المثله

  5. تعداد تشکر ها از DedicatedBOX به دلیل پست مفید


اطلاعات موضوع

کاربرانی که در حال مشاهده این موضوع هستند

در حال حاضر 1 کاربر در حال مشاهده این موضوع است. (0 کاربران و 1 مهمان ها)

موضوعات مشابه

  1. از بین رفتن mysql در سی پنل جدید !
    توسط TZHOST در انجمن سی پنل CPanel
    پاسخ ها: 3
    آخرين نوشته: July 14th, 2017, 15:30
  2. مشکل دان شدن mysql در سی پنل
    توسط mandana32 در انجمن سی پنل CPanel
    پاسخ ها: 27
    آخرين نوشته: April 28th, 2017, 11:36
  3. مشکل mysql سی پنل
    توسط Ali_faraji در انجمن سی پنل CPanel
    پاسخ ها: 3
    آخرين نوشته: September 9th, 2016, 13:51
  4. پاسخ ها: 14
    آخرين نوشته: August 11th, 2013, 01:44
  5. ارور Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
    توسط pc.rootall در انجمن سوالات و مشکلات
    پاسخ ها: 8
    آخرين نوشته: July 20th, 2013, 17:37

مجوز های ارسال و ویرایش

  • شما نمیتوانید موضوع جدیدی ارسال کنید
  • شما امکان ارسال پاسخ را ندارید
  • شما نمیتوانید فایل پیوست کنید.
  • شما نمیتوانید پست های خود را ویرایش کنید
  •