LinuxSay - A Discussion Forum for Linux Enthusiasts

How to import database in mysql running on XAMP


#1

Hey guys i know this question seems to funny that’s why i wanna clear it more.

I am running a local server on my ubuntu 12.04 on xamp.

Question: I have 30 database and wanna backup them in one step for that i’m using this:

# mysqldump -u root -p --all-databases > backu.sql  .

The syntax is working fine and now i have a full backup of my all database.

PROBLEM NOW I WANT TO IMPORT THEM AND SEE THEM AGAIN IN PHPMYADMIN using following command.

# mysql -u username -p < dump.sql

error: The program ‘mysql’ is currently not installed. You can install it by typing:

$ sudo apt-get install mysql-client-core-5.5

all know when you install xamp you dont need to install mysql separately.


#2

May be try to view log file concerning XAMP, and if possible put the screen shot for us to view.
But if running:

$ sudo apt-get install mysql-client-core-5.5

helps then i suggest you try to do it.