Changeset 3244 for trunk/gui/tools/pma/Documentation.txt
- Timestamp:
- 08/31/10 21:10:39 (21 months ago)
- File:
-
- 1 edited
-
trunk/gui/tools/pma/Documentation.txt (modified) (18 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/gui/tools/pma/Documentation.txt
r3214 r3244 1 phpMyAdmin 3.3. 5.1Documentation1 phpMyAdmin 3.3.6 Documentation 2 2 3 3 * Top … … 258 258 259 259 If 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 youshould run the SQL script found in scripts/upgrade_tables_mysql_4_1_2+.sql.260 version 5.x or newer and if you use the pmadb/linked table infrastructure, you 261 should run the SQL script found in scripts/upgrade_tables_mysql_4_1_2+.sql. 262 262 263 263 Using authentication modes … … 267 267 don't want them to play around with others. 268 268 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. 271 270 Even in a single-user environment, you might prefer to use HTTP or cookie 272 271 mode so that your user/password pair are not in clear in the configuration … … 593 592 and to hide both "db1" and "db2" use 594 593 595 $cfg['Servers'][$i]['hide_db'] = ' (db1|db2)';594 $cfg['Servers'][$i]['hide_db'] = '^(db1|db2)$'; 596 595 597 596 More information on regular expressions can be found in the PCRE pattern … … 1874 1873 Server 1875 1874 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. 1875 1.1 My server is crashing each time a specific action is required or phpMyAdmin 1876 sends a blank page or a page full of cryptic characters to my browser, what can 1877 I do? 1878 1881 1879 Try to set the $cfg['OBGzip'] directive to FALSE in your config.inc.php file 1882 1880 and the zlib.output_compression directive to Off in your php configuration 1883 1881 file. 1884 Furthermore, we know about such problems connected to the release candidates of1885 PHP 4.2.0 (tested with PHP 4.2.0 RC1 to RC4) together with MS Internet1886 Explorer. Please upgrade to the release version PHP 4.2.0.1887 1882 1888 1883 1.2 My Apache server crashes when using phpMyAdmin. … … 1893 1888 support groups. 1894 1889 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. 1890 1.3 (withdrawn). 1902 1891 1903 1892 1.4 Using phpMyAdmin on IIS, I'm displayed the error message: "The specified … … 1925 1914 These features are based on the gzencode() and bzcompress() PHP functions to be 1926 1915 more 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. 1916 So, you must have Zlib/Bzip2 support (--with-zlib and --with-bz2). 1932 1917 1933 1918 1.8 I cannot insert a text file in a table, and I get an error about safe mode … … 2054 2039 are located in the MySQL Documentation. 2055 2040 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. 2041 1.18 (withdrawn). 2063 2042 2064 2043 1.19 I can't run the "display relations" feature because the script seems not … … 2074 2053 To connect to a MySQL server, PHP needs a set of MySQL functions called "MySQL 2075 2054 extension". 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 2055 otherwise it needs to be loaded dynamically. Its name is probably mysql.so or 2077 2056 php_mysql.dll. phpMyAdmin tried to load the extension but failed. 2078 2057 … … 2106 2085 SHOW VARIABLES LIKE 'lower_case_table_names'; 2107 2086 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. 2087 1.24 (withdrawn). 2112 2088 2113 2089 1.25 I am running Apache with mod_gzip-1.3.26.1a on Windows XP, and I get … … 2286 2262 ProxyPass /mirror/foo/ http://backend.example.com/ 2287 2263 ProxyPassReverse /mirror/foo/ http://backend.example.com/ 2288 ProxyPassReverseCookieDomain backend.example.com public.example.com 2289 ProxyPassReverseCookiePath / /mirror/foo/ 2264 ProxyPassReverseCookieDomain backend.example.com public.example.com 2265 ProxyPassReverseCookiePath / /mirror/foo/ 2290 2266 2291 2267 Note: if the backend url looks like http://host/~user/phpmyadmin, the tilde (~) … … 2330 2306 For RedHat users, Harald Legner suggests this on the mailing list: 2331 2307 2332 On my RedHat-Box the socket of MySQL is /var/lib/mysql/mysql.sock. In your 2308 On my RedHat-Box the socket of MySQL is /var/lib/mysql/mysql.sock. In your 2333 2309 php.ini you will find a line 2334 2310 … … 2465 2441 2466 2442 Compressed 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 2443 memory limit. For GZip/BZip2 exports this can be overcome since 2.5.4 using 2468 2444 $cfg['CompressOnFly'] (enabled by default). Zip exports can not be handled this 2469 2445 way, so if you need Zip files for larger dump, you have to use another way. … … 2735 2711 2736 2712 MS 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! 2713 version 6. 2740 2714 2741 2715 5.5 In Internet Explorer 5.0, I get JavaScript errors when browsing my rows. … … 2972 2946 Coordinates are relative; your diagram will be automatically scaled to fit 2973 2947 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 2975 2949 graphical editor to position the element correctly. 2976 2950 * When you'd like to look at your PDF, first be sure to click the Save button … … 3136 3110 \end{document} % end of document 3137 3111 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. 3112 6.20 I see a lot of databases which are not mine, and cannot access them. 3113 3114 You have one of these global privileges: CREATE TEMPORARY TABLES, SHOW 3115 DATABASES, LOCK TABLES. Those privileges also enable users to see all the 3116 database names. See this bug report. 3144 3117 3145 3118 So if your users do not need those privileges, you can remove them and their … … 3188 3161 6.25 How does BLOB streaming work in phpMyAdmin? 3189 3162 3190 First, for general information about BLOB streaming on MySQL, visit 3163 First, for general information about BLOB streaming on MySQL, visit 3191 3164 blobstreaming.org. We currently support streaming if you are running MySQL 5.1 3192 3165 with the PBXT and PBMS storage engines. Moreover, only PBMS 0.5.04 is … … 3326 3299 ['display'] configuration directive. 3327 3300 * 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 3329 3302 server_*.php and so on. 3330 3303 * Please don't put message strings in your code, instead add the string (at
Note: See TracChangeset
for help on using the changeset viewer.
