24
votes
How to export mysql schema from phpmyadmin?
Select your database or table.
Select the Export tab.
Below Export method, select Custom.
Below Tables, check the appropriate Structure boxes.
Here's a screenshot:
- 339
20
votes
Make the table listing show entire fields
Click on + Options
Select Full texts and click Go
Example image:
- 303
16
votes
WAMP MySQL Service will not start
I tried going to:
C:\wamp\bin\mysql\mysql5.6.17\data
and deleted the following:
auto.cnf, xxxxxxxxx.err, xxxxxxxxx.pid, ib_logfile0 and ib_logfile1
But I left the ibdata1 alone as it references all ...
- 161
4
votes
Make the table listing show entire fields
There is another permanent solution if you could able to access the phpmyadmin configuration file config.inc.php. The solution is to change LimitChars property from its default value 50 to any desired ...
- 308
4
votes
View existing indexes using phpMyAdmin
At the structure tab, bellow the columns there is a link indexes, just click there and another table will show all the indexes related.
- 141
3
votes
WAMP MySQL Service will not start
Please check the port that MySQL is using on your system. Then, change the port number of the WAMP server's MySQL service to that number by entering it in my.ini.
If you're running Windows, make sure ...
- 131
3
votes
Is there a shortcut key to run a query PHPMyAdmin?
Latest Versions of PHPMyAdmin support Ctrl + Enter and Ctrl+Shift+Enter.
- 131
3
votes
Accepted
I cant access my website that I hosted in home "Apache24" from internet
Enable apache's error log and see what is going wrong.
Since you can access the website for some seconds from outside and apache shows your client's IP successfully connecting to server, try to move ...
- 573
2
votes
How to fix: "phpMyAdmin - Error Cannot start session without errors"?
PHP "sessions" store variables so they can persist across multiple HTTP requests.
PHP sends your browser a single cookie that serves as a key. The key is used to retrieve the values from server-side ...
2
votes
Accepted
phpMyAdmin Quick database export: is it OK to use it for WordPress database backup?
A PhpMyAdmin quick export is a perfectly safe way to backup a Wordpress database.
PhpMyAdmin's quick export is configured by default to export the database structure and all the records as SQL. You ...
- 156
2
votes
Accepted
pmyAdmin how to overcome 2Mb import limit?
There are probably three properties that need to be changed.
php.ini
upload_max_filesize = 16M
post_max_size = 16M
my.cnf
max_allowed_packet = 16M
After adjusting these commands I suggest a ...
- 2,019
2
votes
Where can I find database backup files?
phpMyAdmin does not create backups for you – unless you set up some backups yourself, there are no backups stored within phpMyAdmin nor on your local drive.
If you wanted backups, you would have (had)...
- 224k
2
votes
How to delete bookmarked SQL requests and export templates in phpMyAdmin
OK, so it is actually quite simple once you are reminded that all this is likely kept in another shema of the DB, that you can also tinker with phpMyAdmin. So the answer is:
open the phpmyadmin....
- 9,812
2
votes
Accepted
DATEDIFF() refuses to run on a MySQL Event
CREATE EVENT check_expire
ON SCHEDULE
EVERY 1 DAY
STARTS '2019-08-21'
DO
UPDATE users
SET soon_expires = (DATEDIFF(expirationtime, CURRENT_DATE) < 45);
or
UPDATE users
SET soon_expires = 1
WHERE ...
- 3,195
2
votes
Accepted
How to change user password in phpmyadmin?
This is a summary of the article
How to Reset Your Admin Password in phpMyAdmin:
Open phpMyAdmin and click the admins table on the left
Find your user in the username column and click "Edit"...
- 458k
1
vote
Starting phpMyAdmin gives mbstring extension is missing error even php-mbstring is installed in Fedora 27
From Remi's repository blog.
Known issues
5.1. Configuration change
After a configuration change, or after a new extension installation, it is now required to restart the php-fpm service.
Run these ...
- 11
1
vote
Accepted
Install phpmyadmin with MariaDB
MariaDB is essentially forked MySQL so they work the same.
With a clean installation there is a root user with no password, so you can just connect via commandline by not specifying -p (run in the ...
- 681
1
vote
How do I get PhpMyAdmin to see my website's database?
PPHMyAdmin can connect to both local and remote databases.
Adjust the config file to hardcode a hostnames. Place the following content in /etc/phpmyadmin/conf.d/default-login.inc.php. This can be ...
- 462
1
vote
Accepted
Import and export databases,phpmyadmin
Go to your database, click to export, select the format (if you use it only for database save it as sql) then select the folder where you want to save. Then when you have to open it you have to select ...
- 38
1
vote
CentOS phpmyadmin folder forbidden
This works. Centos 7.
<Directory /usr/share/phpMyAdmin/>
AddDefaultCharset UTF-8
<IfModule mod_authz_core.c>
# Apache 2.4
<RequireAny>
Require all ...
1
vote
Access phpMyAdmin control panel from external ip
You're connecting to MySQL instead of Apache (which your browser, for obvious reasons, has no idea what to do with).
Change http://11.11.11.11:3306/phpMyAdmin to http://11.11.11.11:80/phpMyAdmin (or ...
- 2,282
1
vote
When/why would Chrome get 500 error on localhost but load OK from 127.0.0.1, while Firefox loads both?
A 500 Internal Server Error indicates that Chrome does try to load the page and even gets a server response (being the 500 error). So, the server fails. It probably has some logs?
As cookies are ...
- 31k
1
vote
export page of phpmyadmin goes blank after update php5 to php7.0
I solved the problem by modifying line 864 in phpmyadmin/export.php, change :
break 2;
By:
break;
Solution provided by bbalent in the following answer:
Don't worry, this is a code mistake from ...
- 621
1
vote
Centos - PhpMyAdmin showing blank screen
Check if you have all the php extensions installed, if it's showing 200 in the console when you access the page but the page is blank, chances are you are missing some extensions. Try installing these ...
- 11
1
vote
Centos - PhpMyAdmin showing blank screen
Depending what else is running on that public (I assume based on your link) web server, I recommend looking at the error logs (located in /var/log/httpd/php_error_log.log according to the phpinfo) ...
- 569
1
vote
You don't have permission to access /phpmyadmin on this server
I have found the solution:
I edited the file /etc/httpd/conf.d/phpMyAdmin.conf like the following :
<Directory /usr/share/phpMyAdmin/>
AddDefaultCharset UTF-8
<IfModule mod_authz_core.c&...
- 139
1
vote
Accepted
Invalid field count in CSV input on line XX in phpmyadmin?
To find these cases, look for any characters that may be interpreted as a delimiter, or a complex or unclosed quote. Remember that if there is a newline as part of a field value earlier in the file, ...
- 905
1
vote
Errors with a phpMyAdmin install on CentOS 7
To solve your problem you need to install priorities:
yum install yum-priorities
Next edit your /etc/yum.repos.d/remi.repo:
nano /etc/yum.repos.d/remi.repo
and add priority=5 to remi repository. ...
- 11
1
vote
Forcing SSL on phpmyadmin
You must wrap true in quotes in this last line:
cfg['ForceSSL'] = 'true';
otherwise it won't work.
1
vote
How to fix the phpmyadmin error "json extension is missing"?
Open the following file:
/etc/php5/apach2/php.ini
Write the following line in the end of the file.
extension=json.so
restart the apache2
$ sudo service apache2 restart
Enjoy
- 135
Only top scored, non community-wiki answers of a minimum length are eligible