Jump to content

Import Big file Size of Database to MySQL


Recommended Posts

HI, I would to Import and big database file around 2.5 G, to a user account(website) kindly guide on how can I cope with please.

Note: I used this command : mysql -u alemaren_gild -p alemaren_statute < alemaren_english.sql but it's not working and I getting access dined error.

waiting for you help


Link to comment
Share on other sites

You could try using phpMyAdmin by editing the config file at /usr/local/cwpsrv/var/services/pma/config.inc.php to specify an upload directory:

 * Directories for saving/loading files from server
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

If you move your file there you should be able to select it from the phpMyAdmin panel when doing an import.  Just make sure you have the appropriate file ownerships for the phpMyAdmin user and that you are importing into the correct user account database.

Note: the config file changes could get overwritten on updates.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...