Troubleshooting and Support - Mastering phpMyAdmin 3.1 for Effective MySQL Management - page 304

Problems importing large files or uploading large
BLOB files
Usually, these problems indicate that we have hit a limit during the transfer.
Chapter 8 explains these limits and the recommended course of action. As a last
resort, we might have to split our large text files. (Search the Internet for
file splitters .)
MySQL root password lost
The MySQL manual explains the general solution at
http://www.mysql.com/doc/en/Resetting_permissions.html .
The solution involves stopping the MySQL server and restarting it with the special
option skip-grant-tables (which basically starts the server without security).
The way to stop and restart the server depends on the server platform used. We can
then connect to the server from phpMyAdmin as a superuser (like root) and any
password. The next step is to change the root's password (see Chapter 18). We can
then stop the MySQL server and restart it using normal procedures. (Security will
become active again.)
Duplicate field names when creating a table
Here is a curious symptom. When we try to create a table containing, for example,
one field named FIELD1 of type VARCHAR(15) , it looks like phpMyAdmin has sent a
command to create two identical fields named FIELD1 . The problem is not caused by
phpMyAdmin, but by the environment. In this case, the Apache web server seems
well-configured to run PHP scripts when in fact it is not. However, this bug appears
only for some scripts.
The problem occurs when two different (and conflicting) sets of directives are used
in the Apache configuration file. The first set of directives are:
SetOutputFilter PHP
SetInputFilter PHP
and the second one:
AddType application/x-httpd-php .php