XAMPP database

[bantex07]

how can i transper may database to other computer i use xampp and mySQL Admin please help me :(

[mattster]

If you're using XAMPP, its easiest to "export" all databases from phpMyAdmin, and then "import" them on your new machine.

[broj1]

You use mysqldump program to export database into a SQL file, something like:

mysqldump -u USER -p DATABASE > FILENAME.sql

then use mysql client to import SQL file into another database:

mysql -u USER -p DATABASE < FILENAME.sql

This was taken from this link.

EDIT: I just noticed that you said you use Xamp. I think these two programs should be available in xamp but I am not 100% sure.

Don't know about you, but I find phpMyAdmin a bit clunky. There are other GUIs out there such as SQLyog. You can download the free community version from here: the 64-bit Windows version:
https://code.google.com/p/sqlyog/downloads/detail?name=SQLyog-11.0.1-0.x64Community.exe&can=2&q=

This has export functionality...

[IIM]

Import from mysql command line
Two ways to import datase in mysql from .sql file

1. • Open MySQL command line client or execute mysql.exe from command prompt present in MySQL installation path.
     Create a new database .
     mysql> Create database test
     mysql> use test
   • Then import the database into test databse by using one of this commend:-
     source test.sql
     or
     ./ test.sql

2. Go to the location where mysql is installed or add MySQL.exe location(insth/bin) in system environment path:-
   MySQL->bin
   now execute following command:-
   mysql -u <user> -p<password> -h <hostname> <database> < /path/to/updated_script/database.sql

Export database

mysqldump -u <user> -p<password> -h database --result-file="location_to_export_database.sql"

[bantex07]

thx guys