Install MySQL Server
Install MySQL Server 5.1.30 in the machine where you want to store the StoreGrid Backup Server's metadata.
1. Download the MySQL server (mysql-5.1.30.tar.gz) file from the URL http://downloads.mysql.com/archives.php?p=mysql-5.1&v=5.1.34
2. Extract the tar file by executing 'tar -xzvf mysql-5.1.30.tar.gz'
3. Go the extracted folder by executing 'cd mysql-5.1.30'
4. Execute './configure --enable-thread-safe-client --with-plugins=max --with-gnu-ld' (Assuming you have all the appropriate stuff like gcc, g++, make, etc.,)
5. Execute 'make'
6. Execute 'make install' as root user. By default, this will install MySQL in /usr/local.
7. Copy the MySQL configuration file by executing 'cp support-files/my-medium.cnf /etc/my.cnf' as root user.
8. Open the '/etc/my.cnf' file and edit the settings as follows :
[mysqld]
socket=/tmp/mysql.sock
user=root
default-storage_engine=innodb
max_connections=800
slow_query_log = 1
innodb_log_file_size = 512M
transaction-isolation = READ-COMMITTED
innodb_flush_method=O_DIRECT
9. Execute 'mysql_install_db' to install and set up the system tables.
10. Copy the MySQL daemon script file by executing the command 'cp support-files/mysql.server /etc/init.d/mysql' as root user.
11. Change mode for the daemon file by executing the command 'chmod 755 /etc/init.d/mysql' as root user.
12. Add the MySQL daemon by executing the command '/sbin/chkconfig --add mysql' as root.
13. Start MySQL Server by executing '/etc/init.d/mysql start'.
14. Set the root password for MySQL Server by executing 'mysqladmin -u root password [mysql_root_password]' where [mysql_root_password] is the password for the MySQL root user.
Install MySQL Client
StoreGrid Backup server uses the MySQL client program to connect to the MySQL Server. Hence, you need to install the MySQL 5.1.30 client in the backup server.
Note: If you have installed the MySQL Server in your StoreGrid backup server machine itself, then please ignore this step.
For backup/replication server running in 32 bit machine :
1. Extract the MySQL installer file by executing 'tar -xzvf mysql-5.1.30.tar.gz'
2. Go to the extracted folder by executing 'cd mysql-5.1.30'
3. Execute the command './configure --enable-thread-safe-client --enable-gui=no --without-server --with-plugins=max --with-gnu-ld'
4. Execute 'make'
5. Execute 'make install' as root user
For backup/replication server running in 64 bit machine :
1. Login as root user and execute yum install mysql.i386
2. This will install 32 bit MySQL client in your 64 bit machine.
分享到:
相关推荐
linux+apache2+php5+mysql5--Install&Config
Django连接MySQL数据库需要依赖第三方库mysqlclient,然而服务器通过pip3 install mysqlclient 命令安装第三方库mysqlclient时会经常报错: ERROR: Command errored out with exit status 1: command: /home/bright...
call %1%\mysql\bin\mysqld --install mysql5 sc config mysql5 start= auto net start mysql5 call %mysql_home%\bin\mysqladmin -h localhost -u root password 123 call %mysql_home%\bin\mysql -hlocalhost -u...
因为pip在线安装会报错找不到文件EnvironmentError: mysql_config not found ;折腾来很久才装上,我已经修改了setup_posix.py...解压之后,cd进MySQL-python-1.2.5文件夹内 sudo python setup.py install 安装即可。
DBD-mysql-3.0008 DBD-mysql-3.0008 mysqlhotcopy 需要的这个文件 问题:mysqlhotcopy备份报错 /usr/local/mysql/bin/mysqlhotcopy -u ...perl Makefile.PL --mysql_config=/usr/local/mysql/bin/mysql_config make
宝塔 PHP7+安装 mysql拓展 包括资源文件和安装方法 ... 在扩展解压后的文件夹里执行下面命令 ...4.make && make install 这一步结束后,系统会提示: Installing shared extensions: /www/server/php/74/lib/p
python在安装mysql支持模块时(pip install mysql)报错_mysql.c(42) : fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory,请下载此文件默认安装,这个是64位,安装完成后在...
在使用pip install mysql总会报错: _mysql.c(42) : fatal error C1083: Cannot open include file: 'config-win.h': No such file or directory 原来还是驱动问题,不管mysql的事。 希望该安装包对你有所帮助~
my_config.h: No such file or directory. 解决办法:1)mysql版本太高,可降低版本 --此路一般不会考虑 2)注意下载的mysql-python的版本是否符和当前版本兼容 2)下载附件中的文件,放至/usr/include目录下,重新...
6. 管理员模式运行cmd到MySQL根目录运行 mysqld --install 7. 管理员模式cmd到根目录运行net start mysql启动服务,net stop mysql停止服务,可创建管理员模式批处理命令(start mysql service.bat)形如 @echo off ...
config.exe path=L:/MysqlDatabase/mySQL;Action=install;startup=true;Remoteaccess=true;password=video; 注册后启动: net start mysql 停止: net stop mysql 删除服务: config.exe path=L:/MysqlDatabase/...
6. 管理员模式运行cmd到MySQL根目录运行 mysqld --install 7. 管理员模式cmd到根目录运行net start mysql启动服务,net stop mysql停止服务,可创建管理员模式批处理命令(start mysql service.bat)形如 @echo off ...
python使用mysql时,pip install mysql-python时会报错,_mysql.c(42) : fatal error C1083: Cannot open include file: 'config-win.h': No s uch file or directory,此时使用此版本可完美解决
下载此文件可以直接通过sudo dpkg -i mysql-apt-config_0.8.9-1_all.deb 、sudo apt-get update 、sudo apt-get install mysql-server 方式安装 mysql5.7版本
mysql-proxy 安装需要依赖已有的mariadb或mysql 中的mysql_config yum install mariadb yum install mariadb-devel 解压资源进入后 ./configure make && make install
4.修改文件,添加相应字符集的编译定义: [root@www mysql-5.1.55]# vim include/config.h …… #define HAVE_CHARSET_gbk 1 #define HAVE_CHARSET_gb2312 1 …… 5.编译安装 安装后的其他调整: 建立配置文件: ...
$ pip install mysql-python Collecting MySQL-python==1.2.5 (from -r requirement (line 16)) Downloading MySQL-python-1.2.5.zip (108kB) 100% |################################| 112kB 56kB/s Complete ...
Python课程设计-基于python+MySQL+Redis+Django的智慧校园考试系.zip 系统环境 MySQL 5.5以上版本 ...配置文件位于config/local_settings.py 测试登录账号:ozn88917@bcaoo.com 密码:abc123456
在数据库中,创建库并将程序的 Public/Install/InstallDb/install.sql导入到刚刚创建的库中。 打开程序Config/config.php文件。根据内容,将数据库连接的配置信息更改为您的。 访问系统,默认的账号是admin 密码是...
新建数据库,数据库名为manage,数据库使用的是mysql npm install 修改config目录下的db.js,填写数据库ip地址,用户名和密码 npm start 【备注】 主要针对计算机相关专业的正在做毕设的学生和需要项目实战的Java...