Ignore:
Timestamp:
08/31/10 21:10:39 (21 months ago)
Author:
ShadowJumper
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/gui/tools/pma/Documentation.txt

    r3214 r3244  
    1 phpMyAdmin 3.3.5.1 Documentation 
     1phpMyAdmin 3.3.6 Documentation 
    22 
    33  * Top 
     
    258258 
    259259If you have upgraded your MySQL server from a version previous to 4.1.2 to 
    260 version 4.1.2 or newer and if you use the pmadb/linked table infrastructure, 
    261 you should run the SQL script found in scripts/upgrade_tables_mysql_4_1_2+.sql. 
     260version 5.x or newer and if you use the pmadb/linked table infrastructure, you 
     261should run the SQL script found in scripts/upgrade_tables_mysql_4_1_2+.sql. 
    262262 
    263263Using authentication modes 
     
    267267    don't want them to play around with others. 
    268268    Nevertheless be aware that MS Internet Explorer seems to be really buggy 
    269     about cookies, at least till version 6, and PHP 4.1.1 is also a bit buggy 
    270     in this area! 
     269    about cookies, at least till version 6. 
    271270    Even in a single-user environment, you might prefer to use HTTP or cookie 
    272271    mode so that your user/password pair are not in clear in the configuration 
     
    593592    and to hide both "db1" and "db2" use 
    594593 
    595     $cfg['Servers'][$i]['hide_db'] = '(db1|db2)'; 
     594    $cfg['Servers'][$i]['hide_db'] = '^(db1|db2)$'; 
    596595 
    597596    More information on regular expressions can be found in the PCRE pattern 
     
    18741873Server 
    18751874 
    1876 1.1 I'm running PHP 4+ and my server is crashing each time a specific action is 
    1877 required or phpMyAdmin sends a blank page or a page full of cryptic characters 
    1878 to my browser, what can I do? 
    1879  
    1880 There are some known PHP bugs with output buffering and compression. 
     18751.1 My server is crashing each time a specific action is required or phpMyAdmin 
     1876sends a blank page or a page full of cryptic characters to my browser, what can 
     1877I do? 
     1878 
    18811879Try to set the $cfg['OBGzip'] directive to FALSE in your config.inc.php file 
    18821880and the zlib.output_compression directive to Off in your php configuration 
    18831881file. 
    1884 Furthermore, we know about such problems connected to the release candidates of 
    1885 PHP 4.2.0 (tested with PHP 4.2.0 RC1 to RC4) together with MS Internet 
    1886 Explorer. Please upgrade to the release version PHP 4.2.0. 
    18871882 
    188818831.2 My Apache server crashes when using phpMyAdmin. 
     
    18931888support groups. 
    18941889 
    1895 1.3 I'm running phpMyAdmin with "cookie" authentication mode under PHP 4.2.0 or 
    1896 4.2.1 loaded as an Apache 2 module but can't enter the script: I'm always 
    1897 displayed the login screen. 
    1898  
    1899 This is a known PHP bug (see this bug report) from the official PHP bug 
    1900 database. It means there is and won't be any phpMyAdmin fix against it because 
    1901 there is no way to code a fix. 
     18901.3 (withdrawn). 
    19021891 
    190318921.4 Using phpMyAdmin on IIS, I'm displayed the error message: "The specified 
     
    19251914These features are based on the gzencode() and bzcompress() PHP functions to be 
    19261915more independent of the platform (Unix/Windows, Safe Mode or not, and so on). 
    1927 So, you must have PHP4 >= 4.0.4 and Zlib/Bzip2 support (--with-zlib and 
    1928 --with-bz2). 
    1929 We faced PHP crashes when trying to download a dump with MS Internet Explorer 
    1930 when phpMyAdmin is run with a release candidate of PHP 4.2.0. In this case you 
    1931 should switch to the release version of PHP 4.2.0. 
     1916So, you must have Zlib/Bzip2 support (--with-zlib and --with-bz2). 
    19321917 
    193319181.8 I cannot insert a text file in a table, and I get an error about safe mode 
     
    20542039are located in the MySQL Documentation. 
    20552040 
    2056 1.18 I'm running MySQL <= 4.0.1 having lower_case_table_names set to 1. If I 
    2057 create a new table with a capital letter in its name it is changed to lowercase 
    2058 as it should. But if I try to DROP this table MySQL is unable to find the 
    2059 corresponding file. 
    2060  
    2061 This is a bug of MySQL <= 4.0.1. Please upgrade to at least MySQL 4.0.2 or turn 
    2062 off your lower_case_table_names directive. 
     20411.18 (withdrawn). 
    20632042 
    206420431.19 I can't run the "display relations" feature because the script seems not 
     
    20742053To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL 
    20752054extension". This extension may be part of the PHP distribution (compiled-in), 
    2076 otherwise it needs to be loaded dynamically. Its name is probably mysql.so or 
     2055otherwise it needs to be loaded dynamically. Its name is probably mysql.so or  
    20772056php_mysql.dll. phpMyAdmin tried to load the extension but failed. 
    20782057 
     
    21062085SHOW VARIABLES LIKE 'lower_case_table_names'; 
    21072086 
    2108 1.24 Some characters are being truncated in my queries, or I get characters 
    2109 randomly added. I am running PHP 4.2.3. 
    2110  
    2111 This is a PHP 4.2.3 bug. 
     20871.24 (withdrawn). 
    21122088 
    211320891.25 I am running Apache with mod_gzip-1.3.26.1a on Windows XP, and I get 
     
    22862262ProxyPass /mirror/foo/ http://backend.example.com/ 
    22872263ProxyPassReverse /mirror/foo/ http://backend.example.com/ 
    2288 ProxyPassReverseCookieDomain backend.example.com public.example.com 
    2289 ProxyPassReverseCookiePath / /mirror/foo/ 
     2264ProxyPassReverseCookieDomain backend.example.com public.example.com  
     2265ProxyPassReverseCookiePath / /mirror/foo/  
    22902266 
    22912267Note: if the backend url looks like http://host/~user/phpmyadmin, the tilde (~) 
     
    23302306For RedHat users, Harald Legner suggests this on the mailing list: 
    23312307 
    2332 On my RedHat-Box the socket of MySQL is /var/lib/mysql/mysql.sock. In your 
     2308On my RedHat-Box the socket of MySQL is /var/lib/mysql/mysql.sock. In your  
    23332309php.ini you will find a line 
    23342310 
     
    24652441 
    24662442Compressed dumps are built in memory and because of this are limited to php's 
    2467 memory limit. For GZip/BZip2 exports this can be overcome since 2.5.4 using 
     2443memory limit. For GZip/BZip2 exports this can be overcome since 2.5.4 using  
    24682444$cfg['CompressOnFly'] (enabled by default). Zip exports can not be handled this 
    24692445way, so if you need Zip files for larger dump, you have to use another way. 
     
    27352711 
    27362712MS Internet Explorer seems to be really buggy about cookies, at least till 
    2737 version 6. And thanks to Andrew Zivolup we've traced also a PHP 4.1.1 bug in 
    2738 this area! 
    2739 Then, if you're running PHP 4.1.1, try to upgrade or downgrade... it may work! 
     2713version 6. 
    27402714 
    274127155.5 In Internet Explorer 5.0, I get JavaScript errors when browsing my rows. 
     
    29722946    Coordinates are relative; your diagram will be automatically scaled to fit 
    29732947    the page. When initially placing tables on the page, just pick any 
    2974     coordinates -- say, 50x50. After clicking Save, you can then use the 
     2948    coordinates -- say, 50x50. After clicking Save, you can then use the  
    29752949    graphical editor to position the element correctly. 
    29762950  * When you'd like to look at your PDF, first be sure to click the Save button 
     
    31363110\end{document}          % end of document 
    31373111 
    3138 6.20 In MySQL 4, I see a lot of databases which are not mine, and cannot access 
    3139 them. 
    3140  
    3141 Upgrading to MySQL 4 usually gives users those global privileges: CREATE 
    3142 TEMPORARY TABLES, SHOW DATABASES, LOCK TABLES. Those privileges also enable 
    3143 users to see all the database names. See this bug report. 
     31126.20 I see a lot of databases which are not mine, and cannot access them. 
     3113 
     3114You have one of these global privileges: CREATE TEMPORARY TABLES, SHOW 
     3115DATABASES, LOCK TABLES. Those privileges also enable users to see all the 
     3116database names. See this bug report. 
    31443117 
    31453118So if your users do not need those privileges, you can remove them and their 
     
    318831616.25 How does BLOB streaming work in phpMyAdmin? 
    31893162 
    3190 First, for general information about BLOB streaming on MySQL, visit 
     3163First, for general information about BLOB streaming on MySQL, visit  
    31913164blobstreaming.org. We currently support streaming if you are running MySQL 5.1 
    31923165with the PBXT and PBMS storage engines. Moreover, only PBMS 0.5.04 is 
     
    33263299    ['display'] configuration directive. 
    33273300  * Please try to keep up the file-naming conventions. Table-related stuff goes 
    3328     to tbl_*.php, db-related code to db_*.php, server-related tools to 
     3301    to tbl_*.php, db-related code to db_*.php, server-related tools to  
    33293302    server_*.php and so on. 
    33303303  * Please don't put message strings in your code, instead add the string (at 
Note: See TracChangeset for help on using the changeset viewer.