Welcome to the Linux Foundation Forum!

mysql server

Options
jonjonrhernandez2nine
jonjonrhernandez2nine Posts: 4
in Command Line

can some one help me to export and import sql cli????needed so much thank you

Comments

  • kwame
    kwame Posts: 2
    Options
    What have you tried? What commands have you ran?
  • jonjonrhernandez2nine
    jonjonrhernandez2nine Posts: 4
    Options
    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,,,
    please help,,,
  • mfillpot
    mfillpot Posts: 2,177
    edited June 2013
    Options
    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.
  • jonjonrhernandez2nine
    jonjonrhernandez2nine Posts: 4
    Options
    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
  • jonjonrhernandez2nine
    jonjonrhernandez2nine Posts: 4
    Options
    mysql server is 5.1
    hope some one can help me to import and export the database because the command is not working..exmple of the not working command is mysqldump --help.,,,tnx

Categories

Upcoming Training