Linux下的MySql4.1.10

1.下载MySQL4.1.10
http://www.mysql.com
http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-server-4.1.10-0.i386.rpm/from/http://mirror.services.wisc.edu/mysql/
http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-client-4.1.10-0.i386.rpm/from/http://mysql.ihostunit.com/
http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-devel-4.1.10-0.i386.rpm/from/http://mysql.ihostunit.com/
http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-Max-4.1.10-0.i386.rpm/from/http://mirror.services.wisc.edu/mysql/
http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-bench-4.1.10-0.i386.rpm/from/http://mysql.ihostunit.com/
http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-embedded-4.1.10-0.i386.rpm/from/http://mysql.ihostunit.com/
http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-shared-4.1.10-0.i386.rpm/from/http://mysql.ihostunit.com/
如果是从3.x升级还需要下载这个(上面的shared就不要了):
http://dev.mysql.com/get/Downloads/MySQL-4.1/MySQL-shared-compat-4.1.10-0.i386.rpm/from/http://mysql.ihostunit.com/


2.安装:跟一般RPM安装没什么区别
rpm -Uvh *.rpm

默认安装目录:
mysql 的数据库在/var/lib/mysql下,每个database都有自己的目录
mysql server 安装在/usr/share/mysql下
mysql client 安装在/usr/lib/mysql下
mysql 的可执行程序在/usr/bin下
mysql 的守护进程在/etc/rc.d/init.d/下,叫mysqld

mysqld start启动mysql
mysql 启动Client
mysql>connect mysql 连接到名叫mysql的库上
mysql>select * from user; 试试能不能选出数据.
mysqld stop 停止mysql

3.备份与恢复:

备份:mysqldump -u[user name] -p[password] [database name] > [export filename]
恢复:mysql -u[user name] -p[password] [database name] < [export filename] (提示:需要先建好database)

好像也可以直接用tar压缩/var/lib/mysql下的文件?
原文地址:https://www.cnblogs.com/huqingyu/p/107871.html