How to export / import database in mysql through comman line,
mysql system config ,
WAMPSERVER server installed .
OS WINDOWS
The advise for my local host , not an live hosting...
Thanks
A:
use mysqldump -u username -p databasename > filename.sql to export and mysql -u username -p databasename < filename.sql to import
matei
2010-04-25 11:01:24
This is the first time am doing the export using sql, Tell my my sql can place any where , that is my file may in desktop or d drive , or is there any particular location i have past my sql file
Bharanikumar
2010-04-25 12:04:13
![alt text][1] [1]: http://img19.imageshack.us/img19/6106/mysqlcmdprob.jpg
Bharanikumar
2010-04-25 12:25:39
plz look this screenshot
Bharanikumar
2010-04-25 12:26:03
you can place your file anywhere as long as you have your mysql bin folder in your PATH. the alternative is to call the mysql and mysqldump executables using the full path to them (e.g F:\wamp\bin\mysql\mysql5.1.36\bin\mysql and F:\wamp\bin\mysql\mysql5.1.36\bin\mysqldump) . In your screenshot the problem is that you didn't supply the username and password when starting the mysql program (you supply it with: mysql -u USERNAME -p <enter> and then type your password)
matei
2010-04-26 05:47:58
A:
To backup:
mysqldump -u user -p DATABASE > backup.sql
To import:
mysql -u user -p DATABASE < backup.sql
Francisco Soto
2010-04-25 11:03:08