Mysql - Restore mysql database from command prompt in lampp, Import mysql database in lampp

Restore mysql database from command prompt in lampp

Consider that you have installed your lampp under /opt director

So you lampp folder seems to be like /opt/lampp/, by default the path of the mysql is /opt/lampp/var/mysql/

when you type the mysql connector will search for the socket, to specify the socket use the bellow command

mysql -u root --socket=/opt/lampp/var/mysql/mysql.sock

To import or restore a mysql database in lampp or to lampp directory use the below command

mysql -u root --socket=/opt/lampp/var/mysql/mysql.sock your DBNAME < DBFILE.SQL

Mysql will use the socket /opt/lampp/var/mysql/mysql.sock and will store the database user the lampp directory or folder.

The topic on Mysql - Restore mysql database from command prompt in lampp is posted by - Math

Hope you have enjoyed, Mysql - Restore mysql database from command prompt in lamppThanks for your time