FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » database dump and phpmyadmin..
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Return to the default flat view Create a new topic Submit Reply
database dump and phpmyadmin.. [message #2775] Fri, 24 May 2002 13:43 Go to previous message
Olliver   Germany
Messages: 443
Registered: March 2002
Karma:
Senior Member
add to buddy list
ignore all messages by this user
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 19:32]

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: slave database mysql
Next Topic: fud26_ses
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 15 20:41:45 EST 2017

Total time taken to generate the page: 0.00763 seconds