archive-lt.com » LT » P » PROBIOBONA.LT

Total: 172

Choose link from "Titles, links and description words view":

Or switch to "Titles and links view".
  • Other sources of information — phpMyAdmin 4.2.7.1 documentation
    Mastering phpMyAdmin for Effective MySQL Management by Marc Delisle You can get information on that book and other officially endorsed books at the phpMyAdmin site Tutorials Third party tutorials and articles are listed on our wiki page Table Of Contents Other sources of information Printed Book Tutorials Previous topic User management Next topic FAQ Frequently Asked Questions This Page Show Source Quick search Enter search terms or a module class

    Original URL path: http://www.probiobona.lt/phpmyadmin/doc/html/other.html (2016-04-28)
    Open archived version from archive


  • FAQ - Frequently Asked Questions — phpMyAdmin 4.2.7.1 documentation
    the phpMyAdmin configuration file 2 6 I get an Access denied for user root localhost Using password YES error when trying to access a MySQL Server on a host which is port forwarded for my localhost When you are using a port on your localhost which you redirect via port forwarding to another host MySQL is not resolving the localhost as expected Erik Wasser explains The solution is if your host is localhost MySQL the command line tool mysql as well always tries to use the socket connection for speeding up things And that doesn t work in this configuration with port forwarding If you enter 127 0 0 1 as hostname everything is right and MySQL uses the TCP connection 2 7 Using and creating themes Themes are configured with cfg ThemePath cfg ThemeManager and cfg ThemeDefault Under cfg ThemePath you should not delete the directory pmahomme or its underlying structure because this is the system theme used by phpMyAdmin pmahomme contains all images and styles for backwards compatibility and for all themes that would not include images or css files If cfg ThemeManager is enabled you can select your favorite theme on the main page Your selected theme will be stored in a cookie To create a theme make a new subdirectory for example your theme name under cfg ThemePath by default themes copy the files and directories from pmahomme to your theme name edit the css files in your theme name css put your new images in your theme name img edit layout inc php in your theme name edit info inc php in your theme name to contain your chosen theme name that will be visible in user interface make a new screenshot of your theme and save it under your theme name screen png In theme directory there is file info inc php which contains theme verbose name theme generation and theme version These versions and generations are enumerated from 1 and do not have any direct dependence on phpMyAdmin version Themes within same generation should be backwards compatible theme with version 2 should work in phpMyAdmin requiring version 1 Themes with different generation are incompatible If you do not want to use your own symbols and buttons remove the directory img in your theme name phpMyAdmin will use the default icons and buttons from the system theme pmahomme 2 8 I get Missing parameters errors what can I do Here are a few points to check In config inc php try to leave the cfg PmaAbsoluteUri directive empty See also 4 7 Authentication window is displayed more than once why Maybe you have a broken PHP installation or you need to upgrade your Zend Optimizer See http bugs php net bug php id 31134 If you are using Hardened PHP with the ini directive varfilter max request variables set to the default 200 or another low value you could get this error if your table has a high number of columns Adjust this setting accordingly Thanks to Klaus Dorninger for the hint In the php ini directive arg separator input a value of will cause this error Replace it with If you are using Hardened PHP you might want to increase request limits The directory specified in the php ini directive session save path does not exist or is read only 2 9 Seeing an upload progress bar To be able to see a progress bar during your uploads your server must have the APC extension the uploadprogress one or you must be running PHP 5 4 0 or higher Moreover the JSON extension has to be enabled in your PHP If using APC you must set apc rfc1867 to on in your php ini If using PHP 5 4 0 or higher you must set session upload progress enabled to 1 in your php ini However starting from phpMyAdmin version 4 0 4 session based upload progress has been temporarily deactivated due to its problematic behavior See also RFC 1867 Known limitations 3 1 When using HTTP authentication a user who logged out can not log in again in with the same nick This is related to the authentication mechanism protocol used by phpMyAdmin To bypass this problem just close all the opened browser windows and then go back to phpMyAdmin You should be able to log in again 3 2 When dumping a large table in compressed mode I get a memory limit error or a time limit error Compressed dumps are built in memory and because of this are limited to php s memory limit For GZip BZip2 exports this can be overcome since 2 5 4 using cfg CompressOnFly enabled by default Zip exports can not be handled this way so if you need Zip files for larger dump you have to use another way 3 3 With InnoDB tables I lose foreign key relationships when I rename a table or a column This is an InnoDB bug see http bugs mysql com bug php id 21704 3 4 I am unable to import dumps I created with the mysqldump tool bundled with the MySQL server distribution The problem is that older versions of mysqldump created invalid comments like this MySQL dump 8 22 Host localhost Database database Server version 3 23 54 The invalid part of the code is the horizontal line made of dashes that appears once in every dump created with mysqldump If you want to run your dump you have to turn it into valid MySQL This means you have to add a whitespace after the first two dashes of the line or add a before it or 3 5 When using nested folders multiple hierarchies are displayed in a wrong manner Please note that you should not use the separating string multiple times without any characters between them or at the beginning end of your table name If you have to think about using another TableSeparator or disabling that feature See also cfg NavigationTreeTableSeparator 3 6 What is currently not supported in phpMyAdmin about InnoDB In Relation view having more than one index column in the foreign key In Query by example Query automatic generation of the query LEFT JOIN from the foreign table 3 7 I have table with many 100 columns and when I try to browse table I get series of errors like Warning unable to parse url How can this be fixed Your table neither have a primary key nor an unique one so we must use a long expression to identify this row This causes problems to parse url function The workaround is to create a primary or unique key 3 8 I cannot use clickable HTML forms in columns where I put a MIME Transformation onto Due to a surrounding form container for multi row delete checkboxes no nested forms can be put inside the table where phpMyAdmin displays the results You can however use any form inside of a table if keep the parent form container with the target to tbl row delete php and just put your own input elements inside If you use a custom submit input field the form will submit itself to the displaying page again where you can validate the HTTP POST VARS in a transformation For a tutorial on how to effectively use transformations see our Link section on the official phpMyAdmin homepage 3 9 I get error messages when using sql mode ANSI for the MySQL server When MySQL is running in ANSI compatibility mode there are some major differences in how SQL is structured see http dev mysql com doc mysql en ansi mode html Most important of all the quote character is interpreted as an identifier quote character and not as a string quote character which makes many internal phpMyAdmin operations into invalid SQL statements There is no workaround to this behaviour News to this item will be posted in Bug report 1013 3 10 Homonyms and no primary key When the results of a SELECT display more that one column with the same value for example SELECT lastname from employees where firstname like A and two Smith values are displayed if I click Edit I cannot be sure that I am editing the intended row Please make sure that your table has a primary key so that phpMyAdmin can use it for the Edit and Delete links 3 11 The number of rows for InnoDB tables is not correct phpMyAdmin uses a quick method to get the row count and this method only returns an approximate count in the case of InnoDB tables See cfg MaxExactCount for a way to modify those results but this could have a serious impact on performance 3 12 withdrawn 3 13 I get an error when entering USE followed by a db name containing an hyphen The tests I have made with MySQL 5 1 49 shows that the API does not accept this syntax for the USE command 3 14 I am not able to browse a table when I don t have the right to SELECT one of the columns This has been a known limitation of phpMyAdmin since the beginning and it s not likely to be solved in the future 3 15 withdrawn 3 16 withdrawn 3 17 withdrawn 3 18 When I import a CSV file that contains multiple tables they are lumped together into a single table There is no reliable way to differentiate tables in CSV format For the time being you will have to break apart CSV files containing multiple tables 3 19 When I import a file and have phpMyAdmin determine the appropriate data structure it only uses int decimal and varchar types Currently the import type detection system can only assign these MySQL types to columns In future more will likely be added but for the time being you will have to edit the structure to your liking post import Also you should note the fact that phpMyAdmin will use the size of the largest item in any given column as the column size for the appropriate type If you know you will be adding larger items to that column then you should manually adjust the column sizes accordingly This is done for the sake of efficiency 3 20 After upgrading some bookmarks are gone or their content cannot be shown At some point the character set used to store bookmark content has changed It s better to recreate your bookmark from the newer phpMyAdmin version ISPs multi user installations 4 1 I m an ISP Can I setup one central copy of phpMyAdmin or do I need to install it for each customer Since version 2 0 3 you can setup a central copy of phpMyAdmin for all your users The development of this feature was kindly sponsored by NetCologne GmbH This requires a properly setup MySQL user management and phpMyAdmin HTTP or cookie authentication See also Using authentication modes 4 2 What s the preferred way of making phpMyAdmin secure against evil access This depends on your system If you re running a server which cannot be accessed by other people it s sufficient to use the directory protection bundled with your webserver with Apache you can use htaccess files for example If other people have telnet access to your server you should use phpMyAdmin s HTTP or cookie authentication features Suggestions Your config inc php file should be chmod 660 All your phpMyAdmin files should be chown R phpmy apache where phpmy is a user whose password is only known to you and apache is the group under which Apache runs Follow security recommendations for PHP and your webserver 4 3 I get errors about not being able to include a file in lang or in libraries Check php ini or ask your sysadmin to check it The include path must contain somewhere in it and open basedir if used must contain and lang to allow normal operation of phpMyAdmin 4 4 phpMyAdmin always gives Access denied when using HTTP authentication This could happen for several reasons cfg Servers i controluser and or cfg Servers i controlpass are wrong The username password you specify in the login dialog are invalid You have already setup a security mechanism for the phpMyAdmin directory eg a htaccess file This would interfere with phpMyAdmin s authentication so remove it 4 5 Is it possible to let users create their own databases Starting with 2 2 5 in the user management page you can enter a wildcard database name for a user for example joe and put the privileges you want For example adding SELECT INSERT UPDATE DELETE CREATE DROP INDEX ALTER would let a user create manage his her database s 4 6 How can I use the Host based authentication additions If you have existing rules from an old htaccess file you can take them and add a username between the deny allow and from strings Using the username wildcard of would be a major benefit here if your installation is suited to using it Then you can just add those updated lines into the cfg Servers i AllowDeny rules array If you want a pre made sample you can try this fragment It stops the root user from logging in from any networks other than the private network IP blocks block root from logging in except from the private networks cfg Servers i AllowDeny order deny allow cfg Servers i AllowDeny rules array deny root from all allow root from localhost allow root from 10 0 0 0 8 allow root from 192 168 0 0 16 allow root from 172 16 0 0 12 4 7 Authentication window is displayed more than once why This happens if you are using a URL to start phpMyAdmin which is different than the one set in your cfg PmaAbsoluteUri For example a missing www or entering with an IP address while a domain name is defined in the config file 4 8 Which parameters can I use in the URL that starts phpMyAdmin When starting phpMyAdmin you can use the db pma username pma password and server parameters This last one can contain either the numeric host index from i of the configuration file or one of the host names present in the configuration file Using pma username and pma password has been tested along with the usage of cookie auth type Browsers or client OS 5 1 I get an out of memory error and my controls are non functional when trying to create a table with more than 14 columns We could reproduce this problem only under Win98 98SE Testing under WinNT4 or Win2K we could easily create more than 60 columns A workaround is to create a smaller number of columns then come back to your table properties and add the other columns 5 2 With Xitami 2 5b4 phpMyAdmin won t process form fields This is not a phpMyAdmin problem but a Xitami known bug you ll face it with each script website that use forms Upgrade or downgrade your Xitami server 5 3 I have problems dumping tables with Konqueror phpMyAdmin 2 2 2 With Konqueror 2 1 1 plain dumps zip and GZip dumps work ok except that the proposed file name for the dump is always tbl dump php Bzip2 dumps don t seem to work With Konqueror 2 2 1 plain dumps work zip dumps are placed into the user s temporary directory so they must be moved before closing Konqueror or else they disappear GZip dumps give an error message Testing needs to be done for Konqueror 2 2 2 5 4 I can t use the cookie authentication mode because Internet Explorer never stores the cookies MS Internet Explorer seems to be really buggy about cookies at least till version 6 5 5 In Internet Explorer 5 0 I get JavaScript errors when browsing my rows Upgrade to at least Internet Explorer 5 5 SP2 5 6 In Internet Explorer 5 0 5 5 or 6 0 I get an error like Page not found when trying to modify a row in a table with many columns or with a text column Your table neither have a primary key nor an unique one so we must use a long URL to identify this row There is a limit on the length of the URL in those browsers and this not happen in Netscape for example The workaround is to create a primary or unique key or use another browser 5 7 I refresh reload my browser and come back to the welcome page Some browsers support right clicking into the frame you want to refresh just do this in the right frame 5 8 With Mozilla 0 9 7 I have problems sending a query modified in the query box Looks like a Mozilla bug 0 9 6 was OK We will keep an eye on future Mozilla versions 5 9 With Mozilla 0 9 to 1 0 and Netscape 7 0 PR1 I can t type a whitespace in the SQL Query edit area the page scrolls down This is a Mozilla bug see bug 26882 at BugZilla 5 10 With Netscape 4 75 I get empty rows between each row of data in a CSV exported file This is a known Netscape 4 75 bug it adds some line feeds when exporting data in octet stream mode Since we can t detect the specific Netscape version we cannot workaround this bug 5 11 Extended ASCII characters like German umlauts are displayed wrong Please ensure that you have set your browser s character set to the one of the language file you have selected on phpMyAdmin s start page Alternatively you can try the auto detection mode that is supported by the recent versions of the most browsers 5 12 Mac OS X Safari browser changes special characters to This issue has been reported by a Mac OS X user who adds that Chimera Netscape and Mozilla do not have this problem 5 13 With Internet Explorer 5 5 or 6 and HTTP authentication type I cannot manage two servers I log in to the first one then the other one but if I switch back to the first I have to log in on each operation This is a bug in Internet Explorer other browsers do not behave this way 5 14 Using Opera6 I can manage to get to the authentication but nothing happens after that only a blank screen Please upgrade to Opera7 at least 5 15 I have display problems with Safari Please upgrade to at least version 1 2 3 5 16 With Internet Explorer I get Access is denied Javascript errors Or I cannot make phpMyAdmin work under Windows Please check the following points Maybe you have defined your cfg PmaAbsoluteUri setting in config inc php to an IP address and you are starting phpMyAdmin with a URL containing a domain name or the reverse situation Security settings in IE and or Microsoft Security Center are too high thus blocking scripts execution The Windows Firewall is blocking Apache and MySQL You must allow HTTP ports 80 or 443 and MySQL port usually 3306 in the in and out directions 5 17 With Firefox I cannot delete rows of data or drop a database Many users have confirmed that the Tabbrowser Extensions plugin they installed in their Firefox is causing the problem 5 18 With Konqueror 4 2 x an invalid LIMIT clause is generated when I browse a table This happens only when both of these conditions are met using the http authentication mode and register globals being set to On on the server It seems to be a browser specific problem meanwhile use the cookie authentication mode 5 19 I get JavaScript errors in my browser Issues have been reported with some combinations of browser extensions To troubleshoot disable all extensions then clear your browser cache to see if the problem goes away Using phpMyAdmin 6 1 I can t insert new rows into a table I can t create a table MySQL brings up a SQL error Examine the SQL error with care Often the problem is caused by specifying a wrong column type Common errors include Using VARCHAR without a size argument Using TEXT or BLOB with a size argument Also look at the syntax chapter in the MySQL manual to confirm that your syntax is correct 6 2 When I create a table I set an index for two columns and phpMyAdmin generates only one index with those two columns This is the way to create a multi columns index If you want two indexes create the first one when creating the table save then display the table properties and click the Index link to create the other index 6 3 How can I insert a null value into my table Since version 2 2 3 you have a checkbox for each column that can be null Before 2 2 3 you had to enter null without the quotes as the column s value Since version 2 5 5 you have to use the checkbox to get a real NULL value so if you enter NULL this means you want a literal NULL in the column and not a NULL value this works in PHP4 6 4 How can I backup my database or table Click on a database or table name in the navigation panel the properties will be displayed Then on the menu click Export you can dump the structure the data or both This will generate standard SQL statements that can be used to recreate your database table You will need to choose Save as file so that phpMyAdmin can transmit the resulting dump to your station Depending on your PHP configuration you will see options to compress the dump See also the cfg ExecTimeLimit configuration variable For additional help on this subject look for the word dump in this document 6 5 How can I restore upload my database or table using a dump How can I run a sql file Click on a database name in the navigation panel the properties will be displayed Select Import from the list of tabs in the right hand frame or SQL if your phpMyAdmin version is previous to 2 7 0 In the Location of the text file section type in the path to your dump filename or use the Browse button Then click Go With version 2 7 0 the import engine has been re written if possible it is suggested that you upgrade to take advantage of the new features For additional help on this subject look for the word upload in this document 6 6 How can I use the relation table in Query by example Here is an example with the tables persons towns and countries all located in the database mydb If you don t have a pma relation table create it as explained in the configuration section Then create the example tables CREATE TABLE REL countries country code char 1 NOT NULL default description varchar 10 NOT NULL default PRIMARY KEY country code TYPE MyISAM INSERT INTO REL countries VALUES C Canada CREATE TABLE REL persons id tinyint 4 NOT NULL auto increment person name varchar 32 NOT NULL default town code varchar 5 default 0 country code char 1 NOT NULL default PRIMARY KEY id TYPE MyISAM INSERT INTO REL persons VALUES 11 Marc S INSERT INTO REL persons VALUES 15 Paul S C CREATE TABLE REL towns town code varchar 5 NOT NULL default 0 description varchar 30 NOT NULL default PRIMARY KEY town code TYPE MyISAM INSERT INTO REL towns VALUES S Sherbrooke INSERT INTO REL towns VALUES M Montréal To setup appropriate links and display information on table REL persons click Structure then Relation view for town code choose from dropdowns mydb REL towns code for foreign database table and column respectively for country code choose from dropdowns mydb REL countries country code for foreign database table and column respectively on table REL towns click Structure then Relation view in Choose column to display choose description repeat the two previous steps for table REL countries Then test like this Click on your db name in the navigation panel Choose Query Use tables persons towns countries Click Update query In the columns row choose persons person name and click the Show tickbox Do the same for towns description and countries descriptions in the other 2 columns Click Update query and you will see in the query box that the correct joins have been generated Click Submit query 6 7 How can I use the display column feature Starting from the previous example create the pma table info as explained in the configuration section then browse your persons table and move the mouse over a town code or country code See also 6 21 In edit insert mode how can I see a list of possible values for a column based on some foreign table for an additional feature that display column enables drop down list of possible values 6 8 How can I produce a PDF schema of my database First the configuration variables relation table coords and pdf pages have to be filled in Then you need to think about your schema layout Which tables will go on which pages Select your database in the navigation panel Choose Operations in the navigation bar at the top Choose Edit PDF Pages near the bottom of the page Enter a name for the first PDF page and click Go If you like you can use the automatic layout which will put all your linked tables onto the new page Select the name of the new page making sure the Edit radio button is selected and click Go Select a table from the list enter its coordinates and click Save Coordinates are relative your diagram will be automatically scaled to fit the page When initially placing tables on the page just pick any coordinates say 50x50 After clicking Save you can then use the 6 28 How can I easily edit relational schema for export to position the element correctly When you d like to look at your PDF first be sure to click the Save button beneath the list of tables and coordinates to save any changes you made there Then scroll all the way down select the PDF options you want and click Go Internet Explorer for Windows may suggest an incorrect filename when you try to save a generated PDF When saving a generated PDF be sure that the filename ends in pdf for example schema pdf Browsers on other operating systems and other browsers on Windows do not have this problem 6 9 phpMyAdmin is changing the type of one of my columns No it s MySQL that is doing silent column type changing 6 10 When creating a privilege what happens with underscores in the database name If you do not put a backslash before the underscore this is a wildcard grant and the underscore means any character So if the database name is john db the user would get rights to john1db john2db If you put a backslash before the underscore it means that the database name will have a real underscore 6 11 What is the curious symbol ø in the statistics pages It means average 6 12 I want to understand some Export options Structure Add DROP TABLE will add a line telling MySQL to drop the table if it already exists during the import It does NOT drop the table after your export it only affects the import file If Not Exists will only create the table if it doesn t exist Otherwise you may get an error if the table name exists but has a different structure Add AUTO INCREMENT value ensures that AUTO INCREMENT value if any will be included in backup Enclose table and column names with backquotes ensures that column and table names formed with special characters are protected Add into comments includes column comments relations and MIME types set in the pmadb in the dump as SQL comments xxx Data Complete inserts adds the column names on every INSERT command for better documentation but resulting file is bigger Extended inserts provides a shorter dump file by using only once the INSERT verb and the table name Delayed inserts are best explained in the MySQL manual INSERT DELAYED Syntax Ignore inserts treats errors as a warning instead Again more info is provided in the MySQL manual INSERT Syntax but basically with this selected invalid values are adjusted and inserted rather than causing the entire statement to fail 6 13 I would like to create a database with a dot in its name This is a bad idea because in MySQL the syntax database table is the normal way to reference a database and table name Worse MySQL will usually let you create a database with a dot but then you cannot work with it nor delete it 6 14 withdrawn 6 15 I want to add a BLOB column and put an index on it but MySQL says BLOB column used in key specification without a key length The right way to do this is to create the column without any indexes then display the table structure and use the Create an index dialog On this page you will be able to choose your BLOB column and set a size to the index which is the condition to create an index on a BLOB column 6 16 How can I simply move in page with plenty editing fields You can use Ctrl arrows Option Arrows in Safari for moving on most pages with many editing fields table structure changes row editing etc 6 17 Transformations I can t enter my own mimetype WTF is this feature then useful for Slow down Defining mimetypes is of no use if you can t put transformations on them Otherwise you could just put a comment on the column Because entering your own mimetype will cause serious syntax checking issues and validation this introduces a high risk false user input situation Instead you have to initialize mimetypes using functions or empty mimetype definitions Plus you have a whole overview of available mimetypes Who knows all those mimetypes by heart so he she can enter it at will 6 18 Bookmarks Where can I store bookmarks Why can t I see any bookmarks below the query box What is this variable for Any query you have executed can be stored as a bookmark on the page where the results are displayed You will find a button labeled Bookmark this query just at the end of the page As soon as you have stored a bookmark it is related to the database you run the query on You can now access a bookmark dropdown on each page the query box appears on for that database You can also have inside the query a placeholder for a variable This is done by inserting into the query a SQL comment between and Inside the comment the special string VARIABLE is used Be aware that the whole query minus the SQL comment must be valid by itself otherwise you won t be able to store it as a bookmark When you execute the bookmark everything typed into the value input box on the query box page will replace the string VARIABLE in your stored query Also remember that everything else inside the VARIABLE string for your query will remain the way it is but will be stripped of the chars So you can use VARIABLE AS myname which will be expanded to VARIABLE as myname in your query where VARIABLE is the string you entered in the input box If an empty string is provided no replacements are made A more complex example Say you have stored this query SELECT Name Address FROM addresses WHERE 1 AND Name LIKE VARIABLE Say you now enter phpMyAdmin as the variable for the stored query the full query will be SELECT Name Address FROM addresses WHERE 1 AND Name LIKE phpMyAdmin You can use multiple occurrences of VARIABLE in a single query that is multiple occurrences of the same variable NOTE THE ABSENCE OF SPACES inside the construct Any spaces inserted there will be later also inserted as spaces in your query and may lead to unexpected results especially when using the variable expansion inside of a LIKE expression Your initial query which is going to be stored as a bookmark has to yield at least one result row so you can store the bookmark You may have that to work around using well positioned comments 6 19 How can I create simple LATEX document to include exported table You can simply include table in your LATEX documents minimal sample document should look like following one assuming you have table exported in file table tex documentclass article or any class you want usepackage longtable for displaying table begin document start of document include table including exported table end document end of document 6 20 I see a lot of databases which are not mine and cannot access them You have one of these global privileges CREATE TEMPORARY TABLES SHOW DATABASES LOCK TABLES Those privileges also enable users to see all the database names So if your users do not need those privileges you can remove them and their databases list will shorten See also http bugs mysql com 179 6 21 In edit insert mode how can I see a list of possible values for a column based on some foreign table You have to setup appropriate links between the tables and also setup the display column in the foreign table See 6 6 How can I use the relation table in Query by example for an example Then if there are 100 values or less in the foreign table a drop down list of values will be available You will see two lists of values the first list containing the key and the display column the second list containing the display column and the key The reason for this is to be able to type the first letter of either the key or the display column For 100 values or more a distinct window will appear to browse foreign key values and choose one To change the default limit of 100 see cfg ForeignKeyMaxLimit 6 22 Bookmarks Can I execute a default bookmark automatically when entering Browse mode for a table Yes If a bookmark has the same label as a table name and it s not a public bookmark it will be executed 6 23 Export I heard phpMyAdmin can export Microsoft Excel files You can use CSV for Microsoft Excel which works out of the box Changed in version 3 4 5 Since phpMyAdmin 3 4 5 support for direct export to Microsoft Excel version 97 and newer was dropped 6 24 Now that phpMyAdmin supports native MySQL 4 1 x column comments what happens to my column comments stored in pmadb Automatic migration of a table s pmadb style column comments to the native ones is done whenever you enter Structure page for this table 6 25 withdrawn 6 26 How can I select a range of rows Click the first row of the range hold the shift key and click the last row of the range This works everywhere you see rows for example in Browse mode or on the Structure page 6 27 What format strings can I use In all places where phpMyAdmin accepts format strings you can use VARIABLE expansion and strftime format strings The expanded variables depend on a context for example if you haven t chosen a table you can not get

    Original URL path: http://www.probiobona.lt/phpmyadmin/doc/html/faq.html (2016-04-28)
    Open archived version from archive

  • Developers Information — phpMyAdmin 4.2.7.1 documentation
    to contribute to it Many great features have been written by other people and you too can help to make phpMyAdmin a useful tool You can check out all the possibilities to contribute in the contribute section on our website Previous topic FAQ Frequently Asked Questions Next topic Distributing and packaging phpMyAdmin This Page Show Source Quick search Enter search terms or a module class or function name Navigation index

    Original URL path: http://www.probiobona.lt/phpmyadmin/doc/html/developers.html (2016-04-28)
    Open archived version from archive

  • Distributing and packaging phpMyAdmin — phpMyAdmin 4.2.7.1 documentation
    var lib phpmyadmin config inc php and you will also probably want to skip directory writable check so set SETUP DIR WRITABLE to false External libraries phpMyAdmin includes several external libraries you might want to replace them with system ones if they are available but please note that you should test whether version you provide is compatible with the one we ship Currently known list of external libraries js jquery

    Original URL path: http://www.probiobona.lt/phpmyadmin/doc/html/vendors.html (2016-04-28)
    Open archived version from archive

  • Credits — phpMyAdmin 4.2.7.1 documentation
    Tomáš Srnka Google Summer of Code 2009 Replication support Muhammad Adnan Google Summer of Code 2010 Relation schema export to multiple formats Lori Lee Google Summer of Code 2010 User interface improvements ENUM SET editor Simplified interface for export import Ninad Pundalik Google Summer of Code 2010 AJAXifying the interface Martynas Mickevičius Google Summer of Code 2010 Charts Barrie Leslie BLOBstreaming support with PBMS PHP extension withdrawn in release 4 0 Ankit Gupta Google Summer of Code 2010 Visual query builder Madhura Jayaratne Google Summer of Code 2011 OpenGIS support Ammar Yasir Google Summer of Code 2011 Zoom search Aris Feryanto Google Summer of Code 2011 Browse mode improvements Thilanka Kaushalya Google Summer of Code 2011 AJAXification Tyron Madlener Google Summer of Code 2011 Query statistics and charts for the status page Zarubin Stas Google Summer of Code 2011 Automated testing Rouslan Placella Google Summer of Code 2011 and 2012 Improved support for Stored Routines Triggers and Events Italian translation updates Removal of frames new navigation Dieter Adriaenssens Various bugfixes Dutch translation updates Alex Marin Google Summer of Code 2012 New plugins and properties system Thilina Buddika Abeyrathna Google Summer of Code 2012 Refactoring Atul Pratap Singh Google Summer of Code 2012 Refactoring Chanaka Indrajith Google Summer of Code 2012 Refactoring Yasitha Pandithawatta Google Summer of Code 2012 Automated testing Jim Wigginton phpseclib sourceforge net phpseclib Bin Zu Google Summer of Code 2013 Refactoring Supun Nakandala Google Summer of Code 2013 Refactoring Mohamed Ashraf Google Summer of Code 2013 AJAX error reporting Adam Kang Google Summer of Code 2013 Automated testing Ayush Chaudhary Google Summer of Code 2013 Automated testing Kasun Chathuranga Google Summer of Code 2013 Interface improvements Hugues Peccatte Load save query by example database search bookmarks And also to the following people who have contributed minor changes enhancements bugfixes or support for a new language since version 2 1 0 Bora Alioglu Ricardo Sven Erik Andersen Alessandro Astarita Péter Bakondy Borges Botelho Olivier Bussier Neil Darlow Mats Engstrom Ian Davidson Laurent Dhima Kristof Hamann Thomas Kläger Lubos Klokner Martin Marconcini Girish Nair David Nordenberg Andreas Pauley Bernard M Piller Laurent Haas Sakamoto Yuval Sarna www securereality com au Alexis Soulard Alvar Soome Siu Sun Peter Svec Michael Tacelosky Rachim Tamsjadi Kositer Uros Luís V Martijn W van der Lee Algis Vainauskas Daniel Villanueva Vinay Ignacio Vazquez Abrams Chee Wai Jakub Wilk Thomas Michael Winningham Vilius Zigmantas Manuzhai Translators Following people have contributed to translation of phpMyAdmin Arabic Abdullah Al Saedi abdullah 10 at windowslive com Bulgarian stoyanster stoyanster at gmail com Catalan Xavier Navarro xvnavarro at gmail com Czech Michal Čihař michal at cihar com Danish opensource opensource at jth net Jørgen Thomsen opensource at jth net German mrbendig mrbendig at mrbendig com torsten funck torsten funck at googlemail com Sven Strickroth email at cs ware de typo3 typo3 at dirk weise de Jo Michael me at mynetx net Greek Panagiotis Papazoglou papaz p at yahoo com English United Kingdom Robert Readman robert readman at hotmail com

    Original URL path: http://www.probiobona.lt/phpmyadmin/doc/html/credits.html (2016-04-28)
    Open archived version from archive

  • Glossary — phpMyAdmin 4.2.7.1 documentation
    See also http www wikipedia org wiki Internet Information Services Index a feature that allows quick access to the rows in a table See also http www wikipedia org wiki Index database IP Internet Protocol is a data oriented protocol used by source and destination hosts for communicating data across a packet switched internetwork See also http www wikipedia org wiki Internet Protocol IP Address a unique number that devices use in order to identify and communicate with each other on a network utilizing the Internet Protocol standard See also http www wikipedia org wiki IP Address IPv6 IPv6 Internet Protocol version 6 is the latest revision of the Internet Protocol IP designed to deal with the long anticipated problem of its precedessor IPv4 running out of addresses See also http www wikipedia org wiki IPv6 ISAPI Internet Server Application Programming Interface is the API of Internet Information Services IIS See also http www wikipedia org wiki ISAPI ISP Internet service provider is a business or organization that offers users access to the Internet and related services See also http www wikipedia org wiki ISP ISO International Standards Organisation JPEG a most commonly used standard method of lossy compression for photographic images See also http www wikipedia org wiki JPEG JPG look at jpeg Key look at index LATEX a document preparation system for the TEX typesetting program See also http www wikipedia org wiki LaTeX Mac Apple Macintosh is line of personal computers is designed developed manufactured and marketed by Apple Computer seealso http www wikipedia org wiki Mac Mac OS X the operating system which is included with all currently shipping Apple Macintosh computers in the consumer and professional markets See also http www wikipedia org wiki Mac OS X MCrypt a cryptographic library See also http www wikipedia org wiki MCrypt mcrypt the MCrypt PHP extension See also http php net mcrypt MIME Multipurpose Internet Mail Extensions is an Internet Standard for the format of e mail See also http www wikipedia org wiki MIME module some sort of extension for the Apache Webserver See also http www wikipedia org wiki module MySQL a multithreaded multi user SQL Structured Query Language Database Management System DBMS See also http www wikipedia org wiki MySQL mysqli the improved MySQL client PHP extension See also http php net mysqli mysql the MySQL client PHP extension See also http php net mysql OpenDocument open standard for office documents See also http www wikipedia org wiki OpenDocument OS X look at Mac OS X See also http www wikipedia org wiki OS X PDF Portable Document Format is a file format developed by Adobe Systems for representing two dimensional documents in a device independent and resolution independent format See also http www wikipedia org wiki Portable Document Format PEAR the PHP Extension and Application Repository See also http pear php net PCRE Perl Compatible Regular Expressions is the perl compatible regular expression functions for PHP See also http php net pcre PHP

    Original URL path: http://www.probiobona.lt/phpmyadmin/doc/html/glossary.html (2016-04-28)
    Open archived version from archive

  • Search — phpMyAdmin 4.2.7.1 documentation
    can search these documents Enter your search words into the box below and click search Note that the search function will automatically search for all of the words Pages containing fewer words won t appear in the result list Navigation

    Original URL path: http://www.probiobona.lt/phpmyadmin/doc/html/search.html (2016-04-28)
    Open archived version from archive


  • 14 04 48 2012 You can adapt this file completely to your liking but it should at least contain the root toctree directive Welcome to phpMyAdmin s documentation Contents toctree maxdepth 2 intro require setup config user faq developers vendors

    Original URL path: http://www.probiobona.lt/phpmyadmin/doc/html/_sources/index.txt (2016-04-28)
    Open archived version from archive



  •