https://sourceforge.net/p/phpminiadmin/news/2012-05-10T12:56:15ZRecent posts to news2012-05-10T12:56:15Z2012-05-10T12:56:15ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.net4dc9f260b5f35fecadf2d0a456731240cfa8526d

<div class="markdown_content"><p>what's fixed?<br /> - Undefined offset in get_rand_str<br /> - automatic relogin on XSS error </p> <p>what's new?<br /> - added: page navigator at the bottom<br /> - added: row counts, table sizes on the table list<br /> - added: MIT license<br /> - added: query history via browser's localStorage (last 32 queries remembered)<br /> - added: if database empty - show databases<br /> - added: after import - show tables<br /> - changed: moved from html 4.01 to html 5<br /> - changed: simplified settings form</p></div>

2011-04-29T23:54:17Z2011-04-29T23:54:17ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.net601b3782744f752116bc8b4e56f927d859c3646b

<div class="markdown_content"><p>Hi there, I finally decided that it's useful to import/export database in compressed format like gzip. <br /> So, changes in phpMiniAdmin 1.7.110429:<br /> - added: import/export to/from gzip compressed files (.gz)</p></div>

2011-04-26T09:17:44Z2011-04-26T09:17:44ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.netb059a465cb9198b3cd9baabb646817f7547b38a7

<div class="markdown_content"><p>Several more fixes and Security update:</p> <p>- added cross-site scripting (XSS) shield<br /> - fixed: default charset sometimes not worked correctly <br /> - fixed: Export broken if table names contain underscore <br /> - fixed: Export CSV in utf8 now done with bom-mark<br /> - fixed: added date_default_timezone_set<br /> - added cacheing database list in session<br /> - fixed: small fixes in export</p></div>

2009-12-21T09:44:07Z2009-12-21T09:44:07ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.net01def9eb876633aa1c019844a8cdb4d376dcc7cf

<div class="markdown_content"><p>well, I am back. I see that many people like this thing, so I decided to make it better. Look for further updates soon...</p> <p>Changes in phpMiniAdmin 1.5.091221</p> <p>- fixed: non-latin data issues. Now HTML pages always displayed in UTF8 and DB connection charset set to UTF8 too<br /> - fixed: empty (&quot;&quot;) fields displayed as NULL. Now it correctly distinguish between NULL and &quot;&quot;<br /> - fixed: export fails if db name only contains numbers or &quot;-&quot;. Added quoting for db names<br /> - fixed: error if table name = reserved word. Added quoting for table names<br /> - fixed: export problem with large inserts. Added &quot;SET GLOBAL max_allowed_packet=16777216&quot; to exported dump.sql<br /> - added: Line highliting in table view for mouseover and for mouse click<br /> - added: separate screen for database selection/management<br /> - added: on show tables screen - quick links to review mysql server variables and status</p></div>

2008-02-17T20:44:22Z2008-02-17T20:44:22ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.net8dc7d640efd76dbd28f406bb48592f9751c77935

