PhpMyAdmin file size limit solution _ PHP Tutorial

Source: Internet
Author: User
PhpMyAdmin file size limit solution. The phpMyAdmin of XAMPP has various problems such as file size limitation and upload timeout. one solution is to modify the configuration file, however, I would like to recommend another method today -- the phpMyAdmin of sh XAMPP has various problems such as file size restrictions and upload timeout. one solution is to modify the configuration file, however, I would like to recommend another method today-shell command, which allows you to import databases more quickly, directly, and effectively. this can fundamentally avoid file size restrictions and upload timeout.

Database server management permission


In the php. ini configuration file, modify upload_max_filesize, memory_limit, and post_max_size.


The steps to solve the problem are as follows:

1. open CMD. Start> Run> CMD.

Second, go to the mysql directory.

The code is as follows:

D:
Cd d: xamppmysqlbin

3. start mysql and enter the user name and password.

The code is as follows:

Mysql-u wper-p
Enter password :*******

Fourth, select the database name.

Mysql> use wp
Fifth, set utf8 encoding.

The code is as follows:

Mysql> set names utf8;

Sixth, select and import the SQL database file path.

The code is as follows:

Mysql> source d: wangeim. SQL

Method 3: use some dedicated data backup software so that they can set the size of exported data to solve this problem.

Http://www.bkjia.com/PHPjc/632153.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/632153.htmlTechArticleXAMPP phpMyAdmin will have file size restrictions, upload timeout and other issues, there is a solution is to modify the configuration file, but today I would like to recommend another way -- sh...

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.