MySQL

• Manuálová stránka MySQL

• mysqldump --single-transaction --all-databases --skip-extended-insert -h localhost  -u root -p > <soubor>

  
  -p: zeptat se na heslo

• mysqldump --single-transaction --all-databases --skip-extended-insert -h localhost  -u root --password=heslo > <soubor>

• mysql -h <IP> -A -u root -p < <soubor>

• návod na MySQL.com
• nejjednodušší je pustit MySQL bez načtení tabulek s právama mysqld –skip-grant-tables nebo přidat do my.cnf souboru do sekce mysqld řádek skip-grant-tables
• změna hesla:

shell> mysql -u root
mysql> UPDATE mysql.user SET Password=PASSWORD('newpwd') WHERE User='root';
mysql> FLUSH PRIVILEGES;

character_set_server=utf8
collation_server=utf8_czech_ci

[client]
port			      = 3306
socket                  = /tmp/mysql-4.1.10a.sock
host			      = localhost
character-sets-dir	= /usr/local/mysql-4.1.10a/share/mysql/charsets
default-character-set	= latin2


[mysqld]
basedir		= /usr/local/mysql-4.1.10a
port			= 3306
socket		= /tmp/mysql-4.1.10a.sock
user			= mysql
language		= /usr/local/mysql-4.1.10a/share/mysql/english
character-sets-dir	= /usr/local/mysql-4.1.10a/share/mysql/charsets
default-character-set	= latin2
datadir			= /var/lib/mysql
pid-file		= /var/run/mysqld.pid
log-error		= /var/log/mysql/mysql-err.log
### vypnout INNO DB
skip-innodb
skip-locking
key_buffer = 16K
max_allowed_packet = 1M
table_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K

# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (using the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking
server-id	= 1

# Uncomment the following if you want to log updates
#log-bin

# Uncomment the following if you are NOT using BDB tables
#skip-bdb

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /usr/local/mysql/data/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/mysql/data/
#innodb_log_arch_dir = /usr/local/mysql/data/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

#!/bin/sh
# starovaci script pro MySQL
DIR=/usr/local/mysql-4.1.10a
PIDFILE=/var/run/mysqld.pid
MYCNF=$DIR/etc/my.cnf
 
case "$1" in
    'start')
    echo 'Startuji MySQL ......'
    if test -s "$PIDFILE"
    then
      mysqld_pid=`cat $PIDFILE`
	echo "MySQL jiz bezi pod id $mysqld_pid"
	exit
    else
	$DIR/bin/mysqld --defaults-extra-file=$MYCNF > /dev/null &
    fi
    sleep 2
    if test -s "$PIDFILE"
    then
        mysqld_pid=`cat $PIDFILE`
	echo "MySQL bezi pod id $mysqld_pid"
    else
	echo "MySQL se nespustilo ..."
    fi
    ;;
 
    'stop')
    if test -s "$PIDFILE"
    then
      mysqld_pid=`cat $PIDFILE`
      echo "Zastavuji MySQL bezici pod id $mysqld_pid"
      kill $mysqld_pid
      sleep 2
      while [ -s $PIDFILE -a "$flags" != aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa ]
      do
        [ -z "$flags" ] && echo "Cekam na ukonceni mysql" || echo "."
        flags=a$flags
        sleep 1
      done
      if [ -s $PIDFILE ]
         then echo " .. nezdarilo se ukonci, stale bezi!"
      elif [ -n "$flags" ]
         then echo " ...hotovo."
      fi
    else
      echo "Nenalezen $PIDFILE ... MySQL asi nebezi"
    fi
    ;;
 
  'restart')
    $0 stop
    sleep 1
    $0 start
    ;;
 
  *)
    echo "parametry: start|stop|restart"
    sleep 1
  ;;
esac