phpMyAdmin – How to Know the Import Progress of SQL File

phpmyadmin

Im importing large size of sql file in PHPMyAdmin and it takes to long to import. is there any way to know its progress?.

like some kind of loading bar or percent of its progress?.

and i'm importing using the browser not the mysqldump command line.

Best Answer

Sort of; phpMyAdmin does have an upload progress bar, but there are some additional webserver dependencies:

To be able to see a progress bar during your uploads, your server must have the APC extension [or] the uploadprogress one

...

Moreover, the JSON extension has to be enabled in your PHP.

If using APC, you must set apc.rfc1867 to on in your php.ini.

As some background information, this is a bit difficult to determine; since phpMyAdmin runs on the server that means it has difficulty knowing the size of the file before the upload is completed, which makes it inaccurate to show progress. I've never gone to the trouble to configure these additional requirements, so I'm not sure how well this works in practice.

Related Solutions

MySQL incredibly slow on WAMP and XAMPP

When MySQL is really slow on windows (not 30ms slower) is nearly always a matter of a forgotten localhost instead of 127.0.0.1 in settings or URL. Very few times it is due to a very slow fragmented hard drive (acting slower due to windows complex ACL and parallel processes using it). MySQL is slower in some benchmarks on windows but the difference is so small that cant change your experience.

Import SQL Dump File – Use XAMPP Command Line

Depending on the tool and parameters used to create the .sql dump file of multiple databases, the file will normally have

CREATE DATABASE DBn...;

and

USE DBn;

statements that will allow your import to proceed without hiccups. For example, both the mysqldump command mysqldump command and phpMyAdmin's Export function for multiple database insert them.

Assuming you have exported with a sensible tool like those above, then you can import the database with a command line like this:

mysql -u username -p < dumpfile.sql

Your mysql username account needs to have appropriate privileges to, for example, create databases.

You can even run this command in a more familiar way by naming the startingDB database to use before running the commands in dumpfile.sql:

mysql -u username -p startingDB < dumpfile.sql

As the dumpfile will have a CREATE DATABASE and USE before any CREATE TABLE or INSERT statements, everything will work fine.

Best Answer

Related Solutions

MySQL incredibly slow on WAMP and XAMPP

Import SQL Dump File – Use XAMPP Command Line

Related Question