<div class="markdown_content"><p>changes in phpMiniAdmin 1.4.080217</p> <p>- VULNERABILITY FIX - now all conents of the DB fields htmlescaped to prevent javascripts (and other XSS tricks) to run. Please let me know if someone needs an option to turn this off.<br /> - fixed: NULL values in SQL dump was replaced by ''<br /> - added: support of &quot;desc TABLE&quot; queries (suggested by Chavaranis Nikolaos)<br /> - added: Repair function in &quot;show tables&quot; (suggested by Josh)<br /> - added: in export file added final comments (so it's easy to see if export was completed fully - useful for slow servers or large DB when PHP script may timeout before the end of the export)</p></div>

2007-03-27T10:56:10Z2007-03-27T10:56:10ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.net5d0fdfe442d16e34e88fb62d77f15949bc1c0ee1

<div class="markdown_content"><p>changes in phpMiniAdmin 1.4.070327</p> <p>- fixed: script won't able to work if short_open_tag=Off in php.ini<br /> - added: DB export now contains extended information (version, database name, date/time)<br /> - changed: better length tuning of extended inserts in DB export<br /> - added: ability to export data from one table to CSV format (import from CSV to table will be implemented in next version)</p></div>

2007-03-23T12:35:07Z2007-03-23T12:35:07ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.netd5c9589c89a66040ea49e119e43f67d34c368c33

<div class="markdown_content"><p>changes in phpMiniAdmin 1.4.070323</p> <p>- fixed: on some hosting servers MySQL configured with disabled 'SHOW DATABASES' privilege and phpminiadmin wasn't able to show list of DBs and stop working.</p></div>

2007-03-15T12:55:56Z2007-03-15T12:55:56ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.net5df926db4f12aebbc94fecac355769fac3f44744

<div class="markdown_content"><p>changes in phpMiniAdmin 1.4.070315</p> <p>- added: ability to see DB table status via 'status' link on the top header (equal to 'SHOW TABLE STATUS')</p> <p>- added: ability to select several tables to apply particular function to (Export, Drop, Truncate, Optimize)</p> <p>- fixed: if select done from 2 tables that have same column names - column values displayed incorrectly</p> <p>- changed: now if user click 'Logoff' - cookies with DB Settings cleared for better security</p></div>

2007-02-27T16:11:19Z2007-02-27T16:11:19ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.net3417f70ee6f27cae0cc0abb8c7b495e6df86d241

<div class="markdown_content"><p>changes in phpMiniAdmin 1.4.070227</p> <p>- added (MAJOR): ability to put/execute multiple SQL statements into SQL-query text area.<br /> - added: as done in usual mysqldump the following additional statements added to 'export':<br /> - DROP TABLE IF EXISTS statements before each CREATE TABLE in (as done in usual mysqldump)<br /> - /*!40000 ALTER TABLE `....` DISABLE KEYS */; and /*!40000 ALTER TABLE `....` DISABLE KEYS */; before and after INSERT INTO</p> <p>- added: now all INSERT INTO statements in export are in 'extended' format (this decreases filesize of the result .sql file)</p> <p>- added: ability to OPTIMIZE table from 'show tables' view</p> <p>- fixed: backslash bug in SQL parser</p></div>

2007-02-16T11:42:15Z2007-02-16T11:42:15ZOleg Savchukhttps://sourceforge.net/u/userid-1631629/https://sourceforge.netd68494d2b7cba329afaed81ffbdb4de45998e366

<div class="markdown_content"><p>I found that some hosting providers moving from phpMyAdmin to phpMiniAdmin as main solution for accessing user’s MySQL databases due to installation simplicity and 10x faster performance:<br /> - <a href="http://www.110mb.com" rel="nofollow">http://www.110mb.com</a> ( they even created nice installation help <a href="http://www.110mb.com/phpmyadmin/" rel="nofollow">http://www.110mb.com/phpmyadmin/</a> )<br /> - <a href="http://www.quotaless.com" rel="nofollow">http://www.quotaless.com</a></p> <p>From the forums on those hosting sites I’ve analyzed complaints about phpMiniAdmin and now I am ready to announce new features coming in nearest 1.4 version:<br /> - ability to put multiple SQL queries in the input area and execute them correctly<br /> - ability to import from .gz and .zip files (it’s really better to upload large DBs as zipped files, isn’t it? ;)</p> <p>Other problems ('Settings screen' bug, inability to import DB dumps) was fixed recently – see previous project news.</p> <p>Also for 1.5 version I am going to add ability to Add/Edit table rows from ‘select * from table’.</p> <p>Anyway, if you believe that phpMiniAdmin missing some important and frequently used feature, submit a ticket using SourceForge’s Tracker <a href="http://sourceforge.net/tracker/?group_id=181023&amp;atid=895535">http://sourceforge.net/tracker/?group_id=181023&amp;atid=895535</a></p> <p>And of course, I will try to keep script simple to use and tiny in size.</p> <p>Thanks,<br /> Oleg</p></div>