FUDforum: Database discussions » database dump and phpmyadmin..

Home » General » Database discussions » database dump and phpmyadmin..

Show: Today's Messages :: Polls :: Message Navigator

database dump and phpmyadmin.. [message #2775]

Fri, 24 May 2002 17:43

Olliver

Messages: 443
Registered: March 2002

Karma:

Senior Member

Hi,
There are times when using phpmyadmin is not that wise...Today I inserted a database dump with just a size about 1,9megs, not that terrific actually. Using phpmyadmin the following happened: It kept on loading endlessly... the command "top" revealed that httpd was eating an average of 90-97% Cpu time. Even after 15 minutes nothing else happened but the hourglass turning in Mozilla Wink

I finally killed the process in order to avoid crashing the server. Just typing:
$ mysql database -u uraccount -p < urdump.sql
did the job in a few seconds. This way u will get a password prompt, but it has the advantage of not showing the password. I think the critical mass for phpmyadmin to handle is about 600-800k. anything beyond may still work, but it will take endless minutes to complete. I tested it with the following equipment:
Apache 1.3.24, PHP 4.2.1, MySQL 3.23.49a and phpmyadmin 2.26 (most recent version). So use the command line whenever it may be reasonable, saves time, money and unpleasant emails from BOFHs Wink

--edit: oops flipped "2" and "3" in MySQL Smile

. corrected.
bye Ken

[Updated on: Fri, 24 May 2002 23:32]

Report message to a moderator

[Message index]

		database dump and phpmyadmin.. By: Olliver on Fri, 24 May 2002 17:43
		Re: database dump and phpmyadmin.. By: Ilia on Sat, 25 May 2002 02:45
		Re: database dump and phpmyadmin.. By: Olliver on Sat, 25 May 2002 11:42
		Re: database dump and phpmyadmin.. By: Olliver on Sat, 25 May 2002 22:01
		Re: database dump and phpmyadmin.. By: Ilia on Sat, 25 May 2002 22:41
		Re: database dump and phpmyadmin.. By: Olliver on Sat, 25 May 2002 23:35
		Re: database dump and phpmyadmin.. By: Ilia on Sun, 26 May 2002 00:26
		Re: database dump and phpmyadmin.. By: Olliver on Sun, 26 May 2002 00:56
		Re: database dump and phpmyadmin.. By: Ilia on Sun, 26 May 2002 03:03
		Re: database dump and phpmyadmin.. By: jsam on Tue, 20 January 2015 01:22

Previous Topic:	slave database mysql
Next Topic:	fud26_ses

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 00:29:59 GMT 2024

Total time taken to generate the page: 0.07010 seconds