Új hozzászólás Aktív témák

• #5522 vargalex Topikgazda r3pl4y #5463

  Új Válasz 2010-11-02 15:28:33 #5522

  Új hozzászólás

  Összes hozzászólása itt Válaszok az összes hozzászólására itt Válaszok erre a hozzászólásra

  Privát üzenet küldése

  

  vargalex

  Topikgazda

  válasz r3pl4y #5463 üzenetére

  Hi!

  Nálam a MYSQL telepítés így néz ki:

  root@D-Link:/opt/data# opkg install mysql-server
  Installing mysql-server (5.0.18-3) to root...
  Downloading http://downloads.openwrt.org/snapshots/trunk/ar71xx/packages//mysql-server_5.0.18-3_ar71xx.ipk.
  Installing libmysqlclient (5.0.18-3) to root...
  Downloading http://downloads.openwrt.org/snapshots/trunk/ar71xx/packages//libmysqlclient_5.0.18-3_ar71xx.ipk.
  Configuring libmysqlclient.
  Configuring mysql-server.
  root@D-Link:/opt/data#vi /etc/my.conf
  
  [client]
  port = 3306
  socket = /var/run/mysqld.sock
  
  [mysqld]
  user = root
  socket = /var/run/mysqld.sock
  port = 3306
  basedir = /usr
  
  ############ Don't put this on the NAND #############
  # Figure out where you are going to put the databases
  # And run mysql_install_db --force
  datadir = /opt/data/mysql/
  
  ######### This should also not go on the NAND #######
  tmpdir = /opt/data/tmp/
  
  skip-external-locking
  
  bind-address = 127.0.0.1
  
  # Fine Tuning
  key_buffer = 16M
  max_allowed_packet = 16M
  thread_stack = 192K
  thread_cache_size = 8
  
  # Here you can see queries with especially long duration
  #log_slow_queries = /var/log/mysql/mysql-slow.log
  #long_query_time = 2
  #log-queries-not-using-indexes
  
  # The following can be used as easy to replay backup logs or for replication.
  #server-id = 1
  #log_bin = /var/log/mysql/mysql-bin.log
  #expire_logs_days = 10
  #max_binlog_size = 100M
  #binlog_do_db = include_database_name
  #binlog_ignore_db = include_database_name
  
  
  [mysqldump]
  quick
  quote-names
  max_allowed_packet = 16M
  
  [mysql]
  #no-auto-rehash # faster start of mysql but no tab completition
  
  [isamchk]
  key_buffer = 16M
  
  
  root@D-Link:/opt/data# ls -las
  4 drwxr-xr-x 2 root root 4096 Nov 2 15:16 .
  4 drwxr-xr-x 10 root root 4096 Nov 2 14:50 ..
  root@D-Link:/opt/data# mkdir mysql
  root@D-Link:/opt/data# mkdir tmp
  root@D-Link:/opt/data# mysql_install_db --force
  /usr/bin/mysql_install_db: line 151: /bin/hostname: not found
  Installing all prepared tables
  Fill help tables
  
  To start mysqld at boot time you have to copy support-files/mysql.server
  to the right place for your system
  
  PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
  To do so, start the server, then issue the following commands:
  /usr/bin/mysqladmin -u root password 'new-password'
  /usr/bin/mysqladmin -u root -h password 'new-password'
  See the manual for more instructions.
  
  You can start the MySQL daemon with:
  cd /usr ; /usr/bin/mysqld_safe &
  
  You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
  cd sql-bench ; perl run-all-tests
  
  Please report any problems with the /usr/bin/mysqlbug script!
  
  The latest information about MySQL is available on the web at
  http://www.mysql.com
  Support MySQL by buying support/licenses at https://order.mysql.com
  root@D-Link:/opt/data#
  
  root@D-Link:/opt/data# cd mysql
  root@D-Link:/opt/data/mysql# ls -las
  4 drwxr-xr-x 4 root root 4096 Nov 2 15:16 .
  4 drwxr-xr-x 4 root root 4096 Nov 2 15:16 ..
  4 drwx------ 2 root root 4096 Nov 2 15:16 mysql
  4 drwx------ 2 root root 4096 Nov 2 15:16 test
  root@D-Link:/opt/data/mysql# /etc/init.d/mysqld start
  
  root@D-Link:/opt/data/mysql# mysqladmin -u root password mypass
  root@D-Link:/opt/data/mysql# mysqladmin -u root --password=mypass create mydatabase
  root@D-Link:/opt/data/mysql# ls -las
  4 drwxr-xr-x 5 root root 4096 Nov 2 15:19 .
  4 drwxr-xr-x 4 root root 4096 Nov 2 15:16 ..
  4 -rw-rw---- 1 root root 6 Nov 2 15:18 D-Link.pid
  5120 -rw-rw---- 1 root root 5242880 Nov 2 15:18 ib_logfile0
  5120 -rw-rw---- 1 root root 5242880 Nov 2 15:18 ib_logfile1
  10240 -rw-rw---- 1 root root 10485760 Nov 2 15:18 ibdata1
  4 drwx------ 2 root root 4096 Nov 2 15:19 mydatabase
  4 drwx------ 2 root root 4096 Nov 2 15:16 mysql
  4 drwx------ 2 root root 4096 Nov 2 15:16 test
  root@D-Link:/opt/data/mysql#

  Látszik, hogy megy a dolog.
  Ha a hibaüzenet zavar, akkor megcsinálhatod a hostname-t. A /bin/hostname tartalma legyen ez:

  echo `uci get system.@system[0].hostname`

  Az rtorrent-ért bocsánat, teljesen kiment a fejemből a libtorrent. Jogos a felvetés. A teljes letölthető innen.

  Alex

Új hozzászólás Aktív témák