Hot answers tagged

25

Execute your sql query in the SQL tab of phpMyAdmin. After execution, scroll down the page and look for “Query results operations” Click “Export” link from the above and you will get the page to export all the results of the queries to desired format. That’s it.


12

I know this is something old -- so I'm posting here just in case someone stumbles in the same question. In the latest versions of phpMyAdmin the setting to flip is NavigationTreeEnableGrouping, i.e. in config.inc.php set: $cfg['NavigationTreeEnableGrouping'] = false; p.s. on localhost, config.inc.php is placed in /phpmyadminX.XX/ folder Or, for a "...


5

The package is called phpmyadmin3 for version 3.5 (on the epel repo). Read the doc to check about the recommended update procedure.


4

The reason for this behavior are the dependencies of phpmyadmin (at least in Debian, and I think it's quite similar in Ubuntu): # apt-cache show phpmyadmin | grep Depends: libapache2-mod-php5 | libapache2-mod-php5filter | php5-cgi | php5-fpm | php5, php5-mysql | php5-mysqli | php5-mysqlnd, php5-mcrypt, php5-json, perl, debconf (>= 0.5) | debconf-2.0, ...


4

Using php7 and any OS packages will be difficult until distros (or third party repos) are updated to handle this and you really shouldn't do this on a production system. My advice is to not attempt this and wait until a PHP7 infrastructure is in place. You could work around by installing most things like PHPMyAdmin by hand, but this is not good system ...


4

Took me a while to figure this out. Trick was to enable "table_info" in the config.inc.php, like so: $cfg['Servers'][$i]['table_info'] = 'pma_table_info';


4

Instead of the export button at the top of the GUI, use the one at the bottom, within the "Query results operations" box. That is the one you want.


2

You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. Find your config.inc.php file under the phpMyAdmin installation directory and update the line that looks like this: $cfg['Servers'][$i]['password'] = 'password'; ... to ...


2

You realize all the configuration lines are commented out? You need to uncomment and fill-in those fields for anything to happen. I think including this one would be sufficient (assuming you want it to prompt you for a username/password): $cfg['Servers'][$i]['auth_type'] = 'cookie';


2

You can disable grouping by setting LeftFrameDBTree to false: $cfg['LeftFrameDBTree'] = false; UPDATE: the option was renamed to NavigationTreeEnableGrouping in phpMyAdmin 4.0.0.0 (2013-05-03).


2

Apperently you also configured the Webtatic yum repository to get a newer version of PHP (php56w) than what is included by default in CentOS or provided by EPEL. That conflicts with the PHP version the EPEL phpMyAdmin package expects. It could well be that phpMyAdmin still works well with a (much) newer PHP version and then the suggested --skip-broken is a ...


2

The STABLE branch should always match the current release. That's the best branch to track if you wish to use git to stay updated but not on the development version (master, which is rarely actually broken but still not for general development use). I have no idea why you saw a delay on the update -- if it happens again, you should probably contact the ...


2

I have resolved the issue. Indeed, my config file was being ignored. I had been copying config.inc.sample.php to config.inc.php in the top level directory of the website (/var/www/html/pma). However, on CentOS 6 there is a separate config directory -- /etc/phpMyAdmin/. Once I copied my config there, everything works ok.


2

I found it eventually! Perhaps this will work for PMA from rpms only. Despite PMA itself is in /usr/share/phpMyAdmin it expects to have config dir at /var/lib/phpMyAdmin/ and config in /etc Solution: just edit ./libraries/vendor_config.php and set the correct paths or ln -s /usr/share/phpMyAdmin/config.inc.php /var/lib/phpMyAdmin/config/ Edit 3 months ...


2

The safest would be running it on a (sub)domain you own. This way you could request a CA signed certificate. If you really want to run phpMyAdmin on an IP over SSL you could install a self-signed certificate. However this means the users will get a warning the first time they visit the page and will need to accept the certificate manually. (This also means ...


2

I had the same issue last night and was able to solve it. You'll need the gzrt package to repair the gzip. Here's how to fix it: Copy the beginning plaintext portion of your database.sql.gz file to a new file called database.sql Run gzrecover database.sql.gz Append the contents of database.sql.recovered into database.sql You might have to manually ...


1

I think the session folder is not writable by the web service try to change permission chmod -R 777 /var/lib/php/session


1

Unless you use the built-in default location PHP also needs to be explicitly configured with the location of the MySQL socket file in the php.ini file or in the connection string... pdo_mysql.default_socket= /home/mysql/mysql.sock or depending on your choice of API's mysqli.default_socket= /home/mysql/mysql.sock


1

There is a catalogue of problems with alias and try_files. You might want to consider using your old configuration hidden behind an internal rewrite: location /pma { rewrite ^/pma(.*)$ /phpmyadmin$1; } location /phpmyadmin { internal; ... }


1

It seems that the module 'mod_authz_user' is not enabled. You can try to run the following commands: sudo a2enmod authz_user sudo service apache2 restart


1

just install an earlier version, I installed is http://sourceforge.net/projects/xampp/files/XAMPP%20Linux/5.6.12/


1

I made it working with some changes in /opt/lampp/phpmyadmin/config.inc.php: Add a $i=1 after /* server parameters */ /* Server parameters */ $i = 1 AND fix tablespaces of phpMyAdmin as written in http://stackoverflow.com/a/11506495/2364405


1

Look in the full processlist for the Host column of theses connections : show full processlist\G Take the host and port of one of theses connections. Then SSH to the source server, and search which process has make this connection : netstat -ntp |grep :theport At the end of the line you will have the pid/process name of your script.


1

Here is an example of a working configuration for nginx and phpMyAdmin http://pkgs.fedoraproject.org/cgit/phpMyAdmin.git/tree/phpMyAdmin.nginx This is the file include in the Fedora RPM (which cannot be in the CentOS package because of missing nginx configuration) Also see http://pkgs.fedoraproject.org/cgit/php.git/tree/nginx-php.conf http://pkgs....


1

Try set $cfg['Servers'][$i]['verbose'] $cfg['Servers'][$i]['verbose'] Type: string Default value: '' Only useful when using phpMyAdmin with multiple server entries. If set, this string will be displayed instead of the hostname in the pull-down menu on the main page. This can be useful if you want to show only certain databases on ...


1

Reposting my comments above into an answer: Check /var/log/httpd/error_log for errors when you load the page - it might contain PHP error messages. Possibly also check /var/log/audit/audit.log for any SELinux block messages when you load that page. If there's anything useful in the logs, please add it to your question. -- update -- Check https://...


1

You need to set the appropriate SELinux boolean to allow the web server to communicate with MySQL. setsebool -P httpd_can_network_connect_db 1


1

You've already got the query? You can insert into a new table using another query's results Looks like the steps you need: Create the new table with all the columns. INSERT INTO newTable (field1, field2, field3) SELECT field1, field2, field3 FROM otherTable GROUP BY field1 Adjust for your 50-line query.


1

(can't comment yet #*@%!) It seems relevant to precise that dependind on your linux distro, config file locations may vary. On my Debian (squeeze), /usr/share/phpmyadmin/config.inc.php contains a warning on the first lines, which I might well have missed : /** * Please, do not edit this file. The configuration file for Debian * is located in the /etc/...


1

http://www.phpmyadmin.net/documentation/#authentication_modes details that you would want to use 'config' authentication mode.



Only top voted, non community-wiki answers of a minimum length are eligible