June 2009 - Developers - lists.phpmyadmin.net

[Phpmyadmin-devel] slave replication, load data from master
by Tomas Srnka 29 Jul '09

29 Jul '09

Hello, I've been working on my design for managing slave replication and I've run into a problem. To explain, slave replication works in a way, that it loads master log (located on master server), where information about transactions are stored. Everything is fine, if you are setting up replication on empty server. However, once you have some data on master, you have to copy them to slave server before slave replication is started. My original idea was to use LOAD DATA FROM MASTER, but this feature is no longer supported (http://dev.mysql.com/doc/refman/5.0/en/load-data-from-master.html) One of my ideas is to create some sort of export/import function for copying data from master to slave with phpMyAdmin. Another possibility (for large databases/tables) is to ask root (=user) to do it manually (with mysqldump+mysql client). If anyone has any better idea how to solve this problem, please let me know. Thank you. Tomas

3 3

[Phpmyadmin-devel] Suggestions for Import/Export Changes
by Derek Schaefer 07 Jul '09

07 Jul '09

Hello everyone, I have a couple matters that I wanted to get input from you all on. First, possibilities for the new import interface. For those who don't know much about my GSoC project, one of the goals was to create an intermediary interface for editing the structure of a new database/table set that was deduced from some import data. Via this interface the structure is to be altered and changed as necessary (dropping tables, changes keys, etc.) and once the user is satisfied, it is created and the data (now adapted to the new structure) in inserted. This involved storing all the data from the import in a PHP session so the source wouldn't have to be reanalyzed after the user made edits to the structure. I have been having some second thoughts regarding such an interface. Depending on the size of the import, the PHP session could take up a considerable amount of memory. Also, all database and table options are editable after creation via the current regular db/table interface, therefore I believe the intermediary interface would be redundant at best, and counterintuitive as worst. All the while being rather inefficient. I find that directing the user towards the newly created database and/or tables via a notification after a successful import is simple, effective, and vastly more efficient. Suggestions, thought, comments, concerns, anyone? Second, I would like to propose a new XML export format to better support my new import features. This new format will present the option to export the SQL creation code for each of the exported tables in the manner outlined below: <?xml version="1.0" encoding="utf-8" ?>  <pma_xml_export version="1.0" xmlns:pma="http://www.phpmyadmin.net/some_doc_url/"> <pma:structure> <pma:db_name> <pma:tbl_name_1>CREATE TABLE `tbl_name_1`...</pma:tbl_name_1> <pma:tbl_name_2>CREATE TABLE `tbl_name_2`...</pma:tbl_name_2> <pma:tbl_name_3>CREATE TABLE `tbl_name_3`...</pma:tbl_name_3> </pma:db_name> </pma:structure> <db_name> <tbl_name_1> <col_1>data</col_1> <col_2>data</col_2> <col_3>data</col_3> </tbl_name_1> <tbl_name_2> <col_1>data</col_1> <col_2>data</col_2> <col_3>data</col_3> </tbl_name_2> <tbl_name_3> <col_1>data</col_1> <col_2>data</col_2> <col_3>data</col_3> </tbl_name_3> </db_name> </pma_xml_export> ...as opposed to the existing format: <?xml version="1.0" encoding="utf-8" ?>  <db_name> <tbl_name_1> <col_1>data</col_1> <col_2>data</col_2> <col_3>data</col_3> </tbl_name_1> <tbl_name_2> <col_1>data</col_1> <col_2>data</col_2> <col_3>data</col_3> </tbl_name_2> <tbl_name_3> <col_1>data</col_1> <col_2>data</col_2> <col_3>data</col_3> </tbl_name_3> </db_name> If you have any advice, I would love to hear from you. Thanks for your time and advice, Derek Schaefer

4 6

[Phpmyadmin-devel] Suggestions--What to do with previous data in target database when it is about to synchronize with a source database?
by Zahra Naeem 01 Jul '09

01 Jul '09

Hi, Could any one suggest, whether : Should I ask the user "Do you want to delete the uncommon tables or uncommon rows from the target database/table? " by prompting a message box or dialog box OR Should I make my own assumption that there is no need to delete any previous data in the target database. Regards, Zahra

2 1

[Phpmyadmin-devel] phpMyAdmin 3.2.0.1 is released
by Marc Delisle 30 Jun '09

30 Jun '09

Welcome to the first security release for phpMyAdmin 3.2.0. Details will follow on http://phpmyadmin.net in the Security section (see PMASA-2009-5). In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team --- http://infomarc.info

1 0

Re: [Phpmyadmin-devel] HELP! Problem using $REQUEST and $POST variables
by Michal Čihař 23 Jun '09

23 Jun '09

Hi First I think that phpmyadmin-devel is the right list for this question. Dne Tue, 23 Jun 2009 02:37:09 +0500 Zahra Naeem <xara.fast(a)gmail.com> napsal(a): > Hope all of you are doing great and having fun at GSoC. > > Hey guys! could anyone help me out with this problem. > > Whenever I try to retrieve data from a "form" using $_REQUEST or $_POST > variables when I am also including certain files at the top of the page > using require_once function call, it cannot not find any values in the > $_REQUEST or $_POST variables. > > Whereas, if I first retrieve the same values using the $_REQUEST or $_POST > variables and then include all the files using require_once function, it > finds values in $_REQUEST or $_POST variables. > > My problem is that I have to include those files before I retrieve data from > the "form" using these variables. > > I have tried to retreive data and save it in simple php variables before > including the files. But those variable show values before the require_once > function but do not show any value after the code lines that call the > function require_once(). > > This is pretty strange but I hope any one of you would be able to suggest > some appropriate solution for my problem. It looks like you do not propagate token over your form, what leads to removal of all non whitelisted variables from request. Use one of functions in libraries/url_generating.lib.php to include token and other common magic in your form. -- Michal Čihař | http://cihar.com | http://blog.cihar.com

2 2

[Phpmyadmin-devel] phpMyAdmin finalist in two categories!
by Marc Delisle 23 Jun '09

23 Jun '09

The 2009 SourceForge.net Community Choice Awards program has announced that phpMyAdmin is finalist for "Best Tool or Utility for SysAdmins" and "Best Tool or Utility for Developers". This is great news but it's up to all users to vote for us (you have until July 20 but hey -- now is the perfect time to vote!). Please visit http://sourceforge.net/community/cca09/vote/. --- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] about XML import
by Marc Delisle 22 Jun '09

22 Jun '09

Hi, I had a quick look at Derek's current state of XML import plug-in which tries to detect column types based on values. I think that the original problem about this, is that phpMyAdmin's XML export does not have the option of exporting structure, data or both. I'm not sure how people are currently importing phpMyAdmin's XML output but I believe we could change the export format to handle our importing needs. -- Marc Delisle http://infomarc.info

3 2

[Phpmyadmin-devel] user prefs: another possible setting
by Marc Delisle 17 Jun '09

17 Jun '09

Hi, It might be interesting to give users direct control over the EditInWindow setting. https://sourceforge.net/tracker/?func=detail&aid=2692299&group_id=23067&ati… -- Marc Delisle http://infomarc.info

1 0

[Phpmyadmin-devel] foreign key on external database
by Isart Montane 16 Jun '09

16 Jun '09

Hi all, For a personal project I need to create foreign keys between different databases. I've realised that phpmyadmin only allows foreign keys on the same db so I'm thinking on develop this feature. I know it's not a very good practice to create foreign keys on different databases... but I need it anyway... Any comments or guidelines to do it? Thanks, Isart

4 9

[Phpmyadmin-devel] phpMyAdmin 3.2.0 is released
by Marc Delisle 15 Jun '09

15 Jun '09

Welcome to phpMyAdmin 3.2.0. This version contains a number of small new features and some bug fixes. Details will appear on http://phpmyadmin.net. In a hurry? you can visit http://sourceforge.net/projects/phpmyadmin to download. Marc Delisle, for the team http://infomarc.info

1 0