Tuesday, August 26, 2008

Import and Export mysql database in Debian using phpmyadmin

Step 1: Install phpmyadmin

aptitude install phpmyadmin

Step 2: Login to phpmyadmin

https://192.168.100.1/phpmyadmin/
Default user: root
Enter root password.

Step 3: Export Database

After log in, click Export
In EXPORT menue select your database
e.g joomla
Select format under Select All/Unselect All
e.g SQL (by default)
Click Save as file e.g jooml
Press Go (botton right)
Save it to your local hard disk

Step 4: Import Database

Press Import after log in to phpmyadmin in other machine.
select the file under Location of the text file,
Leave every thing by default and
Press Go
This will import the mysql database.

No comments: