In the construction of PHP website, the maintenance of MySQL database is the daily work, MySQL database import and export to achieve backup function is one of them, in the previous PHP tutorial I introduced a number of MySQL command to maintain the
During PHP website construction, Mysql database maintenance is a daily task. the backup function of Mysql database import and export is one of them. in the previous PHP Tutorial, during PHP website construction, mysql database maintenance is a daily
Many use Php+mysql station webmaster friends, often to use the phpMyAdmin database management tools to back up and restore the database, when the site runs for a long time, the MySQL database will be very large, when the site encountered problems,
After LNMP is set up, use PhpMyAdmin to import the database file, prompting that the file content is too large. Create the upload and save directories under phpmyadmin.
After LNMP is set up, use PhpMyAdmin to import the database file, prompting
PhpMyAdmin is easy to use and has become a common tool for most webmasters. phpmyadmin is more than enough for small websites. However, when the database is large for medium and large websites, phpmyadmin seems to be powerless!When the size of the
A common approach
phpMyAdmin cannot import large files. At the command line, use the following
The code is as follows
Copy Code
Command import: Mysql-u -p Example: mysql-u root-p123456 Box
The above method
The solution for importing phpmyadmin database to KB is as follows. Solution 1 of phpmyadmin database import of KB. open php. ini. Find the upload_max_filesize, memory_limit, and post_max_size parameters! (By default, php only allows the phpmyadmin
PhpMyAdmin import a large SQL file phpmyadmin
BitsCN.com
Data Import and Export (Export/Import) are often used when phpMyAdmin is used. However, when importing big data, the php file upload and script response time are limited, as a result,
Import large MySQL database backup files with Bigdump tool
created in 2010-07-01, Thursday 00:00
author
Bai Jianpeng
In the joomla! 1.5 website anti-Black 9 commandments "The first thing
After LNMP is set up, use PhpMyAdmin to import the database file, prompting that the file content is too large.
Modified
Upload_max_filesize = 30 M
Post_max_size = 40 M
Still useless. You can solve the problem as follows:
Modify the config. inc.
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.