olemskoi.ru

Архив тега ‘mysql’

mysql-worbench-5.2.27 (перепечатка)

Комментариев нет

MySQL Worbench, the modeling, development and administration graphical tool for MySQL databases is now available as 5.2.27 (GA = stable). RPM for Fedora ≥ 10 are available in remi repository.

Read the Releases Page for changes history, or Changes in MySQL Workbench 5.2.27.
The download site only provide RPM for Fedora 13 i386 and x86_64. My repository provides RPM for Fedora 10, 11, 12, 13, i386, x86_64, ppc and ppc64. Previous Fedora versions don't have needed dependencies, such as cairo >= 1.8.0.
As always :
yum --enablerepo=remi... Lire mysql-worbench-5.2.27

MySQL 5 to MySQL 4.1 downgrade on Plesk (перепечатка)

Комментариев нет

Для сборки mysql на потребуется установить:

yum install gcc ncurses-devel gcc-c++

берем тарбол mysql-4.1.22, распаковываем, собираем и ставим в /opt/mysql-4.1.22 дефолтная кодировка mysql будет cp1251

wget http://www.mirrorservice.org/sites/ftp.mysql.com/Downloads/MySQL-4.1/mysql-4.1.22.tar.gz
tar zxf mysql-4.1.22.tar.gz
cd mysql-4.1.22
./configure --with-charset=cp1251 --with-collation=cp1251_general_ci \
                --with-extra-charset=all --prefix=/opt/mysql-4.1.22 \
                --without-docs --without-man --without-bench
make && make install

теперь остановим mysql5 установленный панелью Plesk и заменим инитскрипт

/etc/init.d/mysqld stop
gzip /etc/init.d/mysqld
cp /opt/mysql-4.1.22/share/mysql/mysql.server /etc/init.d/mysqld
/etc/init.d/mysqld start

После запуска mysql 4.1 проверим работоспособность mysql

mysql -uadmin -p`cat  /etc/psa/.psa.shadow`
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 4.1.22

В панели плеск root не используется, суперпользователь имеет логин admin а пароль совпадает с паролем от входа в панель, если вы его забыли или не знаете, подсмотреть его можно в файле /etc/psa/.psa.shadow

Administering MySQL (перепечатка)

Комментариев нет

In this lesson of the MySQL tutorial, you will learn...

1. To start up and shut down the MySQL Server
2. To view Information about the Server and Databases
3. To view and kill Threads
4. To clear System Caches
5. Various mysqladmin Options

Original news source

A simple guide to redundant cloud hosting (перепечатка)

Комментариев нет

Today, on my 28th birthday, I'm finally delivering on a promise to my readers which I made about two months ago. I've written a guide on how to host a web application redundantly in a cloud environment. While it's still a bit of a rough draft, it should be a good starting point for those who haven't worked in virtualized environments before. Also, it may show some of the more experienced systems administrators a new way to do things.

The guide: Redundant Cloud Hosting Guide

As always, if you find anything in the guide that needs improvement, I'm all ears. :-)

©2010 Racker Hacker. All Rights Reserved.

.

MySQL 5.1 coming to yum repo, info & warnings within… (перепечатка)

Комментариев нет

My original thoughts were to roll out packages for MySQL 5.1 and PHP 5.3 at the same time. Given the issues with Zend getting loaders for 5.3 out the door, and the complications with developers needing a newer version of Zend Guard and having to recompile everything in order for it to work with [...]

mysql-worbench-5.2.26 (перепечатка)

Комментариев нет

MySQL Worbench, the modeling, development and administration graphical tool for MySQL databases is now available as 5.2.26 (GA = stable). RPM for Fedora ≥ 10 are available in remi repository.

Read the Releases Page for changes history, or Changes in MySQL Workbench 5.2.26.
The download site only provide RPM for Fedora 12 i386 and x86_64. My repository provides RPM for Fedora 10, 11, 12, 13, i386, x86_64, ppc and ppc64. Previous Fedora versions don't have needed dependencies, such as cairo >= 1.8.0.
As always :
yum --enablerepo=remi... Lire mysql-worbench-5.2.26

mysql-5.1.49 (перепечатка)

Комментариев нет

RPM of the MySQL Community Server 5.1.49 are available in remi repository for EL 4 & 5 and for Fedora. See Changelog.

This build use a spec file close to the one from Rawhide. The Federated «storage engines» is activated by default by the launch script.
The new InnoDB plugin (version 1.0.10 which is GA) is also available. The configuration file (/etc/my.cnf) contains the directives needed to enable it.
WARNING: before upgrading, a full backup of your databases... Lire mysql-5.1.49

mysql-worbench-5.2.25 (перепечатка)

Комментариев нет

MySQL Worbench, the modeling, development and administration graphical tool for MySQL databases is now available as 5.2.25 (GA = stable). RPM for Fedora ≥ 10 are available in remi repository.

Read the Releases Page for changes history, or Changes in MySQL Workbench 5.2.25.
The download site only provide RPM for Fedora 12 i386 and x86_64. My repository provides RPM for Fedora 10, 11, 12, 13, i386, x86_64, ppc and ppc64. Previous Fedora versions and don't have needed dependencies, such as cairo >= 1.8.0.
As always :
yum... Lire mysql-worbench-5.2.25

mysql-worbench-5.2.24 (перепечатка)

Комментариев нет

MySQL Worbench, the modeling, development and administration graphical tool for MySQL databases is now available as 5.2.24 (Release Candidate 3). RPM for Fedora ≥ 10 are available in remi repository.

Read the Releases Page for changes history, or Changes in MySQL Workbench 5.2.24.
The download site only provide RPM for Fedora 12 i386 and x86_64. My repository provides RPM for Fedora 10, 11, 12, 13, i386, x86_64, ppc and ppc64. Previous Fedora versions and don't have needed dependencies, such as cairo >= 1.8.0.
As always :
yum... Lire mysql-worbench-5.2.24

mysql-5.1.48 (перепечатка)

Комментариев нет

RPM of the MySQL Community Server 5.1.48 are available in remi repository for EL 4 & 5 and for Fedora. See Changelog.

This build use a spec file close to the one from Rawhide. The Federated «storage engines» is activated by default by the launch script.
The new InnoDB plugin (version 1.0.8 which is GA) is also available. The configuration file (/etc/my.cnf) contains the directives needed to enable it.
WARNING: before upgrading, a full backup of your databases... Lire mysql-5.1.48