Resultaten 1 tot 15 van de 23
Pagina 1 van de 2 1 2 LaatsteLaatste
Geen

Onderwerp: linux mysql

  1. #1
    linux mysql
    geregistreerd gebruiker
    91 Berichten
    Ingeschreven
    08/04/09

    Locatie
    Nederland

    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1 Berichten zijn liked



    Thread Starter

    linux mysql

    Hoi vraagje,

    ik heb een sql bestand van 1,5 gb die ikwil importeren, via de web loopt het steeds vast. is er een software waarmee je dan kan oploaden?

    gr

  2. #2
    linux mysql
    geregistreerd gebruiker
    483 Berichten
    Ingeschreven
    09/09/05

    Locatie
    Beilen / Groningen

    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    25 Berichten zijn liked


    Naam: Jasper Aikema
    Bedrijf: ja - advies en beheer
    Functie: Eigenaar
    URL: www.jasperaikema.nl
    KvK nummer: 55931480
    View jasperaikema's profile on LinkedIn

    Jazeker. Je kunt dmv mysql < sql-bestand.sql een bestand importeren. Let er wel op dat je wel de juiste gebruikersnaam, wachtwoord, database en hostnaam mee geeft.

    Zie ook de man pages: man mysql
    ja - advies en beheer: Hosting in de cloud - the next big thing!

  3. #3
    linux mysql
    ISPConnect
    3.729 Berichten
    Ingeschreven
    10/01/07

    Locatie
    Nieuwegein

    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    0 Thread(s)
    134 Berichten zijn liked


    Naam: Marin Heideman
    Bedrijf: DigiState B.V.
    URL: http://www.digistate.nl
    ISPConnect: Lid
    View mheideman's profile on LinkedIn

    Inderdaad, je moet dan wel SSH toegang hebben tot de server. Blaas het bestand ernaartoe met (S)FTP en laadt het in via de sql cli
    Marin Heideman (DigiState B.V.)

  4. #4
    linux mysql
    geregistreerd gebruiker
    91 Berichten
    Ingeschreven
    08/04/09

    Locatie
    Nederland

    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1 Berichten zijn liked



    Thread Starter
    Citaat Oorspronkelijk geplaatst door asusk7m550 Bekijk Berichten
    Jazeker. Je kunt dmv mysql < sql-bestand.sql een bestand importeren. Let er wel op dat je wel de juiste gebruikersnaam, wachtwoord, database en hostnaam mee geeft.

    Zie ook de man pages: man mysql
    hiermee moet je volgens mij eerst de bestand upload naar de server, is er ook een windows aplicatie waarmee je vanuit lokaal kan imorteren naar de mysql

  5. #5
    linux mysql
    geregistreerd gebruiker
    441 Berichten
    Ingeschreven
    16/09/05

    Locatie
    Terneuzen

    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    0 Thread(s)
    12 Berichten zijn liked


    Naam: Frank Buijze
    Bedrijf: FraJa WeB
    Functie: Eigenaar
    URL: www.frajaweb.nl
    Registrar SIDN: ja
    ISPConnect: Lid
    KvK nummer: 58893962
    Ondernemingsnummer: nvt

    MySQL heeft wel verschillende tooltjes op haar website die daar bij kunnen assisteren.

  6. #6
    linux mysql
    ISPConnect
    3.729 Berichten
    Ingeschreven
    10/01/07

    Locatie
    Nieuwegein

    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    0 Thread(s)
    134 Berichten zijn liked


    Naam: Marin Heideman
    Bedrijf: DigiState B.V.
    URL: http://www.digistate.nl
    ISPConnect: Lid
    View mheideman's profile on LinkedIn

    Citaat Oorspronkelijk geplaatst door Peter Kroon Bekijk Berichten
    hiermee moet je volgens mij eerst de bestand upload naar de server, is er ook een windows aplicatie waarmee je vanuit lokaal kan imorteren naar de mysql
    Ja die zijn er wel, maar vaak staat de MySQL poort niet open naar buiten toe, da gaat dat niet werken. Heb je direct toegang tot die server? Op Shell niveau?
    Marin Heideman (DigiState B.V.)

  7. #7
    linux mysql
    geregistreerd gebruiker
    89 Berichten
    Ingeschreven
    09/08/10

    Locatie
    Zoetermeer

    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    13 Berichten zijn liked


    Naam: Mark Kapitein
    Bedrijf: ColoCenter B.V.
    Functie: Operations Manager
    URL: http://colocenter.nl
    Registrar SIDN: nee
    KvK nummer: 27258635
    Ondernemingsnummer: NL812442878B01
    View pub/mark-kapitein/18/145/a61's profile on LinkedIn

    Probeer het hiermee even:

    http://www.ozerov.de/bigdump/

  8. #8
    linux mysql
    ICTFrameworks
    1.584 Berichten
    Ingeschreven
    05/07/03

    Locatie
    's-Gravenzande

    Post Thanks / Like
    Mentioned
    15 Post(s)
    Tagged
    0 Thread(s)
    138 Berichten zijn liked


    Bedrijf: ICT Frameworks
    KvK nummer: 52425762

    Ik zou het aan je hoster vragen, is een kleine moeite vanaf de prompt.

  9. #9
    linux mysql
    www.xenius.be
    1.515 Berichten
    Ingeschreven
    26/11/11

    Locatie
    Oud-Turnhout

    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    0 Thread(s)
    73 Berichten zijn liked


    Naam: Steve Vos
    Bedrijf: Xenius
    Functie: Zaakvoerder
    URL: www.xenius.be
    Ondernemingsnummer: 0505928838

    Mysqldumper.. Daarmee al meermaals zoiets gedaan

    Sent from my Nexus 5 using webhostingtalk mobile app
    Xenius.be | Our solutions, our products, your success !

  10. #10
    linux mysql
    geregistreerd gebruiker
    87 Berichten
    Ingeschreven
    12/01/13

    Locatie
    Antwerpen

    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    9 Berichten zijn liked


    Naam: Mathias
    URL: denbeke.be

    Ik doe zulke dingen altijd via de command line...

  11. #11
    linux mysql
    geregistreerd gebruiker
    91 Berichten
    Ingeschreven
    08/04/09

    Locatie
    Nederland

    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1 Berichten zijn liked



    Thread Starter
    mysqldump -u username -p password dbname_ > /var/www/vhosts/xx.nl/xx.sql

    krijg ik dit error
    Got error: 1044: Access denied for user

  12. #12
    linux mysql
    geregistreerd gebruiker
    1.425 Berichten
    Ingeschreven
    20/03/09

    Locatie
    Barendrecht

    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)
    178 Berichten zijn liked


    Naam: Patrick Ekkel
    Bedrijf: Unsal Infratechniek B.V.
    Functie: Monteur Laagspanning
    URL: unsal.nl

    Om een MySQL databse te exporteren

    mysqldump -u username -p database_name > dumpfile.sql

    Om een MySQL database te importeren

    mysql -u username -p database_name < dumpfile.sql


    en anders http://sql-splitter.soft112.com/



  13. #13
    linux mysql
    ISPConnect
    3.729 Berichten
    Ingeschreven
    10/01/07

    Locatie
    Nieuwegein

    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    0 Thread(s)
    134 Berichten zijn liked


    Naam: Marin Heideman
    Bedrijf: DigiState B.V.
    URL: http://www.digistate.nl
    ISPConnect: Lid
    View mheideman's profile on LinkedIn

    Citaat Oorspronkelijk geplaatst door Peter Kroon Bekijk Berichten
    mysqldump -u username -p password dbname_ > /var/www/vhosts/xx.nl/xx.sql

    krijg ik dit error
    Got error: 1044: Access denied for user
    uuuhm, ik hoop dat je "username" en "password" en "dbname" en de xjes wel hebt vervangen door de juiste data?
    Marin Heideman (DigiState B.V.)

  14. #14
    linux mysql
    geregistreerd gebruiker
    91 Berichten
    Ingeschreven
    08/04/09

    Locatie
    Nederland

    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1 Berichten zijn liked



    Thread Starter
    iid de xjes wel met mijn info

  15. #15
    linux mysql
    geregistreerd gebruiker
    91 Berichten
    Ingeschreven
    08/04/09

    Locatie
    Nederland

    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    1 Berichten zijn liked



    Thread Starter
    met de mysql command krijg ik dit te zien... gebeurt verder niets.

    mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
    Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.

    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.
    -B, --batch Don't use history file. Disable interactive behavior.
    (Enables --silent.)
    --character-sets-dir=name
    Directory for character set files.
    --column-type-info Display column type information.
    -c, --comments Preserve comments. Send comments to the server. The
    default is --skip-comments (discard comments), enable
    with --comments.
    -C, --compress Use compression in server/client protocol.
    -#, --debug[=#] This is a non-debug version. Catch this and exit.
    --debug-check Check memory and open file usage at exit.
    -T, --debug-info Print some debug info at exit.
    -D, --database=name Database to use.
    --default-character-set=name
    Set the default character set.
    --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.
    -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.
    -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 Ignore statements except those that occur while the
    default database is the one named at the command line.
    --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.
    -P, --port=# Port number to use for connection or 0 for default to, in
    order of preference, my.cnf, $MYSQL_TCP_PORT,
    /etc/services, built-in default (3306).
    --prompt=name Set the mysql prompt to this value.
    --protocol=name The protocol to use for 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 The 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.
    --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=#
    The maximum packet length to send to or receive from
    server.
    --net_buffer_length=#
    The buffer size 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.
    --server-arg=name Send embedded server this as a parameter.
    --show-warnings Show warnings after every statement.

    Default options are read from the following files in the given order:
    /etc/mysql/my.cnf /etc/my.cnf ~/.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 option 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)
    column-type-info FALSE
    comments FALSE
    compress FALSE
    debug-check FALSE
    debug-info FALSE
    database (No default value)
    default-character-set latin1
    delimiter ;
    vertical FALSE
    force FALSE
    named-commands FALSE
    ignore-spaces FALSE
    local-infile FALSE
    no-beep FALSE
    host (No default value)
    html FALSE
    xml FALSE
    line-numbers TRUE
    unbuffered FALSE
    column-names TRUE
    sigint-ignore FALSE
    port 0
    prompt mysql>
    quick FALSE
    raw FALSE
    reconnect FALSE
    socket (No default value)
    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
    user (No default value)
    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

Pagina 1 van de 2 1 2 LaatsteLaatste

Webhostingtalk.nl

Contact

  • Rokin 113-115
  • 1012 KP, Amsterdam
  • Nederland
  • Contact
© Copyright 2001-2018 Webhostingtalk.nl.
Web Statistics