Re: Need a tool for mysql file

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