Re: Need a tool for mysql file

---------- Forwarded message ----------
From: nagendra prasad <[email protected]>
To: PHP DB <[email protected]>, [email protected], php mysql <
[email protected]>
Date: Thu, 25 Feb 2010 16:52:40 +0200
Subject: Need a tool for mysql file
Hi All,

I have a mysql database file of around 1 GB in size. Is their any tool which
which I can see all the database without uploading it on phpmyadmin on
localhost. I have tried to upload it on localhost but it said the file size
is too large  (I have changed the ini file as well but no luck ). I need a
tool with which I can see all the tables and the data in the file.

Best,

--
Guru Prasad
Ubuntu Voice GTK+ Forum


Hi

Hove you made all the changes to the php.ini file?

upload_max_filesize = 2M
post_max_size = 8M

Besides the 2 settings above, try increasing the settings given below.

max_execution_time = 30     ; Maximum execution time of each script, in
seconds
max_input_time = 60    ; Maximum amount of time each script may spend
parsing request data
;max_input_nesting_level = 64 ; Maximum input variable nesting level (this
may not be needed in your case)
memory_limit = 128M      ; Maximum amount of memory a script may consume
(128MB)

The effect of uploading a large file is that it will probably take quite
some time to upload, even over a local network.

HTH

Ferdi