can some one help me to export and import sql cli????needed so much thank you
i enter this line
select * from attendance into outfile "c:/database/attendance.sql";
it only export the table content what i need is to export the database not the table only,,,
First off this is a Linux forum and I am assuming that you are using mysql on a Linux server, why then would you be trying to output the file into a windows C drive?
You can use mysqldump to output your entire database as a backup or transfer method and mysqlimport to inport the data into another database. All of the information is in the mysql online manual, I highly recommend reading through it there are many useful utilities.
i using mysql server cli combining with visual studio vb.net 2008 how can i create the syntax of importing db with out opening the mysql server shell???or creating the buck up for all the content of the database??? i need it for my thesis,,,,tnx