Import Big file Size of Database to MySQL

[Navid]

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

thanks.

[SeaScoot]

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.