Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

The solution to the problem that the data cannot be exported due to errors in PhpMyAdmin

2025-04-01 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Editor to share with you the PhpMyAdmin error data can not be exported solutions, I believe that most people do not understand, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

PhpMyAdmin error data can not be exported solutions: 1, select other options menu, call up the php directory [php.ini], and [CTRL+f] look for [post_max_size=8M] directly modified to the desired size; 2, use DW to find the file code in the source code to modify directly.

The solution to the problem that the data cannot be exported due to an error in PhpMyAdmin:

Method 1. The solution on Windosw server is as follows:

First of all, let's configure the remote login server as follows:

Look at the figure below: select other options menu: call up the php.ini under the php directory, and then CTRL+f search: post_max_size = 8m directly modify the size you want.

The default is post_max_size = 8m, just change it to post_max_size = 20m.

Note: the size in this is the size of the database. Set as much data as you want to upload.

Method 2. Use the following methods in the linux server system

The code is as follows:

/ usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries To apply the fix, log into your server via SSH as a "root" user and run the following commands: Change directories into the folder with the affected file. Cd

The code is as follows:

/ usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/librariesMove the old file as a backup. Mv session.inc.php session.inc.php-oldDownload the fixed file. Wget

The code is as follows:

Http://download1.swsoft.com/Plesk/Autoupdate/Windows/8.1.1.2/120220/session.inc.php Restart Plesk

The code is as follows:

/ etc/init.d/psa restart

Method 3, php source code directly modify the solution: use DW to find the source code in the file code can be directly modified.

Ini_set ('memory_limit',' 180M')

The above is all the contents of this article entitled "the solution to the error data in PhpMyAdmin cannot be exported". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report