On Saturday 14 August 2004 01:06 am, [EMAIL PROTECTED] wrote:
> mysql> mysqldump b
> -> c:/hdump/dump.sql
Do it from the command line, not mysql command prompt.
--
===
Jabber: tradergt@(smelser.org|jabber.org)
Quote: "We don'
Dear friends,
I am using following command to dump mysql database files,
mysql> mysqldump b
-> c:/hdump/dump.sql
where c:/hdump/dump.sql is the path where database files should be stored,
however its not working.
Any guidance, please.
Lars,
uhm, installed that package and it confirms your suspicion:
Total memory: 612 Megabytes
Kernel Memory: 60 Megabytes
Application: 89 Megabytes
Executable & libs: 32 Megabytes
File Cache: 419 Megabytes
Free, file cache: 6 M
Hi Markus,
I just missed something in your original Mail,
I guess its not the mysql server growing to 1gig (check with ps -ely)
its simply the system memory showing no free mem.
If you have root access to the maschine its probably a good idea to
install the prtmem command (ftp://playground.sun.co
Lars,
the amount used increases until all free memory is used plus a fair amount of
swap. On a machine with 2GB memory this can well grow up to 1GB.
Any chance to get the current size of the malloc pool to check if this
causes the effect?
thx so far,
Markus
On Don, 21 Nov 2002, Lars Heidieker
Does the memory amount used increases any further if repeating the dump
import.
If so there is a leak if not you just got fooled by the standard malloc
of solaris which wont return memory free(d) to the system but instead
the memory will be kept in a pool for the next malloc.
Lars
On Donnerst
>Description:
Dump several big tables or entire databases with mysqldump, then
import to same or another database with mysql -f db How-To-Repeat:
Dump a database with around 250.000 to 3.000.000 records, record size
is around 200 bytes.
Import dump file and s
g to load large dump files
Hi Tracy,
Just add err-log=/path/to/logfile/mysqld.err under safe_mysqld entry in your
my.cnf file and see what the error file says after you restart it.. We can
track down the problem from the error..
Gurhan
-Original Message-
From: Tracy Kitts [mailto:[EMAIL P
I've created a dump file using mysqldump that is about 4MB. When I try to
load it on another server using "mysql database < dump.sql" I get errors.
If I create a smaller dump file (below 1MB) it loads without a problem. I
noticed that the default max_allowed_packet size is 1MB, but I've not had
i guess that is confusing to me because it says "query".
i'm really stuck though -see my recent 'please help' post to the mysql list.
thanks.
At 2:48 AM -0600 6/18/01, Chris Bolt wrote:
> > thank you.
>> that's sort of what i thought.
>>
>> now for the silly question:
>> i know how to do it w
> thank you.
> that's sort of what i thought.
>
> now for the silly question:
> i know how to do it with 'monitor' (CLI), but where/how do you
> "import" using phpMyAdmin, please? (this i'd love to know :) i looked
> through the manual but didn't see anything for "import" db.
Click a database on
i'd like to use the db i sent but unless i'm importing wrong there's
an error in it somewhere and thus it won't import.
i don't suppose anyone who has it could take a peek? or knows where i
can get something like it?
Thank you.
Ted Rogers
At 4:30 AM -0600 6/17/01, Chris Bolt wrote:
>That is
thank you.
that's sort of what i thought.
now for the silly question:
i know how to do it with 'monitor' (CLI), but where/how do you
"import" using phpMyAdmin, please? (this i'd love to know :) i looked
through the manual but didn't see anything for "import" db.
Ted
At 4:30 AM -0600 6/17/01,
That is a .sql file renamed to a .dump file, there's no difference. Import
it with phpMyAdmin or mysql -u username -ppassword dbname < whatever.dump
> i had some others that i browsed into phpmyadmin and they seemed to
> work, but others, like this one, showed a Query error -but that
> "method" o
we need to say something.','\r\nMamma
mia!\r\n\r\n\r\n\r\nWhat you think?\r\n\r\n\r\n');
INSERT INTO story_versions VALUES
(7,20001105194956,'brad',4,'2000-11-07','A New Story','Another new
story.','By','It\'s not so much that we have something to say as that
we need to say somet
What format are they in? Please paste a few sample lines.
> hello,
>
> i have some files from a Cd that are .dump files, how do i get these
> db into mysql? (is it possible using phpMyAdmin).
>
> again, these are ".dump&q
hello,
i have some files from a Cd that are .dump files, how do i get these
db into mysql? (is it possible using phpMyAdmin).
again, these are ".dump" files, not ".sql" files.
thank you.
-
Before p
I'm using 3.23.26-beta on FreeBSD 4.1.1-STABLE. I'm getting corruption in
the dump files in the form of "^A"'s showing up in strange places (they
mostly appear in table definitions, but also in the data that is close to
these definitions). The dump file cannot be used t
18 matches
Mail list logo
