3 messages in com.mysql.lists.mysqlRe: can't import sql using database<w...| From | Sent On | Attachments |
|---|---|---|
| Victor Spång Arthursson | 13 Oct 2003 00:27 | |
| Victoria Reznichenko | 13 Oct 2003 02:01 | |
| gerald_clark | 13 Oct 2003 06:40 |
| Subject: | Re: can't import sql using database<whatever.sql |
|---|---|
| From: | gerald_clark (gera...@suppliersystems.com) |
| Date: | 10/13/2003 06:40:33 AM |
| List: | com.mysql.lists.mysql |
-p without the passwd immediately following is not compatible with input redirection. Either add the password after the -p with NO space, or better yet, create a .my.cnf file in the home directory of the user running the script and have it contain the user and password settings.
Victor Spång Arthursson wrote:
Hi!
I'm having a strange problem - I can't read data using the
mysql -u root -p database<path/to/whatever.sql
Not getting any error message, but some kind of introduction text flashes by reading:
---- [powerbook:~] victor% /usr/local/mysql/bin/mysql -u root -p *** databas < /path/to/tabell.sql /usr/local/mysql/bin/mysql Ver 12.21 Distrib 4.0.15, for apple-darwin6.4 (powerpc) Copyright (C) 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: /usr/local/mysql/bin/mysql [OPTIONS] [database] -?, --help Display this help and exit. --auto-rehash Enable automatic rehashing. One doesn't need to use
[... clip ...]
max_allowed_packet 16777216 net_buffer_length 16384 select_limit 1000 max_join_size 1000000
----
Anyone knowing what to do? It's pretty urgent cause I'm having this big database for a project that is to big to import using phpmyadmin - causes the browser to time out...
Sincerely
Victor