CODE EXAMPLE FOR SQL

how to upload large sql file in phpmyadmin

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:xamppmysqlin>mysql“. run command: ” cd C:xamppmysqlin>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:xamppmysqlin>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:downloadssqlvh_backup.sql“

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