Skocz do zawartości

miguslaw

Użytkownicy
 Wyświetl profil  Zobacz jego aktywność

  • Zawartość

    136

  • Rejestracja

  • Ostatnio

  • Wygrane dni

    1

Posty napisane przez miguslaw

  4. Napisano · Raportuj odpowiedź

     

    105:~# mysql -uroot -pzxcvbnm1 -host localhost vt < /var/www/baza.sql

    mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2

    Copyright © 2002 MySQL AB

    This software comes with ABSOLUTELY NO WARRANTY. This is free software,

    and you are welcome to modify and redistribute it under the GPL license

    Usage: mysql [OPTIONS] [database]

    -?, --help Display this help and exit.

    -I, --help Synonym for -?

    --auto-rehash Enable automatic rehashing. One doesn't need to use

    'rehash' to get table and field completion, but startup

    and reconnecting may take a longer time. Disable with

    --disable-auto-rehash.

    -A, --no-auto-rehash

    No automatic rehashing. One has to use 'rehash' to get

    table and field completion. This gives a quicker start of

    mysql and disables rehashing on reconnect. WARNING:

    options deprecated; use --disable-auto-rehash instead.

    -B, --batch Don't use history file. Disable interactive behavior.

    (Enables --silent)

    --character-sets-dir=name

    Directory where character sets are.

    --default-character-set=name

    Set the default character set.

    -C, --compress Use compression in server/client protocol.

    -#, --debug[=#] This is a non-debug version. Catch this and exit

    -D, --database=name Database to use.

    --delimiter=name Delimiter to be used.

    -e, --execute=name Execute command and quit. (Disables --force and history

    file)

    -E, --vertical Print the output of a query (rows) vertically.

    -f, --force Continue even if we get an sql error.

    -G, --named-commands

    Enable named commands. Named commands mean this program's

    internal commands; see mysql> help . When enabled, the

    named commands can be used from any line of the query,

    otherwise only from the first line, before an enter.

    Disable with --disable-named-commands. This option is

    disabled by default.

    -g, --no-named-commands

    Named commands are disabled. Use \* form only, or use

    named commands only in the beginning of a line ending

    with a semicolon (;) Since version 10.9 the client now

    starts with this option ENABLED by default! Disable with

    '-G'. Long format commands still work from the first

    line. WARNING: option deprecated; use

    --disable-named-commands instead.

    -i, --ignore-spaces Ignore space after function names.

    --local-infile Enable/disable LOAD DATA LOCAL INFILE.

    -b, --no-beep Turn off beep on error.

    -h, --host=name Connect to host.

    -H, --html Produce HTML output.

    -X, --xml Produce XML output

    --line-numbers Write line numbers for errors.

    -L, --skip-line-numbers

    Don't write line number for errors. WARNING: -L is

    deprecated, use long version of this option instead.

    -n, --unbuffered Flush buffer after each query.

    --column-names Write column names in results.

    -N, --skip-column-names

    Don't write column names in results. WARNING: -N is

    deprecated, use long version of this options instead.

    -O, --set-variable=name

    Change the value of a variable. Please note that this

    option is deprecated; you can set variables directly with

    --variable-name=value.

    --sigint-ignore Ignore SIGINT (CTRL-C)

    -o, --one-database Only update the default database. This is useful for

    skipping updates to other database in the update log.

    --pager[=name] Pager to use to display results. If you don't supply an

    option the default pager is taken from your ENV variable

    PAGER. Valid pagers are less, more, cat [> filename],

    etc. See interactive help (\h) also. This option does not

    work in batch mode. Disable with --disable-pager. This

    option is disabled by default.

    --no-pager Disable pager and print to stdout. See interactive help

    (\h) also. WARNING: option deprecated; use

    --disable-pager instead.

    -p, --password[=name]

    Password to use when connecting to server. If password is

    not given it's asked from the tty. WARNING: This is

    insecure as the password is visible for anyone through

    /proc for a short time.

    -P, --port=# Port number to use for connection.

    --prompt=name Set the mysql prompt to this value.

    --protocol=name The protocol of connection (tcp,socket,pipe,memory).

    -q, --quick Don't cache result, print it row by row. This may slow

    down the server if the output is suspended. Doesn't use

    history file.

    -r, --raw Write fields without conversion. Used with --batch.

    --reconnect Reconnect if the connection is lost. Disable with

    --disable-reconnect. This option is enabled by default.

    -s, --silent Be more silent. Print results with a tab as separator,

    each row on new line.

    -S, --socket=name Socket file to use for connection.

    --ssl Enable SSL for connection (automatically enabled with

    other flags). Disable with --skip-ssl.

    --ssl-ca=name CA file in PEM format (check OpenSSL docs, implies

    --ssl).

    --ssl-capath=name CA directory (check OpenSSL docs, implies --ssl).

    --ssl-cert=name X509 cert in PEM format (implies --ssl).

    --ssl-cipher=name SSL cipher to use (implies --ssl).

    --ssl-key=name X509 key in PEM format (implies --ssl).

    --ssl-verify-server-cert

    Verify server's "Common Name" in its cert against

    hostname used when connecting. This option is disabled by

    default.

    -t, --table Output in table format.

    -T, --debug-info Print some debug info at exit.

    --tee=name Append everything into outfile. See interactive help (\h)

    also. Does not work in batch mode. Disable with

    --disable-tee. This option is disabled by default.

    --no-tee Disable outfile. See interactive help (\h) also. WARNING:

    option deprecated; use --disable-tee instead

    -u, --user=name User for login if not current user.

    -U, --safe-updates Only allow UPDATE and DELETE that uses keys.

    -U, --i-am-a-dummy Synonym for option --safe-updates, -U.

    -v, --verbose Write more. (-v -v -v gives the table output format).

    -V, --version Output version information and exit.

    -w, --wait Wait and retry if connection is down.

    --connect_timeout=# Number of seconds before connection timeout.

    --max_allowed_packet=#

    Max packet length to send to, or receive from server

    --net_buffer_length=#

    Buffer for TCP/IP and socket communication

    --select_limit=# Automatic limit for SELECT when using --safe-updates

    --max_join_size=# Automatic limit for rows in a join when using

    --safe-updates

    --secure-auth Refuse client connecting to server if it uses old

    (pre-4.1.1) protocol

    --show-warnings Show warnings after every statement.

     

    Default options are read from the following files in the given order:

    /etc/mysql/my.cnf ~/.my.cnf /usr/etc/my.cnf

    The following groups are read: mysql client

    The following options may be given as the first argument:

    --print-defaults Print the program argument list and exit

    --no-defaults Don't read default options from any options file

    --defaults-file=# Only read default options from the given file #

    --defaults-extra-file=# Read this file after the global files are read

     

    Variables (--variable-name=value)

    and boolean options {FALSE|TRUE} Value (after reading options)

    --------------------------------- -----------------------------

    auto-rehash TRUE

    character-sets-dir (No default value)

    default-character-set latin1

    compress FALSE

    database (No default value)

    delimiter ;

    vertical FALSE

    force FALSE

    named-commands FALSE

    local-infile FALSE

    no-beep FALSE

    host ost

    html FALSE

    xml FALSE

    line-numbers TRUE

    unbuffered FALSE

    column-names TRUE

    sigint-ignore FALSE

    port 3306

    prompt mysql>

    quick FALSE

    raw FALSE

    reconnect FALSE

    socket /var/run/mysqld/mysqld.sock

    ssl FALSE

    ssl-ca (No default value)

    ssl-capath (No default value)

    ssl-cert (No default value)

    ssl-cipher (No default value)

    ssl-key (No default value)

    ssl-verify-server-cert FALSE

    table FALSE

    debug-info FALSE

    user root

    safe-updates FALSE

    i-am-a-dummy FALSE

    connect_timeout 0

    max_allowed_packet 16777216

    net_buffer_length 16384

    select_limit 1000

    max_join_size 1000000

    secure-auth FALSE

    show-warnings FALSE

     

    Dobrze??

  11. Napisano · Raportuj odpowiedź

    Witam mam taki problem .

    W pliku readme.txt punkt 5 i 9 umie ktos je wykonac?? bo ja nie zbyt :/ prosze o pomoc To te punkty:

     

     

     

    5. za pomocą crontab -e dopisz ponizsze wpisy uwzględniając scieżke do panelu

     

    */1 * * * * /home/panel/files/sprawdz.sh

     

    */1 * * * * /home/panel/files/1.sh

     

    3 2 * * * php-f /home/panel/files/sprawdz.php (ważne)

     

    lub jesli posiadasz php-cgi to

    * */1 * * * /usr/bin/php-cgi -f /home/panel/files/sprawdz.php

     

    oraz.

     

     

    9. Edytować Plik bota /panel/files/bt.sh

     

    zmienić ścieżke do pliku config: include('/var/www/panel/config.php');

     

    dodać do crona wpis

     

    */1 * * * * /home/panel/files/bt.sh

     

     

     

    wtF??? Cron itp co to jest prosze o pomoc nie ogarniam tego troszke :P

     

     

    Zly dzial ?? prosze o przeniesienie ;)

  13. Napisano · Raportuj odpowiedź

    Witam!

     

    Mam sprawę. Czy mógłby mi ktoś zainstalować jakis darmowy panel, do instalacji serwerów gier lub cos typu ispCP Omega??

     

    Moj serwer:

    Linux (Debian)

     

     

    Dane podam na GG: 1359087 mam nadzieje że nikt nie haknie :) eHh pisac gg z góry thx.... :)

     

    P.S.

     

    Próbowałem już instalować ispCP Omega i cos nie wyszlo ;(

×