New Thread
Advanced Reply
I use XAMPP 1.8 and phpmyadmin that comes with it, but I have a problem importing my database .sql file. It says max 2mb but my database is 2.6mb! How to increase phpmyadmin import database file size? 
Mind blowing SEO improving and Google rank increasing Signature Rotator SEO Tool.
SEO Forum
›
Money Making / Business Marketing
›
Search Engine Optimization 
Import .sql file to database, large database
Import .sql file to database, large database
6
24
To increase phpmyadmin import database file size go to: xampp\php inside that directory find a file called php.ini inside the file find:
memory_limit = 128M
upload_max_filesize = 2M
and replace with:
memory_limit = 128M
upload_max_filesize = 128M
This will increate .sql maximum file size to 128MB
memory_limit = 128M
upload_max_filesize = 2M
and replace with:
memory_limit = 128M
upload_max_filesize = 128M
This will increate .sql maximum file size to 128MB
6
85
Stop being lazy and learn some CLI for mysql!
www.AdminEmpire.com
www.BlimptonTech.com - Best Free Online JavaScript tool to minify JavaScript files.
www.BlimptonTech.com - Best Free Online JavaScript tool to minify JavaScript files.
109
He's new to XAMPP server, it's normal he doesn't know all this stuff! If you have any questions feel free to ask, we are here to help 
85
But using phpmyadmin will not teach him mysql. That was my point!
And in all honesty he should not be using the XAMPP stack as it adds in too many bells and whistles I am sure he does not even grasp yet, he should be on a WAMP stack. Then adding more GUI's on top further hinders learning things properly.
And he still has yet to even discuss the issue about his old host and that they flag his code as hacking/cracking/scanner type site. If it is not that type of a site then he has way larger problems to solve before continuing on. You never bring compromised code into another environment unless it is segregated and locked internally from accessing all other resources.
And in all honesty he should not be using the XAMPP stack as it adds in too many bells and whistles I am sure he does not even grasp yet, he should be on a WAMP stack. Then adding more GUI's on top further hinders learning things properly.
And he still has yet to even discuss the issue about his old host and that they flag his code as hacking/cracking/scanner type site. If it is not that type of a site then he has way larger problems to solve before continuing on. You never bring compromised code into another environment unless it is segregated and locked internally from accessing all other resources.
www.AdminEmpire.com
www.BlimptonTech.com - Best Free Online JavaScript tool to minify JavaScript files.
www.BlimptonTech.com - Best Free Online JavaScript tool to minify JavaScript files.
24
Every webmaster needs to have XAMPP or similar server installed on localhost where codes are tested before they are implemented on the website!
Similar Topics:
- How To Use of Robot.txt File In Webmaster..?
- What is .htaccess file?
- Why the robots.txt file is important ??
- Why do we need to add sitemap link on our robots.txt file?
- What is disallow in robots.txt file?
- How to create SQL database, table?
- How to fetch data from SQL database table?
- How to Upload a File to Your Website
- How to Create a Js File
- What is a Database Lock ?
User(s) browsing this thread: 1 Guest(s)
