Breaking News: Grepper is joining You.com. Read the official announcement!

how to upload large sql file in phpmyadmin

Hamza Dev answered on June 27, 2022 Popularity 9/10 Helpfulness 4/10

answer how to upload large sql file in phpmyadmin

related how to upload large database in phpmyadmin

how to upload large sql file in phpmyadmin

Comment

Solution 1:

in php.ini of your php installation (note: depending if you want it for CLI, apache, or nginx, find the right php.ini to manipulate)

post_max_size=500M
upload_max_filesize=500M
memory_limit=900M


Solution 2:
1. first of all, we need to open the command prompt in administrator privilege.
2. furthermore, change your location to “C:\xampp\mysql\bin>mysql“. run command: ” cd C:\xampp\mysql\bin>mysql “
3. after that you need to run this command: “mysql -u {DB_USER} -p {DB_NAME} < path/to/file/ab.sql ” where you have to enter your database user_name and database name. In my case my
DB_USER : root && my
DB_NAME: vintagehome && we need vh_backup.sql file to import with the complete path.
finally merging both 2nd and 3rd point the whole syntax is :

“C:\xampp\mysql\bin>mysql -u {DB_USER} -p {DB_NAME} < path/to/file/ab.sql “

here is the code That I execute for importing SQL file:
my database name DB_NAME: vintageh_vintagehome
user name DB_USER: root
DB password: root
SQL file name: vh_backup

“mysql -u root -p vintageh_vintagehome < D:\downloads\sql\vh_backup.sql“

furthermore, the password of DB user is required. In my case, the password: root.

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: file php phpmyadmin sql upload

Link to this answer
Share Copy Link

Contributed on Jun 27 2022

Hamza Dev

0 Answers Avg Quality 2/10

Closely Related Answers

how to upload large database in phpmyadmin

Comment

# set upload file size to XG, example 2G
# On php.ini:
upload_max_filesize=4Gb
post_max_size=4Gb

Popularity 8/10 Helpfulness 3/10 Language php

Source: Grepper

Tags: php phpmyadmin phpmyad

Link to this answer
Share Copy Link

Contributed on Feb 08 2023

Tiago F2

0 Answers Avg Quality 2/10

how to upload large sql file in phpmyadmin

Contents

More Related Answers

how to upload large sql file in phpmyadmin

Closely Related Answers

how to upload large database in phpmyadmin

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.