Jump to content

Featured Replies

Posted
comment_726

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.

comment_728

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.

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