how can i transper may database to other computer i use xampp and mySQL Admin please help me :(
If you're using XAMPP, its easiest to "export" all databases from phpMyAdmin, and then "import" them on your new machine.
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:
This has export functionality...
Import from mysql command line
Two ways to import datase in mysql from .sql file
Go to the location where mysql is installed or add MySQL.exe location(insth/bin) in system environment path:-
now execute following command:-
mysql -u <user> -p<password> -h <hostname> <database> < /path/to/updated_script/database.sql
mysqldump -u <user> -p<password> -h database --result-file="location_to_export_database.sql"