XAMPP phpMyAdmin: Importing of Large SQL files to database

preview_player
Показать описание
phpMyAdmin Error: "You probably tried to upload a file that is too large. Please refer to documentation for a workaround for this limit."

Here's a simple tutorial of importing large sql files to your phpMyAdmin database.

Summary:
2. Restart the MySQL module from the XAMPP Control Panel to enable the changes that you made.
3. Open Command Prompt.
4. Change your directory to where the bin folder of the mysql module of your XAMPP is located. e.g. "C:\xampp\mysql\bin"
**Make sure you are using the less-than symbol to import. Using greater-than symbol will export files. Make sure the database is already created**
6. Provide username's password
7. Press enter and wait for a couple of seconds to minutes. It takes longer when file size is huge.
8. Verify the database if the files are imported.

Thank you for watching this video tutorial.
Don't forget to drop comments, hit like, and subscribe to this YouTube Channel :D

Credits to Reev Music for the background music.
Рекомендации по теме
Комментарии
Автор

I've come back and watched this video probably 5 times since I started my new job. Thanks again

gavinwright
Автор

I know you did this years ago, but still very useful. It worked. Thank you!

MargaretSavoy
Автор

I always forget this command. So glad for this video still being here. Thanks!

gotaminutereviews
Автор

Absolutely great video! Thank you so much Cebuana, you ROCK :)

dandebiase
Автор

I was able to upload my 1.1 GB database to Xampp, thanks for the tutorial.

criscamgel
Автор

Thanks a lot it work I ahve about 215MB of online sql database and I successfully import in my loacl Xampp Server with help of your describe procedure. Thanks

ZulfiqarAadil
Автор

You saved my bacon. GREAT VIDEO! Thanks so much for taking the time to make it.

MattBreckenridge
Автор

thank you thank you for this ma'am its very helpful for programmer beginners love you :)

shanmichaelreyes
Автор

Its a nice one, I was worried but it git me, , bulls eye, thanks for posting

melwinpinto
Автор

You have a nice voice, and your tutorial was easy to follow thank you.

DJDevilOriginal
Автор

More power to your tutorials .. this helped me a lot .. ほんとうにありがとうござました!。。「Thank u very much」

jiyasama
Автор

Thank you very very much you are seriously a life saver likes(y)

cricketlive
Автор

Awesome, this video helpful me greatly...thank you!!

dariorfh
Автор

Thanks for this video, it helps a lot!

alpindustriya
Автор

Helped me so so so much. thanks a million!

zzane
Автор

Thank you! this video helped me a lot!

vedmed
Автор

Thank you so much, this helped me a lot! :)

tornqvistjim
Автор

Thank you for this video! You helped me a lot!

diegoramos
Автор

Thanks done in a simple and understanding method

informationwowiase
Автор

What happens if your installation of MySQL doesn't have a password? If I leave it blank, it fails.

sandysailer