-- Forwarded message --
From: nagendra prasad nagendra802...@gmail.com
To: PHP DB php-db@lists.php.net, phpexpe...@yahoogroups.com, php mysql
php_mysql_usergr...@yahoogroups.com
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